Replicat Abending After SQL MX 3.2 Upgrade
Last updated on JANUARY 12, 2017
Applies to:Oracle GoldenGate - Version 126.96.36.199.5 and later
Information in this document applies to any platform.
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)),
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