"ODI-1228: Task GG_Staging (Journalizing) fails... ORA-01722: invalid number" Signalled on Extend Window Step of ODI 11g JKM for Golden Gate ODI Task (Doc ID 1910258.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 to 11.1.1.9.99 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

When attempting to perform CDC operation using Oracle Data Integrator (ODI) 11g Golden Gate approach using the JKM for Golden Gate, the Integration Interfaces works fine until it reads the 10th file and then fails with following message in the Extend Window task:

ODI-1228: Task GG_Staging (Journalizing) fails on the target ORACLE connection ORACLE_STAGING.
Caused By: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms