QVD file filed reload

[0li5a3a]

Hi Guys,

I need your help.

I made a new qvd file and I schedule to reload every day during the night.

For no reason or I don't know to read the error message the qvd file is reloading but after one hour is failed.

Please see below the error message:

(2016-06-28 00:57:34) Information: The Source Document reload complete. DocumentPath=C:\OrderLines.qvw

(2016-06-28 00:57:34) Information: Memory Allocation Delta for this file=14.04 Mb. Available Physical Memory Before Reload=52295.68 Mb. Available Physical Memory After Reload=51919.07 Mb. Total Physical Memory=51919.07 Mb.

(2016-06-28 00:57:34) Error: The Source Document was NOT reloaded successfully. DocumentPath=C:\QLIKWAREHOUSE\LOAD SCRIPTS\MongoDB\Constantin\OrderLines.qvw.

(2016-06-28 00:57:34) Information: Closing the document.

(2016-06-28 00:57:35) Information: Closed the QlikView Engine successfully. ProcessID=12500

(2016-06-28 00:57:35) Error: The task "Load Scripts/OrderLines.qvw" 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=C:\OrderLines.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-06-28 00:57:35) Information: Task Execute Duration=00:27:35.0366451

(2016-06-28 00:57:35) Information: TaskResult.status=Finished

(2016-06-28 00:57:35) Information: Notifying all triggers of new state:FinishedWithErrors

(2016-06-28 00:57:35) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2016-06-28 00:57:35) Information: Saving Task Result

Thanks in advance!

[marcus_sommer]

Could you reload the qvw manually? What said the log-file (to enable within the document properties in tab general)?

Quite often the reasons are missing access rights to the databases/files through the user which runs the server services.

- Marcus

[kuczynska]

Hi,

I would also suggest reloading this qvw manually with the generate logfile option enabled, just like Marcus mentioned before me. The reasons for this failure could be quiet few - starting from missing access rights to "read" from the source, failing over STORE statement, or (my personal favorite!) - change on the DB site; columns renamed, missing columns etc, not accommodated in your QV script. Information from the logfile is usually clarifying all of your concerns.

Good luck.

Michalina