Trying to open the UPM Console the following error could be displayed: ?Http Status 500?

book

Article ID: 41008

calendar_today

Updated On:

Products

CA Automation Suite for Data Centers - Configuration Automation CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Remote Control CA Client Automation - Asset Intelligence CA Client Automation - Desktop Migration Manager CA Client Automation - Patch Manager

Issue/Introduction

Issue: 

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:  

UPM installation on Windows environment

 

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]

 

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

Environment

Release: UASIT.99000-12.9-Asset Intelligence
Component: