ODI Tool ODIWaitForLogData Package Object Fails With Error "ORA-00904: "JRN"."WINDOW_ID": invalid identifier"
(Doc ID 2463111.1)
Last updated on FEBRUARY 25, 2019
Applies to:
Oracle Data Integrator - Version 12.2.1.3.0 and laterInformation in this document applies to any platform.
Symptoms
While using Oracle Data Integrator (ODI) knowledge module "JKM Oracle To Oracle Consistent(OGG Online)" with USE_INTEGRATED_REPLICAT_MODE=True, the ODIWaitForLogData package object fails with the following error:
ODI-1226: Step Wait for Changes fails after 1 attempt(s).
ODI-1241: Oracle Data Integrator tool execution fails.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00904: "JRN"."WINDOW_ID": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at ...
at com.sunopsis.sql.SnpsQuery.execute(SnpsQuery.java:517)
at com.sunopsis.dwg.tools.RefreshJournalCount.refreshJournalCountCdcSetName(RefreshJournalCount.java:225)
at com.sunopsis.dwg.tools.WaitForLogData.waitCdcNonOptimizedMode(WaitForLogData.j ava:1103)
at com.sunopsis.dwg.tools.WaitForLogData.actionExecute(WaitForLogData.java:289)
at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:235)
at oracle.odi.runtime.agent.execution.SessionTask.execIntegratedFunction(SessionTask.java:902)
at oracle.odi.runtime.agent.execution.SessionTask.executeOdiCommand(SessionTask.java:583)
at ...
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:745)
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 |