1st error message:
11/5/2011 9:09:09 AM Error Could not get ScriptErrorCount/ScriptErrorList. TotalErrors=. Exception=System.Runtime.InteropServices.COMException (0x80010100): System call failed. (Exception from HRESULT: 0x80010100 (RPC_E_SYS_CALL_FAILED))
at QlikView.IVariableDescription.get_Name()
at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog)
11/5/2011 9:09:09 AM Error The Source Document was NOT reloaded successfully. DocumentPath=D:\QLIKVIEW\SOURCE DOCUMENTS\DI Full Load QVD.qvw.
11/5/2011 9:09:09 AM Error Reload failed.
11/5/2011 9:09:10 AM Error Reload failed. Distribution skipped.
11/5/2011 9:09:10 AM Error The task "Source Documents/DI Full Load QVD.qvw" failed. ErrorCount=4
2nd error message:
11/7/2011 2:02:04 PM Error Failed to read ScriptErrorCount. Exception=System.Runtime.InteropServices.COMException (0x80029C4A): Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY))
at QlikView.Doc.GetVariable(String _Name)
at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog)
11/7/2011 2:02:04 PM Error Could not get ScriptErrorCount/ScriptErrorList. TotalErrors=. Exception=System.Runtime.InteropServices.COMException (0x80029C4A): Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY))
at QlikView.Doc.GetVariableDescriptions()
at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog)
11/7/2011 2:02:04 PM Error The Source Document was NOT reloaded successfully. DocumentPath=D:\QLIKVIEW\SOURCE DOCUMENTS\DI Full Load QVD.qvw.
11/7/2011 2:02:04 PM Error Reload failed.
11/7/2011 2:02:05 PM Error Reload failed. Distribution skipped.
11/7/2011 2:02:05 PM Error The task "Source Documents/DI Full Load QVD.qvw" failed. ErrorCount=5
The above occurred on a Microsoft SQL Server 2008 R2 box running QlikView Server v10 SR3, 32GB RAM.
Has anyone ever encountered the above errors before? I am testing out an upgrade to QlikView v10, and I just started getting this error while reloading one .QVW file. I had three successful scheduled reloads of this file before I started getting these errors. The logic in the file is very basic, it is a simple SELECT from a table in a local SQL Server Database that contains approximately 110,000,000 records. Both times that the script errored out, it pulled just over 27,000,000 records before failing. The odd thing is that it went ahead and wrote the data that it pulled to the .QVD file. Normally, when I have a script error out, all of the data is lost (unless this is a new function of QlikView v10, that data is written to the .QVD file as it is pulled?).
I just completed a succesful reload of this script in QlikView Developer, so the issue must be with QlikView Server. Any suggestions?
