Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
Thanks Gonzalo,
Here's the log file of the script
I don't see any error on the script. could it be a memory problem? or some problem trying to store the qvw?
Do you have a section access inside ?
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.
Hi,
Is your document file still open somewhere?
thanks,
Rajesh Vaswani
no, i don't have section access
but i think synthetic keys didn't affect it
no