Extract Captures Inserts As Ggspkupdate Causing Replicat To Abend With ORA-1400

(Doc ID 1987062.1)

Last updated on FEBRUARY 06, 2017

Applies to:

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


Replicat running on below version

Oracle GoldenGate Delivery for Oracle
Version OGGCORE_12.
Solaris, sparc, 64bit (optimized), Oracle 11g on Aug 8 2014 06:54:40

fails with error:

2014-11-27 14:33:40 WARNING OGG-00869 OCI Error ORA-01400: cannot insert NULL into ("<schema>"."<table_name>"."<columns_name>400),



 It fails on GGSPKUPDATE operation. But logminer output shows that the operation type is insert for the problematic reecord


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