Job Failure Unexplained

bradley_isaacs — Tue, 30 Aug 2016 12:36:16 GMT

Hi there

Im reloading a model through the scheduler, every 30mins. Every now and then the job fails, for no apparent reason. It then succeeds the next time without any intervention.

The model log file looks like this :

30/08/2016 10:01:03 AM: 0060 ELSE

30/08/2016 10:01:03 AM: 0073 store AVAYA_CMS_hagent into ..\..\QVData\1_Extract\AVAYA_CMS_hagent.qvd(qvd)

30/08/2016 10:01:09 AM: General Script Error

30/08/2016 10:01:09 AM: Execution Failed

30/08/2016 10:01:09 AM: Execution finished.

The QMC log file looks like this ....

(2016-08-30 14:06:05) Information: Memory Allocation Delta for this file=129.47 Mb. Available Physical Memory Before Reload=138127.44 Mb. Available Physical Memory After Reload=137477.53 Mb. Total Physical Memory=137477.53 Mb.

(2016-08-30 14:06:06) Error: The Source Document was NOT reloaded successfully. DocumentPath=\\XXXXXX\AFS\QVETL\1_Extract\AVAYA_CMSh.qvw.

(2016-08-30 14:06:06) Information: Closing the document.

(2016-08-30 14:06:06) Information: Closed the QlikView Engine successfully. ProcessID=170364

(2016-08-30 14:06:06) Error: The task "AVAYA_CMS_HALFHOURLY" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=\\XXXXXX\AFS\QVETL\1_Extract\AVAYA_CMSh.qvw. || at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult) || at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || --- End of inner exception stack trace --- || at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) || --- End of inner exception stack trace --- || at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) || at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2016-08-30 14:06:06) Information: Task Execute Duration=00:01:06.4116405

(2016-08-30 14:06:06) Information: TaskResult.status=Finished

(2016-08-30 14:06:06) Information: Notifying all triggers of new state:FinishedWithErrors

(2016-08-30 14:06:07) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2016-08-30 14:06:07) Information: Saving Task Result

topic Job Failure Unexplained in QlikView

Job Failure Unexplained