Oracle GoldenGate z/OS Extract And Defgen Abend with SQLCODE -180: Date, Time, Timestamp Value Invalid (Doc ID 2173869.1)

Last updated on APRIL 18, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
IBM z/OS on System z

Symptoms

  Extract or Defgen abend with:

OGG-00551 Database operation failed: Retrieving encoding information ... ODBC error: SQLSTATE 22007 native database error -180.

{DB2 FOR OS/390}{ODBC DRIVER}{DSN11010}
DSNT408I SQLCODE = -180, ERROR: THE DATE, TIME, OR TIMESTAMP VALUE 2016-08-12.15.40.21.428673 IS INVALID

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