topic Re: OLEDB Read Failed in QlikView

OLEDB Read Failed

Anonymous — Wed, 18 Nov 2015 15:45:20 GMT

I get an 'OLEDB Read Failed' when i am connecting QlikView to my MS SQL Server data base after adding the following expression at preceding load time:

Sum(MedicalAidAmount + Shortfall)

MedicalAidAmount and Shortfall are two different columns in my data base. Can one sum across columns at load or this transformation is not allowed. If i remove this transformation from the preceding load, there is no problem, data reading goes well.

Any ideas on what is going?

Re: OLEDB Read Failed

buzzy996 — Wed, 18 Nov 2015 16:02:53 GMT

can u try tis,

Sum(MedicalAidAmount) +sum( Shortfall)

Re: OLEDB Read Failed

Anonymous — Wed, 18 Nov 2015 16:04:49 GMT

Playing a hunch, but can you give the column a unique alias in the result set and see if things get better?

Sum(MedicalAidAmount + Shortfall) AS ReallyUniqueColumnName

Re: OLEDB Read Failed

marcus_sommer — Wed, 18 Nov 2015 16:05:20 GMT

If you want to use sum() you will need a group by statement, too for this load and if not you should better use:

RangeSum(MedicalAidAmount, Shortfall)

- Marcus

Re: OLEDB Read Failed

Anonymous — Wed, 18 Nov 2015 16:09:37 GMT

Many thanks, that's what i have and it fails load

Re: OLEDB Read Failed

Anonymous — Wed, 18 Nov 2015 16:12:10 GMT

Thanks Marcus will try this

Re: OLEDB Read Failed

Anonymous — Wed, 18 Nov 2015 16:13:15 GMT

Many thanks will try out