Error in QlikView Server Reload

[#1]

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?

[lhr]

have you verified that the account running the qlikview distribution service has all the access it needs to talk to the sql server?

[#3]

Yes, it does have the required access to the SQL database.  I have other scripts accessing the same database.  This particular reload ran three times prior without issue, and it ran last night without issue.

[lhr]

very weird.

any signs of the computer being heavily loaded at the time of the failure or something like that?

[#5]

The first time the error occurred, there were other processes running but the machine wasn't maxed out.  The second time, it was the only thing running.  I agree, it really doesn't make sense.  What I really don't like is that it's not consistent, which makes it even harder to diagnose.

[lhr]

i would try and get in touch with qliktech support with this case tbh.

cheers

[Anonymous]

Did you find any resolution to this issue.  We are seeing the same messages.   The QDS service becomes stopped in QEMC.   This is causing grief with our weekend downloads.

Thanks,

JS

[#8]

Hi,

I believe this ended up being a packet issue while pulling data from an oracle server (sorry I am not certain, we had several issues occur at once).  I decreased the fetch size in the oracle connection and this alleviated the error.  My understanding as to why this was only an issue when reloading through the server application is how the server app handles multi-threading the reloads, it seems too much data was being pulled at a time and the server app couldn't handle it.  Hope this helps!

[#9]

Hi All

I too have the same issue while running an incremental load batch.

the batch had run successfully for past  few days ,but in one instance it got failed with below error.

Looking out for any solutions for this issue. Plz advise.

Thanks in Advance.

-----------------------------------

(2014-11-21 20:58:50) Information: Reloading

(2014-11-21 21:16:02) Information: Reloading.

(2014-11-21 21:18:21) Information: The Source Document reload complete. DocumentPath=E:\QVPROD\Extraction\QVD_Generator\Incremental_Load.qvw

(2014-11-21 21:18:21) Information: Memory Allocation Delta for this file=4968.72 Mb. Available Physical Memory Before Reload=73463.32 Mb. Available Physical Memory After Reload=46486.39 Mb. Total Physical Memory=46486.39 Mb.

(2014-11-21 21:18:22) 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))

(2014-11-21 21:18:22) Error:    at QlikView.Doc.GetVariableDescriptions()

(2014-11-21 21:18:22) Error:    at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog)

(2014-11-21 21:18:22) Error: The Source Document was NOT reloaded successfully. DocumentPath=E:\QVPROD\Extraction\QVD_Generator\Incremental_Load.qvw.

(2014-11-21 21:18:22) Information: Closing the document.

(2014-11-21 21:18:23) Information: Closed the QlikView Engine successfully. ProcessID=26816

(2014-11-21 21:18:23) Error: The task "Reload of Incremental_Load.qvw" failed. Exception:

(2014-11-21 21:18:23) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=E:\QVPROD\Extraction\QVD_Generator\Incremental_Load.qvw.

(2014-11-21 21:18:23) Error:    at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2014-11-21 21:18:23) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2014-11-21 21:18:23) Error:    --- End of inner exception stack trace ---

(2014-11-21 21:18:23) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2014-11-21 21:18:23) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-11-21 21:18:23) Error:    --- End of inner exception stack trace ---

(2014-11-21 21:18:23) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-11-21 21:18:23) Error:    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2014-11-21 21:18:23) Information: Task Execute Duration=03:18:23.1450699

(2014-11-21 21:18:23) Information: TaskResult.status=Finished

(2014-11-21 21:18:23) Information: Notifying all triggers of new state:FinishedWithErrors

(2014-11-21 21:18:23) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2014-11-21 21:18:23) Information: Saving Task Result

[Anonymous]

Hi Sathis,

Have you found the solution for this error?