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.
Workload Automation Agent for PeopleSoft (plugin) on UNIX, Linux and Windows
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
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
The PeopleSoft database connection parameters are not set correctly.
Follow these steps: