1372896 - Deadlock issue with SQL Server "NO LOCK"

Symptom

When running jobs on an operative SQL Server database the following error might occur:

SQL submitted to ODBC data source <10.1.89.20> resulted in error < [Microsoft][ODBC SQL Server
Driver][SQL Server]Transaction (Process ID 85) was deadlocked on lock | communication buffer resources with another process and
has been chosen as the deadlock victim. Rerun the transaction.>............

Product

SAP Data Integrator XI R2 Accelerated

Keywords

SQL Server, Deadlock, NO LOCK , KBA , EIM-DS , Data Services , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.