Verified Answers


If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Verified Answer
  • Replies reply
    1
  • Subscribers subscribers
    8
  • Views views
    218
  • Users 0 members are here
Related
Options

ALM 15 After db password changes, unable to login to site admin with "Failed to Get DBServers Properties"

Chroncy56

Using ALM 15

After conducting DB users password updates (both DB admin and DBSiteAdmin) and updating the siteadmin.xml file in D:\ProgramData\Micro Focus\ALM\application\20qcbin.war\WEB-INF The admin console will not allow for me to login with the error "Failed to Get DBServers Properties" But the error does not reference any location, whether it is the file system or db location.

sa Logs shows

qtp1470087417-24 [WebFilter:RequestFilterProcess] [GetDBServersProperties] [login_id:3075203] [connect_id:-1] [call_id:16]

 

com.hp.alm.platform.exception.CTdException

Messages:
Failed to Get DBServers Properties; Failed to get DB Servers properties; Failed to obfuscate default admin password for database server 'sa_db_host';

Stack Trace:
com.hp.alm.platform.frec.CTdFrecException: Failed to obfuscate default admin password for database server 'sa_db_host'

com.hp.alm.platform.exception.CTdException

Messages:
Failed to Get DBServers Properties; Failed to get DB Servers properties; Failed to obfuscate default admin password for database server 'sa_db_host';

Stack Trace:
com.hp.alm.platform.frec.CTdFrecException: Failed to obfuscate default admin password for database server 'sa_db_host'
at com.hp.alm.platform.siteadmin.directory.CDbServer.saveToFrec(CDbServer.java:284)
at com.hp.alm.platform.siteadmin.directory.CDbServersDirectory.saveToFrec(CDbServersDirectory.java:186)
at com.hp.alm.platform.siteadmin.api.logics.CDbServerLogic.getDbServersProperties(CDbServerLogic.java:121)
wrapped in com.hp.alm.platform.exception.CTdException: Failed to get DB Servers properties
at com.hp.alm.platform.siteadmin.api.logics.CDbServerLogic.getDbServersProperties(CDbServerLogic.java:126)
at com.hp.alm.platform.siteadmin.requests.GetDBServersProperties.execute(GetDBServersProperties.java:27)
at com.hp.alm.platform.web.RequestsDispatcher.execute(RequestsDispatcher.java:93)
wrapped in com.hp.alm.platform.exception.CTdException: Failed to Get DBServers Properties
at com.hp.alm.platform.web.RequestsDispatcher.execute(RequestsDispatcher.java:104)
at com.hp.alm.platform.server.web.CAbsServlet.executeFunction(CAbsServlet.java:599)
at com.hp.alm.platform.server.web.CAbsServlet.processRequest(CAbsServlet.java:588)
at com.hp.alm.platform.server.web.CAbsServlet.doPost(CAbsServlet.java:439)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)

  • Verified Answer

    +1

    This issue started after updating both DB Admin and Db User passwords. The changes did not fully update all necessary locations, and I had to update the values in the DB_USER_PASS & DB_ADMIN_PASSWORD columns in the QCSITEADMIN_DB.DBSERVERS table to the plain text, but support indicated that "TXT:" was not necessary before the plain text password value. The service was able to start, but I was unable to login to the site admin page. 

    After updating the columns to "TXT:" preceding the plain text password value in each entry on the QCSITEADMIN_DB.DBSERVERS, the error was resolved.

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.