Informix Extract Captures Incorrect Data Causing Replicat To Abend With Record Not Found Error
Last updated on FEBRUARY 06, 2017
Applies to:Oracle GoldenGate - Version 22.214.171.124.6 and later
Information in this document applies to any platform.
Replication configured from Informix to Oracle
When attempting to start the replicat, the following error occurs.
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>.
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