Yesterday, while performing some activities in Quality Center Site Admin, I got following error on one of the projects.
Messages:
Failed to Get Users In Project;
Failed to get users of project id = ***;
Stack Trace:
com.mercury.jdbc.base.BaseSQLException: [Mercury][Oracle JDBC Driver][Oracle]ORA-28000: the account is locked
**I have clipped the rest of stack trace
I got the idea but still, in an effort to not to contact the DBA, I deactivated the project. On trying to activate the project, I again got following message.
Messages:
Failed to Get Projects Properties;
Failed to get projects properties;
Failed to save projects properties;
Cannot build directory item for key ‘[***_db@jdbc:mercury:oracle://***:1521;sid=***(***_db)]’ in TD Tables Struct Dir;
Failed to fill table struct for table null in database ***_db@jdbc:mercury:oracle://***:1521;sid=***(***_db);
[Mercury][Oracle JDBC Driver][Oracle]ORA-28000: the account is locked
;
**I have clipped the rest of stack trace
The solution was very simple. I did not have to do anything here. I just dropped an email to the DBA asking him to unlock the account. Bingo!!!
Still if you want detailed solution from DBA end, following link may help: