Hello All,
One more issue we are facing while opening VSI or VSM in particular registry and getting below error stack;
In logs also below I am seeing data base errors:
2017-08-08 11:12:55,041Z (12:12) [qtp150892791-107] INFO com.itko.lisa.serverconsole.server.network.vse.GetVirtualServicesHandler - Virtual Service Environment is not null. List of all services = [com.itko.lisa.vse.VirtualServiceStatus@68134cd0, com.itko.lisa.vse.VirtualServiceStatus@4b182111, com.itko.lisa.vse.VirtualServiceStatus@1d23099b, com.itko.lisa.vse.VirtualServiceStatus@674bae0e, com.itko.lisa.vse.VirtualServiceStatus@19904e1d, com.itko.lisa.vse.VirtualServiceStatus@50f85f07, com.itko.lisa.vse.VirtualServiceStatus@6226ee18, com.itko.lisa.vse.VirtualServiceStatus@69d99bff, com.itko.lisa.vse.VirtualServiceStatus@4d90b8a3, com.itko.lisa.vse.VirtualServiceStatus@5849fd1d, com.itko.lisa.vse.VirtualServiceStatus@6188a833, com.itko.lisa.vse.VirtualServiceStatus@52dade4b, com.itko.lisa.vse.VirtualServiceStatus@1f38386c, com.itko.lisa.vse.VirtualServiceStatus@24004a77, com.itko.lisa.vse.VirtualServiceStatus@f18dd18, com.itko.lisa.vse.VirtualServiceStatus@295b5a66, com.itko.lisa.vse.VirtualServiceStatus@2c8bf3c0, com.itko.lisa.vse.VirtualServiceStatus@182fd919, com.itko.lisa.vse.VirtualServiceStatus@6d5604b6, com.itko.lisa.vse.VirtualServiceStatus@2a4f80ce, com.itko.lisa.vse.VirtualServiceStatus@49916a15, com.itko.lisa.vse.VirtualServiceStatus@69cbae6e, com.itko.lisa.vse.VirtualServiceStatus@3b28ee05, com.itko.lisa.vse.VirtualServiceStatus@7c22a89a, com.itko.lisa.vse.VirtualServiceStatus@476b5621, com.itko.lisa.vse.VirtualServiceStatus@57e3b528, com.itko.lisa.vse.VirtualServiceStatus@268a822c, com.itko.lisa.vse.VirtualServiceStatus@4f682a78, com.itko.lisa.vse.VirtualServiceStatus@3fbc5502, com.itko.lisa.vse.VirtualServiceStatus@657116fe, com.itko.lisa.vse.VirtualServiceStatus@639cb1b9, com.itko.lisa.vse.VirtualServiceStatus@44581bc6, com.itko.lisa.vse.VirtualServiceStatus@74878737, com.itko.lisa.vse.VirtualServiceStatus@6dbe67a5, com.itko.lisa.vse.VirtualServiceStatus@6f86b9ec, com.itko.lisa.vse.VirtualServiceStatus@76186e27, com.itko.lisa.vse.VirtualServiceStatus@3de7ff03, com.itko.lisa.vse.VirtualServiceStatus@4a173db5, com.itko.lisa.vse.VirtualServiceStatus@3bd45c13, com.itko.lisa.vse.VirtualServiceStatus@72e90214, com.itko.lisa.vse.VirtualServiceStatus@1f87a9fc, com.itko.lisa.vse.VirtualServiceStatus@3a8ef90, com.itko.lisa.vse.VirtualServiceStatus@4807d8d0, com.itko.lisa.vse.VirtualServiceStatus@7b2b64a1, com.itko.lisa.vse.VirtualServiceStatus@5ddbc533, com.itko.lisa.vse.VirtualServiceStatus@76fc769, com.itko.lisa.vse.VirtualServiceStatus@3b8cc24f, com.itko.lisa.vse.VirtualServiceStatus@1628ef14, com.itko.lisa.vse.VirtualServiceStatus@59681569]
2017-08-08 11:13:07,462Z (12:13) [pool-15-thread-1] ERROR com.itko.lisa.report.services.QueryService - Error cleaning summaries
java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:689)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
at com.itko.lisa.utils.db.LisaWrappedDataSource.getConnection(LisaWrappedDataSource.java:32)
at com.itko.lisa.report.dbutil.ConnectionHelper.getConnection(ConnectionHelper.java:53)
at com.itko.lisa.report.dbutil.ConnectionHelper.getConnection(ConnectionHelper.java:34)
at com.itko.lisa.report.services.QueryService.removeBadSummaries(QueryService.java:6933)
at com.itko.lisa.report.utils.CalcPerfSummary.run(CalcPerfSummary.java:35)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
Please advise in this as well.
Cheers..