Replicat Abending After SQL MX 3.2 Upgrade (Doc ID 1993428.1)

Last updated on JANUARY 12, 2017

Applies to:

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

Symptoms

Replicat abends with

WARNING OGG-00869  [SQL error 0 (0x0)][HP][ODBC/MX Driver]GENERAL ERROR. Null Value in a non nullable column. Row: 1 Column: 75.
ERROR   OGG-01296  Error mapping from $X.X.LOG09999 to RSM. FINIPC_SEGS_REPLAY.

After SQL/MX upgrade. The statement that caused this was

date_recon_acqr = @if(@STRCMP(date-recon-acqr,"000000"),@colstat(null),@date("yyyy-mm-dd 00:00:00.001","yymmdd",date-recon-acqr)),

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