3 Replies Latest reply: Mar 7, 2018 3:27 PM by Chip Matejowsky RSS

    Error reloading with no reason

    shay raber

      hi,

      we have few documents and reload tasks.

      we have recently upgraded our server form QV 11.2 SR13 to QV 12 November 2017 SR2

      all worked but all of a sudden, last night, some tasks (only some, not all) has started to fail over and over.

      at the failing scripts we get the same unknown error:

      2018-03-04 09:55:52 0015 LOAD id, 
      2018-03-04 09:55:52 0016      account_id, 
      ...........
      2018-03-04 09:55:52 0085 FROM some_file.qvd (qvd)
      2018-03-04 09:55:52      70 fields found: id, account_id, ...
      2018-03-04 09:55:52      -128 = 
      2018-03-04 09:55:52      Execution Failed
      2018-03-04 09:55:52      Execution finished.
      

       

      the task doesn't reload from DB so it's not a connection.

      there is no other process writing into that QVD in parallel

      the task error is:

      (04/03/2018 09:55:52) Information: The Source Document is being reloaded. DocumentPath=D:\QLIK....qvw
      
      
      (04/03/2018 09:55:52) 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. ||
      at QlikView.Doc.DoReload(Int32 _Mode, Boolean _Partial, Boolean _Debug) ||
      at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog)
      
      
      (04/03/2018 09:55:52) Information: Closing the document.
      
      
      (04/03/2018 09:55:53) Information: Closed the QlikView Engine successfully. ProcessID=9256
      
      
      (04/03/2018 09:55:53) Error: The task "some task" failed. Exception:
      || QDSMain.Exceptions.TaskFailedException: Task execution 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. ||
      at QlikView.Doc.DoReload(Int32 _Mode, Boolean _Partial, Boolean _Debug) ||
      at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog) ||
      at QDSMain.AbstractReloadTask.VerifyConditions(IExecutingTaskResult executingTaskResult) ||
      at QDSMain.AbstractReloadTask.Reload(String fileName, IExecutingTaskResult executingTaskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) ||
      --- End of inner exception stack trace --- ||
      at QDSMain.AbstractReloadTask.Reload(String fileName, IExecutingTaskResult executingTaskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) ||
      at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) ||
      --- End of inner exception stack trace --- ||
      at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) ||    
      at QDSMain.Task.AbstractTask.TaskExecution(CurrentExecutionArgs args)
      
      
      (04/03/2018 09:55:53) Information: Task Execute Duration=00:00:07.5940641
      

       

      also in TaskResult:

      <?xml version="1.0" encoding="utf-8"?>
      <Root TaskID="0d5e026c-4c76-42b7-ab6e-6053352afbb5" OwnedByClusterID="1" RunID="aaa5fd1f-d280-49dd-ad34-dc86db44f313" TaskManuallyAborted="False" PreviousRunHadErrors="True" InternalError="True" LastExecution="04/03/2018 09:55:45" LastExecutedOn="DIL-QLP" QueuedAt="04/03/2018 03:05:26" QueuedByTriggerId="3adddab1-88d7-4ec4-ae72-72a2f6262d18" RunningOn="" StartedAt="04/03/2018 09:55:45" FinishedAt="04/03/2018 09:55:56" MaxRunTime="00:15:00" StartCount="33956" HasWarnings="False" Status="Finished" Modified="2018-03-04T07:55:56.7278640Z">
        <LogFinalEntries>
          <LogFinalEntry Type="Error" Date="04/03/2018 09:55:52" Text="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.&#xD;&#xA;
      at QlikView.Doc.DoReload(Int32 _Mode, Boolean _Partial, Boolean _Debug)&#xD;&#xA;   at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog)" />
          <LogFinalEntry Type="Error" Date="04/03/2018 09:55:53" Text="The task &quot;some file.qvw&quot; failed. Exception:&#xD;&#xA;QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---&gt; QDSMain.Exceptions.ReloadFailedException: Reload failed ---&gt; 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.&#xD;&#xA;
      at QlikView.Doc.DoReload(Int32 _Mode, Boolean _Partial, Boolean _Debug)&#xD;&#xA;
      at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog)&#xD;&#xA;
      at QDSMain.AbstractReloadTask.VerifyConditions(IExecutingTaskResult executingTaskResult)&#xD;&#xA;
      at QDSMain.AbstractReloadTask.Reload(String fileName, IExecutingTaskResult executingTaskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)&#xD;&#xA;
      --- End of inner exception stack trace ---&#xD;&#xA;
      at QDSMain.AbstractReloadTask.Reload(String fileName, IExecutingTaskResult executingTaskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)&#xD;&#xA;
      at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult)&#xD;&#xA;
      --- End of inner exception stack trace ---&#xD;&#xA;
      at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult)&#xD;&#xA;
      at QDSMain.Task.AbstractTask.TaskExecution(CurrentExecutionArgs args)" />
        </LogFinalEntries>
      </Root>
      

       

      GD shows nothing.

      any idea?