My Oracle Support Banner

IR throws Error ORA-01722: Invalid Number after database upgrade to 12.2.0.1 (Doc ID 2430980.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Problem Description
---------------------------------------------------

After updating the database to version 12.2.0.1, and starting REPLICAT does not advance and shows the following error in the ggserr.log:


2017-10-27 15:28:03 INFO OGG-01971 Oracle GoldenGate Delivery for Oracle,replicate.prm: The previous message, 'WARNING OGG-02544', repeated 1 times.
2017-10-27 15:28:03 WARNING OGG-02544 Oracle GoldenGate Delivery for Oracle, replicate.prm: Unhandled error (ORA-01722: invalid number) while processing the record at SEQNO 43740, RBA 62918184 in Integrated mode. REPLICAT will retry in Direct mode.
2017-10-27 15:28:03 INFO OGG-01971 Oracle GoldenGate Delivery for Oracle, replicate.prm: The previous message, 'WARNING OGG-02544', repeated 2 times.


Changes

 Database upgrade from version 12.1 to 12.2

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.