java.sql.SQLException: Wrong data type: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

Pentaho BI Platform Tracking | Aliaksandr Bialkevich | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    1.Login into PUC 2.Run report from /public/bi-developers/legacy-steel-wheels/steel-wheels-3.0/order_detail.xaction. Actual result: Order_detail.xaction fails and throws exception in tomcat. "Wrong data type: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]" Expected result: the report file should run without errors. Additional info: Log file contains the following: 2015-03-23 16:34:26,897 ERROR [org.pentaho.platform.plugin.action.sql.SQLLookupRule] Error Start: Pentaho Pentaho Business Analytics Server Enterprise Edition MASTER-NIGHTLY-205 2015-03-23 16:34:26,901 ERROR [org.pentaho.platform.plugin.action.sql.SQLLookupRule] 52202a12-d161-11e4-8c5b-080027ea3b37:COMPONENT:context-1798184209-1427117664783:order_detail.xactionSQLBaseComponent.ERROR_0006 - Could not execute order_detail.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.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.setParameter(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.setObject(Unknown Source) at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:169) at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:169) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.prepareAndExecuteQuery(SQLConnection.java:520) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.prepareAndExecuteQuery(SQLConnection.java:418) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.doQuery(SQLBaseComponent.java:650) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.runQuery(SQLBaseComponent.java:570)

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

    1.Login into PUC 2.Run report from /public/bi-developers/legacy-steel-wheels/steel-wheels-3.0/order_detail.xaction. Actual result: Order_detail.xaction fails and throws exception in tomcat. "Wrong data type: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]" Expected result: the report file should run without errors. Additional info: Log file contains the following: 2015-03-23 16:34:26,897 ERROR [org.pentaho.platform.plugin.action.sql.SQLLookupRule] Error Start: Pentaho Pentaho Business Analytics Server Enterprise Edition MASTER-NIGHTLY-205 2015-03-23 16:34:26,901 ERROR [org.pentaho.platform.plugin.action.sql.SQLLookupRule] 52202a12-d161-11e4-8c5b-080027ea3b37:COMPONENT:context-1798184209-1427117664783:order_detail.xactionSQLBaseComponent.ERROR_0006 - Could not execute order_detail.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.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.setParameter(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.setObject(Unknown Source) at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:169) at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:169) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.prepareAndExecuteQuery(SQLConnection.java:520) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.prepareAndExecuteQuery(SQLConnection.java:418) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.doQuery(SQLBaseComponent.java:650) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.runQuery(SQLBaseComponent.java:570)

    Pentaho BI Platform Tracking | 2 years ago | Aliaksandr Bialkevich
    java.sql.SQLException: Wrong data type: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
  3. 0

    [SAK-8895] Warehouse Task fails in Oracle - TImestamp issue - Sakai

    sakaiproject.org | 10 months ago
    java.sql.SQLException: Wrong data type: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Run the Samples>Steel Wheels>Pentaho Reporting>Steel Wheels- Order Status and Detail Report. The report fails in the PUC and shows the following error message. Failed Error: SQLBaseComponent.ERROR_0006 - Could not execute order_detail.xaction - java.sql.SQLException: Wrong data type: java.lang.NumberFormatException: For input string: "" (org.pentaho.platform.plugin.action.sql.SQLLookupRule) Debug: Starting execute of samples/steel-wheels/reports/order_detail.xaction (org.pentaho.platform.engine.services.solution.SolutionEngine) Debug: Getting runtime context and data (org.pentaho.platform.engine.services.solution.SolutionEngine) Debug: Loading action sequence definition file (org.pentaho.platform.engine.services.solution.SolutionEngine) Debug: audit: instanceId=03c7383f-a475-11de-813b-5f50efd5826d, 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 order_detail.xaction - java.sql.SQLException: Wrong data type: java.lang.NumberFormatException: For input string: "" (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 (org.pentaho.platform.engine.services.solution.SolutionEngine) Server Version: Pentaho Platform Core CITRUS-NIGHTLY.development It also throws the following exception in tomcat. 13:02:12,453 ERROR [RuntimeContext] 01c91e4e-a475-11de-813b-5f50efd5826d:RUNTIME:context-25187846-1253293331578:invent_subscribe.xaction RuntimeContext.ERROR_0029 - Error output parameter "ConfMessage" not found during save. 13:02:15,062 ERROR [SQLLookupRule] Error Start: Pentaho Pentaho Platform Core CITRUS-NIGHTLY.development 13:02:15,062 ERROR [SQLLookupRule] 03c7383f-a475-11de-813b-5f50efd5826d:COMPONENT:context-1031348-1253293334921:order_detail.xactionSQLBaseComponent.ERROR_0006 - Could not execute order_detail.xaction java.sql.SQLException: Wrong data type: java.lang.NumberFormatException: For input string: "" at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.setParameter(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.setObject(Unknown Source) at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:165) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.prepareAndExecuteQuery(SQLConnection.java:475) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.prepareAndExecuteQuery(SQLConnection.java:387) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.doQuery(SQLBaseComponent.java:624) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.runQuery(SQLBaseComponent.java:545) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.executeAction(SQLBaseComponent.java:257) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:463) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1331) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1298) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1216) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1165) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1045) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:938) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:413) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:316) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:192) at sun.reflect.GeneratedMethodAccessor221.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.pentaho.platform.web.http.context.a.invoke(SourceFile:189) at $Proxy9.execute(Unknown Source) at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159) at org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:148) at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:275) 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.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile: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(Thread.java:595) 13:02:15,078 ERROR [SQLLookupRule] Error end: 13:02:15,078 ERROR [RuntimeContext] 03c7383f-a475-11de-813b-5f50efd5826d:RUNTIME:context-1031348-1253293334921:order_detail.xaction RuntimeContext.ERROR_0012 - ActionDefinition for SQLLookupRule did not execute successfully 13:02:15,093 ERROR [SolutionEngine] 03c7383f-a475-11de-813b-5f50efd5826d:SOLUTION-ENGINE:order_detail.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed

    Pentaho BI Platform Tracking | 7 years ago | Golda David
    java.sql.SQLException: Wrong data type: java.lang.NumberFormatException: For input string: ""
  6. 0

    When you run the SteelWheels Order Status and Details report, you get an error message and a server exception: Failed ________________________________________ Error: SQLBaseComponent.ERROR_0006 - Could not execute order_detail.xaction - java.sql.SQLException: Wrong data type: For input string: "" (org.pentaho.platform.plugin.action.sql.SQLLookupRule) Debug: Starting execute of samples/steel-wheels/reports/order_detail.xaction (org.pentaho.platform.engine.services.solution.SolutionEngine) Debug: Getting runtime context and data (org.pentaho.platform.engine.services.solution.SolutionEngine) Debug: Loading action sequence definition file (org.pentaho.platform.engine.services.solution.SolutionEngine) Debug: audit: instanceId=5be75906-7332-11dd-a8f6-51c10ee679a6, 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 order_detail.xaction - java.sql.SQLException: Wrong data type: For input string: "" (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 (org.pentaho.platform.engine.services.solution.SolutionEngine) !MessageFormatter.USER_SERVER_VERSION! 01:47:25,656 ERROR [SQLLookupRule] Error Start: Pentaho Pentaho Platform Engine Core 2.0.0-M1 01:47:25,703 ERROR [SQLLookupRule] 76023d58-7332-11dd-a8f6-51c10ee679a6:COMPONENT:context-19216806-1219729645640:order_detail.xactionSQLBaseComponent.ERROR_0006 - Could not execute order_detail.xactio n java.sql.SQLException: Wrong data type: For input string: "" at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.setParameter(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.setObject(Unknown Source) at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:165) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.prepareAndExecuteQuery(SQLConnection.java:320) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.prepareAndExecuteQuery(SQLConnection.java:303) at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.doQuery(SQLBaseComponent.java:588) 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:1293) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1260) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1169) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1122) 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:151) 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) 01:47:25,703 ERROR [SQLLookupRule] Error end: 01:47:25,703 ERROR [RuntimeContext] 76023d58-7332-11dd-a8f6-51c10ee679a6:RUNTIME:context-19216806-1219729645640:order_detail.xaction RuntimeContext.ERROR_0012 - ActionDefinition for SQLLookupRule did not execute successfully 01:47:25,703 ERROR [SolutionEngine] 76023d58-7332-11dd-a8f6-51c10ee679a6:SOLUTION-ENGINE:order_detail.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed

    Pentaho BI Platform Tracking | 9 years ago | Jared Pshedesky
    java.sql.SQLException: Wrong data type: For input string: ""

    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

      Wrong data type: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

      at org.hsqldb.jdbc.Util.throwError()
    2. HSQLDB
      jdbcPreparedStatement.setObject
      1. org.hsqldb.jdbc.Util.throwError(Unknown Source)
      2. org.hsqldb.jdbc.jdbcPreparedStatement.setParameter(Unknown Source)
      3. org.hsqldb.jdbc.jdbcPreparedStatement.setObject(Unknown Source)
      3 frames
    3. Commons DBCP
      DelegatingPreparedStatement.setObject
      1. org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:169)
      2. org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:169)
      2 frames
    4. org.pentaho.platform
      SQLBaseComponent.runQuery
      1. org.pentaho.platform.plugin.services.connections.sql.SQLConnection.prepareAndExecuteQuery(SQLConnection.java:520)
      2. org.pentaho.platform.plugin.services.connections.sql.SQLConnection.prepareAndExecuteQuery(SQLConnection.java:418)
      3. org.pentaho.platform.plugin.action.sql.SQLBaseComponent.doQuery(SQLBaseComponent.java:650)
      4. org.pentaho.platform.plugin.action.sql.SQLBaseComponent.runQuery(SQLBaseComponent.java:570)
      4 frames