我的位置：首页 › 智能数据治理平台-睿治 › 睿治-问题求助 › 睿治查看mysql数据库的表报错

[数据交换] 睿治查看mysql数据库的表报错

复制链接 | 收藏本帖

4039

: AlexisP 小试身手Lv3

发表于2021-7-15 14:47

悬赏100

已解决

楼主

睿治版本v2.2.1,查看mysql数据源的库表时候报错。使用sql输入组件时，输出是mysql的表也报错。
报错信息：
2021-07-15 14:41:17 开始迁移到目标表：DW.TS_MANAGEMENT_OPERATION_IND_ACT_M_D
2021-07-15 14:41:17 com.esen.exception.RuntimeException4I18N: 执行数据迁移时出现异常
at com.esen.jdbc.dialect.impl.TableMetaDataImpl.initPrimaryKey(TableMetaDataImpl.java:210)
at com.esen.jdbc.dialect.impl.TableMetaDataImpl.getPrimaryKey(TableMetaDataImpl.java:164)
at com.esen.edataexchange.data.migrate.DataMigration.initKeys(DataMigration.java:969)
at com.esen.edataexchange.data.migrate.DataMigration.migrateIntoPhysicalTable(DataMigration.java:279)
at com.esen.edataexchange.data.migrate.DataMigration.execute(DataMigration.java:242)
at com.esen.edataexchange.domain.job.widget.AbstractEtlWidgetTarget.executeDataMigration(AbstractEtlWidgetTarget.java:598)
at com.esen.edataexchange.domain.job.widget.AbstractEtlWidgetTarget.process(AbstractEtlWidgetTarget.java:403)
at com.esen.edataexchange.domain.job.EtlJob.processEtlJob(EtlJob.java:567)
at com.esen.edataexchange.domain.job.EtlJob.process(EtlJob.java:462)
at com.esen.edataexchange.domain.job.EtlJobRequestTask.call(EtlJobRequestTask.java:72)
at com.esen.edataexchange.domain.job.EtlJobRequestTask.call(EtlJobRequestTask.java:28)
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: java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: errCode = 2, detailMessage = Unknown table 'default_cluster

W.default_cluster

W.TS_MANAGEMENT_OPERATION_IND_ACT_M_D'
... 17 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: errCode = 2, detailMessage = Unknown table 'default_cluster

W.default_cluster

W.TS_MANAGEMENT_OPERATION_IND_ACT_M_D'
at sun.reflect.GeneratedConstructorAccessor332.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
at com.mysql.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:3737)
at com.mysql.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:3727)
at com.mysql.jdbc.IterateBlock.doForAll(IterateBlock.java:50)
at com.mysql.jdbc.DatabaseMetaData.getPrimaryKeys(DatabaseMetaData.java:3725)
at com.esen.jdbc.dialect.impl.TableMetaDataImpl.initPrimaryKey(TableMetaDataImpl.java:189)
... 16 more

2021-07-15 14:41:17 执行交换任务[交换任务1626331120506]出现异常：com.esen.exception.RuntimeException4I18N: 执行数据迁移时出现异常
at com.esen.jdbc.dialect.impl.TableMetaDataImpl.initPrimaryKey(TableMetaDataImpl.java:210)
at com.esen.jdbc.dialect.impl.TableMetaDataImpl.getPrimaryKey(TableMetaDataImpl.java:164)
at com.esen.edataexchange.data.migrate.DataMigration.initKeys(DataMigration.java:969)
at com.esen.edataexchange.data.migrate.DataMigration.migrateIntoPhysicalTable(DataMigration.java:279)
at com.esen.edataexchange.data.migrate.DataMigration.execute(DataMigration.java:242)
at com.esen.edataexchange.domain.job.widget.AbstractEtlWidgetTarget.executeDataMigration(AbstractEtlWidgetTarget.java:598)
at com.esen.edataexchange.domain.job.widget.AbstractEtlWidgetTarget.process(AbstractEtlWidgetTarget.java:403)
at com.esen.edataexchange.domain.job.EtlJob.processEtlJob(EtlJob.java:567)
at com.esen.edataexchange.domain.job.EtlJob.process(EtlJob.java:462)
at com.esen.edataexchange.domain.job.EtlJobRequestTask.call(EtlJobRequestTask.java:72)
at com.esen.edataexchange.domain.job.EtlJobRequestTask.call(EtlJobRequestTask.java:28)
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: java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: errCode = 2, detailMessage = Unknown table 'default_cluster

W.default_cluster

W.TS_MANAGEMENT_OPERATION_IND_ACT_M_D'
... 17 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: errCode = 2, detailMessage = Unknown table 'default_cluster

W.default_cluster