I-Replicat abends with ORA-01400: cannot insert NULL and Apply Reports ORA-07445 [knlqdqm2usr()+161] (Doc ID 2699198.1)

Last updated on JULY 18, 2023

Applies to:

Symptoms

Oracle GoldenGate Integrated replicat abends with the following error on a table configured with autoCDR:

WARNING OGG-02544  Unhandled error (
ORA-01400: cannot insert NULL into ("<OWNER>"."<TABLE>"."CDRTS$CONTEXT")) while processing the record at SEQNO xx, RBA xxxxx in Integrated mode. REPLICAT will retry in Direct mode.

WARNING OGG-01004  Aborted grouped transaction on <OWNER>.<TABLE>,
Database error 3113 (ORA-03113: end-of-file on communication channel
SQL INSERT INTO "<OWNER>"."<TABLE>" ("<TABLE>_ID","<COL1>","<COL2>,...) VALUES (:a0,:a1,:...)).

ERROR   OGG-00665  OCI Error  Sending data database inbound server, 'OGG$REP' (
status = 3114-ORA-03114: not connected to ORACLE),
SQL INSERT INTO "<OWNER>"."<TABLE>" ("<TABLE>_ID","<COL1>","<COL2>,...) VALUES (:a0,:a1,:...)).

and I-replicat's apply aborted with the following in the alert log:

ORA-07445: exception encountered: core dump [knlqdqm2usr()+161] [SIGSEGV] [ADDR:0x0] [PC:0xB73E911] [Address not mapped to object] []
ORA-01400: cannot insert NULL into ("<OWNER>"."<TABLE>"."<COL1>")
ORA-26787: The row with key ("<COL1>") = (<VALUE>) does not exist in table <OWNER>.<TABLE>
ORA-01403: no data found

Changes

Cause

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