search cancel

Error "Http Status 500" while opening Patch Management console

book

Article ID: 41008

calendar_today

Updated On:

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://…………………

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 [email protected]

Environment

Patch Management installed on Windows

Resolution

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

2.   Set default password “[email protected]” (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