Informix Extract Captures Primary Key Update As Fieldcomp (Doc ID 2030084.1)

Last updated on FEBRUARY 06, 2017

Applies to:

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

Symptoms

On :  12.1.2.1.0 version, 2 - Oracle DB backend

When replicating from Informix to Oracle ,Replicat abends
ERROR
-----------------------
WARNING OGG-01154  SQL error 1403 mapping atago.informix.shop to ORDER_ADMIN.SHOP OCI Error ORA-01403: no data found, SQL <UPDATE "ORDER_ADMIN"."SHOP" x SET x."TIME_STAMP" = :a4 WHERE x."SHOP_ID" = :b0 AND x."URL" = :b1 AND x."CANDY" = :b2 AND x."GUM" = :b3 AND ROWNUM = 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