java.sql.SQLException: Unknown JDBC escape sequence: {{PREPARELATER:Customers} GROUP BY PRODUCTS.PRODUCTLINE ORDER BY 2 DESC

Pentaho BI Platform Tracking | Jared Pshedesky | 8 years ago
  1. 0

    The Steelwheels Top Ten Customers' Product Line report sample fails with a boatload of exceptions. Report gets generated, but the charts are all empty. Abridged exception spew: 09:57:37,531 WARN [JCommon] Warning: Data-Set does not contain a column with name 'TOTALPRICE' 09:57:37,546 ERROR [SQLLookupRule] Error Start: Pentaho Pentaho Platform Engine Core 2.0.0-SNAPSHOT.32698 09:57:37,546 ERROR [SQLLookupRule] e584e0b2-8b09-11dd-82a2-69a312a91bef:COMPONENT:context-17709255-1222351051264:Top Ten Customer Product Line Analysis.xactionSQLBaseComponent.ERROR_0006 - Could not e xecute Top Ten Customer Product Line Analysis.xaction java.sql.SQLException: Unknown JDBC escape sequence: {{PREPARELATER:Customers} GROUP BY PRODUCTS.PRODUCTLINE ORDER BY 2 DESC at org.hsqldb.jdbc.jdbcConnection.onStartEscapeSequence(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.nativeSQL(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.executePrepared(SQLBaseComponent.java:443) at org.pentaho.platform.plugin.action.jfreereport.helper.PentahoTableDataFactory.queryData(PentahoTableDataFactory.java:116) at org.jfree.report.states.CachingDataFactory.queryData(CachingDataFactory.java:284) at org.jfree.report.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:89) at org.jfree.report.states.datarow.DefaultFlowController.performSubReportQuery(DefaultFlowController.java:207) at org.jfree.report.states.process.ProcessState.<init>(ProcessState.java:150) at org.jfree.report.states.process.ProcessDetailsHandler.commit(ProcessDetailsHandler.java:88) at org.jfree.report.states.process.ProcessState.commit(ProcessState.java:320) at org.jfree.report.layout.output.AbstractReportProcessor.processPage(AbstractReportProcessor.java:1052) at org.jfree.report.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1116) at org.pentaho.platform.plugin.action.jfreereport.JFreeReportComponent.writePdf(JFreeReportComponent.java:1089) at org.pentaho.platform.plugin.action.jfreereport.JFreeReportComponent.writeReport(JFreeReportComponent.java:958) at org.pentaho.platform.plugin.action.jfreereport.JFreeReportComponent.generateReport(JFreeReportComponent.java:911) at org.pentaho.platform.plugin.action.jfreereport.JFreeReportComponent.executeReportAction(JFreeReportComponent.java:307) at org.pentaho.platform.plugin.action.jfreereport.JFreeReportComponent.executeAction(JFreeReportComponent.java:295) 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 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 org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:55) 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:57:37,703 ERROR [SQLLookupRule] Error end:

    Pentaho BI Platform Tracking | 8 years ago | Jared Pshedesky
    java.sql.SQLException: Unknown JDBC escape sequence: {{PREPARELATER:Customers} GROUP BY PRODUCTS.PRODUCTLINE ORDER BY 2 DESC
  2. 0

    HSQLDB issue: Using HSQL as backend for the existing MVC application using JDBC template

    Stack Overflow | 5 years ago | AbdulAziz
    java.sql.SQLException: Table not found in statement [select id, description, price from products]
  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

      Unknown JDBC escape sequence: {{PREPARELATER:Customers} GROUP BY PRODUCTS.PRODUCTLINE ORDER BY 2 DESC

      at org.hsqldb.jdbc.jdbcConnection.onStartEscapeSequence()
    2. HSQLDB
      jdbcStatement.executeQuery
      1. org.hsqldb.jdbc.jdbcConnection.onStartEscapeSequence(Unknown Source)
      2. org.hsqldb.jdbc.jdbcConnection.nativeSQL(Unknown Source)
      3. org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
      4. org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
      4 frames
    3. Commons DBCP
      DelegatingStatement.executeQuery
      1. org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
      1 frame
    4. org.pentaho.platform
      PentahoTableDataFactory.queryData
      1. org.pentaho.platform.plugin.services.connections.sql.SQLConnection.executeQuery(SQLConnection.java:294)
      2. org.pentaho.platform.plugin.services.connections.sql.SQLConnection.executeQuery(SQLConnection.java:266)
      3. org.pentaho.platform.plugin.action.sql.SQLBaseComponent.executePrepared(SQLBaseComponent.java:443)
      4. org.pentaho.platform.plugin.action.jfreereport.helper.PentahoTableDataFactory.queryData(PentahoTableDataFactory.java:116)
      4 frames
    5. org.jfree.report
      AbstractReportProcessor.processReport
      1. org.jfree.report.states.CachingDataFactory.queryData(CachingDataFactory.java:284)
      2. org.jfree.report.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:89)
      3. org.jfree.report.states.datarow.DefaultFlowController.performSubReportQuery(DefaultFlowController.java:207)
      4. org.jfree.report.states.process.ProcessState.<init>(ProcessState.java:150)
      5. org.jfree.report.states.process.ProcessDetailsHandler.commit(ProcessDetailsHandler.java:88)
      6. org.jfree.report.states.process.ProcessState.commit(ProcessState.java:320)
      7. org.jfree.report.layout.output.AbstractReportProcessor.processPage(AbstractReportProcessor.java:1052)
      8. org.jfree.report.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1116)
      8 frames
    6. org.pentaho.platform
      ViewAction.doGet
      1. org.pentaho.platform.plugin.action.jfreereport.JFreeReportComponent.writePdf(JFreeReportComponent.java:1089)
      2. org.pentaho.platform.plugin.action.jfreereport.JFreeReportComponent.writeReport(JFreeReportComponent.java:958)
      3. org.pentaho.platform.plugin.action.jfreereport.JFreeReportComponent.generateReport(JFreeReportComponent.java:911)
      4. org.pentaho.platform.plugin.action.jfreereport.JFreeReportComponent.executeReportAction(JFreeReportComponent.java:307)
      5. org.pentaho.platform.plugin.action.jfreereport.JFreeReportComponent.executeAction(JFreeReportComponent.java:295)
      6. org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:440)
      7. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1298)
      8. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1265)
      9. org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1174)
      10. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1127)
      11. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1012)
      12. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:908)
      13. org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:409)
      14. org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:313)
      15. org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:192)
      16. org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159)
      17. org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:141)
      18. org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:268)
      18 frames
    7. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      2 frames
    8. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    9. Acegi Security Core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
      2. org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
      3. org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
      4. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      5. org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
      6. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      7. org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341)
      8. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      8 frames
    10. org.pentaho.platform
      SecurityStartupFilter.doFilter
      1. org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:81)
      1 frame
    11. Acegi Security Core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      2. org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
      3. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      4. org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
      5. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      5 frames
    12. org.pentaho.platform
      RequestParameterAuthenticationFilter.doFilter
      1. org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164)
      1 frame
    13. Acegi Security Core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      2. org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
      3. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      4. org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
      5. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      6. org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
      7. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      7 frames
    14. org.pentaho.platform
      HttpSessionReuseDetectionFilter.doFilter
      1. org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:129)
      1 frame
    15. Acegi Security Core
      FilterToBeanProxy.doFilter
      1. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      2. org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
      3. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      4. org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
      5. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
      6. org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
      7. org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
      7 frames
    16. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    17. org.pentaho.platform
      SystemStatusFilter.doFilter
      1. org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:55)
      1 frame
    18. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    19. org.pentaho.platform
      SetCharacterEncodingFilter.doFilter
      1. org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
      1 frame
    20. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
      6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      8. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
      9. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
      9 frames
    21. Grizzly HTTP
      LeaderFollowerWorkerThread.runIt
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
      2. org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
      3. org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
      4. org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
      4 frames
    22. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
      1 frame
    23. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame