My Oracle Support Banner

Simple CDC Implementation Throwing Error While Locking Journalized Table using ODI (Doc ID 2640647.1)

Last updated on MAY 21, 2020

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 to 12.2.1.4.200304 [Release 12c]
Information in this document applies to any platform.

Symptoms

When using simple change data capture (CDC) implementation in Oracle Data Integrator (ODI), having a load involving expressions with aggregations or rank functions, mapping is failing in the initial step "Lock journalized table" with an error message searching for an unknown table "TEMP_JRN_TABLE" which is not the actual journalized table used in the mapping:

ODI-1228: Task Lock journalized table-IKM SQL Load- fails on the target connection <SOURCE_DATA_SERVER>.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1055)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:613)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:214)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:38)
  at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:891)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1194)
  at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1835)
  at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1790)
  at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:301)
  at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:205)
  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.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
  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: Error : 942, Position : 8, Sql =
update TEMP_JRN_TABLE
set JRN_CONSUMED = '1'
where (1=1)
, OriginalSql =
update TEMP_JRN_TABLE
set JRN_CONSUMED = '1'
where (1=1)
, Error Msg = ORA-00942: table or view does not exist
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499)
... 30 more

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.