topic Re: OLEDB read failed in QlikView

OLEDB read failed

Tue, 20 May 2014 11:21:03 GMT

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 — Tue, 20 May 2014 11:30:45 GMT

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

Tue, 20 May 2014 14:13:39 GMT

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 — Tue, 20 May 2014 16:59:41 GMT

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