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

[#1]

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.

[#2]

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.

[michael123]

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