My Oracle Support Banner

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

Last updated on AUGUST 19, 2020

Applies to:

Oracle GoldenGate - Version 12.3.0.1.4 and later
Information in this document applies to any platform.

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

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
Changes
Cause
Solution
References


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