10 Replies Latest reply: Oct 8, 2015 2:22 PM by Edward Ramos RSS

    Error in QlikView Server Reload

      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?

        • Error in QlikView Server Reload
          Lars Helmer

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

          • Error in QlikView Server Reload
            Jerry Somsen

            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

              • Error in QlikView Server Reload

                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!

              • Re: Error in QlikView Server Reload

                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

                • Re: Error in QlikView Server Reload
                  Edward Ramos

                  Any solution??