Informix Extract Captures Incorrect Data Causing Replicat To Abend With Record Not Found Error

(Doc ID 2062755.1)

Last updated on FEBRUARY 06, 2017

Applies to:

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

Symptoms

Replication configured from Informix to Oracle

When attempting to start the replicat, the following error occurs.

ERROR
-----------------------
OGG-01154 SQL error 1403 mapping db013.informix.auction_result to ORDER_ADMIN_GG.AUCTION_RESULT OCI Error ORA-01403: no data found, SQL <UPDATE "ORDER_ADMIN_GG"."AUCTION_RESULT" x SET x."SHOP_ID" = :a0,x."ITEM_ID" = :a1 WHERE x."SHOP_ID" = :b0 AND x."ITEM_ID" = :b1>.

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