topic Transaction was deadlocked on lock in QlikView

Transaction was deadlocked on lock

joelle_alhanna — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Transaction was deadlocked on lock

olivierrobin — Wed, 30 May 2018 14:30:49 GMT

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

Re: Transaction was deadlocked on lock

vishsaggi — Wed, 30 May 2018 14:35:53 GMT

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.

Re: Transaction was deadlocked on lock

buzzy996 — Wed, 30 May 2018 14:36:34 GMT

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.