Replicat Is Abending With OGG-00660 Could not find unique key column within table definition When FUNCTION BASED INDEX and BATCHSQL Is Used

Issue :

Note : The issue was on Linux x86-64 bit OS

Observation :

After upgrading Goldengate 11.2.x to 19.1.x, replicats on target side abend with OGG-00660 : Could not find unique key column within table definition when BATCHSQL feature is used.

Reason :

Issue is related to Bug 29558383

Fix :

The patches related to this Bug#29558383 were applied and the issue got resolved.

Patch : 30281367

Patch : 31132619

Patch : 32176463

Asif Hussain

13+ years of experience in the IT industry as an Oracle Apps DBA (Oracle Applications 11i,R12) & Oracle DBA (Oracle 9i,10g,11g,12c) with expertise in Implementations/Upgrades/Support/Migrations projects on Oracle Solaris,RHEL,HP-UX,IBM-AIX,OEL,SUSE Linux, Windows