Static Table Driver Interface Is Very Slow To Open (Doc ID 1509000.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 6.0 to 6.1.1.1 [Release 6]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When attempting to edit and save Static Table Driver with over 20,000 rows the following error occurs.

Error:
User Interface shows:
1021 Static Table Driver Definition not Saved

pftapp.log shows:
[17-10-12 17:24:11 PM] ~ INFO ~ PFT ~ [** Error when clearing temp table **]
java.lang.Exception: Common Search : Error failed to get connection from DBConnectionFactory infodom:INFODOMinfodom=INFODOM

Steps:
1. Open Static table driver, tried to edit it (by changing the coefficient, add a new member, remove an existing member)
2. Try to save and it takes 20 to 30 minutes then it produced the above error.


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