OLEDB read failed

[#1]

Hi All,

When qvw reloading using publisher,I got the below error message

  QVX_UNEXPECTED_END_OF_DATA:

01:10:51.5029494 Information 5/19/2014 1:10:51 AM:       Error: OLEDB read failed

01:10:51.5185494 Information 5/19/2014 1:10:51 AM:       General Script Error

01:10:51.5185494 Information 5/19/2014 1:10:51 AM:       Execution Failed

01:10:51.5185494 Information 5/19/2014 1:10:51 AM:      Execution finished

I am getting the same error many times,what will be the reason..Is there any connection string changes or code changes required?

Thanks ALL

Ramgopal.

[ashfaq_haseeb]

Hi,

This usually happens when dead lock situation arises and Database forcibly end connection.

to avoid such issue try to fetch data with nolock on table.

Regards

ASHFAQ

[#3]

This usually happens to me when I've changed some code, and inadvertently select the same field twice, or reuse an

alias e.g. (the examples are simple, but in a 100-line SELECT statement, you can make them!)

Select

custid as CustName

custfirst As FirstName,

custlast as CustName  <-- this will generate an error, as you can't alias two fields into one

or (simpler)

Select

box,

cube,

tetrahedron,

box,      <-- this will generate an error

sphere,

[Ronnie_Taborn]

Make sure the account doing the reloads have permission to the database. Make sure the connection string is correct.