Kettle7.1,表输出中有错误,求大佬帮忙解决

weixin_44931603 2019-08-16 04:35:12
求大佬帮忙看一下,我这用Kettle7.1,表输出一直有问题,本人是Kettle小白,下面是日志中的问题。

2019/08/16 15:52:25 - Spoon - Using legacy execution engine
2019/08/16 15:52:25 - Spoon - 转换已经打开.
2019/08/16 15:52:25 - Spoon - 正在打开转换 [1]...
2019/08/16 15:52:25 - Spoon - 开始执行转换.
2019/08/16 15:52:25 - 1 - 为了转换解除补丁开始 [1]
2019/08/16 15:52:25 - 表输出.0 - Connected to database [172.17.6.195] (commit=1000)
2019/08/16 15:52:26 - 表输入.0 - Finished reading query, closing connection.
2019/08/16 15:52:26 - 表输入.0 - 完成处理 (I=12841, O=0, R=0, W=12841, U=0, E=0)
2019/08/16 15:52:30 - 表输出.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Because of an error, this step can't continue:
2019/08/16 15:52:30 - 表输出.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : org.pentaho.di.core.exception.KettleException:
2019/08/16 15:52:30 - 表输出.0 - Error batch inserting rows into table [giap_apply_base].
2019/08/16 15:52:30 - 表输出.0 - Errors encountered (first 10):
2019/08/16 15:52:30 - 表输出.0 -
2019/08/16 15:52:30 - 表输出.0 -
2019/08/16 15:52:30 - 表输出.0 - Error updating batch
2019/08/16 15:52:30 - 表输出.0 - Duplicate entry '2c91865b6b4141da016b476c11440aa5' for key 'PRIMARY'
2019/08/16 15:52:30 - 表输出.0 -
2019/08/16 15:52:30 - 表输出.0 -
2019/08/16 15:52:30 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:349)
2019/08/16 15:52:30 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:125)
2019/08/16 15:52:30 - 表输出.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2019/08/16 15:52:30 - 表输出.0 - at java.lang.Thread.run(Thread.java:748)
2019/08/16 15:52:30 - 表输出.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseBatchException:
2019/08/16 15:52:30 - 表输出.0 - Error updating batch
2019/08/16 15:52:30 - 表输出.0 - Duplicate entry '2c91865b6b4141da016b476c11440aa5' for key 'PRIMARY'
2019/08/16 15:52:30 - 表输出.0 -
2019/08/16 15:52:30 - 表输出.0 - at org.pentaho.di.core.database.Database.createKettleDatabaseBatchException(Database.java:1427)
2019/08/16 15:52:30 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:296)
2019/08/16 15:52:30 - 表输出.0 - ... 3 more
2019/08/16 15:52:30 - 表输出.0 - Caused by: java.sql.BatchUpdateException: Duplicate entry '2c91865b6b4141da016b476c11440aa5' for key 'PRIMARY'
2019/08/16 15:52:30 - 表输出.0 - at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2019/08/16 15:52:30 - 表输出.0 - at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
2019/08/16 15:52:30 - 表输出.0 - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2019/08/16 15:52:30 - 表输出.0 - at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
2019/08/16 15:52:30 - 表输出.0 - at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
2019/08/16 15:52:30 - 表输出.0 - at com.mysql.jdbc.Util.getInstance(Util.java:408)
2019/08/16 15:52:30 - 表输出.0 - at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1163)
2019/08/16 15:52:30 - 表输出.0 - at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1778)
2019/08/16 15:52:30 - 表输出.0 - at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1262)
2019/08/16 15:52:30 - 表输出.0 - at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:970)
2019/08/16 15:52:30 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:292)
2019/08/16 15:52:30 - 表输出.0 - ... 3 more
2019/08/16 15:52:30 - 表输出.0 - Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '2c91865b6b4141da016b476c11440aa5' for key 'PRIMARY'
2019/08/16 15:52:30 - 表输出.0 - at sun.reflect.GeneratedConstructorAccessor72.newInstance(Unknown Source)
2019/08/16 15:52:30 - 表输出.0 - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2019/08/16 15:52:30 - 表输出.0 - at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
2019/08/16 15:52:30 - 表输出.0 - at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
2019/08/16 15:52:30 - 表输出.0 - at com.mysql.jdbc.Util.getInstance(Util.java:408)
2019/08/16 15:52:30 - 表输出.0 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
2019/08/16 15:52:30 - 表输出.0 - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
2019/08/16 15:52:30 - 表输出.0 - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
2019/08/16 15:52:30 - 表输出.0 - at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
2019/08/16 15:52:30 - 表输出.0 - at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
2019/08/16 15:52:30 - 表输出.0 - at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
2019/08/16 15:52:30 - 表输出.0 - at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
2019/08/16 15:52:30 - 表输出.0 - at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
2019/08/16 15:52:30 - 表输出.0 - at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1756)
2019/08/16 15:52:30 - 表输出.0 - ... 6 more
2019/08/16 15:52:30 - 表输出.0 - 完成处理 (I=0, O=999, R=1000, W=0, U=0, E=1)
2019/08/16 15:52:30 - 1 - 转换被检测
2019/08/16 15:52:30 - 1 - 转换正在杀死其他步骤!
2019/08/16 15:52:30 - 字段选择.0 - 完成处理 (I=0, O=0, R=11001, W=11001, U=0, E=0)
2019/08/16 15:52:30 - 1 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : 错误被检测到!
2019/08/16 15:52:30 - Spoon - 转换完成!!
2019/08/16 15:52:30 - 1 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : 错误被检测到!
2019/08/16 15:52:30 - 1 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : 错误被检测到!
...全文
4443 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
qwee154 2022-07-18
  • 打赏
  • 举报
回复

我想问问你是咋解决的

编程界萌星 2021-12-22
  • 打赏
  • 举报
回复

Caused by: java.sql.BatchUpdateException: Duplicate entry '2c91865b6b4141da016b476c11440aa5' for key 'PRIMARY',挖坟了...

430

社区成员

发帖
与我相关
我的任务
社区描述
其他技术讨论专区
其他 技术论坛(原bbs)
社区管理员
  • 其他技术讨论专区社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧