Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

OLEDB read failed

After an OLEDB CONNECT TO claue I am trying to use the following SQL statement in my QlikView Script:

SQL SELECT * FROM [JBVProcessDB01].[dbo].[tblEvent01]

INNER JOIN

(

SELECT MAX(DateTime) as LatestDate, [sFieldValue0]

FROM [JBVProcessDB01].[dbo].[tblEvent01]

Group by sFieldValue0

) SubMax

on [JBVProcessDB01].[dbo].[tblEvent01].DateTime = SubMax.LatestDate

and [JBVProcessDB01].[dbo].[tblEvent01].sFieldValue0 = SubMax.sFieldValue0 and lFieldValue2 > 2

But when I run the script I get an error message stating that "OLEDB read failed". This SQL query works fine in SQL management studio, and I have tested my OLEDB CONNECT TO statement which also works.

So what can be the problem here?

1 Solution

Accepted Solutions
Not applicable
Author

though too late, but just wanted to answer for others so that they do not find it unanswered

I had the same "OLEDB read failed" error. Which occurred due to duplicate columns names in the query. When removed, it worked.

View solution in original post

2 Replies
Not applicable
Author

though too late, but just wanted to answer for others so that they do not find it unanswered

I had the same "OLEDB read failed" error. Which occurred due to duplicate columns names in the query. When removed, it worked.

View solution in original post

Not applicable
Author

Nice work Sibtain Naqvi!

Thank you so much!