导数据问题处理ORA-00001: 违反唯一约束条件

2023/05/09 16:52:08 - Spoon - Running transformation using the Kettle execution engine
2023/05/09 16:52:08 - Spoon - 转换已经打开.
2023/05/09 16:52:08 - Spoon - 正在打开转换 [首次病程记录]...
2023/05/09 16:52:08 - Spoon - 开始执行转换.
2023/05/09 16:52:08 - 首次病程记录 - 为了转换解除补丁开始  [首次病程记录]
2023/05/09 16:52:08 - 表输出.0 - Connected to database [pt] (commit=1000)
2023/05/09 16:52:09 - 表输入.0 - Finished reading query, closing connection.
2023/05/09 16:52:09 - 表输入.0 - 完成处理 (I=943, O=0, R=0, W=943, U=0, E=0)
2023/05/09 16:52:09 - 表输出.0 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : Unexpected batch update error committing the database connection.
2023/05/09 16:52:09 - 表输出.0 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseBatchException: 
2023/05/09 16:52:09 - 表输出.0 - Error updating batch
2023/05/09 16:52:09 - 表输出.0 - ORA-00001: 违反唯一约束条件 (DATACENTER.PK_T_FIRSTDURATION)

2023/05/09 16:52:09 - 表输出.0 - 
2023/05/09 16:52:09 - 表输出.0 -     at org.pentaho.di.core.database.Database.createKettleDatabaseBatchException(Database.java:1436)
2023/05/09 16:52:09 - 表输出.0 -     at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1425)
2023/05/09 16:52:09 - 表输出.0 -     at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:590)
2023/05/09 16:52:09 - 表输出.0 -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:97)
2023/05/09 16:52:09 - 表输出.0 -     at java.lang.Thread.run(Thread.java:748)
2023/05/09 16:52:09 - 表输出.0 - Caused by: java.sql.BatchUpdateException: ORA-00001: 违反唯一约束条件 (DATACENTER.PK_T_FIRSTDURATION)

2023/05/09 16:52:09 - 表输出.0 -     at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10070)
2023/05/09 16:52:09 - 表输出.0 -     at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:213)
2023/05/09 16:52:09 - 表输出.0 -     at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1412)
2023/05/09 16:52:09 - 表输出.0 -     ... 3 more
2023/05/09 16:52:09 - 表输出.0 - 完成处理 (I=0, O=0, R=943, W=0, U=0, E=1)
2023/05/09 16:52:09 - 首次病程记录 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : 错误被检测到!
2023/05/09 16:52:09 - Spoon - 转换完成!!
2023/05/09 16:52:09 - 首次病程记录 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : 错误被检测到!
2023/05/09 16:52:09 - 首次病程记录 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : 错误被检测到!
2023/05/09 16:52:09 - 首次病程记录 - 转换被检测
2023/05/09 16:52:09 - 首次病程记录 - 转换正在杀死其他步骤!

解决方法: