Dataphin集成任务运行失败报错："Column 'workspaceid' cannot be resolved"

问题描述

Dataphin集成任务运行失败报错："Column 'workspaceid' cannot be resolved"。

2021-10-19 01:00:41.867 [0-0-0-reader] ERROR CommonRdbmsReader$Task - error occurred when reading.

java.sql.SQLException: [20038, 2021101901004101023103513903151122531] : line 0:1: Column 'workspaceid' cannot be resolved

 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) ~[mysql-connector-java-5.1.47.jar:5.1.47]

 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) ~[mysql-connector-java-5.1.47.jar:5.1.47]

 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) ~[mysql-connector-java-5.1.47.jar:5.1.47]

 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) ~[mysql-connector-java-5.1.47.jar:5.1.47]

 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) ~[mysql-connector-java-5.1.47.jar:5.1.47]

 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2491) ~[mysql-connector-java-5.1.47.jar:5.1.47]

 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2449) ~[mysql-connector-java-5.1.47.jar:5.1.47]

 at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381) ~[mysql-connector-java-5.1.47.jar:5.1.47]

 at com.alibaba.datax.plugin.rdbms.util.DBUtil.query(DBUtil.java:460) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]

 at com.alibaba.datax.plugin.rdbms.util.DBUtil.query(DBUtil.java:447) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]

 at com.alibaba.datax.plugin.rdbms.util.DBUtil.query(DBUtil.java:426) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]

 at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:209) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]

 at com.alibaba.datax.plugin.reader.mysqlreader.MysqlReader$Task.startRead(MysqlReader.java:82) [mysqlreader-0.0.1-SNAPSHOT.jar:na]

 at com.alibaba.dt.dlink.core.trans.adaptor.engine.ReaderRunnerAdaptor.run(ReaderRunnerAdaptor.java:57) [dlink-engine-0.0.1-SNAPSHOT.jar:na]

 at java.lang.Thread.run(Thread.java:882) [na:1.8.0_152]

问题原因

源表中没有workspaceid字段导致。

解决方案

重新配置集成任务，保存提交发布即可。

适用于

• Dataphin