Unable to Login to OFSAA After Upgrading AAI To 184.108.40.206 / "ORA-01000: maximum open cursors exceeded" Error Upon Running saltuserprofiles.sh
(Doc ID 2432878.1)
Last updated on AUGUST 08, 2018
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Unable to login OFSAA Application after upgrading OFSAA 220.127.116.11 via Patch 27504805 - CONSOLIDATED FIXES OF ALL ISSUES IDENTIFIED IN AAI COMPONENTS POST 8051 ML
None of the users can log into the OFSAA application anymore. When users attempt to login, error message is being displayed on the screen.
Login was not allowed either while using decrypted credentials data from database.
When verifying installation logs, ORA-01000 error message was found while executing saltuserprofiles.sh script. saltuserprofiles.sh script seems to have been run successfully for only 1000 of the total users.
 Please Contact Your System Administrator.
ORA-01000: maximum open cursors exceeded
STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
- Apply Patch 27504805.
- Check whether there are any login issues in the environment.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!