PAT2 - Compliance Studio Failed Due To Invalid Username And Password (Doc ID 2961171.1)

Last updated on JULY 18, 2023

Applies to:

Symptoms

On : 8.1.2 version, MICC Transfer to TSC

Invalid username and password.

steps to reproduce:

1. Go to <compliance studio>/deployed/ficdb/bin

2. Run the ER job 1 

nohup ./ER_Create_And_Load_Data_Into_Index.sh "CSA_812" "<ER alias name>" "DeltaLoad" "<fic_mis_date>" "<pipeline>" "CSA_812" "CSA_812" "TEST" &

Expected result:

The Job should be successful.

Actual result:
The job got failed due to below error.

Failed due to invalid username and password

/home/afccmap1:$ cat nohup.out
Exception occurred while getting connection with schema alias: walletentres812. Exception: java.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-01017: invalid username/password; logon denied
)
Exception occurred while getting connection with schema alias: walletentres812. Exception: java.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-01017: invalid username/password; logon denied
)
Exception occurred while getting connection with schema alias: walletentres812. Exception: java.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-01017: invalid username/password; logon denied
)
Exception occurred while fetching status: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

Cause

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