Replication from IBM iSeries Gives ORA-1403 Errors When Replicating IBM GRAPHIC Datatype

(Doc ID 2015370.1)

Last updated on JANUARY 25, 2017

Applies to:

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

Symptoms

Data was loaded successfully from DB2 on an AS400 to Oracle.
When normal replication was started replicats abended with ORA-1403 errors -

OCI Error ORA-01403: no data found, SQL <DELETE FROM "OWNER"."TABLE_NAME"  WHERE "COL1" = :b0 AND "COL2" = :b1 AND "COL3" = :b2 AND "COL4" = :b3 AND "COL5" = :b4 AND "COL6" = :b5>
Aborting transaction on <TRAIL_FILE> beginning at seqno 445 rba 794509
                        error at seqno 445 rba 794509
Problem replicating OWNER.TABLE_NAME to ORACLE.TABLE_NAME
Record not found
Mapping problem with delete record (target format)...

 

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