OLEDB read failed

[#1]

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?

[fkeuroglian]

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

Fernando

[ashfaq_haseeb]

Hi,

This clearly say you cannot establish connection to DB.

Make sure you have proper connection string.

Regards

ASHFAQ

[#4 · Accepted solution]

Hi

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.

[maksim_senin]

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