java.sql.SQLException: Not a condition

Pentaho BI Platform Tracking | James Dixon | 9 years ago
  1. 0

    Whilst fiddling with metadata models I got the following error message on the console. Without knowing the SQL statement being executed its hard to diagnose and fix problems: 22:38:28,557 ERROR [SQLLookupRule] Error Start: Pentaho 1.6.0 build 782 RC1 22:38:28,557 ERROR [SQLLookupRule] 187817a9-51eb-11dc-869c-6728c2707b39:COMPONENT:context-2384903-1187923108396:InMemorySolution SQLBaseComponent.ERROR_0006 - Could not execute InMemorySolution java.sql.SQLException: Not a condition 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.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:169) at org.pentaho.data.connection.sql.SQLConnection.executeQuery(SQLConnection.java:230) at org.pentaho.plugin.sql.SQLBaseComponent.runQuery(SQLBaseComponent.java:558) at org.pentaho.plugin.sql.SQLBaseComponent.executeAction(SQLBaseComponent.java:303) at org.pentaho.plugin.mql.MQLRelationalDataComponent.executeAction(MQLRelationalDataComponent.java:117) at org.pentaho.plugin.ComponentBase.execute(ComponentBase.java:437) at org.pentaho.core.runtime.RuntimeContextBase.executeComponent(RuntimeContextBase.java:1097) at org.pentaho.core.runtime.RuntimeContextBase.executeAction(RuntimeContextBase.java:1071) at org.pentaho.core.runtime.RuntimeContextBase.performActions(RuntimeContextBase.java:986) at org.pentaho.core.runtime.RuntimeContextBase.executeLoop(RuntimeContextBase.java:942) at org.pentaho.core.runtime.RuntimeContextBase.executeSequence(RuntimeContextBase.java:847) at org.pentaho.core.runtime.RuntimeContextBase.executeSequence(RuntimeContextBase.java:754) at org.pentaho.core.solution.SolutionEngineBase.executeInternal(SolutionEngineBase.java:298) at org.pentaho.core.solution.SolutionEngineBase.execute(SolutionEngineBase.java:232) at org.pentaho.core.solution.SolutionEngineBase.execute(SolutionEngineBase.java:171) at org.pentaho.ui.servlet.AdhocWebService.executeActionSequence(AdhocWebService.java:385) at org.pentaho.ui.servlet.AdhocWebService.generatePreview(AdhocWebService.java:338) at org.pentaho.ui.servlet.AdhocWebService.dispatch(AdhocWebService.java:245) at org.pentaho.ui.servlet.AdhocWebService.doGet(AdhocWebService.java:207) at org.pentaho.ui.servlet.AdhocWebService.doPost(AdhocWebService.java:275)

    Pentaho BI Platform Tracking | 9 years ago | James Dixon
    java.sql.SQLException: Not a condition
  2. 0

    Whilst fiddling with metadata models I got the following error message on the console. Without knowing the SQL statement being executed its hard to diagnose and fix problems: 22:38:28,557 ERROR [SQLLookupRule] Error Start: Pentaho 1.6.0 build 782 RC1 22:38:28,557 ERROR [SQLLookupRule] 187817a9-51eb-11dc-869c-6728c2707b39:COMPONENT:context-2384903-1187923108396:InMemorySolution SQLBaseComponent.ERROR_0006 - Could not execute InMemorySolution java.sql.SQLException: Not a condition 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.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:169) at org.pentaho.data.connection.sql.SQLConnection.executeQuery(SQLConnection.java:230) at org.pentaho.plugin.sql.SQLBaseComponent.runQuery(SQLBaseComponent.java:558) at org.pentaho.plugin.sql.SQLBaseComponent.executeAction(SQLBaseComponent.java:303) at org.pentaho.plugin.mql.MQLRelationalDataComponent.executeAction(MQLRelationalDataComponent.java:117) at org.pentaho.plugin.ComponentBase.execute(ComponentBase.java:437) at org.pentaho.core.runtime.RuntimeContextBase.executeComponent(RuntimeContextBase.java:1097) at org.pentaho.core.runtime.RuntimeContextBase.executeAction(RuntimeContextBase.java:1071) at org.pentaho.core.runtime.RuntimeContextBase.performActions(RuntimeContextBase.java:986) at org.pentaho.core.runtime.RuntimeContextBase.executeLoop(RuntimeContextBase.java:942) at org.pentaho.core.runtime.RuntimeContextBase.executeSequence(RuntimeContextBase.java:847) at org.pentaho.core.runtime.RuntimeContextBase.executeSequence(RuntimeContextBase.java:754) at org.pentaho.core.solution.SolutionEngineBase.executeInternal(SolutionEngineBase.java:298) at org.pentaho.core.solution.SolutionEngineBase.execute(SolutionEngineBase.java:232) at org.pentaho.core.solution.SolutionEngineBase.execute(SolutionEngineBase.java:171) at org.pentaho.ui.servlet.AdhocWebService.executeActionSequence(AdhocWebService.java:385) at org.pentaho.ui.servlet.AdhocWebService.generatePreview(AdhocWebService.java:338) at org.pentaho.ui.servlet.AdhocWebService.dispatch(AdhocWebService.java:245) at org.pentaho.ui.servlet.AdhocWebService.doGet(AdhocWebService.java:207) at org.pentaho.ui.servlet.AdhocWebService.doPost(AdhocWebService.java:275)

    Pentaho BI Platform Tracking | 9 years ago | James Dixon
    java.sql.SQLException: Not a condition
  3. 0

    One of the charts in the Chart Samples Dashboard (http://localhost:8080/pentaho/ChartSamplesDashboard) has a problem. Exceptions in the console and the chart fails to render. 10:21:09,109 INFO [STDOUT] 10:21:09,109 ERROR [SQLLookupRule] 15e1e04b-5fd5-11dd-b822-eb9f70840f19:COMPONENT:context-22396601-1217600469078:timeserieschart_data.xactionSQLBaseComponent.ERROR_0006 - C ould not execute timeserieschart_data.xaction java.sql.SQLException: Wrong data type: java.lang.NumberFormatException: For input string: "JAN" 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.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:171) at org.pentaho.data.connection.sql.SQLConnection.executeQuery(SQLConnection.java:282) at org.pentaho.data.connection.sql.SQLConnection.executeQuery(SQLConnection.java:253) at org.pentaho.plugin.sql.SQLBaseComponent.doQuery(SQLBaseComponent.java:589) at org.pentaho.plugin.sql.SQLBaseComponent.runQuery(SQLBaseComponent.java:504) at org.pentaho.plugin.sql.SQLBaseComponent.executeAction(SQLBaseComponent.java:234) at org.pentaho.plugin.ComponentBase.execute(ComponentBase.java:459) at org.pentaho.core.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1142) at org.pentaho.core.runtime.RuntimeContext.executeAction(RuntimeContext.java:1114) at org.pentaho.core.runtime.RuntimeContext.performActions(RuntimeContext.java:1026) at org.pentaho.core.runtime.RuntimeContext.executeLoop(RuntimeContext.java:981) at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContext.java:884) at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContext.java:780) at org.pentaho.core.solution.SolutionEngine.executeInternal(SolutionEngine.java:333) at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:241) at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:169) at com.pentaho.core.solution.ProSolutionEngine.execute(ProSolutionEngine.java:88) at org.pentaho.ui.component.charting.AbstractChartComponent.getActionData(AbstractChartComponent.java:167) at org.pentaho.ui.component.charting.TimeSeriesCollectionChartComponent.createChart(TimeSeriesCollectionChartComponent.java:87) at org.pentaho.ui.component.charting.TimeSeriesCollectionChartComponent.getXmlContent(TimeSeriesCollectionChartComponent.java:155) at org.pentaho.ui.XmlComponent.getContent(XmlComponent.java:46) at org.pentaho.ui.ChartHelper.doChart(ChartHelper.java:279) at org.apache.jsp.jsp.ChartSamplesDashboard_jsp._jspService(ChartSamplesDashboard_jsp.java:211) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:387) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 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 com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) 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 com.pentaho.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 com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) 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: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.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) 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:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241) at org.apache.coyote.http1 10:21:09,125 INFO [STDOUT] 1.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) 10:21:09,125 INFO [STDOUT] 10:21:09,125 ERROR [SQLLookupRule] Error end: 10:21:09,125 INFO [STDOUT] 10:21:09,125 ERROR [RuntimeContext] 15e1e04b-5fd5-11dd-b822-eb9f70840f19:RUNTIME:context-22396601-1217600469078:timeserieschart_data.xaction RuntimeContext.ERROR_0012 - Act ionDefinition for SQLLookupRule did not execute successfully 10:21:09,125 INFO [STDOUT] 10:21:09,125 ERROR [ProSolutionEngine] 15e1e04b-5fd5-11dd-b822-eb9f70840f19:SOLUTION-ENGINE:timeserieschart_data.xaction: SolutionEngine.ERROR_0007 - Action sequence execut ion failed

    Pentaho BI Platform Tracking | 8 years ago | Jared Pshedesky
    java.sql.SQLException: Wrong data type: java.lang.NumberFormatException: For input string: "JAN"
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    One of the charts in the Chart Samples Dashboard (http://localhost:8080/pentaho/ChartSamplesDashboard) has a problem. Exceptions in the console and the chart fails to render. 10:21:09,109 INFO [STDOUT] 10:21:09,109 ERROR [SQLLookupRule] 15e1e04b-5fd5-11dd-b822-eb9f70840f19:COMPONENT:context-22396601-1217600469078:timeserieschart_data.xactionSQLBaseComponent.ERROR_0006 - C ould not execute timeserieschart_data.xaction java.sql.SQLException: Wrong data type: java.lang.NumberFormatException: For input string: "JAN" 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.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:171) at org.pentaho.data.connection.sql.SQLConnection.executeQuery(SQLConnection.java:282) at org.pentaho.data.connection.sql.SQLConnection.executeQuery(SQLConnection.java:253) at org.pentaho.plugin.sql.SQLBaseComponent.doQuery(SQLBaseComponent.java:589) at org.pentaho.plugin.sql.SQLBaseComponent.runQuery(SQLBaseComponent.java:504) at org.pentaho.plugin.sql.SQLBaseComponent.executeAction(SQLBaseComponent.java:234) at org.pentaho.plugin.ComponentBase.execute(ComponentBase.java:459) at org.pentaho.core.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1142) at org.pentaho.core.runtime.RuntimeContext.executeAction(RuntimeContext.java:1114) at org.pentaho.core.runtime.RuntimeContext.performActions(RuntimeContext.java:1026) at org.pentaho.core.runtime.RuntimeContext.executeLoop(RuntimeContext.java:981) at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContext.java:884) at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContext.java:780) at org.pentaho.core.solution.SolutionEngine.executeInternal(SolutionEngine.java:333) at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:241) at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:169) at com.pentaho.core.solution.ProSolutionEngine.execute(ProSolutionEngine.java:88) at org.pentaho.ui.component.charting.AbstractChartComponent.getActionData(AbstractChartComponent.java:167) at org.pentaho.ui.component.charting.TimeSeriesCollectionChartComponent.createChart(TimeSeriesCollectionChartComponent.java:87) at org.pentaho.ui.component.charting.TimeSeriesCollectionChartComponent.getXmlContent(TimeSeriesCollectionChartComponent.java:155) at org.pentaho.ui.XmlComponent.getContent(XmlComponent.java:46) at org.pentaho.ui.ChartHelper.doChart(ChartHelper.java:279) at org.apache.jsp.jsp.ChartSamplesDashboard_jsp._jspService(ChartSamplesDashboard_jsp.java:211) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:387) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 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 com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) 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 com.pentaho.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 com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) 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: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.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) 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:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241) at org.apache.coyote.http1 10:21:09,125 INFO [STDOUT] 1.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) 10:21:09,125 INFO [STDOUT] 10:21:09,125 ERROR [SQLLookupRule] Error end: 10:21:09,125 INFO [STDOUT] 10:21:09,125 ERROR [RuntimeContext] 15e1e04b-5fd5-11dd-b822-eb9f70840f19:RUNTIME:context-22396601-1217600469078:timeserieschart_data.xaction RuntimeContext.ERROR_0012 - Act ionDefinition for SQLLookupRule did not execute successfully 10:21:09,125 INFO [STDOUT] 10:21:09,125 ERROR [ProSolutionEngine] 15e1e04b-5fd5-11dd-b822-eb9f70840f19:SOLUTION-ENGINE:timeserieschart_data.xaction: SolutionEngine.ERROR_0007 - Action sequence execut ion failed

    Pentaho BI Platform Tracking | 8 years ago | Jared Pshedesky
    java.sql.SQLException: Wrong data type: java.lang.NumberFormatException: For input string: "JAN"
  6. 0

    how to resolve java.sql.SQLException: Table not found in statement

    Stack Overflow | 4 years ago | user1551750
    java.sql.SQLException: Table not found in statement [select * from "PUBLIC"."xxx"]

    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

      Not a condition

      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. JBoss Application Server Connector
      WrappedStatement.executeQuery
      1. org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:169)
      1 frame
    4. org.pentaho.data
      SQLConnection.executeQuery
      1. org.pentaho.data.connection.sql.SQLConnection.executeQuery(SQLConnection.java:230)
      1 frame
    5. org.pentaho.plugin
      ComponentBase.execute
      1. org.pentaho.plugin.sql.SQLBaseComponent.runQuery(SQLBaseComponent.java:558)
      2. org.pentaho.plugin.sql.SQLBaseComponent.executeAction(SQLBaseComponent.java:303)
      3. org.pentaho.plugin.mql.MQLRelationalDataComponent.executeAction(MQLRelationalDataComponent.java:117)
      4. org.pentaho.plugin.ComponentBase.execute(ComponentBase.java:437)
      4 frames
    6. org.pentaho.core
      SolutionEngineBase.execute
      1. org.pentaho.core.runtime.RuntimeContextBase.executeComponent(RuntimeContextBase.java:1097)
      2. org.pentaho.core.runtime.RuntimeContextBase.executeAction(RuntimeContextBase.java:1071)
      3. org.pentaho.core.runtime.RuntimeContextBase.performActions(RuntimeContextBase.java:986)
      4. org.pentaho.core.runtime.RuntimeContextBase.executeLoop(RuntimeContextBase.java:942)
      5. org.pentaho.core.runtime.RuntimeContextBase.executeSequence(RuntimeContextBase.java:847)
      6. org.pentaho.core.runtime.RuntimeContextBase.executeSequence(RuntimeContextBase.java:754)
      7. org.pentaho.core.solution.SolutionEngineBase.executeInternal(SolutionEngineBase.java:298)
      8. org.pentaho.core.solution.SolutionEngineBase.execute(SolutionEngineBase.java:232)
      9. org.pentaho.core.solution.SolutionEngineBase.execute(SolutionEngineBase.java:171)
      9 frames
    7. org.pentaho.ui
      AdhocWebService.doPost
      1. org.pentaho.ui.servlet.AdhocWebService.executeActionSequence(AdhocWebService.java:385)
      2. org.pentaho.ui.servlet.AdhocWebService.generatePreview(AdhocWebService.java:338)
      3. org.pentaho.ui.servlet.AdhocWebService.dispatch(AdhocWebService.java:245)
      4. org.pentaho.ui.servlet.AdhocWebService.doGet(AdhocWebService.java:207)
      5. org.pentaho.ui.servlet.AdhocWebService.doPost(AdhocWebService.java:275)
      5 frames