topic Re: Sql Error in QlikView

Sql Error

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

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

Re: Sql Error

Kushal_Chawda — Thu, 12 May 2016 06:38:25 GMT

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

Re: Sql Error

Thu, 12 May 2016 06:40:43 GMT

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

Re: Sql Error

PrashantSangle — Thu, 12 May 2016 06:45:30 GMT

Hi,

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

Regards

Re: Sql Error

avinashelite — Thu, 12 May 2016 06:50:07 GMT

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 ..

Re: Sql Error

Anil_Babu_Samineni — Thu, 12 May 2016 07:00:47 GMT

Error 1205