com.hp.t4jdbc.HPT4Exception: The message id: invalid_parameter_value With parameters: Timestamp data format is incorrect for column: 0 = 2005-01-01

Pentaho BI Platform Tracking | Jens Bleuel | 9 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

    To reproduce: http://localhost:8080/pentaho/ViewAction?solution=samples&path=steel-wheels/reports&action=Sales_by_Customer.xaction Leave the default date (Jan 01 2005 - May 31 2005) Select Web Page Run Report ERROR [org.pentaho.plugin.sql.SQLLookupRule] fd4512da-0b29-11dd-9382-61d155a81001:COMPONENT:context-33228358-1208291086171:Sales_by_Customer.xactionSQLBaseComponent.ERROR_0006 - Fehler beim Ausführen von Sales_by_Customer.xaction com.hp.t4jdbc.HPT4Exception: The message id: invalid_parameter_value With parameters: Timestamp data format is incorrect for column: 0 = 2005-01-01 at com.hp.t4jdbc.HPT4Messages.createSQLException(HPT4Messages.java:326) at com.hp.t4jdbc.HPT4Messages.createSQLException(HPT4Messages.java:232) at com.hp.t4jdbc.InterfaceStatement.convertObjectToSQL2(InterfaceStatement.java:314) at com.hp.t4jdbc.InterfaceStatement.fillInSQLValues2(InterfaceStatement.java:806) at com.hp.t4jdbc.InterfaceStatement.execute(InterfaceStatement.java:1319) at com.hp.t4jdbc.HPT4PreparedStatement.execute(HPT4PreparedStatement.java:2952) at com.hp.t4jdbc.HPT4PreparedStatement.executeQuery(HPT4PreparedStatement.java:404) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236) at org.pentaho.data.connection.sql.SQLConnection.prepareAndExecuteQuery(SQLConnection.java:255) at org.pentaho.plugin.sql.SQLBaseComponent.runQuery(SQLBaseComponent.java:565)

    Pentaho BI Platform Tracking | 9 years ago | Jens Bleuel
    com.hp.t4jdbc.HPT4Exception: The message id: invalid_parameter_value With parameters: Timestamp data format is incorrect for column: 0 = 2005-01-01
  2. 0

    To reproduce: http://localhost:8080/pentaho/ViewAction?solution=samples&path=steel-wheels/reports&action=Sales_by_Customer.xaction Leave the default date (Jan 01 2005 - May 31 2005) Select Web Page Run Report ERROR [org.pentaho.plugin.sql.SQLLookupRule] fd4512da-0b29-11dd-9382-61d155a81001:COMPONENT:context-33228358-1208291086171:Sales_by_Customer.xactionSQLBaseComponent.ERROR_0006 - Fehler beim Ausführen von Sales_by_Customer.xaction com.hp.t4jdbc.HPT4Exception: The message id: invalid_parameter_value With parameters: Timestamp data format is incorrect for column: 0 = 2005-01-01 at com.hp.t4jdbc.HPT4Messages.createSQLException(HPT4Messages.java:326) at com.hp.t4jdbc.HPT4Messages.createSQLException(HPT4Messages.java:232) at com.hp.t4jdbc.InterfaceStatement.convertObjectToSQL2(InterfaceStatement.java:314) at com.hp.t4jdbc.InterfaceStatement.fillInSQLValues2(InterfaceStatement.java:806) at com.hp.t4jdbc.InterfaceStatement.execute(InterfaceStatement.java:1319) at com.hp.t4jdbc.HPT4PreparedStatement.execute(HPT4PreparedStatement.java:2952) at com.hp.t4jdbc.HPT4PreparedStatement.executeQuery(HPT4PreparedStatement.java:404) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236) at org.pentaho.data.connection.sql.SQLConnection.prepareAndExecuteQuery(SQLConnection.java:255) at org.pentaho.plugin.sql.SQLBaseComponent.runQuery(SQLBaseComponent.java:565)

    Pentaho BI Platform Tracking | 9 years ago | Jens Bleuel
    com.hp.t4jdbc.HPT4Exception: The message id: invalid_parameter_value With parameters: Timestamp data format is incorrect for column: 0 = 2005-01-01

    Root Cause Analysis

    1. com.hp.t4jdbc.HPT4Exception

      The message id: invalid_parameter_value With parameters: Timestamp data format is incorrect for column: 0 = 2005-01-01

      at com.hp.t4jdbc.HPT4Messages.createSQLException()
    2. com.hp.t4jdbc
      HPT4PreparedStatement.executeQuery
      1. com.hp.t4jdbc.HPT4Messages.createSQLException(HPT4Messages.java:326)
      2. com.hp.t4jdbc.HPT4Messages.createSQLException(HPT4Messages.java:232)
      3. com.hp.t4jdbc.InterfaceStatement.convertObjectToSQL2(InterfaceStatement.java:314)
      4. com.hp.t4jdbc.InterfaceStatement.fillInSQLValues2(InterfaceStatement.java:806)
      5. com.hp.t4jdbc.InterfaceStatement.execute(InterfaceStatement.java:1319)
      6. com.hp.t4jdbc.HPT4PreparedStatement.execute(HPT4PreparedStatement.java:2952)
      7. com.hp.t4jdbc.HPT4PreparedStatement.executeQuery(HPT4PreparedStatement.java:404)
      7 frames
    3. JBoss Application Server Connector
      WrappedPreparedStatement.executeQuery
      1. org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
      1 frame
    4. org.pentaho.data
      SQLConnection.prepareAndExecuteQuery
      1. org.pentaho.data.connection.sql.SQLConnection.prepareAndExecuteQuery(SQLConnection.java:255)
      1 frame
    5. org.pentaho.plugin
      SQLBaseComponent.runQuery
      1. org.pentaho.plugin.sql.SQLBaseComponent.runQuery(SQLBaseComponent.java:565)
      1 frame