2022/05/18 16:19:58 - Spoon - 转换已经打开.
2022/05/18 16:19:58 - Spoon - 正在打开转换 [zy_brry]…
2022/05/18 16:19:58 - Spoon - 开始执行转换.
2022/05/18 16:19:58 - zy_brry - 为了转换解除补丁开始 [zy_brry]
2022/05/18 16:19:58 - 表输出.0 - Connected to database [192.168.1.98] (commit=1000)
2022/05/18 16:19:58 - 表输出.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Because of an error, this step can’t continue:
2022/05/18 16:19:58 - 表输出.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : org.pentaho.di.core.exception.KettleException:
2022/05/18 16:19:58 - 表输出.0 - Error batch inserting rows into table [MDM_BIZ_SYS_PAT_RAW].
2022/05/18 16:19:58 - 表输出.0 - Errors encountered (first 10):
2022/05/18 16:19:58 - 表输出.0 - ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER
2022/05/18 16:19:58 - 表输出.0 -
2022/05/18 16:19:58 - 表输出.0 -
2022/05/18 16:19:58 - 表输出.0 - Error updating batch
2022/05/18 16:19:58 - 表输出.0 - ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER
2022/05/18 16:19:58 - 表输出.0 -
2022/05/18 16:19:58 - 表输出.0 -
2022/05/18 16:19:58 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:349)
2022/05/18 16:19:58 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:125)
2022/05/18 16:19:58 - 表输出.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2022/05/18 16:19:58 - 表输出.0 - at java.lang.Thread.run(Unknown Source)
2022/05/18 16:19:58 - 表输出.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseBatchException:
2022/05/18 16:19:58 - 表输出.0 - Error updating batch
2022/05/18 16:19:58 - 表输出.0 - ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER
2022/05/18 16:19:58 - 表输出.0 -
2022/05/18 16:19:58 - 表输出.0 - at org.pentaho.di.core.database.Database.createKettleDatabaseBatchException(Database.java:1427)
2022/05/18 16:19:58 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:296)
2022/05/18 16:19:58 - 表输出.0 - … 3 more
2022/05/18 16:19:58 - 表输出.0 - Caused by: java.sql.BatchUpdateException: ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER
2022/05/18 16:19:58 - 表输出.0 - at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
2022/05/18 16:19:58 - 表输出.0 - at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10720)
2022/05/18 16:19:58 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:292)
2022/05/18 16:19:58 - 表输出.0 - … 3 more
2022/05/18 16:19:58 - V_ZY_BRRY.0 - Finished reading query, closing connection.
2022/05/18 16:19:58 - 表输出.0 - 完成处理 (I=0, O=999, R=1000, W=0, U=0, E=1)
2022/05/18 16:19:58 - zy_brry - 转换被检测
2022/05/18 16:19:58 - zy_brry - 转换正在杀死其他步骤!
2022/05/18 16:19:58 - V_ZY_BRRY.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Unexpected error closing query : org.pentaho.di.core.exception.KettleDatabaseException:
2022/05/18 16:19:58 - V_ZY_BRRY.0 - Couldn’t close query: resultset or prepared statements
2022/05/18 16:19:58 - V_ZY_BRRY.0 - Cancel has been invoked on this Statement.
2022/05/18 16:19:58 - V_ZY_BRRY.0 - 完成处理 (I=4369, O=0, R=0, W=4367, U=0, E=1)
2022/05/18 16:19:58 - zy_brry - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : 错误被检测到!
2022/05/18 16:19:58 - Spoon - 转换完成!!
2022/05/18 16:19:58 - zy_brry - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : 错误被检测到!
2022/05/18 16:19:58 - zy_brry - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : 错误被检测到!
2022/05/18 16:19:58 - zy_brry - 转换被检测
2022/05/18 16:19:58 - zy_brry - 转换正在杀死其他步骤!
解决:null datetime