My Oracle Support Banner

'RNX0233 unmonitored by CDCRTVJRN' Message Signaled Using ODI CDC/Journalization Procedures on iSeries Servers (Doc ID 424386.1)

Last updated on DECEMBER 20, 2019

Applies to:

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

Symptoms

After having installed ODI Journalization / Changed Data Capture (CDC) on iSeries (AS400) servers using native iSeries Transaction Journals, the Integration Interface interrupts at the "Retrieve iSeries Journal Entries" step with the following message:

java.sql.SQLException: [CEE9901] Application error. RNX0233 unmonitored by CDCRTVJRN at statement *N 

 The command that executed was:

call SUNOPSIS.CDCRTVJRN ('SUNOPSIS.SNP_SUBSCRIBERS', '<SCHEMA>.<TABLE>', 'SUNOPSIS', 'Y')

When consulting the AS400 spool trace, it appears that the "Querying the subscriber table SUNOPSIS.SNP_SUBSCRIBERS for table <SCHEMA>.<TABLE> and subscriber SUNOPSIS" action does not return any rows and raises the following exception:

 

************** Sunopsis Exception ***************
2005-11-30-18.15.09.297000 - Exception Data : Length or starting position is outside of string operation limits.
2005-11-30-18.15.09.299000 - Program : CDCRTVJRN
2005-11-30-18.15.09.302000 - Status : 0
2005-11-30-18.15.09.304000 - Previous Status: 0
2005-11-30-18.15.09.307000 - Error Line No : 401
2005-11-30-18.15.09.309000 - Routine : PGETFILE
2005-11-30-18.15.09.311000 - Params : 12
2005-11-30-18.15.09.314000 - Exception Type : RNX
2005-11-30-18.15.09.316000 - Exception Num : 0100
2005-11-30-18.15.09.319000 - Program Lib : SUNOPSIS
2005-11-30-18.15.09.321000 - Error Id :
2005-11-30-18.15.09.323000 - Job Name : QZDASOINIT
2005-11-30-18.15.09.326000 - User : <USER>
2005-11-30-18.15.09.328000 - Job Number : 026520
2005-11-30-18.15.09.330000 - Current User : SUNOPSIS
2005-11-30-18.15.09.333000 - ************** End Exception ***************

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.