Home > database >  Kettle table output error, what reason be excuse me
Kettle table output error, what reason be excuse me

Time:09-26

2017/09/06 10:44:49 CLUSTER_SPDA - to transform to remove patch began [CLUSTER_SPDA]
2017/09/06 10:44:49 - table output. 0 and Connected to the database [TIDB_CLUSTER] (commit=20000)
2017/09/06 10:44:52 - table output. 0 - ERROR (version 6.1.0.1-196, build 1 from the 2016-04-07 12.08.49 by buildguy) : Because of an ERROR, this step can 't continue:
2017/09/06 10:44:52 - table output. 0 - ERROR (version 6.1.0.1-196, build 1 from the 2016-04-07 12.08.49 by buildguy) : org. Pentaho. Di. Core. Exception. KettleException:
2017/09/06 10:44:52 - table output. 0 - Error batch inserting rows into the table [xt_goods].
2017/09/06 10:44:52 - table output. 0 - Errors encountered (first) :
2017/09/06 10:44:52 - table output. 0
2017/09/06 10:44:52 - table output. 0
2017/09/06 10:44:52 - table output. 0 - Error updating batch
2017/09/06 10:44:52 - table output. 0 - Parameter index out of bounds. 40353 is not between the valid values of 1 and 40352
2017/09/06 10:44:52 - table output. 0
2017/09/06 10:44:52 - table output. 0
2017/09/06 10:44:52 - table output. 0 - at org. Pentaho. Di. Trans. Steps. Tableoutput. Tableoutput. WriteToTable (tableoutput. Java: 342)
2017/09/06 10:44:52 - table output. 0 - at org. Pentaho. Di. Trans. Steps. Tableoutput. Tableoutput. The processRow (tableoutput. Java: 118)
2017/09/06 10:44:52 - table output. 0 - at org. Pentaho. Di. Trans. Step. RunThread. Run (62) RunThread. Java:
2017/09/06 10:44:52 - table output. 0 - at Java. Lang. Thread. The run (745) Thread. Java:
2017/09/06 10:44:52 - table output. 0 - under Caused by: org. Pentaho. Di. Core. Exception. KettleDatabaseBatchException:
2017/09/06 10:44:52 - table output. 0 - Error updating batch
2017/09/06 10:44:52 - table output. 0 - Parameter index out of bounds. 40353 is not between the valid values of 1 and 40352
2017/09/06 10:44:52 - table output. 0
2017/09/06 10:44:52 - table output. 0 - at org. Pentaho. Di. Core. The database. Database. CreateKettleDatabaseBatchException (1379). The database Java:
2017/09/06 10:44:52 - table output. 0 - at org. Pentaho. Di. Trans. Steps. Tableoutput. Tableoutput. WriteToTable (tableoutput. Java: 289)
2017/09/06 10:44:52 - table output. 0 -... 3 more
2017/09/06 10:44:52 - table output. 0 - under Caused by: Java, SQL. SQLException: Parameter index out of bounds. 40353 is not between valid values of 1 and 40352
2017/09/06 10:44:52 - table output. 0 - at com. Mysql. JDBC. SQLError. CreateSQLException (SQLError. Java: 964)
2017/09/06 10:44:52 - table output. 0 - at com. Mysql. JDBC. SQLError. CreateSQLException (SQLError. Java: 897)
2017/09/06 10:44:52 - table output. 0 - at com. Mysql. JDBC. SQLError. CreateSQLException (SQLError. Java: 886)
2017/09/06 10:44:52 - table output. 0 - at com. Mysql. JDBC. SQLError. CreateSQLException (SQLError. Java: 860)
2017/09/06 10:44:52 - table output. 0 - at com. Mysql. JDBC. ServerPreparedStatement. GetBinding (ServerPreparedStatement. Java: 862)
2017/09/06 10:44:52 - table output. 0 - at com. Mysql. JDBC. ServerPreparedStatement. SetString (ServerPreparedStatement. Java: 1974)
2017/09/06 10:44:52 - table output. 0 - at com. Mysql. JDBC. ServerPreparedStatement. SetOneBatchedParameterSet (ServerPreparedStatement. Java: 2750)
2017/09/06 10:44:52 - table output. 0 - at com. Mysql.. JDBC PreparedStatement. ExecuteBatchedInserts (1544) a PreparedStatement. Java:
2017/09/06 10:44:52 - table output. 0 - at com. Mysql.. JDBC PreparedStatement. ExecuteBatchInternal (1253) a PreparedStatement. Java:
2017/09/06 10:44:52 - table output. 0 - at com. Mysql. JDBC. StatementImpl. ExecuteBatch (StatementImpl. Java: 970)
2017/09/06 10:44:52 - table output. 0 - at org. Pentaho. Di. Trans. Steps. Tableoutput. Tableoutput. WriteToTable (tableoutput. Java: 285)
2017/09/06 10:44:52 - table output. 0 -... 3 more
2017/09/06 10:44:53 - table output. 0 - ERROR (version 6.1.0.1-196, build 1 from the 2016-04-07 12.08.49 by buildguy) : Unexpected batch update ERROR committing the database connection.
2017/09/06 10:44:53 - table output. 0 - ERROR (version 6.1.0.1-196, build 1 from the 2016-04-07 12.08.49 by buildguy) : org. Pentaho. Di. Core. Exception. KettleDatabaseBatchException:
2017/09/06 10:44:53 - table output. 0 - Error updating batch
2017/09/06 10:44:53 - table output. 0 - Could not retrieve the transaction the read - only the status from server
2017/09/06 10:44:53 - table output. 0
2017/09/06 10:44:53 - table output. 0 - at org. Pentaho. Di. Core. The database. Database. CreateKettleDatabaseBatchException (1379). The database Java:
2017/09/06 10:44:53 - table output. 0 - at org. Pentaho. Di. Core. The database. Database. EmptyAndCommit (1371). The database Java:
2017/09/06 10:44:53 - table output. 0 - at org. Pentaho. Di. Trans. Steps. Tableoutput. Tableoutput. The dispose (tableoutput. Java: 575)
2017/09/06 10:44:53 - table output. 0 - at org. Pentaho. Di. Trans. Step. RunThread. Run (96) RunThread. Java:
2017/09/06 10:44:53 - table output. 0 - at Java. Lang. Thread. The run (745) Thread. Java:
2017/09/06 10:44:53 - table output. 0 - under Caused by: Java, SQL. SQLException: Could not retrieve the transaction the read - only the status from server
2017/09/06 10:44:53 - table output. 0 - at com. Mysql. JDBC. SQLError. CreateSQLException (SQLError. Java: 964)
2017/09/06 10:44:53 - table output. 0 - at com. Mysql. JDBC. SQLError. CreateSQLException (SQLError. Java: 897)
2017/09/06 10:44:53 - table output. 0 - at com. Mysql. JDBC. SQLError. CreateSQLException (SQLError. Java: 886)
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
  • Related