ORA-01000 in the Fuego.Lib.Notification.Send() PAPI-block method (Doc ID 1300149.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Business Process Management Suite - Version: 10.3.2 and later   [Release: AS10gR3 and later ]
Information in this document applies to any platform.

Symptoms

Scenario:
There is  a Global Automatic activity that notifies several instances using the method Notification.send(). When the number of instances (and queued notifications) reaches the number of maximum open cursors limit configured in the database it throws a SQLException with the code ORA-01000 (maximum open cursors exceeded). The error might look like:

<S>, "01/02/2011 10:42:54", Engine, Main, <4> [ACTIVE] ExecuteThrea, "An exception occurred while executing a transaction. Details:
[BEA][Oracle JDBC Driver][Oracle]ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded

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