OFSAA PFT Does Not Close Database Session Connections (Doc ID 1438748.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 5.6 to 5.6 [Release 5]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.2
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x
OFSPM


Symptoms

In Oracle Financial Services Profitability Management (PFT), 5.6, when a user refreshes Allocation Execution History, an inactive database session is left opened.  OFSAA Application does not close the database connections properly and maximum amount of allowed database connections is reached, causing impossibility to log in in the application afterward.

The following errors are written in the log file alter reaching maximum number of db connections:

ERROR

Error while loading the page.

Not able to execute the query for module Id_Type: ALLC_SPEC_PFT: infodom:
INFODOMMAIN
Query:SELECT distinct fsi_m_object_definition_tl.short_desc
"2",fsi_m_object_definition_b.creation_date
"4",fsi_m_object_definition_b.created_by "3",fsi_alloc_type_mls.alloc_type
"8",fsi_m_object_definition_b.last_modified_date
"6",fsi_m_object_definition_b.modified_by "5",
DECODE(fsi_m_object_definition_b.access_cd, 'R', 'Read Only', 'W', 'Read /
Write') "7", REV_SEGMENT_MAST_V.V_SEGMENT_NAME "9", DECODE(fdi.batch_name,
null, 'BLANK', fdi.batch_name, fdi.batch_name) "10",
fsi_m_object_definition_b.object_definition_id "PrimaryKey", '200~' ||
fsi_m_object_definition_tl.long_desc || ':201~' ||
fsi_m_object_definition_b.object_definition_id "DBToolText",
fsi_m_object_definition_tl.short_desc
||'&folder='||fsi_m_object_definition_b.folder_name "TaskName",
fdi.as_of_date "ErrorDate" from
fsi_m_object_definition_b,fsi_m_object_definition_tl, fsi_m_allocation_rule,
fsi_alloc_type_mls, fsi_data_identity fdi, REV_SEGMENT_MAST_V where
fsi_m_object_definition_b.object_definition_id =
fsi_m_object_definition_tl.object_definition_id and
TO_CHAR(fdi.description(+)) =
TO_CHAR(fsi_m_object_definition_b.object_definition_id) and NVL((SELECT
MAX(ROWID) from fsi_data_identity fdid WHERE fdid.description =
fdi.description ),CHARTOROWID('AAAFd1AAFAAAABSAA/')) =
NVL(fdi.ROWID,CHARTOROWID('AAAFd1AAFAAAABSAA/')) and
fsi_m_object_definition_b.id_type = 0 and fsi_alloc_type_mls.alloc_type_cd =
fsi_m_allocation_rule.allocation_type_cd and
fsi_m_allocation_rule.allocation_sys_id =
fsi_m_object_definition_tl.object_definition_id and
fsi_m_object_definition_b.deleted_flag = 'N' and
REV_SEGMENT_MAST_V.V_SEGMENT_CODE = fsi_m_object_definition_b.folder_name and
REV_SEGMENT_MAST_V.V_DSNID = 'INFODOMMAIN' AND
fsi_m_object_definition_b.folder_name = '4'


DEBUG - Executing action method = doValidate
java.lang.Exception: Common Search : Error failed to get connection from
DBConnectionFactory infodom:INFODOMMAIN
at
com.ofs.reveleus.common.summary.common.DBManager.getConnection(DBManager.java:50)
at
com.ofs.reveleus.common.summary.common.DBManager.executeQuery(DBManager.java:72)
at
com.ofs.reveleus.common.summary.action.RedirectAction.doValidate(RedirectAction.java:415)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611) ...."

Steps to reproduce the issue:

1. Enter Financial Service Application
2. Open any allocation in edit mode
3. Close allocation with "Cancel" buttom
4. Open Allocation History view
5. Reset the Allocation History view
6. Reset the Allocation History view again and again ====>
check that the DB sessions are increasing.

Note: The following select statement can be used to check the number of sessions in DB

select SCHEMANAME, OSUSER, STATUS, count(*) from V$Session
group by SCHEMANAME, OSUSER, STATUS;

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