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 FEBRUARY 14, 2019

Applies to:

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

Symptoms

NOTE: In the example below any information such as schema and table names represent a fictitious sample (based upon made up data used in an Oracle Demo instance). Any similarity to actual data or persons, living or dead, is purely coincidental and not intended in any manner.

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_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_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_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_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")%>'

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.