1.报错是发送在每次写完10000条之后,再次写10000条数据时报错。
2.kettle 表输出组件设置的是每次提交10000
3.Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
2021/05/10 16:37:54 - 表输出.4 - Unexpected error inserting row
2021/05/10 16:37:54 - 表输出.4 - -32463
2021/05/10 16:37:54 - 表输出.4 -
2021/05/10 16:37:54 - 表输出.4 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:298)
2021/05/10 16:37:54 - 表输出.4 - … 3 more
2021/05/10 16:37:54 - 表输出.4 - Caused by: java.lang.ArrayIndexOutOfBoundsException: -32463
2021/05/10 16:37:54 - 表输出.4 - at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2673)
2021/05/10 16:37:54 - 表输出.4 - at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10689)
2021/05/10 16:37:54 - 表输出.4 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:292)
解决方法: 修改表输出组件中的提交条数,我是改成了1000.
原因:可能是ojdbc的问题