Extract On DB2 Abends With ERROR OGG-00551 Database Operation Failed: Retrieving En DSNT408I SQLCODE = -180 (Doc ID 2262146.1)

Last updated on JULY 28, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 to 12.2.0.1.0 [Release 12.2]
IBM z/OS on System z

Symptoms

Using GG version 12.2.0.1 for DB2 z/os, running on z/os version 1.13, extract fails with the following error

2017-03-30 04:31:33 ERROR OGG-00551 Database operation failed: Retrieving encoding information for ICPCB.TCNVR_CNTR_VER. 00014900
 DSNT408I SQLCODE = -180, ERROR: THE DATE, TIME, OR TIMESTAMP VALUE 00015000
  2014-07-24.11.24.06.156377 IS INVALID 00015100
 DSNT418I SQLSTATE = 22007 SQLSTATE RETURN CODE 00015200
 DSNT415I SQLERRP = DSNXOLTD SQL PROCEDURE DETECTING ERROR 00015300
 DSNT416I SQLERRD = -300 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION 00015400
 DSNT416I SQLERRD = X'FFFFFED4' X'00000000' X'00000000' X'FFFFFFFF' 00015500
  X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION 00015600
  ERRLOC=5:10:2.

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