Integrated Replicat Runs Slower With ORA-1840 Warning For Default On NULL column

(Doc ID 2369232.1)

Last updated on MARCH 07, 2018

Applies to:

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

Symptoms

Customer referred earlier Doc ID 2209092.1 and one off Patch 21820934 was applied. Still we were seeing the warning and replicat slowness for the column which had Default Value for a NULL Column with NOT NULL constraint on it.

 

2017-10-23 13:23:55  WARNING OGG-02544  Unhandled error (ORA-01840: input value not long enough for date format) while processing the record at SEQNO 1672, RBA 232201766 in Integrated mode. REPLICAT will retry in Direct mode.

Classic Replicat runs fine with same configuration.

 

Changes

 Replicating a table having Default on NULL column

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