When we use extraction process with certain macro filters, and send the trails to a goldengate with JAVA adapter, the java extract process fails with the following error: OGG-00354 Invalid BEFORE column:(column_name).
EXTRACT PROCESS
EXT01 exttrail ./dirdat/e1, FORMAT RELEASE 11.1 GETUPDATEBEFORES include ./dirmac/filter.mac TABLE OWNER01.TABLE01, #filter01();
PUMP PROCESS
PUMP01 rmthost ggjava.net rmttrail ./dirdat/j1 , format release 11.1 GETUPDATEBEFORES TABLE OWNER01.TABLE01;
EXTRACT GG JAVA
EXTRACT JAVA01 GETUPDATEBEFORES TABLE OWNER01.TABLE01;
In some cases, this issue can be resolved just removing the clause “GETUPDATEBEFORES”, as reported in the Oracle note (Doc ID 2151605.1). But in some environments this procedure not resolve, because it is an undocumented bug in goldengate JAVA 11.1, which is caused by the use of format release 11.1.
This same process has been testing in goldengate 12.1, with format release 12.1, and the problem not occurs.
The solution is the upgrade! \o/
Dieison.