Avoid deadlocks

[AlexisMolina]

Hi everyone,

I have a report that is automatically updated every 3 minutes, sometimes appears a deadlock error. How can I avoid this? or how can I achieve the report's refresh although this happens (after the deadlocks finish)?

This is the error Cognos shows:

XQE-DAT-0001 Data source adapter error: com.microsoft.sqlserver.jdbc.SQLServerException: La transacción (id. de proceso 87) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction....

Thanks!

[MFGF]

Hi everyone,

I have a report that is automatically updated every 3 minutes, sometimes appears a deadlock error. How can I avoid this? or how can I achieve the report's refresh although this happens (after the deadlocks finish)?

This is the error Cognos shows:

XQE-DAT-0001 Data source adapter error: com.microsoft.sqlserver.jdbc.SQLServerException: La transacción (id. de proceso 87) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction....

Thanks!

Hi,

You could try changing the transaction isolation level of the data source connection in Cognos? Try Read Committed or Read Uncommitted - this might avoid the deadlocks.

MF.