I'm upgrading the BI Server from 3.5.0 to 3.7.0 and my last remaining problem is the ad hoc query tool. All reports generate the same error in the logs. I migrated my metadata.xmi file to 3.7 and confirmed that it generates the correct queries within PME. I even tried building a completely new metadata model in 3.7 and published that, and I still get errors, so I'm thinking it's related to my configuration.

I included the log entry. The warnings seem to be related to the JIRA issue noted below, but there's not much in here for a workaround.

http://jira.pentaho.com/browse/BISER...nel#issue-tabs

Any ideas?


14:01:34,246 ERROR [SolutionEngine] 5fc281e9-1e7e-11e0-a135-6973b589bf9c:SOLUTION-ENGINE:session-region-list.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed
14:01:36,114 ERROR [GenericServlet] GenericServlet.ERROR_0004 - Resource /data-access/resources/gwt/modeler_en.properties not found in plugin Pentaho Data Access
14:01:36,174 ERROR [GenericServlet] GenericServlet.ERROR_0004 - Resource /data-access/resources/gwt/main_wizard_panel_en.properties not found in plugin Pentaho Data Access
14:01:36,174 ERROR [GenericServlet] GenericServlet.ERROR_0004 - Resource /data-access/resources/gwt/nativeScripts.js not found in plugin Pentaho Data Access
14:01:36,261 ERROR [GenericServlet] GenericServlet.ERROR_0004 - Resource /data-access/resources/gwt/main_wizard_panel_en_US.properties not found in plugin Pentaho Data Access
14:01:37,534 ERROR [GenericServlet] GenericServlet.ERROR_0004 - Resource /data-access/resources/gwt/gwt-dnd.css not found in plugin Pentaho Data Access
14:01:40,921 ERROR [GenericServlet] GenericServlet.ERROR_0004 - Resource /data-access/resources/gwt/nativeScripts.js not found in plugin Pentaho Data Access
14:01:41,004 ERROR [GenericServlet] GenericServlet.ERROR_0004 - Resource /data-access/resources/gwt/gwt-dnd.css not found in plugin Pentaho Data Access
14:01:41,977 ERROR [GenericServlet] GenericServlet.ERROR_0004 - Resource /data-access/resources/gwt/modeler_en.properties not found in plugin Pentaho Data Access
14:01:42,031 ERROR [GenericServlet] GenericServlet.ERROR_0004 - Resource /data-access/resources/gwt/main_wizard_panel_en.properties not found in plugin Pentaho Data Access
14:01:42,086 ERROR [GenericServlet] GenericServlet.ERROR_0004 - Resource /data-access/resources/gwt/main_wizard_panel_en_US.properties not found in plugin Pentaho Data Access
14:02:07,964 WARN [Logger] misc-org.pentaho.platform.engine.core.system.PentahoSystem: PentahoSystem.WARN_OBJECT_NOT_CONFIGURED - Object with name "metadataqueryexec-SQL" has not been configured in the Pentaho object factory.
14:02:08,090 WARN [Logger] misc-org.pentaho.platform.engine.core.system.PentahoSystem: PentahoSystem.WARN_OBJECT_NOT_CONFIGURED - Object with name "sqlGenerator" has not been configured in the Pentaho object factory.
14:02:08,192 ERROR [SolutionEngine] 73d2ebcb-1e7e-11e0-a135-6973b589bf9c:SOLUTION-ENGINEreview.xaction: Action Sequence execution failed, see details below
| Error Time: Wednesday, January 12, 2011 2:02:08 PM EST
| Session ID: twall
| Instance Id: 73d2ebcb-1e7e-11e0-a135-6973b589bf9c
| Action Sequence: preview.xaction
| Execution Stack:
EXECUTING ACTION: rule (MQLRelationalDataComponent)
| Action Class: MQLRelationalDataComponent
| Action Desc: rule
| Loop Index (1-based): 0
Stack Tracerg.pentaho.platform.api.engine.ActionExecutionException: RuntimeContext.ERROR_0017 - Action failed to execute
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1308)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1262)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1161)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1105)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:987)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:897)
at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:399)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:317)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:202)
at org.pentaho.platform.web.servlet.AdhocWebService.executeActionSequence(AdhocWebService.java:556)
at org.pentaho.platform.web.servlet.AdhocWebService.createJFreeReportAsStream(AdhocWebService.java:485)
at org.pentaho.platform.web.servlet.AdhocWebService.generatePreview(AdhocWebService.java:409)
at org.pentaho.platform.web.servlet.AdhocWebService.dispatch(AdhocWebService.java:297)
at org.pentaho.platform.web.servlet.AdhocWebService.doGet(AdhocWebService.java:263)
at org.pentaho.platform.web.servlet.AdhocWebService.doPost(AdhocWebService.java:337)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:77)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.RuntimeException: Base.ERROR_0002 - Component execution failed
at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:477)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1293)
... 76 more
Caused by: java.lang.NoClassDefFoundError: java/util/ServiceConfigurationError
at org.pentaho.metadata.query.impl.sql.SqlGenerator.getSQL(SqlGenerator.java:444)
at org.pentaho.metadata.query.impl.sql.SqlGenerator.generateSql(SqlGenerator.java:362)
at org.pentaho.platform.plugin.services.connections.metadata.sql.SqlMetadataQueryExec.executeQuery(SqlMetadataQueryExec.java:80)
at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.execute(MetadataQueryComponent.java:231)
at org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent.executeAction(MQLRelationalDataComponent.java:111)
at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:463)
... 77 more