Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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?

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: OLEDB read failed

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.

2 Replies
Not applicable

Re: OLEDB read failed

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.

Not applicable

Re: OLEDB read failed

Nice work Sibtain Naqvi!

Thank you so much!