Oracle Waveset / Siebel Connector (1.0.1) / "ORA-01000: maximum open cursors exceeded"
(Doc ID 1524579.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Waveset - Version 184.108.40.206 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Sep-2014***
The purpose of this knowledge document is to explain a known defect that exists in the Siebel Connector that ships with Oracle Waveset 220.127.116.11 (and later 8.1.1.x releases).
The Siebel Connector will be reported as the following in your lh assessment output:
For the record, this same Siebel Connector is also used with the Oracle Identity Manager (OIM) provisioning product and it's also affected by the same known defect.
The Siebel Connector in both OW and OIM is known as an ICF Connector, which means it's using the common Identity Connector Framework (ICF).
The known defect is documented as:
Bug 13705530: SIEBEL CONNECTOR: ORA-01000: MAXIMUM OPEN CURSORS EXCEEDED
The problem/exception is usually seen when running reconciliation.
The specific error is:
ORA-01000: maximum open cursors exceeded
The full exception looks like this:
org.identityconnectors.framework.common.exceptions.ConnectorException: 2567733356An error has occurred preparing a Sql statement. Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00108)Unknown 7733356 An error has occurred preparing a Sql statement. Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00108) 7733355 ORA-01000: maximum open cursors exceeded
Below I've included the existing patch that resolves this known defect along with its installation instructions that pertain specifically to Oracle Waveset.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document