REPLICAT Reports ORA-01400: Cannot Insert NULL When Using HANDLECOLLISIONS
(Doc ID 1576900.1)
Last updated on DECEMBER 29, 2020
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 <OWNER>.<TABLENAME> at rba xxxxx in file <PATH>/p0000001, while inserting a row into <OWNER>.<TABLE> 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 ("<OWNER>"."<TABLENAME>"."COLx") (status = 1400). INSERT INTO "<OWNER>"."<TABLENAME>" ("KEY_COL1","KEY_COL2","COL3","COL4","COL5") VALUES (:a0,:a1,:a2,:a3,:a4).
WARNING OGG-01004 Aborted grouped transaction on '<OWNER>.<TABLENAME>', Database error 1400 (OCI Error ORA-01400: cannot insert NULL into ("<OWNER>."TABLENAME"."COLx") (status = 1400). INSERT INTO "<OWNER>"."<TABLENAME>" ("KEY_COL1","KEY_COL2","COL3","COL4","COL5") VALUES (:a0,:a1,:a2,:a3,:a4)).
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 |