My Oracle Support Banner

OFSAA Application Suddenly Showing Invalid Request / Error while processing request and ORA-01017: invalid username/password; logon denied Errors (Doc ID 2475089.1)

Last updated on MAY 10, 2023

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

On OFSAA 8.0.5, the OFSAA Application is not responding even after attempting to restart all services. After attempting login the following error message appears:

ERROR

Invalid Request / Error while processing request

The following additional error is seen in the SMSService.log file:

ERROR
[UMMLOG] Oct 22,18 11:20:16 : [DACCONNECTIONPROVIDER]Error getting connection : java.sql.SQLException: ORA-01017: invalid username/password; logon denied

[UMMLOG] Oct 22,18 11:20:16 : [DACCONNECTIONPROVIDER]
java.sql.SQLException: ORA-01017: invalid username/password; logon denied

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:385)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1018)
at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:501)

This instance was previously working and there were no known changes or patches applied to affect this instance. Both Tomcat and Database are remote servers.

The issue can be reproduced at will with the following steps:
1. Stop and restart all OFSAA services
2. Attempt to login

Changes

 

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


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