Devart Forums

I have a data collection app that is inserting into my DB and whilst this is inserting on another app running a select query i get the error

Transaction (Process ID nn) was deadlocked on lock resources with with another process and had been chosen as the deadlock victm. Rerun the transaction.

How should i deal with this?

Thanks

Please specify the isolation level of your transactions in both applications. You can also take a look at this article.

In both cases it is ilReadCommitted and only one process is in a transaction inserting records. The other is a TMSQuery 'select'

It seems that this is not a SDAC problem. Could you please try to read data using SQL Server Management Studio.

I assume the error is returned by the engine. problem is how do I handle it.

Only one of the apps is using a transaction to insert records into the database.

The second "victim" app is running a select query (reading).

the error is still presented, even if i place a try/except around the query.open

To solve the problem try to set the TMSQuery.ReadOnly property to True.

Thanks for the reply.

I tried that and it did not work.

I also tried setting the locktype to ltnolock.

The select statement had some aggregate select statements, I added WITH (NOLOCK) to each of these and I think it may have solved it.

regards

Steve

Was the problem solved?
If not, please try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.