My Oracle Support Banner

GG for DB2 LUW Replicat erroring at SQLEXEC "String Representation Of A Datetime Value Is Out Of Range Error" (Doc ID 2557119.1)

Last updated on OCTOBER 30, 2019

Applies to:

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

Symptoms

In this particular case for DB2 LUW replicat,  when a stored Procedure argument value is NULL then SQLEXEC SP call is not executing but the same SP call from DB2 command line executes successfully.

map <schema>.<Table Name>,target <schema>.<Table Name>,
SQLEXEC
(ID SPAMAL
  ,SPNAME AROYTARGET.SPCALLFROMSQLEXEC
  ,PARAMS( COLINT_IN=COLINT,COLCHAR_IN=COLCHAR,COLTMS_IN=COLTMS), TRACE ALL);

 

Test case:

From replicat SQLEXEC SP call displays error in report file and does not
executes the SP insert but replicat continues processing when the last
argument to the SP call is NULL:

db2 "INSERT INTO <schema>.<Table Name> VALUES (2,2, NULL)"

2018-11-21 12:10:11 INFO OGG-01971 The previous message, 'WARNING
OGG-00869', repeated 1 times.
SQLEXEC SPAMAL error ([IBM][CLI Driver][DB2/LINUXX8664] SQL0181N The string
representation of a datetime value is out of range. SQLSTATE=22007
(native error 4294967115)):
> COLINT_IN: 2
> COLCHAR_IN: 2
> COLTMS_IN:

Where as the below CLP call of the stored procedure executes successfully:

$ db2 "call AROYTARGET.SPCALLFROMSQLEXEC (2,2,NULL)"

Return Status = 0

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.