Originally posted by: Debnarayan

Hi,

I am using wtx 8.3 map to sequentially (single threaded) process and write records in a db (SQL Server 2012). Another process outside WTX is fetching those records in a batch mode (runs every 5 minutes) and creating a file for the end user. If wtx continues to process files when the batch process is running, wtx occasionally gets affected with deadlock issue giving below error in the dbl file. Deadlock affected files are consumed by wtx without writing relevant records in database.

<3336-4956>:     Error in SQLExecDirect

Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 2123) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

SQL State: 40001

Could you advise if anything (may be configuration changes in dtx.ini file or sql modification apply nolock or something else) can be done to avoid deadlock issue?

Thanks,

Debnarayan

Originally posted by: Ejay

Hello ,

I would suggest to place everything in the same transaction and call the batch with a map in the same system.

So the full process itself become sequential and avoid deadlock issues by only firing the batch when the first map is finish. 

If a new trigger come for the next map will be placed in pending and will wait for the previous process to complete . 

Hope that Help

Emmanuel