-
-
qinzhq 初学数据Lv2
发表于2020-9-16 11:32
悬赏1
未解决
楼主
Caused by: com.esen.exception.RuntimeException4I18N: 更新表部分字段出现异常
选择数据覆盖就没问题，选择数更新，更新插入都不行
选择数据覆盖就没问题，选择数更新，更新插入都不行
最近看过此主题的会员
8个回答
xxxl 发表于 2020-9-16 11:42
完整报错信息看一下
2020-09-16 10:11:24 执行ETL过程[ETL过程1600221647817]出现异常：com.esen.exception.RuntimeException4I18N: 执行数据迁移时出现异常
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
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:2490)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013)
at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998)
at com.esen.jdbc.pool.PooledPreparedStatement.executeUpdate(PooledPreparedStatement.java:103)
at com.esen.ecore.util.JdbcUtils.exeUpdate(JdbcUtils.java:619)
at com.esen.ecore.util.JdbcUtils.exeUpdate(JdbcUtils.java:598)
at com.esen.edf.data.migrate.DataMigrationUtils.insertIntoDestFromReferenceTable(DataMigrationUtils.java:444)
at com.esen.edf.data.migrate.DataMigration.updateSomeFieldData(DataMigration.java:721)
at com.esen.edf.data.migrate.DataMigration.updateTargetTable(DataMigration.java:338)
at com.esen.edf.data.migrate.DataMigration.migrateIntoPhysicalTable(DataMigration.java:283)
at com.esen.edf.data.migrate.DataMigration.execute(DataMigration.java:238)
at com.esen.edf.domain.job.widget.AbstractEtlWidgetTarget.executeDataMigration(AbstractEtlWidgetTarget.java:628)
at com.esen.edf.domain.job.widget.AbstractEtlWidgetTarget.process(AbstractEtlWidgetTarget.java:407)
at com.esen.edf.domain.job.EtlJob.processEtlJob(EtlJob.java:549)
at com.esen.edf.domain.job.EtlJob.process(EtlJob.java:445)
at com.esen.edf.domain.job.EtlJobRequestTask.call(EtlJobRequestTask.java:69)
at com.esen.edf.domain.job.EtlJobRequestTask.call(EtlJobRequestTask.java:26)
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:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.esen.exception.RuntimeException4I18N: 更新表部分字段出现异常
... 31 more
Caused by: java.lang.RuntimeException: Column count doesn't match value count at row 1
... 31 more
Caused by: com.esen.jdbc.pool.impl.mysql.MysqlPooledSQLException: Column count doesn't match value count at row 1
... 31 more
qinzhq 发表于 2020-9-16 11:47
2020-09-16 10:11:24 执行ETL过程[ETL过程1600221647817]出现异常：com.esen.exception.RuntimeException ...
可能是部分字段设置导致的异常，检查一下字段长度是否一致。
小亿 发表于 2020-9-18 15:03
问题解决了吗84.gif
售前在对接客户 在解决
xxxl 发表于 2020-9-17 17:15
检查一下字段长度是否一致后，问题解决了吗
售前在对接中
