Hi Guys,
Offlate i happened to see the below warning message getting logged into IS server log frequently… I can see it’s a warning message and it successfully reconnect but my concern is whenver i see this log message I observed IS is losing cluster as well… which give me indication of some serious trouble… i saw the number of DB session’s its pretty much within the limits we have set in our enviornment… fyi… i can set 20 max connection for each pool and at DB end i can see the session are less than this number… so was wondring if you can point me to some direction…
thanks in advance!
I am running on IS 8.0.1 with core Fix 7 and jdbc pool fix 1 (SCG)
2010-11-17 15:24:59 EST [CommonLib.MWS.0002W] DB Server disconnected. Will try to reconnect
[SoftwareAG][SQLServer JDBC Driver]Object has been closed.java.sql.SQLException: [SoftwareAG][SQLServer JDBC Driver]Object has been closed.
at com.wm.dd.jdbc.sqlserverbase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source)
at com.wm.dd.jdbc.sqlserverbase.BaseExceptions40.createSQLException(Unknown Source)
at com.wm.dd.jdbc.sqlserverbase.BaseExceptions.createException(Unknown Source)
at com.wm.dd.jdbc.sqlserverbase.BaseExceptions.getException(Unknown Source)
at com.wm.dd.jdbc.sqlserverbase.BaseConnection.createStatement(Unknown Source)
at com.wm.dd.jdbc.sqlserverbase.BaseConnection.createStatement(Unknown Source)
at com.webMethods.portal.service.sql.core.provider.pool.PoolableConnection.createStatement(PoolableConnection.java:57)
at com.webMethods.portal.service.sql.core.BaseSqlWorker.executeQuery(BaseSqlWorker.java:531)
at com.webMethods.portal.service.sql.runtime.base.CacheGetSysTime.executeQuery(CacheGetSysTime.java:32)
at com.webMethods.portal.service.sql.core.BaseSqlWorker.executeQueryProcOut(BaseSqlWorker.java:734)
at com.webMethods.portal.service.cache.impl.CacheInvalThread.getCheckTime(CacheInvalThread.java:141)
at com.webMethods.portal.service.cache.impl.CacheInvalThread.run(CacheInvalThread.java:71)