CA IDM 14.1 issue with SQL error 7886

[Legacy User]

Hi,

 

We have CA IDM 14.1 version. We are using SQL server database.

Does anyone know how to fix this issue? 

 

 

On SQL server, we saw this error a few times:-

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.

 

We also checked that database is running in READ COMMITTED mode.

[Michael Niebuhr]

I see several fixes that were created for the error Error: 7886, Severity: 20, State: 2 in the older 12.6 versions of the software.  Either these fixes did not make it into 14.1 or the problem has resurfaced.

 

Can you please open a support case so we can review and if necessary get the SE team to correct this behavior in 14.1?

[idmrb idmrb]

Hi,

after upgrading to 14.1 we face the same issue on JBoss 6.4.

Can you please share the solution to this issue?

We have already tried the following:
1) set transaction isolation level in standalone xml
  <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
2) https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=105755 configuration change
<validate-on-match> true </validate-on-match>
<background-validation> false </background-validation>

None of this helped.

Thanks for the reply

Eva