Error OGG-00788 When Extracting Data In Golden Gate (Doc ID 2596163.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Error OGG-00788 when extracting data in Golden Gate

Running Oracle Golden Gate 12.3 to extract data from a DB2 database.
Using a Linux app server connecting to the database with DB2 connect.

Here are the messages from the ggserr.log file :

2019-09-10T08:27:09.283+0200 INFO OGG-06509 Oracle GoldenGate Capture for DB2<Extract_name>.prm: Using the following key columns for source<extract_name><extract_name>: <extract_name><owner>.<table_name>.
2019-09-10T08:27:09.283+0200 WARNING OGG-00788 Oracle GoldenGate Capture for DB2, <Extract_name><extract_name>.prm: check DB2 maintenance for the presence of PQ78544 and the absence of PQ96356 - contact Oracle Support if PQ96356 has been applied.
2019-09-10T08:27:09.283+0200 WARNING OGG-01262 Oracle GoldenGate Capture for DB2, <Extract_name><extract_name>.prm: The call to the cm_co_at_end() function from line 2347 in cm_item_get_next() failed with reason 'cm_item_get_next: no more items: error: 124: co: 00007FE4BC1E3100 obj_id: '.
2019-09-10T08:27:09.283+0200 ERROR OGG-02171 Oracle GoldenGate Capture for DB2, <Extract_name><extract_name>.prm: Error reading LCR from data source. Status 515, data source type 3.
2019-09-10T08:27:09.283+0200 ERROR OGG-02244 Oracle GoldenGate Capture for DB2, <Extract_name><extract_name>.prm: Error reading LCR from TranLog data source. error (124, cm_item_get_next: no more items: error: 124: co: 00007FE4BC1E3100 obj_id: ) retrieving item (1) for transaction.
2019-09-10T08:27:09.283+0200 ERROR OGG-01668 Oracle GoldenGate Capture for DB2, <Extract_name><extract_name>.prm: PROCESS ABENDING.

 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.