Sql Error

[prma7799]

Hi All,

Am getting frequently below SQL error....

5/12/2016 12:10:29 PM:         QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: 40001, ErrorCode: 1205, ErrorMsg: [Microsoft][SQL Server Native Client 10.0][SQL Server]Transaction (Process ID 51) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

5/12/2016 12:10:29 PM:         Error: ODBC read failed

5/12/2016 12:10:29 PM:         General Script Error

5/12/2016 12:10:29 PM:         Execution Failed

5/12/2016 12:10:29 PM:      Execution finished.

Can anyone please tell me how to tackle this.

Thanks

[Kushal_Chawda]

I think the Table was locked due to some Insert, Update or Delete operation was performed at that time.

[#3]

you may use the NOLOCK-option in your SQL-command.

[PrashantSangle]

Hi,

communicate with DBA team. will give you more detail explanation.

Regards

[avinashelite]

I think the tables are LOCKED by some other process for certain changes hence your getting this error.....try to reload after the process is completed ..

[Anil_Babu_Samineni]

Error 1205