topic Re: Automatic Reload Failed in QlikView

Automatic Reload Failed

Wed, 02 Oct 2013 15:01:29 GMT

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

Re: Automatic Reload Failed

Wed, 02 Oct 2013 15:16:15 GMT

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.

Re: Re: Automatic Reload Failed

Wed, 02 Oct 2013 15:24:47 GMT

Thanks Gonzalo,

Here's the log file of the script

Re: Re: Automatic Reload Failed

Wed, 02 Oct 2013 16:35:57 GMT

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

Re: Automatic Reload Failed

Anonymous — Wed, 02 Oct 2013 16:38:37 GMT

Do you have a section access inside ?

Re: Automatic Reload Failed

Larry_Aaron — Wed, 02 Oct 2013 16:54:00 GMT

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.

Re: Automatic Reload Failed

rajeshvaswani77 — Wed, 02 Oct 2013 17:05:45 GMT

Hi,

Is your document file still open somewhere?

thanks,

Rajesh Vaswani

Re: Automatic Reload Failed

Thu, 03 Oct 2013 07:33:08 GMT

no, i don't have section access

Re: Automatic Reload Failed

Thu, 03 Oct 2013 07:33:58 GMT

but i think synthetic keys didn't affect it

Re: Automatic Reload Failed

Thu, 03 Oct 2013 07:34:26 GMT

Re: Automatic Reload Failed

Larry_Aaron — Thu, 03 Oct 2013 14:45:47 GMT

Other potential causes I've seen:

1) Using absolute paths vs. relative paths. If your using an absolute path on your local computer that doesn't exist on the server, the reload will fail. Only use relative paths so your script will run in any directory structure.

2) Storing a table as a QVD in script and the existing copy of the QVD file is locked and your application can't complete the store. Delete or move the existing QVD.

Re: Automatic Reload Failed

rwunderlich — Thu, 03 Oct 2013 14:54:20 GMT

The document log you posted does not match the time of the tasklog you posted. It also appears that the server copy is not set to generate a document log.

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

I recommend you rerun the task with Document Log on and look at that Document Log for errors.

-Rob

Re: Automatic Reload Failed

Anonymous — Thu, 03 Oct 2013 15:07:20 GMT

Mona

The *.log file you attached is from a different time to the Log info you pasted in at the beginning.

Are you sure you attached the *.log from the failed run ?

Best Regards, Bill

Re: Automatic Reload Failed

Mon, 07 Oct 2013 07:56:04 GMT

the relative path was part of solution, but still reload failed.

Re: Automatic Reload Failed

Mon, 07 Oct 2013 07:57:00 GMT

no, i generated the log file not at the same time

but for the same document

Re: Automatic Reload Failed

Mon, 07 Oct 2013 07:58:31 GMT

another problem

automatic reload failed also when i load from acube using mdx query generator

how i overcome this problem?

Re: Automatic Reload Failed

Mon, 07 Oct 2013 09:38:13 GMT

Still, show us a generic log document. It is possible, that OMC user has no access to spezific path or some DB gives no access ... If you generete us separate log file, we dont see these errors..

Show thouse 4 rows, there it is Script error written