Siebel Data Quality Manager (DQMgr) Batch Deduplication Task Returns Error "ORA-01000: maximum open cursors exceeded" With EDQ (Doc ID 1679854.1)

Last updated on MAY 16, 2017

Applies to:

Siebel Data Quality - Version 8.1.1.10 [23021] and later
Oracle Enterprise Data Quality - Version 9.0.5 and later
Oracle Enterprise Data Quality Customer Data Services Pack - Version 9.0.5 and later
Information in this document applies to any platform.

Symptoms

SIEBEL VERSION:
---------------
Siebel 8.1.1.10 [23021] + EDQ 9.0.5

ISSUE STATEMENT:
----------------
Customer is using Siebel 8.1.1.10 and doing batch deduplication with DQMgr using Oracle EDQ as the DQ Software. They are seeing Batch Deduplication DQMgr job aborting with max cursors exceeded error.

- The max cursors exceeded issue/error occurs with DQMgr is executed for all records, no where clause.

- When they provide a where clause to limit the records say with Lowe* or L*, cursors are not exceeded, the error does not occur.

WHERE IT HAPPENED:
-------------------------------
The issue happens in customer's test environment.

STEPS TO REPRODUCE:
-------------------------------
The behaviour occurs as follows:

1. Run DQMgr deduplication task without an object where clause, the error will occur when there is a lot of data.

BEHAVIOR PATTERN:
-------------------------------
Behaviour occurs only when running DQMgr without a where clause.

LOSS OF FUNCTIONALITY / BUSINESS IMPACT:
------------------------------
Due to max cursor error, the DQMgr job is not complete and data is not properly deduplicated/matched.

ERROR MESSAGE:
-------------------
The error message that occurs with this issue is:

GenericLog GenericError 1 000009ad53710034:0 2014-05-13 18:17:39 ( (0) err=2818155 sys=7733355) SBL-OMS-00107: Object manager error: ([1] ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded

Changes

 

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