My Oracle Support Banner

ORA-04025 - Cursor leaks and Business Object leak when FINS Requirement Manager is intensive used. (Doc ID 2752048.1)

Last updated on APRIL 05, 2021

Applies to:

Siebel CRM - Version 17.0 [IP2017] to 21.3 [Release V17]
Information in this document applies to any platform.

Symptoms

On invocation of below scenario:

- use workflow to invoke FINS Requirement Manager business service, method RunRequirementTemplate for generating documents

the 'FINS Requirement Template' Business Object is leaking with its BCs:

FINS Requirement All Template - Common
FINS Requirement Template Item - Common
FINS Siebel Record Related Item - Common


Those business objects have been registered with the model and so when logging out they will be cleaned up for the number of iterations of the scenario. 

Check the Application Object Manager for Business Object leak:

ObjMgrSessionLog    Debug    5    xxx    Business Object leak: FINS Requirement Template
ObjMgrSessionLog    Debug    5    xxx    Business Object leak: FINS Requirement Template


and then followed by the deletion of the BCs like :

BusComp "FINS Requirement All Template - Common" at xxx was deleted.

This should close the corresponding cursors except for one which will be put in the cursor cache. In heavy environments this could lead to open cursor leak behavior and ORA-04025 error.

Changes

 Use FINS Requirement Manager functionality along with database connection pooling.

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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.