Workload Automation Agent for PeopleSoft (plugin) failed to start with following error in the Agent's peoplesoft.log file:
Connection authorization failure occurred.
Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000
As per the error message, the reason for the Connection authorization failure is;
Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=280000
The User ID or Password used to connect to the PeopleSoft database is either invalid or expired.
You can fix the invalid PeopleSoft user/password account issue by checking with the PeopleSoft Administrator on a valid user/password account to connect to the PeopleSoft database and follow these steps to change the default user/password account information:
Step 1: Encrypt the database password
The program will respond with the encrypted password.
Step 2: Modify the agentparm.txt file
The corrected user account/password should allow the PeopleSoft Agent a successful login into the PeopleSoft database and the Agent start successfully.
CA Workload Automation Agent for PeopleSoft - 11.3 Troubleshooting
Valid on UNIX, Linux, and Windows
Symptom:
When I start the agent, it fails to connect to PeopleSoft. The following error message appears in the peoplesoft.log:
cybermation.plugins.ps.PsConfigException: Failed to connect to PS DB
Solution:
The PeopleSoft database connection parameters are not set correctly.
Follow these steps: