View Submitted Tasks results in SQLServerException: The connection is closed.:Error: 7886, Severity: 20, State: 2.


Article ID: 105755


Updated On:


CA Identity Manager CA Identity Governance CA Identity Portal


Error message occurs when clicking on a task in View Submitted Tasks.

Error loading persistence service: The connection is closed.

The Jboss/Wildfly log shows the following:

2018-06-14 12:15:48,325 ERROR [ims.tmt.persistence] (Thread-1387 (HornetQ-client-global-threads-1191891472)) PersistenceProvider: JMS:ID:91139e95-6ff6-11e8-8c6b-e7c5ad84706c: getTaskSession: Exception getting task session: The connection is closed.: The connection is closed.
    at [sqljdbc.jar:]
    at [sqljdbc.jar:]
    at [sqljdbc.jar:]...

This error error occurs on the database:

-- Begin Error --
Date 6/14/2018 12:15:48 PM
Log SQL Server (Current - 6/18/2018 7:09:00 AM)

Source spid90

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.

-- End Error --


There are code changes in the latest  Identity Manager (14.1 CP) that should prevent these errors . If you are unable to apply the latest Cumulative Patch you can add the datasource validation below.


Add this datasource configuration setting in your standalone*.xml:for the task persistence datasource.

<check-valid-connection-sql>SELECT 1</check-valid-connection-sql>

Also, a link from jboss which discusses this setting:

Benefits of using the match on true setting for precheck of datasource connections are: