Veridata Compare Error: Agent Message (999): CoosRows veridata-agent.log shows: Database query failed: 'Cursor state not valid.'

(Doc ID 2057887.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate Veridata - Version 12.1.3.0.2 and later
Information in this document applies to any platform.

Symptoms

 Veridata v12.1.3.0.2 compare of iseries DB2 to Oracle error:

***********************************************************************
                       Oracle GoldenGate Veridata
   12.1.3.0.2 20133050 OGGVDT_12.1.3.0.0OGGVDTBP_PLATFORMS_141212.1612

2015-09-18 09:57:47 OGGV-00118: Agent message (999): CoosRows


The VERIDATA_server1-diagnostic.log shows a parse error on COOS:

[2015-09-18T09:11:02.020-07:00] [VERIDATA_server1] [NOTIFICATION]
[OGGV-00639] [oracle.veridata.server] [tid: (1039,1,1)] [userId: veridata]
[ecid: 814c3246-b6e0-4974-87ce-7e89e393c5fb-000038b9,0:35:1] [APP:
veridata#12.1.3.0.0] Starting comparison: MEEYABP=MEEYABP
[2015-09-18T09:57:45.540-07:00] [VERIDATA_server1] [NOTIFICATION]
[OGGV-00641] [oracle.veridata.server] [tid: (1039,1,1)] [userId: veridata]
[ecid: 814c3246-b6e0-4974-87ce-7e89e393c5fb-000038b9,0:35:1] [APP:
veridata#12.1.3.0.0] First row read
[2015-09-18T09:57:47.593-07:00] [VERIDATA_server1] [ERROR] [OGGV-00613]
[oracle.veridata.server] [tid: (1039,1,1):source coos] [userId: veridata]
[ecid: 814c3246-b6e0-4974-87ce-7e89e393c5fb-00003e8d,0] [APP:
veridata#12.1.3.0.0] Error parsing agent response: CoosRows
[2015-09-18T09:57:47.594-07:00] [VERIDATA_server1] [ERROR] [OGGV-00114]
[oracle.veridata.server] [tid: (1039,1,1):source coos] [userId: veridata]
[ecid: 814c3246-b6e0-4974-87ce-7e89e393c5fb-00003e8d,0] [APP:
veridata#12.1.3.0.0] Communication error (172.23.145.248, 7862)
[2015-09-18T09:57:47.594-07:00] [VERIDATA_server1] [ERROR] [OGGV-00118]
[oracle.veridata.server] [tid: (1039,1,1):source coos] [userId: veridata]
[ecid: 814c3246-b6e0-4974-87ce-7e89e393c5fb-00003e8d,0] [APP:
veridata#12.1.3.0.0] Agent message (999): CoosRows

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms