ODI Tool ODIWaitForLogData Package Object Fails With Error "ORA-00904: "JRN"."WINDOW_ID": invalid identifier" (Doc ID 2463111.1)

Last updated on JUNE 16, 2022

Applies to:

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

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