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
  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