Telemetry database login error on startup of CA Service Catalog

book

Article ID: 223529

calendar_today

Updated On:

Products

CA Service Catalog

Issue/Introduction

The MDBADMIN password has changed, and while an update to config.properties allows Catalog to log in, the Telemetry service tries to access the database with the wrong password. This should also be corrected, in case too many attempts lock the user out.

Environment

Release : 17.2

Component : SDM - Catalog

Resolution

Telemetry object uses DB connection via mdb.deploy.usmpassword.
 
For your reference,
1.mdb.deploy.password is for a system admin (sa) user password to connect to the DB. This is SQL server system admin credentials.
Ex:
mdb.deploy.user =sa
mdb.deploy.password =XXXXXXX
2. mdb.deploy.usmpassword is a lesser privileged user password (usmuser) who can access Catalog tables.This is a local user(mdbadmin) to perform SQL queries on mdb.
Ex:
mdb.deploy.usmuser = mdbadmin
mdb.deploy.usmpassword = XXXXXXX
 
If you have changed the MDBADMIN password it means you have to update the  USM_HOME\config.properties, mdb.deploy.usmpassword value and restart the catalog services.