mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while counting drill-through; sql=[select count(*) as "c0"]

Pentaho BI Platform Tracking | Benny Chow | 7 years ago
  1. 0

    Mondrian Error:Internal error: Error while counting drill-through; sql=[select count(*) as "c0"]mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while counting drill-through; sql=[select count(*) as "c0"] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:826) at mondrian.olap.Util.newInternal(Util.java:1490) at mondrian.olap.Util.newError(Util.java:1506) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:278) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:193) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:230) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:189) at mondrian.rolap.RolapCell.getDrillThroughCount(RolapCell.java:119) at com.pentaho.analyzer.olap.impl.CVMondrianCell.getDrillCount(CVMondrianCell.java:58) at com.pentaho.analyzer.content.controller.DrillBean.drill(DrillBean.java:87) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(AnalyzerContentGenerator.java:231) at sun.reflect.GeneratedMethodAccessor166.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.pentaho.platform.web.http.context.WebSpringPentahoObjectFactory$ProxyInvokeHandler.invoke(WebSpringPentahoObjectFactory.java:220) at $Proxy96.createContent(Unknown Source) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:258) at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:79) 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.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.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.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:264) 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 com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43) 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:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) 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:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:619) Caused by: java.sql.SQLException: Unexpected token , requires FROM in statement [select count(*) as "c0"] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:152) ... 69 more Here is the MDX statement: With Set [*BASE_MEMBERS_Measures] as '{[Measures].[*FORMATTED_MEASURE_0]}' Member [Measures].[*FORMATTED_MEASURE_0] as '[Measures].[Sales]', FORMAT_STRING = '#,###', SOLVE_ORDER=400 Select [*BASE_MEMBERS_Measures] on columns From [SteelWheelsSales] I've attached the steelwheels schema to this JIRA.

    Pentaho BI Platform Tracking | 7 years ago | Benny Chow
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while counting drill-through; sql=[select count(*) as "c0"]
  2. 0

    Mondrian Error:Internal error: Error while counting drill-through; sql=[select count(*) as "c0"]mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while counting drill-through; sql=[select count(*) as "c0"] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:826) at mondrian.olap.Util.newInternal(Util.java:1490) at mondrian.olap.Util.newError(Util.java:1506) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:278) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:193) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:230) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:189) at mondrian.rolap.RolapCell.getDrillThroughCount(RolapCell.java:119) at com.pentaho.analyzer.olap.impl.CVMondrianCell.getDrillCount(CVMondrianCell.java:58) at com.pentaho.analyzer.content.controller.DrillBean.drill(DrillBean.java:87) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(AnalyzerContentGenerator.java:231) at sun.reflect.GeneratedMethodAccessor166.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.pentaho.platform.web.http.context.WebSpringPentahoObjectFactory$ProxyInvokeHandler.invoke(WebSpringPentahoObjectFactory.java:220) at $Proxy96.createContent(Unknown Source) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:258) at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:79) 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.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.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.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:264) 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 com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43) 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:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) 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:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:619) Caused by: java.sql.SQLException: Unexpected token , requires FROM in statement [select count(*) as "c0"] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:152) ... 69 more Here is the MDX statement: With Set [*BASE_MEMBERS_Measures] as '{[Measures].[*FORMATTED_MEASURE_0]}' Member [Measures].[*FORMATTED_MEASURE_0] as '[Measures].[Sales]', FORMAT_STRING = '#,###', SOLVE_ORDER=400 Select [*BASE_MEMBERS_Measures] on columns From [SteelWheelsSales] I've attached the steelwheels schema to this JIRA.

    Pentaho BI Platform Tracking | 7 years ago | Benny Chow
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while counting drill-through; sql=[select count(*) as "c0"]
  3. 0

    Running sales_overtime.xaction sample in the SteelWheels dashboards samples yields the error below, and exceptions below that. Failed Error: SQLBaseComponent.ERROR_0006 - Could not execute sales_overtime.xaction - java.sql.SQLException: Column not found: OFFICE.TERRITORY in statement [SELECT CONCAT(CONCAT( YEAR(ORDERS.ORDERDATE),'-' ),MONTH(ORDERS.ORDERDATE)) AS TIME, SUM(ORDERDETAILS.QUANTITYORDERED*ORDERDETAILS.PRICEEACH) SOLD_PRICE FROM ORDERS INNER JOIN ORDERDETAILS ON ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER INNER JOIN PRODUCTS ON ORDERDETAILS.PRODUCTCODE =PRODUCTS.PRODUCTCODE INNER JOIN CUSTOMERS ON ORDERS.CUSTOMERNUMBER =CUSTOMERS.CUSTOMERNUMBER INNER JOIN EMPLOYEES ON CUSTOMERS.SALESREPEMPLOYEENUMBER = EMPLOYEES.EMPLOYEENUMBER INNER JOIN OFFICES ON EMPLOYEES.OFFICECODE=OFFICES.OFFICECODE WHERE OFFICE.TERRITORY='NA' GROUP BY CONCAT( MONTH(ORDERS.ORDERDATE), YEAR(ORDERS.ORDERDATE))] (org.pentaho.platform.plugin.action.sql.SQLLookupRule) Debug: Starting execute of samples/steel-wheels/dashboards/sales_overtime.xaction (com.pentaho.core.solution.ProSolutionEngine) Debug: Getting runtime context and data (com.pentaho.core.solution.ProSolutionEngine) Debug: Loading action sequence definition file (com.pentaho.core.solution.ProSolutionEngine) Debug: audit: instanceId=5ac39360-8a7b-11dd-bed1-197b80496e7f, objectId=org.pentaho.platform.engine.services.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.platform.engine.services.runtime.RuntimeContext) Error: SQLBaseComponent.ERROR_0006 - Could not execute sales_overtime.xaction - java.sql.SQLException: Column not found: OFFICE.TERRITORY in statement [SELECT CONCAT(CONCAT( YEAR(ORDERS.ORDERDATE),'-' ),MONTH(ORDERS.ORDERDATE)) AS TIME, SUM(ORDERDETAILS.QUANTITYORDERED*ORDERDETAILS.PRICEEACH) SOLD_PRICE FROM ORDERS INNER JOIN ORDERDETAILS ON ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER INNER JOIN PRODUCTS ON ORDERDETAILS.PRODUCTCODE =PRODUCTS.PRODUCTCODE INNER JOIN CUSTOMERS ON ORDERS.CUSTOMERNUMBER =CUSTOMERS.CUSTOMERNUMBER INNER JOIN EMPLOYEES ON CUSTOMERS.SALESREPEMPLOYEENUMBER = EMPLOYEES.EMPLOYEENUMBER INNER JOIN OFFICES ON EMPLOYEES.OFFICECODE=OFFICES.OFFICECODE WHERE OFFICE.TERRITORY='NA' GROUP BY CONCAT( MONTH(ORDERS.ORDERDATE), YEAR(ORDERS.ORDERDATE))] (org.pentaho.platform.plugin.action.sql.SQLLookupRule) Error: RuntimeContext.ERROR_0012 - ActionDefinition for SQLLookupRule did not execute successfully (org.pentaho.platform.engine.services.runtime.RuntimeContext) Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (com.pentaho.core.solution.ProSolutionEngine) Server Version: Pentaho Platform Engine Core 2.0.0-SNAPSHOT.32627 Exceptions: 16:59:11,248 ERROR [SQLLookupRule] Error Start: Pentaho Pentaho Platform Engine Core 2.0.0-SNAPSHOT.32627 16:59:11,248 ERROR [SQLLookupRule] a2f812a1-8a7b-11dd-bed1-197b80496e7f:COMPONENT:context-3994571-1222289951076:sales_overtime.xactionSQLBaseComponent.ERROR_0006 - Could not execute sales_overtime.xac tion java.sql.SQLException: Column not found: OFFICE.TERRITORY in statement [SELECT CONCAT(CONCAT( YEAR(ORDERS.ORDERDATE),'-' ),MONTH(ORDERS.ORDERDATE)) AS TIME, SUM(ORDERDETAILS.QUANTITYORDERED*ORDERDETAI LS.PRICEEACH) SOLD_PRICE FROM ORDERS INNER JOIN ORDERDETAILS ON ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER INNER JOIN PRODUCTS ON ORDERDETAILS.PRODUCTCODE =PRODUCTS.PRODUCTCODE INNER JOIN CUSTOMERS ON ORDERS.CUSTOMERNUMBER =CUSTOMERS.CUSTOMERNUMBER INNER JOIN EMPLOYEES ON CUSTOMERS.SALESREPEMPLOYEENUMBER = EMPLOYEES.EMPLOYEENUMBER INNER JOIN OFFICES ON EMPLOYEES.OFFICECODE=OFFICES.OFFICECODE WHERE OFFICE.TERRITORY='NA' GROUP BY CONCAT( MONTH(ORDERS.ORDERDATE), YEAR(ORDERS.ORDERDATE))] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.executeQuery(SQLConnection.java:294) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.executeQuery(SQLConnection.java:266) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.doQuery(SQLBaseComponent.java:597) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.runQuery(SQLBaseComponent.java:538) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.executeAction(SQLBaseComponent.java:241) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:440) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1298) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1265) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1174) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1127) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1012) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1165) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1127) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1012) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:908) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:409) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:313) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:192) at com.pentaho.core.solution.ProSolutionEngine.execute(ProSolutionEngine.java:95) at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159) at org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:141) at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:268) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:129) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Unknown Source) 16:59:11,264 ERROR [SQLLookupRule] Error end: 16:59:11,264 ERROR [RuntimeContext] a2f812a1-8a7b-11dd-bed1-197b80496e7f:RUNTIME:context-3994571-1222289951076:sales_overtime.xaction RuntimeContext.ERROR_0012 - ActionDefinition for SQLLookupRule did not execute successfully 16:59:11,311 ERROR [ProSolutionEngine] a2f812a1-8a7b-11dd-bed1-197b80496e7f:SOLUTION-ENGINE:sales_overtime.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed

    Pentaho BI Platform Tracking | 8 years ago | Jared Pshedesky
    java.sql.SQLException: Column not found: OFFICE.TERRITORY in statement [SELECT CONCAT(CONCAT( YEAR(ORDERS.ORDERDATE),'-' ),MONTH(ORDERS.ORDERDATE)) AS TIME, SUM(ORDERDETAILS.QUANTITYORDERED*ORDERDETAI LS.PRICEEACH) SOLD_PRICE FROM ORDERS INNER JOIN ORDERDETAILS ON ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER INNER JOIN PRODUCTS ON ORDERDETAILS.PRODUCTCODE =PRODUCTS.PRODUCTCODE INNER JOIN CUSTOMERS ON ORDERS.CUSTOMERNUMBER =CUSTOMERS.CUSTOMERNUMBER INNER JOIN EMPLOYEES ON CUSTOMERS.SALESREPEMPLOYEENUMBER = EMPLOYEES.EMPLOYEENUMBER INNER JOIN OFFICES ON EMPLOYEES.OFFICECODE=OFFICES.OFFICECODE WHERE OFFICE.TERRITORY='NA' GROUP BY CONCAT( MONTH(ORDERS.ORDERDATE), YEAR(ORDERS.ORDERDATE))]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Open BI Developer Examples->Regions and departments Report - it failed giving the error. Error: SQLBaseComponent.ERROR_0006 - Could not execute headcount_actual_by_department.xaction - java.sql.SQLException: Not in aggregate function or group by clause: org.hsqldb.Expression@150bd4d in statement [select REGION, sum(ACTUAL) from QUADRANT_ACTUALS group by REGION order by ACTUAL] (org.pentaho.platform.plugin.action.sql.SQLLookupRule) Debug: Starting execute of bi-developers/services/headcount_actual_by_department.xaction (com.pentaho.core.solution.ProSolutionEngine) Debug: Getting runtime context and data (com.pentaho.core.solution.ProSolutionEngine) Debug: Loading action sequence definition file (com.pentaho.core.solution.ProSolutionEngine) Debug: audit: instanceId=f6244264-9152-11dd-bbce-93e82df8f63d, objectId=org.pentaho.platform.engine.services.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.platform.engine.services.runtime.RuntimeContext) Debug: validateComponent validating component SQLLookupRule (org.pentaho.platform.engine.services.runtime.RuntimeContext) Debug: Validating component for action headcount_actual_by_department.xaction (org.pentaho.platform.plugin.action.sql.SQLLookupRule) Debug: Executing action sequence (org.pentaho.platform.engine.services.runtime.RuntimeContext) Debug: Executing action definition: Iteration 0 (org.pentaho.platform.engine.services.runtime.RuntimeContext) Debug: audit: instanceId=f6244264-9152-11dd-bbce-93e82df8f63d, objectId=SQLLookupRule, messageType=component_execution_started (org.pentaho.platform.engine.services.runtime.RuntimeContext) Debug: execute pre-audit (org.pentaho.platform.engine.services.runtime.RuntimeContext) Debug: Setting component log level to DEBUG (org.pentaho.platform.engine.services.runtime.RuntimeContext) Debug: Initializing component (org.pentaho.platform.engine.services.runtime.RuntimeContext) Debug: executeComponent starting audited execute (org.pentaho.platform.engine.services.runtime.RuntimeContext) Debug: execute validation=true (org.pentaho.platform.plugin.action.sql.SQLLookupRule) Debug: Running query - select REGION, sum(ACTUAL) from QUADRANT_ACTUALS group by REGION order by ACTUAL (org.pentaho.platform.plugin.action.sql.SQLLookupRule) Debug: Executing query with timeout value of [0] (org.pentaho.platform.plugin.action.sql.SQLLookupRule) Error: SQLBaseComponent.ERROR_0006 - Could not execute headcount_actual_by_department.xaction - java.sql.SQLException: Not in aggregate function or group by clause: org.hsqldb.Expression@150bd4d in statement [select REGION, sum(ACTUAL) from QUADRANT_ACTUALS group by REGION order by ACTUAL] (org.pentaho.platform.plugin.action.sql.SQLLookupRule) Debug: executeComponent finished audited execute (org.pentaho.platform.engine.services.runtime.RuntimeContext) Error: RuntimeContext.ERROR_0012 - ActionDefinition for SQLLookupRule did not execute successfully (org.pentaho.platform.engine.services.runtime.RuntimeContext) Debug: audit: instanceId=f6244264-9152-11dd-bbce-93e82df8f63d, objectId=org.pentaho.platform.engine.services.runtime.RuntimeContext, messageType=action_sequence_failed (org.pentaho.platform.engine.services.runtime.RuntimeContext) Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (com.pentaho.core.solution.ProSolutionEngine) Server Version: Pentaho Platform Engine Core 2.0.0-RC1.33017 The following error in the console. 09:55:39,500 ERROR [SQLLookupRule] Error Start: Pentaho Pentaho Platform Engine Core 2.0.0-RC1.33017 09:55:39,515 ERROR [SQLLookupRule] f6244264-9152-11dd-bbce-93e82df8f63d:COMPONENT:context-5836956-1223042139390:headcount_actual_by_department.xactionSQLBaseComponent.ERROR_0006 - Could not execute headcount_actual_by_department.xaction java.sql.SQLException: Not in aggregate function or group by clause: org.hsqldb.Expression@150bd4d in statement [select REGION, sum(ACTUAL) from QUADRANT_ACTUALS group by REGION order by ACTUAL] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.executeQuery(SQLConnection.java:294) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.executeQuery(SQLConnection.java:266) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.doQuery(SQLBaseComponent.java:597) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.runQuery(SQLBaseComponent.java:538) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.executeAction(SQLBaseComponent.java:241) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:440) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1298) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1265) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1174) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1127) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1012) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:908) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:409) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:313) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:192) at com.pentaho.core.solution.ProSolutionEngine.execute(ProSolutionEngine.java:95) at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159) at org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:141) at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:268) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:129) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Unknown Source) 09:55:39,578 ERROR [SQLLookupRule] Error end: 09:55:39,578 ERROR [RuntimeContext] f6244264-9152-11dd-bbce-93e82df8f63d:RUNTIME:context-5836956-1223042139390:headcount_actual_by_department.xaction RuntimeContext.ERROR_0012 - ActionDefinition for SQLLookupRule did not execute successfully 09:55:39,593 ERROR [ProSolutionEngine] f6244264-9152-11dd-bbce-93e82df8f63d:SOLUTION-ENGINE:headcount_actual_by_department.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed

    Pentaho BI Platform Tracking | 8 years ago | Golda David
    java.sql.SQLException: Not in aggregate function or group by clause: org.hsqldb.Expression@150bd4d in statement [select REGION, sum(ACTUAL) from QUADRANT_ACTUALS group by REGION order by ACTUAL]
  6. 0

    Open BIDeveloper Examples ->Charts->Chart Samples Dashboard The following error is thrown in the tomcat console. 15:11:32,546 ERROR [SQLLookupRule] Error Start: Pentaho Pentaho Platform Engine Core 2.0.0-RC1.33017 15:11:32,546 ERROR [SQLLookupRule] ec9b3e2f-90b5-11dd-b2f4-b9c68ef15baa:COMPONENT:context-5653168-1222974692406:timeserieschart_data.xactionSQLBaseComponent.ERROR_0006 - Could not execute timeserieschart_data.xaction java.sql.SQLException: Wrong data type: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.executeQuery(SQLConnection.java:294) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.executeQuery(SQLConnection.java:266) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.doQuery(SQLBaseComponent.java:597) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.runQuery(SQLBaseComponent.java:512) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.executeAction(SQLBaseComponent.java:241) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:440) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1298) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1265) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1174) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1127) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1012) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:908) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:409) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:313) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:192) at com.pentaho.core.solution.ProSolutionEngine.execute(ProSolutionEngine.java:95) at org.pentaho.platform.uifoundation.chart.AbstractChartComponent.getActionData(AbstractChartComponent.java:192) at org.pentaho.platform.uifoundation.chart.TimeSeriesCollectionChartComponent.createChart(TimeSeriesCollectionChartComponent.java:81) at org.pentaho.platform.uifoundation.chart.TimeSeriesCollectionChartComponent.getXmlContent(TimeSeriesCollectionChartComponent.java:151) at org.pentaho.platform.uifoundation.component.xml.XmlComponent.getContent(XmlComponent.java:55) at org.pentaho.platform.uifoundation.chart.ChartHelper.doChart(ChartHelper.java:279) at org.apache.jsp.jsp.ChartSamplesDashboard_jsp._jspService(ChartSamplesDashboard_jsp.java:198) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:129) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Unknown Source) 15:11:32,875 ERROR [SQLLookupRule] Error end: 15:11:32,875 ERROR [RuntimeContext] ec9b3e2f-90b5-11dd-b2f4-b9c68ef15baa:RUNTIME:context-5653168-1222974692406:timeserieschart_data.xaction RuntimeContext.ERROR_0012 - ActionDefinition for SQLLookupRule did not execute successfully 15:11:32,953 ERROR [ProSolutionEngine] ec9b3e2f-90b5-11dd-b2f4-b9c68ef15baa:SOLUTION-ENGINE:timeserieschart_data.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed 15:11:32,984 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: bi-developers/charts/samplesDashboard/Chart_en_US.xsl 15:11:33,000 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: bi-developers/charts/samplesDashboard/Chart_en.xsl 15:11:33,000 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: bi-developers/charts/samplesDashboard/Chart.xsl 15:11:33,000 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: system/custom/xsl/Chart_en_US.xsl 15:11:33,000 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: system/custom/xsl/Chart_en.xsl 15:11:33,234 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: bi-developers/charts/samplesDashboard/Chart_en_US.xsl 15:11:33,234 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: bi-developers/charts/samplesDashboard/Chart_en.xsl 15:11:33,250 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: bi-developers/charts/samplesDashboard/Chart.xsl 15:11:33,250 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: system/custom/xsl/Chart_en_US.xsl 15:11:33,250 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: system/custom/xsl/Chart_en.xsl 15:11:33,531 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: bi-developers/charts/samplesDashboard/Chart_en_US.xsl 15:11:33,531 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: bi-developers/charts/samplesDashboard/Chart_en.xsl 15:11:33,531 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: bi-developers/charts/samplesDashboard/Chart.xsl 15:11:33,546 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: system/custom/xsl/Chart_en_US.xsl 15:11:33,546 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: system/custom/xsl/Chart_en.xsl 15:11:33,859 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: bi-developers/charts/samplesDashboard/Chart_en_US.xsl 15:11:33,859 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: bi-developers/charts/samplesDashboard/Chart_en.xsl 15:11:33,859 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: bi-developers/charts/samplesDashboard/Chart.xsl 15:11:33,859 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: system/custom/xsl/Chart_en_US.xsl 15:11:33,875 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: system/custom/xsl/Chart_en.xsl 15:11:34,187 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: bi-developers/charts/samplesDashboard/Chart_en_US.xsl 15:11:34,187 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: bi-developers/charts/samplesDashboard/Chart_en.xsl 15:11:34,187 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: bi-developers/charts/samplesDashboard/Chart.xsl 15:11:34,203 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: system/custom/xsl/Chart_en_US.xsl 15:11:34,203 ERROR [Logger] misc-org.pentaho.platform.engine.services.SolutionURIResolver: SOLREPO.ERROR_0006 - Resource not found: system/custom/xsl/Chart_en.xsl

    Pentaho BI Platform Tracking | 8 years ago | Golda David
    java.sql.SQLException: Wrong data type: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Unexpected token , requires FROM in statement [select count(*) as "c0"]

      at org.hsqldb.jdbc.Util.sqlException()
    2. HSQLDB
      jdbcStatement.executeQuery
      1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
      3. org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
      3 frames
    3. Commons DBCP
      DelegatingStatement.executeQuery
      1. org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
      1 frame
    4. mondrian.rolap
      RolapCell.getDrillThroughCount
      1. mondrian.rolap.SqlStatement.execute(SqlStatement.java:152)
      2. mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:230)
      3. mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:189)
      4. mondrian.rolap.RolapCell.getDrillThroughCount(RolapCell.java:119)
      4 frames
    5. com.pentaho.analyzer
      AnalyzerContentGenerator.createContent
      1. com.pentaho.analyzer.olap.impl.CVMondrianCell.getDrillCount(CVMondrianCell.java:58)
      2. com.pentaho.analyzer.content.controller.DrillBean.drill(DrillBean.java:87)
      3. com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(AnalyzerContentGenerator.java:231)
      3 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor166.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:597)
      3 frames
    7. com.pentaho.platform
      WebSpringPentahoObjectFactory$ProxyInvokeHandler.invoke
      1. com.pentaho.platform.web.http.context.WebSpringPentahoObjectFactory$ProxyInvokeHandler.invoke(WebSpringPentahoObjectFactory.java:220)
      1 frame
    8. Unknown
      $Proxy96.createContent
      1. $Proxy96.createContent(Unknown Source)
      1 frame
    9. org.pentaho.platform
      GenericServlet.doPost
      1. org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:258)
      2. org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:79)
      2 frames
    10. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      2 frames
    11. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    12. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
      1 frame
    13. org.springframework.security
      FilterSecurityInterceptor.doFilter
      1. org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
      2. org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
      2 frames
    14. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    15. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    16. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    17. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    18. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    19. org.pentaho.platform
      RequestParameterAuthenticationFilter.doFilter
      1. org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
      1 frame
    20. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    21. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    22. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    23. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    24. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    25. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    26. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    27. org.pentaho.platform
      HttpSessionReuseDetectionFilter.doFilter
      1. org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
      1 frame
    28. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    29. Spring Security - Portlet support
      HttpSessionContextIntegrationFilter.doFilterHttp
      1. org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
      1 frame
    30. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      1 frame
    31. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    32. org.pentaho.platform
      HttpSessionPentahoSessionIntegrationFilter.doFilter
      1. org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:264)
      1 frame
    33. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    34. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    35. spring-security-core
      FilterToBeanProxy.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      2. org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
      3. org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
      3 frames
    36. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    37. com.pentaho.ui
      SystemStatusFilter.doFilter
      1. com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43)
      1 frame
    38. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    39. org.pentaho.platform
      SetCharacterEncodingFilter.doFilter
      1. org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
      1 frame
    40. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
      6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      8. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      9. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
      9 frames
    41. Grizzly HTTP
      JIoEndpoint$Worker.run
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
      3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
      3 frames
    42. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame