AnsweredAssumed Answered

SQL connection terminated

Question asked by Gutis Champion on Jun 26, 2015
Latest reply on Jun 3, 2016 by Gutis

We have IM 12.6 SP5 working on JBOSS 6.3 EAP. Object store and other DBs are on MS SQL 2012. User store is on eTrust directory. CA IM databases are split within SQL server.

 

IM and SQL server are on different hosts. Sometimes connection between them closed without any reasons and we need to restart JBOSS.

 

On SQL server corresponding error is:

Error: 7886, Severity: 20, State: 2.

A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED isolation level. This connection will be terminated.

The same error is in two different IM implementations.

 

 

Please assist.

Outcomes