Closed
Description
测试场景
- mysql-> dameng
- 测试使用的版本：dm8:dm8_20240613_rev229704_x86_rh6_64
- 安装文档：https://blog.csdn.net/qq_43421954/article/details/128850147
问题原因猜想
估计是 表名的大小写 的问题造成的 ，大梦里默认 都变成大写的 表了，然后 在找表的时候还是用小写的字母 ，估计会 匹配不上
批量同步异常：
Caused by: java.lang.RuntimeException: TableNotFound{ dbId=merchant,tableName='ad_company_bak,url:jdbc:dm://192.168.5.121:30236?schema=merchant'}
at com.qlangtech.tis.plugin.ds.BasicDataSourceFactory.getTableMetadata(BasicDataSourceFactory.java:124)
at com.alibaba.datax.plugin.rdbms.util.DBUtil.getTableColums(DBUtil.java:527)
at com.alibaba.datax.plugin.rdbms.util.DBUtil.getTableColumnsByConn(DBUtil.java:535)
at com.alibaba.datax.plugin.rdbms.writer.util.OriginalConfPretreatmentUtil.dealColumnConf(OriginalConfPretreatmentUtil.java:108)
at com.alibaba.datax.plugin.rdbms.writer.util.OriginalConfPretreatmentUtil.dealColumnConf(OriginalConfPretreatmentUtil.java:151)
at com.alibaba.datax.plugin.rdbms.writer.util.OriginalConfPretreatmentUtil.doPretreatment(OriginalConfPretreatmentUtil.java:37)
at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Job.init(CommonRdbmsWriter.java:51)
at com.alibaba.datax.plugin.dameng.writer.DaMengWriter$Job.init(DaMengWriter.java:40)
at com.alibaba.datax.core.job.JobContainer.initJobWriter(JobContainer.java:665)
at com.alibaba.datax.core.job.JobContainer.init(JobContainer.java:319)
at com.alibaba.datax.core.job.JobContainer.start(JobContainer.java:148)
... 7 common frames omitted
Caused by: com.qlangtech.tis.plugin.ds.TableNotFoundException: null
at com.qlangtech.tis.plugin.ds.DataSourceFactory.parseTableColMeta(DataSourceFactory.java:213)
at com.qlangtech.tis.plugin.ds.DataSourceFactory.lambda$parseTableColMeta$0(DataSourceFactory.java:345)
at com.qlangtech.tis.plugin.ds.DataSourceFactory.validateConnection(DataSourceFactory.java:128)
at com.qlangtech.tis.plugin.ds.DataSourceFactory.parseTableColMeta(DataSourceFactory.java:344)
at com.qlangtech.tis.plugin.ds.BasicDataSourceFactory.parseTableColMeta(BasicDataSourceFactory.java:144)
at com.qlangtech.tis.plugin.ds.BasicDataSourceFactory.lambda$getTableMetadata$1(BasicDataSourceFactory.java:114)
at com.qlangtech.tis.plugin.ds.DBConfig.vistDbName(DBConfig.java:130)
at com.qlangtech.tis.plugin.ds.BasicDataSourceFactory.getTableMetadata(BasicDataSourceFactory.java:113)
... 17 common frames omitted