ITPAM service failed to start with below error in c2o.log file:
2022-01-13 13:550:28,447 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] [6.216.68-8080-1] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Login failed for user 'sa'.)
Release : 4.3.X
Component : Process Automation
DB: Microsoft SQL Server
Password for DB user 'sa' got modified in DB and the same was not updated in ITPAM configuration.
Update the encrypted password in OasisConfig.properties file as below:
In the command prompt, navigate to ...\CA\PAM\server\c2o, run: passwordencryption.bat <password in plaintext>
Incase it throws error as "'C:\Program' is not recognized as an internal or external command,", please refer: https://knowledge.broadcom.com/external/article/204129/process-automation-passwordencryptionba.html
On successfully execution, it gives encrypted password as shown (starts from 3rd line, ignore the WARN messages):
Copy the encrypted password and update it in the OasisConfig.properties file at below lines(make sure 'sa' user is used for these 3 databases):
oasis.database.password
oasis.reporting.database.password
oasis.runtime.database.password
Save the file and start the service.
In a cluster environment, apply the above steps for all the nodes.