Error "Http Status 500" while opening Patch Management console

Products

• CA Client Automation
• CA Client Automation - IT Client Manager

Issue/Introduction

Trying to open the UPM Console it might be possible that the error message “Http Status 500” appears. 
At the same time the UPM.log generates entries with failure as below: 

15:13:11,067 [ajp-bio-8020-exec-2] FATAL [com.ca.unicenter.upm.eventmanager.UPMException] - SQL exception caught. Stack Trace:
15:13:11,067 [ajp-bio-8020-exec-2] FATAL [com.ca.unicenter.upm.eventmanager.UPMException] - com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'winnt://…………………

Environment

Patch Management installed on Windows

Cause

The error could be related to a mismatch between the upmuser password stored in SQL and password stored in config.properties file.
By default the password is p@ssw0rd. 

Resolution

1.   Open SQL Management Studio -> Logins -> upmuser

2.   Set default password “p@ssw0rd” (without double quotes)

3.   Save and close the SQL

4. Open the Windows Explorer and browse the directory:

<drive>:\ProgramFiles(x86)\CA\UPM\conf\config.properties 

5.   Edit the file entering the below lines:

pdm.config.mdbUser=upmuser 
pdm.config.mdbPassword=BbUwWk+8ZdUMHzfY+/VjEw\=\= 

 

6. Restart Tomcat service with the below commands:

caf stop tomcat 
caf start tomcat

7. Try to open the UPM Console and verify if it works fine.

Additional Information

Having an Oracle DB the below lines could be found in the UPM.log file

FATAL [com.ca.unicenter.upm.eventmanager] - java.sql.SQLException: ORA-01017: invalid username/password; logon denied 

The same resolution steps should be applied as well