(PC) Support tip: Failed loading DB Connection parameters : Authentication Failed

When try to run a test,  we are getting the following error message:

"Performance Center has Encontered a fatal error"  - Problem encontered when application tried to connect to DB - Failed loading DB Connection parameters : Authentication Failed - Verify your user name and password"

We can see from the log the following error message: 

2017-07-18 16:20:17,537 [5408] [1] DEBUG HP.PC.PCS.LabService - < CheckServerBasic [Context: 611ea10f-896d-48dd-aa72-61bc8b71f7d9] [FullContext: QCServer:xxx UserName:_pc_system_ Domain:DEFAULT Project:LAB_PROJECT]

2017-07-18 16:27:56,957 [5200] [19] ERROR HP.PC.Rest.RestProxy - An exception occured on the REST server:PCRemoteException output START

Message:

Authentication failed. Verify your user name and password.

StatusCode:

InternalServerError

As we can see the issue is related with the _pc_system_, So we need to verify that this user is active and it is an system user. For this particular issue, the root cause was:

 US_IS_ACTIVE under QC_SITE_ADMIN squema USERS table ANYHOW was set  to "N" , and it should be to "Y". So you can run an update query to change the value from "N" to "Y".

Also you should make sure that US_IS_SYSTEM is set to "Y".

HPE Support

Tags: