QlikView Task Failed To Reload "System.Runtime.InteropServices.COMException (0x80004005)"

[Sonja_Bauernfeind]

QlikView task fails to reload and task log shows the error message below:

 "The source document failed to reload.. Exception=System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component."


Environment:

• QlikView, all versions

Resolution:

A possible reason for this error is the presence of NULL values in the tables that the document loads data from.

In such case, a solution can be redefined NULL values during load by using the NullAsValues function. 

For example:

nullasvalue BAccountFrom, BAccountTo;

MyTable:
IntervalMatch (AccountNumber)
load BAccountFrom, BAccountTo
resident BRegularRows;