Informix Extract Captures Primary Key Update As Fieldcomp

(Doc ID 2030084.1)

Last updated on FEBRUARY 06, 2017

Applies to:

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


On : version, 2 - Oracle DB backend

When replicating from Informix to Oracle ,Replicat abends
WARNING OGG-01154  SQL error 1403 mapping 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>.


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