Not Null Lob Column Failing With ORA-1400 For Replicat Using INSERTALLRECORDS (Doc ID 2231128.1)

Last updated on FEBRUARY 09, 2017

Applies to:

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

Symptoms

Goldengate replicat abending with ORA-1400 for an INSERT against a table with LOB columns.

Replicat Discard file shows the originating record is an UPDATE:

 

Oracle GoldenGate Delivery for Oracle process started, group REP1 discard file opened: 2017-02-03 12:49:42.100570
Current time: 2017-02-03 12:49:42
Discarded record from action ABEND on error 1400

OCI Error ORA-01400: cannot insert NULL into ("SCOTT"."TEST"."COL_LOB_TEST1") (status = 1400), SQL <INSERT INTO "SCOTT"."TEST" ("COL1_KEY","COL2_DESC") VALUES (:a0,:a1)>
Aborting transaction on ./dirdat/e1 beginning at seqno 4 rba 1210426
error at seqno 4 rba 1210426
Problem replicating SCOTT.TEST to SCOTT.TEST
Mapping problem with compressed update record (target format)...

 

Changes

Using replicat INSERTALLRECORDS option.

Affected LOB column is NOT NULL on target.

 

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