My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2019

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 <source table details> to <schema name>.<table name> OCI Error ORA-01403: no data found, SQL <UPDATE <schema name>.<table name> 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.