AnsweredAssumed Answered

Wily Message: APM Database is not reachable

Question asked by ale81 on May 29, 2013
Latest reply on Jun 2, 2013 by Vaibhav Vir Singh
Hello I have finished t o install CA Wily Introscope Enterprise Manager Release (Build 581100) for connecting with SAp Solution Manager, in the installa´s log i got this message:


Installation: Successful.

1166 Successes
0 Warnings
0 NonFatalErrors
0 FatalErrors

However,, after to start de EM I got this messages on /ccms/apmintroscope/logs/IntroscopeEnterpriseManager.log

I think that the problema is I don´t have connection with DB cemdb

Any sugestion for this problem???


log4j:WARN No appenders could be found for logger (com.mchange.v2.log.MLog).
log4j:WARN Please initialize the log4j system properly.
5/28/13 07:42:19.329 PM ECT [ERROR] [main] [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!




at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(

at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(

at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(

Caused by:
java.sql.SQLException: Connections could not be acquired from the underlying database!

at com.mchange.v2.sql.SqlUtils.toSQLException(

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(

at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(

Caused by:
com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool cannot acquire a new resource -- the factory or source appears to be down.

at java.lang.Throwable.<init>(

at com.mchange.lang.PotentiallySecondaryException.<init>(

at com.mchange.lang.PotentiallySecondaryException.<init>(

at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(

at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(

at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(

... 21 more
5/28/13 09:14:49.758 PM ECT [WARN] [InitializationPool.Thread3] [] ExportReportJob cannot be initialized
org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'cemdb': java.sql.SQLException: Can't allocate JDBC connection [See nested exception: java.sql.SQLException: Can't allocate JDBC connection]]

at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(

at org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(

at org.quartz.impl.StdSchedulerFactory.instantiate(