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 APRIL 17, 2023

Applies to:

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

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