6 Known Issues and Workarounds

This chapter describes the known issues at the time of release.

Release 23ai (23.9) - July 2025

Bug 37873099: Db2 z/OS - Failure to add or delete checkpoint table

If a checkpoint transaction table is improperly cleaned up, the checkpoint table may be removed but the transaction table remains. When this checkpoint table is added again, the transaction table will fail to be added because it already exists.

Workaround

Delete the checkpoint table again. If this doesn't work, then try to manually delete the transaction table, which will be in the same schema as the checkpoint table and will have the same name with _lox appended.

Bug 37710172: Db2 z/OS - Version returned as 0 if the libraries are not authorized

If the WLM steplibs libraries are not authorized then Extract will abend because the version number is 0.

Workaround

Ensure that the libraries are authorized.

Release 23ai (23.8) - April 2025

Bug 37834526: SQL Server - Extract abends on CDC and base table mismatch

Extract compares the table structure of the base table with the CDC capture instance table, causing an abend in case of mismatch.

Workaround

Add the following to the Extract parameter file and restart it: 

TRANLOGOPTIONS GETMETADATAFROMVAM

Release 23ai (23.6) - October 2024

Bug 37152943: Db2 for i - Extract fails with core dump issue for heartbeat table

For Oracle GoldenGate Extract for Db2 for i, abends with the core dump error for heartbeat table. This results in heartbeat functionality not working .

Workaround

None.

Bug 37468391: Oracle - XAGTask is killing all GoldenGate processes running on a node when one Service Manager is stopped

When running Oracle GoldenGate using multiple OGG_HOME directories, and a Service Manager registered with XAG fails, or is stopped by XAG/CRS, all GoldenGate processes running on the server will be stopped, no matter what OGG_HOME they are running out of. This will cause a server wide GoldenGate outage.

Workaround

Only use XAG integration with Oracle GoldenGate on servers with:

  • A single Service Manager.

  • No other Oracle GoldenGate processes running out of a different OGG_HOME.

Release 23ai (23.5) - August 2024

Parallel Replicat is not supported for Sybase

Oracle GoldenGate for Sybase does not support parallel Replicat.

Workaround

Use coordinated or classic Replicat.

Bug 36926498: Sybase - Bi-directional Extract crashes without any error

An issue with Extract configured for bi-directional replication causes the Extract to abend.

Workaround:

None

Bug 36927786: Generic - OGGCA deployment creation is not picking up SYBASE system variable/value

When creating a Sybase deployment, the SYBASE system variable is not getting set automatically for the deployment.

Workaround

Add the SYBASE variable to the deployment’s environment variable configuration manually, and set the path to the Sybase home directory, such as /opt/sap, then restart the deployment.

Release 23ai (23.4) - May 2024

Explicitly exclude Inverted File (IVF) and Hierarchical Navigable Small Worlds (HNSW) index tables

If you are using wildcard parameters, then IVF and HSNW vector index tables must be explicitly excluded from the Extract.

Workaround

None

Extract LSN positioning does not work with 0x:8:8:4 format for the Admin Client

For SQL Server, starting an Extract with ATCSN or AFTERCSN with the Admin Client and using a LSN value with a 0x8:8:4 format is not working as intended.

Workaround

Provide the LSN value in the following format: 0x8:8:4-ffffffff-8:8:4.

For example:

START EXTRACT EXTPROD AFTERCSN 0x000000b3:00002240:0003-ffffffff-000000b3:00002240:0003