ORA-01017 Password Errors When Executing PFT Allocations or FTP Processes from Command Line (Doc ID 1668075.1)

Last updated on NOVEMBER 04, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 6.1 and later
Oracle Financial Services Funds Transfer Pricing - Version 6.1.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When attempting to run any PFT or FTP process from the command line, the following error is thrown:

ERROR

./ofspa INFODOM_200204_EXEC_20131031_4 Allocation Task1 20141031 200204 OFSAA or ./ofstp INFODOM_202519_EXEC_20131031_3 TP TASK1 20131031 202519 OFSAA
Warning: iso88951 does not exist.
Host IP--> 11.222.33.444
HostIP... 11.222.33.444
Port... 6501
[AESCryptorImpl.handleJVM]->INFO: JVM created successfully...
[LOG] Starting up.....
ClsUSmsConnect::ClsUSmsConnect, Forming Login Info statement
Sucssefully Connected to Config schema.
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:

OCI Function: [0] - olon(), orlon()
Oracle Error: [1017] - ORA-01017: invalid username/password; logon denied

Driver Function: drv_oci::Connect()

If either the allocation or FTP process is run from the UI, the process also fails.

An error like the following may exist in the debug log:

Module Logging OFS Access module data: /****************************************************************/
/* Database Connection                */
/****************************************************************/

Module Logging OFS Access module data: /* ODBC Data Source:                */

.
.
.

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [0] - olon(),
    orlon() Oracle Error: [1017] - ORA- 01017: invalid username/
    password; logon denied Driver Function: drv_oci::Connect()

Module Logging OFS Access module data: DB Session Created, Handle: - 1

Module Logging OFS errors: Unable to fetch DB Session: - 1

Module Logging OFS Access module data: Thread Joined, Thread ID: 0

Module Logging OFS errors: Error Joining Threads, Causing Thread ID = 0, Error Code: 3

The errors cause the process to fail.

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