kettle表出输出报错,请问是什么原因
2017/09/06 10:44:49 - CLUSTER_SPDA - 为了转换解除补丁开始 [CLUSTER_SPDA]
2017/09/06 10:44:49 - 表输出.0 - Connected to database [TIDB_CLUSTER] (commit=20000)
2017/09/06 10:44:52 - 表输出.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Because of an error, this step can't continue:
2017/09/06 10:44:52 - 表输出.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : org.pentaho.di.core.exception.KettleException:
2017/09/06 10:44:52 - 表输出.0 - Error batch inserting rows into table [xt_goods].
2017/09/06 10:44:52 - 表输出.0 - Errors encountered (first 10):
2017/09/06 10:44:52 - 表输出.0 -
2017/09/06 10:44:52 - 表输出.0 -
2017/09/06 10:44:52 - 表输出.0 - Error updating batch
2017/09/06 10:44:52 - 表输出.0 - Parameter index out of bounds. 40353 is not between valid values of 1 and 40352
2017/09/06 10:44:52 - 表输出.0 -
2017/09/06 10:44:52 - 表输出.0 -
2017/09/06 10:44:52 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:342)
2017/09/06 10:44:52 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:118)
2017/09/06 10:44:52 - 表输出.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2017/09/06 10:44:52 - 表输出.0 - at java.lang.Thread.run(Thread.java:745)
2017/09/06 10:44:52 - 表输出.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseBatchException:
2017/09/06 10:44:52 - 表输出.0 - Error updating batch
2017/09/06 10:44:52 - 表输出.0 - Parameter index out of bounds. 40353 is not between valid values of 1 and 40352
2017/09/06 10:44:52 - 表输出.0 -
2017/09/06 10:44:52 - 表输出.0 - at org.pentaho.di.core.database.Database.createKettleDatabaseBatchException(Database.java:1379)
2017/09/06 10:44:52 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:289)
2017/09/06 10:44:52 - 表输出.0 - ... 3 more
2017/09/06 10:44:52 - 表输出.0 - 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 - 表输出.0 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
2017/09/06 10:44:52 - 表输出.0 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
2017/09/06 10:44:52 - 表输出.0 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
2017/09/06 10:44:52 - 表输出.0 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
2017/09/06 10:44:52 - 表输出.0 - at com.mysql.jdbc.ServerPreparedStatement.getBinding(ServerPreparedStatement.java:862)
2017/09/06 10:44:52 - 表输出.0 - at com.mysql.jdbc.ServerPreparedStatement.setString(ServerPreparedStatement.java:1974)
2017/09/06 10:44:52 - 表输出.0 - at com.mysql.jdbc.ServerPreparedStatement.setOneBatchedParameterSet(ServerPreparedStatement.java:2750)
2017/09/06 10:44:52 - 表输出.0 - at com.mysql.jdbc.PreparedStatement.executeBatchedInserts(PreparedStatement.java:1544)
2017/09/06 10:44:52 - 表输出.0 - at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1253)
2017/09/06 10:44:52 - 表输出.0 - at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:970)
2017/09/06 10:44:52 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:285)
2017/09/06 10:44:52 - 表输出.0 - ... 3 more
2017/09/06 10:44:53 - 表输出.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Unexpected batch update error committing the database connection.
2017/09/06 10:44:53 - 表输出.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseBatchException:
2017/09/06 10:44:53 - 表输出.0 - Error updating batch
2017/09/06 10:44:53 - 表输出.0 - Could not retrieve transaction read-only status from server
2017/09/06 10:44:53 - 表输出.0 -
2017/09/06 10:44:53 - 表输出.0 - at org.pentaho.di.core.database.Database.createKettleDatabaseBatchException(Database.java:1379)
2017/09/06 10:44:53 - 表输出.0 - at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1371)
2017/09/06 10:44:53 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:575)
2017/09/06 10:44:53 - 表输出.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:96)
2017/09/06 10:44:53 - 表输出.0 - at java.lang.Thread.run(Thread.java:745)
2017/09/06 10:44:53 - 表输出.0 - Caused by: java.sql.SQLException: Could not retrieve transaction read-only status from server
2017/09/06 10:44:53 - 表输出.0 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
2017/09/06 10:44:53 - 表输出.0 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
2017/09/06 10:44:53 - 表输出.0 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
2017/09/06 10:44:53 - 表输出.0 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
2017/09/06 10:44:53 - 表输出.0 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:877)
2017/09/06 10:44:53 - 表输出.0 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:873)
2017/09/06 10:44:53 - 表输出.0 - at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3557)
2017/09/06 10:44:53 - 表输出.0 - at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3526)
2017/09/06 10:44:53 - 表输出.0 - at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1230)
2017/09/06 10:44:53 - 表输出.0 - at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:970)
2017/09/06 10:44:53 - 表输出.0 - at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1355)
2017/09/06 10:44:53 - 表输出.0 - ... 3 more
2017/09/06 10:44:53 - 表输出.0 - Caused by: java.sql.SQLException: ResultSet is from UPDATE. No Data.
2017/09/06 10:44:53 - 表输出.0 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
2017/09/06 10:44:53 - 表输出.0 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
2017/09/06 10:44:53 - 表输出.0 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
2017/09/06 10:44:53 - 表输出.0 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
2017/09/06 10:44:53 - 表输出.0 - at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:6298)
2017/09/06 10:44:53 - 表输出.0 - at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3552)
2017/09/06 10:44:53 - 表输出.0 - ... 7 more
2017/09/06 10:44:53 - 表输入.0 - Finished reading query, closing connection.
2017/09/06 10:44:53 - 字段选择.0 - 完成处理 (I=0, O=0, R=30001, W=30001, U=0, E=0)
2017/09/06 10:44:53 - 表输入.0 - 完成处理 (I=40003, O=0, R=0, W=40002, U=0, E=0)
2017/09/06 10:44:53 - 表输出.0 - 完成处理 (I=0, O=0, R=20000, W=0, U=0, E=1)
2017/09/06 10:44:53 - CLUSTER_SPDA - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : 错误被检测到!
2017/09/06 10:44:53 - Spoon - 转换完成!!
2017/09/06 10:44:53 - CLUSTER_SPDA - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : 错误被检测到!
2017/09/06 10:44:53 - CLUSTER_SPDA - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : 错误被检测到!
2017/09/06 10:44:53 - CLUSTER_SPDA - 转换被检测
2017/09/06 10:44:53 - CLUSTER_SPDA - 转换正在杀死其他步骤!