(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   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   ERROR HP.PC.Rest.RestProxy - An exception occured on the REST server:PCRemoteException output START
Authentication failed. Verify your user name and password.
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".