REPLICAT Reports ORA-01400: Cannot Insert NULL When Using HANDLECOLLISIONS (Doc ID 1576900.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle GoldenGate - Version 11.2.0.0.0 to 12.1.2.0.0 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

On : 11.2.1.0.6 version, 1 - Oracle DB backend

When attempting to INSERT a row,
the following errors occur.

REPLICAT ERROR
----------------------------------------------
WARNING OGG-01396  A complete after image is not available in USER1.TABLE1 at rba 32555908 in file /app/oracle/product/gghome/dirdat/p0000001, while inserting a row into USER1.TABLE1 due to missing target row for a key update operation. NOCOMPRESSUPDATES or FETCHOPTIONS FETCHPKUPDATECOLS may be specified in the EXTRACT parameter file to include a complete image for key update operations.
WARNING OGG-00869  OCI Error ORA-01400: cannot insert NULL into ("USER1"."TABLE1"."COL6") (status = 1400). INSERT INTO "USER1"."TABLE1" ("KEY_COL1","KEY_COL2","COL3","COL4","COL5") VALUES (:a0,:a1,:a2,:a3,:a4).
WARNING OGG-01004  Aborted grouped transaction on 'USER1.TABLE1', Database error 1400 (OCI Error ORA-01400: cannot insert NULL into ("USER1"."TABLE1"."COL6") (status = 1400). INSERT INTO "USER1"."TABLE1" ("KEY_COL1","KEY_COL2","COL3","COL4","COL5") VALUES (:a0,:a1,:a2,:a3,:a4)).


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