Automatic Reload Failed

[#1]

Hi,

the document is reloaded successfully on qvw but when i put it on the server and make task for it on qvmc it failed to reload

i don't know why

here's the log file

(2013-10-02 16:49:07) Information: Starting task 'Sales.V3.qvw'. Id:328efd08-c4a7-4c2f-b4d9-dddefdd46100. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

(2013-10-02 16:49:07) Information: Entering Task Execution.

(2013-10-02 16:49:07) Information: ClusterID=1

(2013-10-02 16:49:07) Information: QDSID=00aa2e3a-fa76-2190-0033-56596f93d1b2

(2013-10-02 16:49:07) Information: TaskID=328efd08-c4a7-4c2f-b4d9-dddefdd46100

(2013-10-02 16:49:07) Information: MaxRunTime=06:00:00

(2013-10-02 16:49:07) Information: MachineName=EGCAQV01

(2013-10-02 16:49:07) Information: Max attempts:1

(2013-10-02 16:49:07) Information: Current Attempt=0

(2013-10-02 16:49:07) Information: Task Dependencies are OK

(2013-10-02 16:49:07) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2013-10-02 16:49:07) Information: Opening "C:\ProgramData\QlikTech\Documents\Sales.V3.qvw"

(2013-10-02 16:49:07) Information: Allocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).

(2013-10-02 16:49:07) Information: Max retries:5

(2013-10-02 16:49:07) Information: Attempt:01

(2013-10-02 16:49:08) Information: Allocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=191.

(2013-10-02 16:49:08) Information: Loading document "C:\ProgramData\QlikTech\Documents\Sales.V3.qvw" (16.85 Mb)

(2013-10-02 16:49:08) Information: Physical FileSize=16.85 Mb. Memory Allocation Delta for this file=21.68 Mb. Available Physical Memory Before Open=6685.93 Mb. Available Physical Memory After Open=6659.51 Mb. Total Physical Memory=8074.68 Mb.

(2013-10-02 16:49:08) Information: Attempted to load the document without data.

(2013-10-02 16:49:08) Information: The document was loaded successfully.

(2013-10-02 16:49:08) Information: Document was opened successfully

(2013-10-02 16:49:08) Information: Starting reload

(2013-10-02 16:49:08) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

(2013-10-02 16:49:08) Information: The Source Document is being reloaded. DocumentPath=C:\ProgramData\QlikTech\Documents\Sales.V3.qvw

(2013-10-02 16:49:09) Information: Reloading.

(2013-10-02 16:49:10) Information: Reloading..

(2013-10-02 16:49:11) Information: Reloading...

(2013-10-02 16:49:12) Information: Reloading....

(2013-10-02 16:49:13) Information: Reloading.....

(2013-10-02 16:49:14) Information: Reloading......

(2013-10-02 16:49:15) Information: Reloading.......

(2013-10-02 16:49:16) Information: Reloading........

(2013-10-02 16:49:17) Information: Reloading.........

(2013-10-02 16:49:18) Information: Reloading..........

(2013-10-02 16:49:19) Information: Slow down logging. Log every <2> seconds.

(2013-10-02 16:49:19) Information: Reloading

(2013-10-02 16:49:21) Information: Reloading.

(2013-10-02 16:49:23) Information: Reloading..

(2013-10-02 16:49:25) Information: Reloading...

(2013-10-02 16:49:27) Information: Reloading....

(2013-10-02 16:49:29) Information: Reloading.....

(2013-10-02 16:49:31) Information: The Source Document reload complete. DocumentPath=C:\ProgramData\QlikTech\Documents\Sales.V3.qvw

(2013-10-02 16:49:31) Information: Memory Allocation Delta for this file=236.38 Mb. Available Physical Memory Before Reload=6659.50 Mb. Available Physical Memory After Reload=6426.28 Mb. Total Physical Memory=6426.28 Mb.

(2013-10-02 16:49:31) Error: The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\Documents\Sales.V3.qvw.

(2013-10-02 16:49:31) Information: Closing the document.

(2013-10-02 16:49:32) Information: Closed the QlikView Engine successfully. ProcessID=3156

(2013-10-02 16:49:32) Error: The task "Sales.V3.qvw" failed. Exception:

(2013-10-02 16:49:32) 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=C:\ProgramData\QlikTech\Documents\Sales.V3.qvw.

(2013-10-02 16:49:32) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2013-10-02 16:49:32) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2013-10-02 16:49:32) Error: --- End of inner exception stack trace ---

(2013-10-02 16:49:32) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2013-10-02 16:49:32) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2013-10-02 16:49:32) Error: --- End of inner exception stack trace ---

(2013-10-02 16:49:32) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2013-10-02 16:49:32) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2013-10-02 16:49:32) Information: Task Execute Duration=00:00:24.5547148

(2013-10-02 16:49:32) Information: TaskResult.status=Finished

(2013-10-02 16:49:32) Information: Notifying all triggers of new state:FinishedWithErrors

(2013-10-02 16:49:32) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2013-10-02 16:49:32) Information: Saving Task Result

[#2]

Hi there.. you probably has a problem in your load script. Maybe a path that is ok on your dev PC and not correct on the server???

Without seeing the script log, is difficult to help you more.

[#3]

Thanks Gonzalo,

Here's the log file of the script

[#4]

I don't see any error on the script. could it be a memory problem? or some problem trying to store the qvw?

[Anonymous]

Do you have a section access inside ?

[Larry_Aaron]

According to your log file you have Synthetic Keys in your script.  Try removing them.

02/10/2013 5:21:39 PM:       $Syn 1 = SDeliveries_deliveryDate+SMonthYear

02/10/2013 5:21:39 PM:       $Syn 2 = ItemC_ItemNo+SMonthYear

02/10/2013 5:21:40 PM:       $Syn 3 = $Syn 1+$Syn 2

02/10/2013 5:21:40 PM:       $Syn 4 = SalesOrdersNO+SOLines_PostionNum

02/10/2013 5:21:42 PM:      Execution finished.

[rajeshvaswani77]

Hi,

Is your document file still open somewhere?

thanks,

Rajesh Vaswani

[#8]

no, i don't have section access

[#9]

but i think synthetic keys didn't affect it

[#10]

no