CA Application Performance Management Agent (APM / Wily / Introscope)INTROSCOPE
Issue/Introduction
We saw this error in the IntroscopeEnterpriseManager.log
8/08/18 07:14:47.432 PM BST [ERROR] [pool-29-thread-2] [Manager.AppMap] Exception occured while refreshing ACA cache org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Data source is closed
Any idea why this error occurred and how to avoid it in future?
Environment
APM 10.7 Linux
Cause
The information "Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Data source is closed" indicates that the Enterprise Manager was unable to connect to the APM database
Resolution
In this situation the problem can be ignored as the error was reported during the Enterprise manager shutdown - as can be seen in a previous log entry
If this message occurs and there is no such logical explanation then check the database status and if further assistance is required contact CA Support.