Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

My reload job keeps failing

Hello,

I've been trying to perform a reload on the server since the number of records is more than 27 million records, but my reload job keeps failing with the below log, is it because of the memory ? as it says Memory Allocation Delta for this file=3768.68 Mb. Available Physical Memory Before Reload=20487.03 Mb. Available Physical Memory After Reload=20455.06 Mb. Total Physical Memory=20455.06 Mb. so is this the memory of the Qvdocs folder it will be publishing the QVD to or is it something else ?

Appreciate your help !

(2015-07-01 14:59:36) Information: Reloading

(2015-07-01 15:14:49) Information: Reloading.

(2015-07-01 15:24:06) Information: The Source Document reload complete. DocumentPath=F:\QVSourceDocs\AWBs POC- Ops.qvw

(2015-07-01 15:24:06) Information: Memory Allocation Delta for this file=3768.68 Mb. Available Physical Memory Before Reload=20487.03 Mb. Available Physical Memory After Reload=20455.06 Mb. Total Physical Memory=20455.06 Mb.

(2015-07-01 15:24:06) Error: The Source Document was NOT reloaded successfully. DocumentPath=F:\QVSourceDocs\AWBs POC- Ops.qvw.

(2015-07-01 15:24:06) Information: Closing the document.

(2015-07-01 15:24:07) Information: Closed the QlikView Engine successfully. ProcessID=6116

(2015-07-01 15:24:07) Error: The task "AWBS& History Reload" failed. Exception:

(2015-07-01 15:24:07) 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=F:\QVSourceDocs\AWBs POC- Ops.qvw.

(2015-07-01 15:24:07) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2015-07-01 15:24:07) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-07-01 15:24:07) Error: --- End of inner exception stack trace ---

(2015-07-01 15:24:07) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-07-01 15:24:07) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-07-01 15:24:07) Error: --- End of inner exception stack trace ---

(2015-07-01 15:24:07) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-07-01 15:24:07) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2015-07-01 15:24:07) Information: Task Execute Duration=03:25:25.9092913

(2015-07-01 15:24:07) Information: AWBS& History Reload - Task Failed. Saving TaskProgress for retry

(2015-07-01 15:24:07) Information: TaskResult.status=Retry

4 Replies
Gysbert_Wassenaar

Check the file F:\QVSourceDocs\AWBs POC- Ops.qvw.log for errors. If that file doesn't exist then enable the Generate Logfile option in the Document Properties of that document and reload the document again.


talk is cheap, supply exceeds demand
Not applicable
Author

Hello Gysbert,

Thank you for your help

Im attaching the log file

Gysbert_Wassenaar

Are you sure that log file is complete? It just breaks off at line 204 in the middle of a list of fields and it doesn't contain any error.


talk is cheap, supply exceeds demand
Peter_Cammaert
Partner - Champion III
Partner - Champion III

The memory allocation delta-message is certainly not the cause of the failure as it is talking about required RAM and available RAM and the two don't clash.

Are you able to reload the document in QV Desktop? Does that reload generate any error dialogs? How long does the reload take? You may run out of time with the publisher reload if executing the script takes longer than the configured maximum delay... That may also explain why the Document log is cut off, as your job is killed on the spot.

Peter