topic Re: OLEDB Read Failed Error in QlikView

OLEDB Read Failed Error

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have the following Script:

When i load the above script i get an OLEDB Read Failed error message. What is wrong in the Script?

Re: OLEDB Read Failed Error

antoniotiman — Sun, 20 Aug 2017 16:15:50 GMT

Hi Christopher,

[Script Number] field there is not in the Group By

Regards,

Antonio

Re: OLEDB Read Failed Error

sasiparupudi1 — Sun, 20 Aug 2017 17:54:03 GMT

Try with a resident load than a preceeding load

Temp:

SQL Select Branch,

"Retail Pharmacy",

"Script Number"

From PharmaMarketAudit.dbo.tblDatawarehouseConsolodatedCleanStage;

Noconcatenate Load

Branch,

[Retail Pharmacy],

[Script Number]

Count(Distinct [Script Number]) as Rx

Resident Temp

Group By

Branch,

[Retail Pharmacy],

[Script Number];

Drop Table Temp;

Re: OLEDB Read Failed Error

Anonymous — Sun, 20 Aug 2017 18:02:34 GMT

Hi Christopher,

Do not use aggregation directly while loading the data. Probably it should be the reason for you to get the error.

First load the data and then use resident load while doing aggregation. Sasidhar has given the script in this thread. It should work for you to resolve the issue.

-GDK

Re: OLEDB Read Failed Error

Anonymous — Sun, 20 Aug 2017 21:22:07 GMT

Noted with thanks Antonio. However the script takes forever to execute and i am having to force it to end

Re: OLEDB Read Failed Error

Anonymous — Sun, 20 Aug 2017 21:23:39 GMT

Thank you Sasidhar. After loading the temp table, the script takes forever to execute the resident load and i am having to force it to quit without ending the script execution

Re: OLEDB Read Failed Error

Anonymous — Sun, 20 Aug 2017 21:24:22 GMT

Thanks Gowtham, please see my responses above

Re: OLEDB Read Failed Error

Anonymous — Sun, 20 Aug 2017 22:50:24 GMT

I did a distinct SQL SELECT in the temp table load and a straight count in the resident load to reduce the amount of memory use

Re: OLEDB Read Failed Error

antoniotiman — Sun, 20 Aug 2017 23:16:12 GMT

Christopher,

move Group by from LOAD to Select

This should be faster..

SQL Select

Branch,[Retail Pharmacy],[Script Number],

Count(Distinct [Script Number]) as Rx

Group By

Branch,

[Retail Pharmacy],

[Script Number]

from PharmaMarketAudit.dbo.tblDatawarehouseConsolodatedCleanStage ;

However, if You Group By [Script Number] then Count(Distinct [Script Number]) is always 1.

Perhaps remove DISTINCT from Count or remove [Script Number] from Select Fields List and from Group By.

Re: OLEDB Read Failed Error

mayuresh_d — Mon, 21 Aug 2017 11:14:04 GMT

as per me here group by is issue....

Please remove group by and load ..then take resident and then aggr value. else aggr in sql script don't agg in preceding load.

Re: OLEDB Read Failed Error

Anonymous — Mon, 21 Aug 2017 11:48:32 GMT

Thanks Antonio. I am getting the following error message with the SQL statement:

Re: OLEDB Read Failed Error

antoniotiman — Mon, 21 Aug 2017 11:55:02 GMT

SQL Select

Branch,[Retail Pharmacy],[Script Number],

Count(Distinct [Script Number]) as Rx

from PharmaMarketAudit.dbo.tblDatawarehouseConsolodatedCleanStage

Group By

Branch,

[Retail Pharmacy],

[Script Number];

Re: OLEDB Read Failed Error

Anonymous — Tue, 22 Aug 2017 13:22:48 GMT

Many thanks Antonio

Re: OLEDB Read Failed Error

Anonymous — Tue, 22 Aug 2017 13:23:39 GMT

Thanks Mayuresh