OGG v11.2 Replicat Fails OGG-00868 OCI Error ORA-01400: Cannot Insert NULL into ("OGG_ADMIN"."CHECKPOINT_LOX"."LOG_CMPLT_CSN") , OGG-00446 CSN Not Found in Supplemental File /u01/App/Oracle/Goldengate/Dirchk/RPBSINI.Cps.

(Doc ID 1468424.1)

Last updated on DECEMBER 16, 2014

Applies to:

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

Symptoms

Case 1:

Replicat fails with following error when using a checkpoint table

2012-06-14 11:59:50 ERROR OGG-00868 OCI Error ORA-01400: cannot insert NULL into ("OGG_ADMIN"."CHECKPOINT_LOX"."LOG_CMPLT_CSN")

When not using checkpoint table it fails with

2012-06-14 15:29:13 ERROR OGG-00446 CSN not found in supplemental file /u01/app/oracle/goldengate/dirchk/RPBSINI.cps.

 

Case 2:

Pump extract fails with error 

ERROR OGG-00446 CSN not found in supplemental file /ggate/dirchk/PTEST.cps.

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