OGG Replicat abends with "Key Data Mismatch Encountered During Key Update" SQLSTATE=58004 (Doc ID 2248603.1)

Last updated on APRIL 19, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.1 to 12.2.0.1.0 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

2017-03-23 01:58:23 WARNING OGG-01004 Aborted grouped transaction on 'DLVRY10.YFS_SHIPMENT_RP', Database error -901 ([SQL error -901 (0xfffffc7b)][IBM][C
LI Driver][DB2/AIX64] SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "Key da
ta mismatch encountered during key update".) SQLSTATE=58004

).

2017-03-23 01:58:23 WARNING OGG-01003 Repositioning to rba 467474088 in seqno 148628.

2017-03-23 01:58:24 WARNING OGG-01154 SQL error -901 mapping YANTRA_ADMIN.YFS_SHIPMENT to DLVRY10.YFS_SHIPMENT_RP [SQL error -901 (0xfffffc7b)][IBM][CLI
Driver][DB2/AIX64] SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "Key data
mismatch encountered during key update".) SQLSTATE=58004.
ch encountered during key update".) SQLSTATE=58004

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