Replicat Abends With Errror mapping SchemaA.TABLEA to CatalogA.SchemaB.TABLEA OCI Error ORA-01400 and warning OGG-01154 SQL error 1400
(Doc ID 2739126.1)
Last updated on JULY 20, 2024
Applies to:
Oracle GoldenGate - Version 19.1.0.0.4 and laterInformation in this document applies to any platform.
Symptoms
WARNING OGG-01154 SQL error 1400 mapping SchemaA.TABLEA to CatalogA.SchemaB.TABLEA OCI Error ORA-01400: cannot insert NULL into (SchemaB.TABLEA."NOT_NULL_CLOUMN_NAME") (status = 1400), SQL <INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO SchemaB.TABLEA ("COLUMN A","NOT_NULL_CLOUMN_NAME","COLUMNB" ... )
Replicat Abends With Errror ORA-01400
Replicat Abends
====================
with mapping error message
Discarded record from action ABEND on error 1400
OCI Error ORA-01400: cannot insert NULL into (CatalogA.SchemaB.TABLEA.NOT_NULL_CLOUMN_NAME) (status = 1400), SQL <INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO CatalogA.SchemaB.TABLEA ("column 1 ","NOT_NULL_CLOUMN_NAME","column 2","column 3",......) VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9,:a10)>
Aborting transaction on trail file location beginning at seqno xxx rba xx
error at seqno xxx rba xxx
Problem replicating source.tablename to target.tablename.
Mapping problem with insert record (target format) SCN:xxxxxxxxx...
*
Replicat Abends With Errror ORA-01400
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 |