Hi,
I am building a ODI mapping to copy data from Oracle 12C db to MemSQL(MySQL variant). All the connections and repositories have been up and running for other loads.
Its a simple mapping to dump data directly from source and into target. I am running into error message, Unknown column <field name> in 'field list', when I execute the mapping. I verified the field names exist in both source and tgt, have the right privileges to select/ insert data.
Here is the detailed log:
Internal GLOBAL oracle.javatools.icons.OracleIcons$LazyIcon@a4f154a 2017-07-16 03:50:20.0 2017-07-16 03:50:20.0
0 ODI-1298 ODI-1226: Step Physical_STEP fails after 1 attempt(s).
ODI-1227: Task SERIAL-MAP_MAIN- fails on the source connection <Empty Value>.
ODI-1298: Serial task "SERIAL-MAP_MAIN- (50)" failed because child task "SERIAL-EU-ERM_QA_UNIT (60)" is in error.
ODI-1298: Serial task "SERIAL-EU-ERM_QA_UNIT (60)" failed because child task "Insert new rows-LKM SQL to SQL (Built-In)-Load DEFAULT_AP (70)"
is in error.
ODI-1228: Task Insert new rows-LKM SQL to SQL (Built-In)-Load DEFAULT_AP fails on the target connection memsql.
Caused By: java.sql.BatchUpdateException: Unknown column 'PROJECT_NAME' in 'field list'
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2038)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1451)
at oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.executeBatch(BatchSQLCommand.java:110)
at oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.execute(BatchSQLCommand.java:68)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:142)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:28)
at oracle.odi.runtime.agent.execution.Executor.performAction(Executor.java:449)
at oracle.odi.runtime.agent.execution.Executor.handleDataMovementTask(Executor.java:334)
at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:51)
at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:206)
at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:117)
at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)
at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2225)
at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:610)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'PROJECT_NAME' in 'field list'
at sun.reflect.GeneratedConstructorAccessor187.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:395)
at com.mysql.jdbc.Util.getInstance(Util.java:370)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1037)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2718)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2139)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2442)
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1990)
... 22 more
0 0 0 0 0
Not sure what's missing here. Any inputs are appreciated.
Thanks!