为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】: x86_64
【问题描述】*:
迁移完成了,但日志中有两个成对出现的set identity status on/off的warning,这是为啥啊?有什么影响吗?
[INFO] 2025-10-26 11:22:14.347> [TASK]{table-"XXXX":"SYSDBA.XXXX"}@COPY_DATA:START:COPIED=0
[WARN] 2025-10-26 11:22:14.419> set identity status on error!
dm.jdbc.driver.DMException: 第1 行附近出现错误:
表[XXXX]不存在IDENTITY列
at dm.jdbc.driver.DBError.throwException(SourceFile:738)
at dm.jdbc.a.a.y.r(SourceFile:623)
at dm.jdbc.a.a.f.r(SourceFile:138)
at dm.jdbc.a.a.y.z(SourceFile:555)
at dm.jdbc.a.a.y.L(SourceFile:536)
at dm.jdbc.a.a.a(SourceFile:269)
at dm.jdbc.a.a.a(SourceFile:803)
at dm.jdbc.driver.DmdbStatement.executeInner(SourceFile:771)
at dm.jdbc.driver.DmdbStatement.do_executeUpdate(SourceFile:248)
at dm.jdbc.driver.DmdbStatement.do_executeUpdate(SourceFile:239)
at dm.jdbc.driver.DmdbStatement.executeUpdate(SourceFile:1143)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.setIdentityStatus(BaseCopyDataTask.java:657)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.lambda$0(BaseCopyDataTask.java:428)
at com.dameng.dts.plugin.support.task.BaseTask.executeWithReconn(BaseTask.java:382)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.borrowDestSession(BaseCopyDataTask.java:426)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.beforeImport(BaseCopyDataTask.java:409)
at com.dameng.dts.plugin.support.task.BaseDm7CopyDataTask.beforeImport(BaseDm7CopyDataTask.java:80)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.internalImp(BaseCopyDataTask.java:1178)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.imp(BaseCopyDataTask.java:339)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.doRun(BaseCopyDataTask.java:316)
at com.dameng.common.task.Task.run(SourceFile:127)
at com.dameng.common.task.TaskRunner$TaskAdapter.call(SourceFile:256)
at com.dameng.common.task.TaskRunner$TaskAdapter.call(SourceFile: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)
[WARN] 2025-10-26 11:22:18.119> set identity status off error!
dm.jdbc.driver.DMException: 第1 行附近出现错误:
表[XXXX]不存在IDENTITY列
at dm.jdbc.driver.DBError.throwException(SourceFile:738)
at dm.jdbc.a.a.y.r(SourceFile:623)
at dm.jdbc.a.a.f.r(SourceFile:138)
at dm.jdbc.a.a.y.z(SourceFile:555)
at dm.jdbc.a.a.y.L(SourceFile:536)
at dm.jdbc.a.a.a(SourceFile:269)
at dm.jdbc.a.a.a(SourceFile:803)
at dm.jdbc.driver.DmdbStatement.executeInner(SourceFile:771)
at dm.jdbc.driver.DmdbStatement.do_executeUpdate(SourceFile:248)
at dm.jdbc.driver.DmdbStatement.do_executeUpdate(SourceFile:239)
at dm.jdbc.driver.DmdbStatement.executeUpdate(SourceFile:1143)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.setIdentityStatus(BaseCopyDataTask.java:657)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.afterImport(BaseCopyDataTask.java:448)
at com.dameng.dts.plugin.support.task.BaseDm7CopyDataTask.afterImport(BaseDm7CopyDataTask.java:104)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.internalImp(BaseCopyDataTask.java:1209)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.imp(BaseCopyDataTask.java:339)
at com.dameng.dts.plugin.support.task.BaseCopyDataTask.doRun(BaseCopyDataTask.java:316)
at com.dameng.common.task.Task.run(SourceFile:127)
at com.dameng.common.task.TaskRunner$TaskAdapter.call(SourceFile:256)
at com.dameng.common.task.TaskRunner$TaskAdapter.call(SourceFile: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)
可以把这里的使用IDENTITY自增列勾选去掉。

DTS工具建议使用和数据版本相近的版本,或者把报错表的表结构的文本方式发出来;