Report Created When Replicating to Sybase Shows Records are Discarded but They Can be Seen in the Sybase Table (Doc ID 1989858.1)

Last updated on JANUARY 09, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.24 to 11.2.1.0.26 [Release 11.2]
Information in this document applies to any platform.

Symptoms

When replicating from Oracle 11.2.0.3 to Sybase ASE 15.3 database using GoldenGate 11.2.0.24 the replicat report shows that for insert statements the records are discarded with ORA-01403 errors but then all the records can be seen in the Sybase table.
The replicat abends and then restarts automatically and the report shows all records are discarded but the discarded records can be seen in the Sybase table.
The replicat report shows the following messages -

Warning: no rows processed.  Row count = -1




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