My Oracle Support Banner

ODI JKM Oracle To Oracle Consistent (OGG Online) Referencing Check Point Table in the Schema While Using Integrated Capture and Delivery (Doc ID 2114266.1)

Last updated on JULY 15, 2018

Applies to:

Oracle Data Integrator - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When using the Journalizing knowledge module ( ODI JKM Oracle to Oracle Consistent (OGG Online) ) with Oracle GoldenGate to extend a window it is referencing <%= odiRef.getInfo("SRC_DEFW_SCHEMA") %> to prefix the checkpoint table with schema.

This causes an error in the generated code as this value does not exist against the physical GoldenGate topology.

Step "Extend Window" in the knowledge module appears like below:

update <%=odiRef.getJrnInfo( "CDC_SET_TABLE" )%>
set CUR_WINDOW_ID=
NVL((select min(to_number(to_char(CKPT.seqno,'9999999999') ||to_char(CKPT.rba, '0000000009MI')))
from <%= odiRef.getInfo("SRC_DEFW_SCHEMA") %>.<%=odiRef.getOption("CHECKPOINT_TABLE_NAME")%> CKPT
where CKPT.GROUP_NAME in <%= replicatListForSQLIn %>), 0),
CUR_WINDOW_ID_DEL=
NVL((select min(to_number(to_char(CKPT.seqno,'9999999999') ||to_char(CKPT.rba, '0000000009MI')))
from <%= odiRef.getInfo("SRC_DEFW_SCHEMA") %>.<%=odiRef.getOption("CHECKPOINT_TABLE_NAME")%> CKPT
where CKPT.GROUP_NAME in <%= replicatListForSQLIn %>), 0),
CUR_WINDOW_ID_INS=
NVL((select min(to_number(to_char(CKPT.seqno,'9999999999') ||to_char(CKPT.rba, '0000000009MI')))
from <%= odiRef.getInfo("SRC_DEFW_SCHEMA") %>.<%=odiRef.getOption("CHECKPOINT_TABLE_NAME")%> CKPT
where CKPT.GROUP_NAME in <%= replicatListForSQLIn %>), 0)
where CDC_SET_NAME = '<%=odiRef.getObjectName("L" ,odiRef.getJrnInfo( "JRN_COD_MOD" ) , "D")%>'

Changes

 

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
Changes
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.