topic Re: OLEDB read failed in QlikView

OLEDB read failed

Wed, 12 Nov 2014 05:53:46 GMT

Hi Everyone

I am getting "OLEDB read failed" error when trying to reload my models. I have confirmed that the datawarehouse is online and I have access to it. What else may be the cause of the error?

Re: OLEDB read failed

fkeuroglian — Wed, 12 Nov 2014 12:53:28 GMT

Hi, could you post an image or put the error , try to put more details to be easy help you

Fernando

Re: OLEDB read failed

ashfaq_haseeb — Wed, 12 Nov 2014 13:14:53 GMT

Hi,

This clearly say you cannot establish connection to DB.

Make sure you have proper connection string.

Regards

ASHFAQ

Re: OLEDB read failed

Wed, 12 Nov 2014 13:43:19 GMT

I actually managed to resolve the issue. I had CrossTable() statement (which I forgot to remove) below the Load which was the cause of the issue. As soon as I commented it out, the load ran susccessfully.

Re: OLEDB read failed

maksim_senin — Wed, 10 May 2017 02:45:20 GMT

Hi All,

Also you can get the "OLEDB read dailed" in the following cases:

1. when two or more columns have the same name

2. where a column has no name assigned in case it conains a calculation, i.e. you should use an alias (just add "as MyFieldName" to each calculated fields)

Best regards,

Maxim