为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:
【CPU】:
【问题描述】*:
oracle迁移表数据到DM8
oracle 表内数据格式
08-9月 -19 07.13.14.160000000 上午
这种格式迁移时候报错
com.dameng.dts.plugin.support.task.TransformDataException: java.lang.RuntimeException: 错误的日期时间类型格式
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.doInsert(BaseCopyDataTask.java:1590)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.insert(BaseCopyDataTask.java:1458)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.insert(BaseCopyDataTask.java:1494)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.doImport(BaseCopyDataTask.java:1401)
at com.dameng.dts.plugin.support.task.BaseDm7CopyDataTask.doImport(BaseDm7CopyDataTask.java:220)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask$DoImportTask.run(BaseCopyDataTask.java:2789)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.doParallelRun(BaseCopyDataTask.java:1112)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.parallelImport(BaseCopyDataTask.java:1302)
at com.dameng.dts.plugin.support.task.BaseDm7CopyDataTask.parallelImport(BaseDm7CopyDataTask.java:375)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.internalImp(BaseCopyDataTask.java:1227)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.imp(BaseCopyDataTask.java:305)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.doRun(BaseCopyDataTask.java:282)
at com.dameng.common.task.Task.run(Task.java:127)
at com.dameng.common.task.TaskRunner$TaskAdapter.call(TaskRunner.java:246)
at com.dameng.common.task.TaskRunner$TaskAdapter.call(TaskRunner.java:1)
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:750)
Caused by: java.lang.RuntimeException: 错误的日期时间类型格式
at dm.jdbc.driver.DBError.throwRuntimeException(DBError.java:626)
at dm.jdbc.util.OracleDateFormat.parse(OracleDateFormat.java:146)
at dm.jdbc.util.OracleDateFormat.parse(OracleDateFormat.java:156)
at dm.jdbc.a.b.a(J2DB.java:393)
at dm.jdbc.driver.DmdbPreparedStatement.do_setString(DmdbPreparedStatement.java:719)
at dm.jdbc.driver.DmdbPreparedStatement.setString(DmdbPreparedStatement.java:1559)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.setPsParamValue(BaseCopyDataTask.java:2120)
at com.dameng.dts.plugin.support.task.BaseDm7CopyDataTask.setPsParamValue(BaseDm7CopyDataTask.java:502)
at com.dameng.dts.plugin.oracle.dm7.task.CopyDataTask.setPsParamValue(CopyDataTask.java:552)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.doInsert(BaseCopyDataTask.java:1584)
... 18 more
Caused by: java.lang.NumberFormatException: For input string: "7-"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:580)
at java.lang.Integer.parseInt(Integer.java:615)
at dm.jdbc.util.OracleDateFormat$MMElement.parse(OracleDateFormat.java:351)
at dm.jdbc.util.OracleDateFormat.parse(OracleDateFormat.java:117)
... 26 more
开启Oracle兼容参数试试:
sp_set_para_values(2,'compatible_mode',2);
修改成功后,重启数据库服务;