Extract Abends With ERROR OGG-00551 Database Operation Failed: SQLGetData For Col GDTXFT Table PYDATA08.F00165. (Doc ID 2250057.1)

Last updated on JULY 28, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 to 12.2.0.1.0 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Using GG version 12.2.0.1.0 for DB2 , running on OS/400 version 7.1, extract fails with the following error

 2017-02-14 13:26:17 ERROR OGG-00551 Database operation failed: SQLGetData
  for col GDTXFT table PYDATA08.F00165. ODBC error: SQLSTATE HY009 native data
 base error 0. Error occurred in SQL Call Level Interfac.
  
 2017-02-14 13:26:17 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