After staring Introscope, we are observing the following error:
APM Database is not reachable. Please check the connectivity... org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code ; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
Checked the tess-db-cfg.xml file and could see there was no modifications in that.
Please let me know your suggestions to resolve the issue.
I suggest you to read this kb:
Please also look at http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec1664675.aspx
Let us know if these two knowledgebase articles are helpful Or if future assistance is needed
Thank you Sergio and Hal . Issue got resolved
Check pg_hba.conf to see if postgres is listening to the proper IP's. Also check if you're using IPV4 or IPV6 and if its listening properly on those settings.
Also check posgresql.conf and make sure that listen_addresses is set properly, the port configured properly and reflects in tess_db_cfg.xml. Double check what your max_connections are set to.
And of course, double check that your DB process is running.