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://…………………
Patch Management installed on Windows
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.
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.
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