8 Replies Latest reply: Oct 31, 2014 4:38 PM by Cesar Augusto Beristain Lopez RSS

    Document reload failure - successful on manual reload

      I have a document that is failing to reload through the distribution server. When I attempt a reload manually in the document itself it executes fine.

       

      Below is the task log showing the errors. If anyone can help resolve this asap it would be much appreciated.

       

      Thanks

      Adam

       

      (2014-01-13 10:11:54) Information: MaxRunTime=1.00:00:00

      (2014-01-13 10:11:54) Information: MachineName=S32036

      (2014-01-13 10:11:54) Information: Max attempts:1

      (2014-01-13 10:11:54) Information: Current Attempt=0

      (2014-01-13 10:11:54) Information: Task Dependencies are OK

      (2014-01-13 10:11:54) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

      (2014-01-13 10:11:54) Information: Opening "D:\S32036\QlikView_Files\Source Documents\Live Documents\UK\Leads\UK Leads.qvw"

      (2014-01-13 10:11:54) Information: Allocating new QlikView Engine. Current usagecount=3 of 4

      (2014-01-13 10:11:54) Information: Max retries:5

      (2014-01-13 10:11:54) Information: Attempt:01

      (2014-01-13 10:11:55) Information: Allocated QlikView Engine successfully. Current usagecount=3 of 4, Ticket=711

      (2014-01-13 10:11:55) Information: Loading document "D:\S32036\QlikView_Files\Source Documents\Live Documents\UK\Leads\UK Leads.qvw" (70.22 Mb)

      (2014-01-13 10:11:55) Information: Physical FileSize=70.22 Mb. Memory Allocation Delta for this file=16.97 Mb. Available Physical Memory Before Open=50980.85 Mb. Available Physical Memory After Open=50937.09 Mb. Total Physical Memory=65535.55 Mb.

      (2014-01-13 10:11:55) Information: Attempted to load the document without data.

      (2014-01-13 10:11:55) Information: The document was loaded successfully.

      (2014-01-13 10:11:55) Information: Document was opened successfully

      (2014-01-13 10:11:55) Information: Starting reload

      (2014-01-13 10:11:55) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.

      (2014-01-13 10:11:55) Information: Waiting for the document log "D:\S32036\QlikView_Files\Source Documents\Live Documents\UK\Leads\UK Leads.qvw" to become available..

      (2014-01-13 10:11:55) Information: The Source Document is being reloaded. DocumentPath=D:\S32036\QlikView_Files\Source Documents\Live Documents\UK\Leads\UK Leads.qvw

      (2014-01-13 10:11:55) Information: Found a document log. FileName=D:\S32036\QlikView_Files\Source Documents\Live Documents\UK\Leads\UK Leads.qvw.log

      (2014-01-13 10:11:55) Information: Writing documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20140113\101154 - UK Leads\DocumentLog.txt

      (2014-01-13 10:11:56) Information: Reloading.

      (2014-01-13 10:11:57) Information: Reloading..

      (2014-01-13 10:11:58) Information: Reloading...

      (2014-01-13 10:11:59) Information: Reloading....

      (2014-01-13 10:12:00) Information: Reloading.....

      (2014-01-13 10:12:01) Information: Reloading......

      (2014-01-13 10:12:02) Information: Reloading.......

      (2014-01-13 10:12:03) Information: Reloading........

      (2014-01-13 10:12:04) Information: Reloading.........

      (2014-01-13 10:12:05) Information: Reloading..........

      (2014-01-13 10:12:06) Information: Slow down logging. Log every <2> seconds.

      (2014-01-13 10:12:06) Information: Reloading

      (2014-01-13 10:12:08) Information: Reloading.

      (2014-01-13 10:12:10) Information: Reloading..

      (2014-01-13 10:12:12) Information: Reloading...

      (2014-01-13 10:12:14) Information: Reloading....

      (2014-01-13 10:12:16) Information: Reloading.....

      (2014-01-13 10:12:18) Information: Reloading......

      (2014-01-13 10:12:20) Information: Reloading.......

      (2014-01-13 10:12:22) Information: Reloading........

      (2014-01-13 10:12:24) Information: Reloading.........

      (2014-01-13 10:12:26) Information: Reloading..........

      (2014-01-13 10:12:28) Information: Slow down logging. Log every <10> seconds.

      (2014-01-13 10:12:28) Information: Reloading

      (2014-01-13 10:12:39) Information: Reloading.

      (2014-01-13 10:12:49) Information: Reloading..

      (2014-01-13 10:12:59) Information: Reloading...

      (2014-01-13 10:13:09) Information: Reloading....

      (2014-01-13 10:13:19) Information: Reloading.....

      (2014-01-13 10:13:29) Information: Reloading......

      (2014-01-13 10:13:39) Information: Reloading.......

      (2014-01-13 10:13:49) Information: Reloading........

      (2014-01-13 10:13:59) Information: Reloading.........

      (2014-01-13 10:14:09) Information: Reloading..........

      (2014-01-13 10:14:19) Information: Slow down logging. Log every <60> seconds.

      (2014-01-13 10:14:19) Information: Reloading

      (2014-01-13 10:14:23) Error: The sourcedocument failed to reload.. Exception=System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component.

      (2014-01-13 10:14:23) Error:    at QlikView.Doc.DoReload(Int32 _Mode, Boolean _Partial, Boolean _Debug)

      (2014-01-13 10:14:23) Error:    at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog)

      (2014-01-13 10:14:23) Information: Closing the document.

      (2014-01-13 10:14:24) Information: Closed the QlikView Engine successfully. ProcessID=8356

      (2014-01-13 10:14:24) Error: The task "UK Leads" failed. Exception:

      (2014-01-13 10:14:24) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The sourcedocument failed to reload.. Exception=System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component.

      (2014-01-13 10:14:24) Error:    at QlikView.Doc.DoReload(Int32 _Mode, Boolean _Partial, Boolean _Debug)

      (2014-01-13 10:14:24) Error:    at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog)

      (2014-01-13 10:14:24) Error:    at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

      (2014-01-13 10:14:24) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

      (2014-01-13 10:14:24) Error:    --- End of inner exception stack trace ---

      (2014-01-13 10:14:24) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

      (2014-01-13 10:14:24) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

      (2014-01-13 10:14:24) Error:    --- End of inner exception stack trace ---

      (2014-01-13 10:14:24) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

      (2014-01-13 10:14:24) Error:    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

      (2014-01-13 10:14:24) Information: Task Execute Duration=00:02:29.9000571

      (2014-01-13 10:14:24) Information: Sending Alert mail

      (2014-01-13 10:14:25) Information: TaskResult.status=Finished

      (2014-01-13 10:14:25) Information: Notifying all triggers of new state:FinishedWithErrors

      (2014-01-13 10:14:25) Information: Notifying all triggers of new state:FinishedWithErrors - completed

      (2014-01-13 10:14:25) Information: Saving Task Result