Author: Mary_Clark
Document ID: TEC596118
Last Modified Date: 7/25/2013
Description:Seeing the following messages in the EM (MOM or Tim Collector) logs:[PO:AppMapAgentPO Mailman 1] [Apm.Data.Model] [ Method : saveAllEdges, RootCause : A ResourcePool could not acquire a resource from its primary factory or source., Error Message : Could not open Hibernate Session for transaction org.hibernate.exception.GenericJDBCException: Cannot open connection][ERROR] [WrapperSimpleAppMain] [Apm.Data.Model] 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 [0]; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!These errors are indicating connection to the APM Database is not available.Solution:There is only one APM Database in a cluster. It may be installed locally to the MoM or a Collector, or it may be on a remote server.APM supports either Oracle or Postgres databases. This article focuses on problems you may experience when attempting to connect to an Oracle APMDB database and discusses what to do about them.Problem: EM's are unable to connect to the APM Database with the following exception: java.sql.SQLException:Connections could not be acquired from the underlying database!Enlist help from your Oracle DBA as necessary to perform the following tests.Restart the APMDB Oracle database listener.Restart the APMDB Oracle database instance.If you are able to use sqlplus or SQLDeveloper to access the database, check the version of the APMDB to be sure it is the same as the version of the APM software you are using by getting the output of:SELECT ts_db_versions FROM ts_domains;You can delete the OSGI cache to attempt a clean connection as follows: delete all org.* folders present in the <EM_Home>/product/enterprisemanager/configuration folder and restart all EMs (MoM and Collectors).
Search the Entire CA APM Knowledge Base