AnsweredAssumed Answered

What does "[CA Clarity][SQLServer JDBC Driver]Socket closed" indicate?

Question asked by LoriHagewood on Jul 15, 2011
Latest reply on Jul 16, 2011 by another_martink
Hi, all.

I'm having some problems accessing our Clarity 12.0.3 development environment (2 app servers behind a load balancer), and when I start the services I noticed the following in the bg-niku.log. Can someone point me to a few places to look to troubleshoot? Our database is SQL Server on a shared VM cluster. I can hit the application if I'm RDP'd into the server itself, but can't from my own workstation and can't figure out why. I'm wondering if it has something to do with the following message. Thanks in advance!

ERROR 2011-07-15 11:14:02,544 [Dispatch Thread-4 : bg@servername] union.persistence (none:none:none) Error closing statement
java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver]Socket closed

at com.ca.clarity.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.ca.clarity.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.ca.clarity.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.ca.clarity.jdbc.sqlserver.tds.TDSRPCRequest.submitRequest(Unknown Source)

at com.ca.clarity.jdbc.sqlserver.tds.TDSRPCNonCursorExecuteRequest.unprepare(Unknown Source)

at com.ca.clarity.jdbc.sqlserver.SQLServerImplStatement.close(Unknown Source)

at com.ca.clarity.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)

at com.ca.clarity.jdbc.base.BaseStatement.close(Unknown Source)

at com.ca.clarity.jdbc.base.BasePreparedStatement.close(Unknown Source)

at org.logicalcobwebs.proxool.AbstractProxyStatement.close(AbstractProxyStatement.java:113)

at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:66)

at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$89345268.close(<generated>)

at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2341)

at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:701)

at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:610)

at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:450)

at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:221)

at com.niku.service.jobs.InvestmentAggregator.executeUpdate(InvestmentAggregator.java:438)

at com.niku.service.jobs.InvestmentAggregator.executeUpdate(InvestmentAggregator.java:412)

at com.niku.service.jobs.InvestmentAggregator.recreateFLAT(InvestmentAggregator.java:680)

at com.niku.service.jobs.InvestmentAggregator.aggregate(InvestmentAggregator.java:182)

at com.niku.service.jobs.AggregateRequestor.scheduledEventFired(AggregateRequestor.java:64)

at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:265)

at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:727)

at java.lang.Thread.run(Thread.java:595)

Outcomes