OGG iSeries Extract Abends With ODBC Error: SQLSTATE 42703 native database error -206. Column or global variable "<table>" not found.
(Doc ID 2249837.1)
Last updated on APRIL 06, 2017
Applies to:
Oracle GoldenGate - Version 12.1.2.1.10 and laterInformation in this document applies to any platform.
Symptoms
After Upgrading OGG to 12.1.2.12, Extract configured for DB2 on iSeries Abends with below error:
Command executed : - start eloada
2016-09-08 17:07:01 INFO OGG-00993 Oracle GoldenGate Capture for DB2 for i, ELOADA.prm: EXTRACT ELOADA started.
2016-09-08 17:07:08 ERROR OGG-00551 Oracle GoldenGate Capture for DB2 for i, ELOADA.prm: Database operation failed: Preparing statement (SELECT RTRIM(CAST("GM.MST" AS CHAR(600...). ODBC error: SQLSTATE 42703 native database error -206. Column or global variable "GM.MST" not found.
2016-09-08 17:07:08 ERROR OGG-01668 Oracle GoldenGate Capture for DB2 for i, ELOADA.prm: PROCESS ABENDING.
Changes
OGG was upgraded to 12.1.2.12 version.
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 |