My Oracle Support Banner

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 SEPTEMBER 26, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.