GGS ERROR 190 Unexpected error fetching from the table - 1

Oracle GoldenGate - Version: 10.4.x and later


Error:
Oracle GoldenGate (OGG) Extract abends with the following error.


GGS ERROR 190 Unexpected error fetching from table - X




This fetching issue is related to specifying fetchcols for a table (or more) when dynamic table resolution is used. The fetch syntax is built for the first table and then not rebuilt so the same syntax is used for all tables that have a FETCHCOLS option. 

Fix:
Add WILDCARDRESOLVE IMMEDIATE parameter to extract


This parameter causes table resolution during start-up processing and the fetch syntax will be created for each table and not reused. This is the same as NODYNAMICRESOLUTION. 

Related Bugs (Ref from Metalink):

BUG:12432903  BUG:12582889