topic Re: Need assistance re: Error message: Error:QVX_UNEXPECTED_END_OF_DATA........ in QlikView

Need assistance re: Error message: Error:QVX_UNEXPECTED_END_OF_DATA........

Wed, 14 Nov 2012 13:34:34 GMT

Hi Community,

I am facing issue at the time of reload data from the sql server database as follows:

Dialog Box pops up as "an error odbc read failed".

When I click OK ,the following statement appears and the reload process continues as before

Error:QVX_UNEXPECTED_END_OF_DATA:SQL##f - SqlState:40001, ErrorCode: 1205, ErrorMsg:[Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 105) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Please help me.

Re: Need assistance re: Error message: Error:QVX_UNEXPECTED_END_OF_DATA........

Thu, 08 Aug 2013 00:17:14 GMT

I had the same problem. After hours of trial and error, I was able to solve the problem:

I found that somehow the adding up of my numbers didn't work properly. After adding cost1=[cost]+.000001 to my statement the error went away and didn't return so far.

Don't know whether this will work in your situation, but thought I throw it out there.

Re: Need assistance re: Error message: Error:QVX_UNEXPECTED_END_OF_DATA........

michael123 — Thu, 08 Aug 2013 08:37:45 GMT

Reading the error message you can try to run your query with the "with (nolock)" hint. I.E:

select * from my_table with (nolock);

/Michael