我的位置：首页 › 智能数据治理平台-睿治 › 睿治-问题求助 › mysql抽取到oracle数据库报错

[数据交换] mysql抽取到oracle数据库报错

复制链接 | 收藏本帖

3333

: AlexisP 小试身手Lv3

发表于2021-5-20 14:15

悬赏1

已解决

楼主

睿治版本v2.2.1

从mysql数据库抽取到oracle数据库时报错，并且利用睿治 不存在则创建 的功能创建的表也无法进行正常的抽数。

报错信息：
2021-05-20 14:08:18 开始迁移到目标表：C##DW.aaaaaaaaaaa

2021-05-20 14:09:26 com.esen.exception.RuntimeException4I18N: 执行数据迁移时出现异常
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:937)
at com.mysql.jdbc.ByteArrayRow.getTimestampFast(ByteArrayRow.java:130)
at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:5918)
at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5588)
at com.esen.jdbc.pool.PooledResultSet.getTimestamp(PooledResultSet.java:143)
at com.esen.edataexchange.data.migrate.jdbc.JdbcReader$ResultSetHandler.fillColumn(JdbcReader.java:214)
at com.esen.edataexchange.data.migrate.jdbc.JdbcReader$ResultSetHandler.getDataRow(JdbcReader.java:172)
at com.esen.edataexchange.data.migrate.jdbc.JdbcReader.getRow(JdbcReader.java:141)
at com.esen.edataexchange.data.migrate.common.buffer.DataSenderRequestTask.call(DataSenderRequestTask.java:54)
at com.esen.edataexchange.data.migrate.common.buffer.DataSenderRequestTask.call(DataSenderRequestTask.java:24)
at com.esen.ethreadpool.req.RequestTaskFutureImpl.call(RequestTaskFutureImpl.java:100)
at com.esen.scheduling.LocaleTask.call(LocaleTask.java:56)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.esen.exception.RuntimeException4I18N: 发送数据时出现异常
... 20 more
Caused by: com.esen.exception.RuntimeException4I18N: 从结果集获取字段ROW_VERSION，类型93数据出现异常
... 20 more
Caused by: java.sql.SQLException: Value '0000-00-00 00:00:00.000000' can not be represented as java.sql.Timestamp
... 20 more

2021-05-20 14:09:26 执行交换任务[to_info_resource_basic_info_test]出现异常：com.esen.exception.RuntimeException4I18N: 执行数据迁移时出现异常
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:937)
at com.mysql.jdbc.ByteArrayRow.getTimestampFast(ByteArrayRow.java:130)
at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:5918)
at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5588)
at com.esen.jdbc.pool.PooledResultSet.getTimestamp(PooledResultSet.java:143)
at com.esen.edataexchange.data.migrate.jdbc.JdbcReader$ResultSetHandler.fillColumn(JdbcReader.java:214)
at com.esen.edataexchange.data.migrate.jdbc.JdbcReader$ResultSetHandler.getDataRow(JdbcReader.java:172)
at com.esen.edataexchange.data.migrate.jdbc.JdbcReader.getRow(JdbcReader.java:141)
at com.esen.edataexchange.data.migrate.common.buffer.DataSenderRequestTask.call(DataSenderRequestTask.java:54)
at com.esen.edataexchange.data.migrate.common.buffer.DataSenderRequestTask.call(DataSenderRequestTask.java:24)
at com.esen.ethreadpool.req.RequestTaskFutureImpl.call(RequestTaskFutureImpl.java:100)
at com.esen.scheduling.LocaleTask.call(LocaleTask.java:56)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.esen.exception.RuntimeException4I18N: 发送数据时出现异常
... 20 more
Caused by: com.esen.exception.RuntimeException4I18N: 从结果集获取字段ROW_VERSION，类型93数据出现异常
... 20 more
Caused by: java.sql.SQLException: Value '0000-00-00 00:00:00.000000' can not be represented as java.sql.Timestamp
... 20 more