Extract abends with "SQLCODE = -180, ERROR: THE DATE, TIME, OR TIMESTAMP VALUE IS INVALID " on z/OS DB2 environment

(Doc ID 2196141.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

Oracle GoldenGate Capture for DB2
Version 12.2.0.1.2 OGGCORE_12.2.0.1.0_PLATFORMS_160310.1305
z/OS 1.12, DB2 UDB 10.1 on Mar 11 2016 15:33:22

Extract abends with a message like below

2016-09-08 13:55:22 ERROR OGG-00551 Database operation failed: Retrieving encoding information for PSBP.ULAZNI_NALOG. ODBC error: SQLSTATE 22007 native database error -180. {DB2 FOR OS/390}{ODBC DRIVER}{DSN10015}
DSNT408I SQLCODE = -180, ERROR: THE DATE, TIME, OR TIMESTAMP VALUE
2016-03-17.19.41.25.181030 IS INVALID
DSNT418I SQLSTATE = 22007 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXOLTD SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -300 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFED4' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
ERRLOC=1:13:2.

2016-09-08 13:55:22 WARNING OGG-01525 Failed to open trace output file, 'dirdmp/gglog-EXTCDC.dmp', error 111 (EDC5111I Permission denied.).

2016-09-08 13:55:22 ERROR OGG-01668 PROCESS ABENDING.

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