Transaction was deadlocked on lock

[joelle_alhanna]

when I reload the Document, sometimes the below error occurs

SQL##f - SqlState: 40001, ErrorCode: 1205, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Error: ODBC read failed

can you please advise

[olivierrobin]

hello

that means you have a query trying to access the same piece of data on you sql server than an another request which access it with a lock (maybe for update)

check on the DB side

[vishsaggi]

Hows does your SQL script looks does the tables have WITH NOLOCK hint in your script? Like

SELECT F1, F2,F3

FROM Table1 tab1 WITH (NOLOCK)

LEFT JOIN

            Table2 tab2 WITH (NOLOCK)

             ON tab.F1 = tab2.F2

add this hint to your script and try.

[buzzy996]

this is bcz,ur sql table is not allowing multiple persons to pull data at a time,check with ur db team.

else both (u & whoever using this) can try with unlock sql query.