Qlikview Scheduler - Not Working

[#1]

I have a number of Qlikview applications that I need to reload automatically overnight and I am trying to use the scheduler to get this to happen. For some applications it works fine everytime and for other applications it just will not work at all. The only common theme that I can see is that where the data source is the tables in our ERP system the scheduling works and where the data source is a .qvd file saved on our server it doesn't. Here is the log file for one of the applications where the scheduling fails. Anyone got any ideas?

(2012-02-29 07:05:00) Information: Starting task 'UserApps/RW & DR Workflow.qvw'. Id:9dfb8d76-f484-4dab-bdfe-4adfcccca05c. Triggered by 'ScheduleTrigger'. Id:258c0774-d424-4488-b841-3fb83c880915

(2012-02-29 07:05:00) Information: Entering Task Execution.

(2012-02-29 07:05:00) Information: ClusterID=1

(2012-02-29 07:05:00) Information: QDSID=2ee48c9a-9aab-7803-2ab9-5f2984632fbc

(2012-02-29 07:05:00) Information: TaskID=9dfb8d76-f484-4dab-bdfe-4adfcccca05c

(2012-02-29 07:05:00) Information: MaxRunTime=06:00:00

(2012-02-29 07:05:00) Information: Max attempts:1

(2012-02-29 07:05:00) Information: Current Attempt=0

(2012-02-29 07:05:00) Information: Task Dependencies are OK

(2012-02-29 07:05:00) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2012-02-29 07:05:00) Information: Opening "D:\DEPLOYED APPLICATIONS\USERAPPLICATIONS\RW & DR Workflow.qvw"

(2012-02-29 07:05:00) Information: Allocating new QlikView Engine. Current usagecount=1 of 2

(2012-02-29 07:05:00) Information: Max retries:5

(2012-02-29 07:05:00) Information: Attempt:01

(2012-02-29 07:05:00) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 2, Ticket=6168

(2012-02-29 07:05:00) Information: Loading document "D:\DEPLOYED APPLICATIONS\USERAPPLICATIONS\RW & DR Workflow.qvw" (1.24 Mb)

(2012-02-29 07:05:01) Information: Physical FileSize=1.24 Mb. Memory Allocation Delta for this file=7.54 Mb. Available Physical Memory Before Open=5769.84 Mb. Available Physical Memory After Open=5759.61 Mb. Total Physical Memory=8178.11 Mb.

(2012-02-29 07:05:01) Information: Attempted to load the document without data.

(2012-02-29 07:05:01) Information: The document was loaded successfully.

(2012-02-29 07:05:01) Information: Document was opened successfully

(2012-02-29 07:05:01) Information: Starting reload

(2012-02-29 07:05:01) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

(2012-02-29 07:05:01) Information: The Source Document is being reloaded. DocumentPath=D:\DEPLOYED APPLICATIONS\USERAPPLICATIONS\RW & DR Workflow.qvw

(2012-02-29 07:05:01) Information: The Source Document reload complete. DocumentPath=D:\DEPLOYED APPLICATIONS\USERAPPLICATIONS\RW & DR Workflow.qvw

(2012-02-29 07:05:01) Information: Memory Allocation Delta for this file=1.09 Mb. Available Physical Memory Before Reload=5759.60 Mb. Available Physical Memory After Reload=5754.69 Mb. Total Physical Memory=5754.69 Mb.

(2012-02-29 07:05:02) Error: The Source Document was NOT reloaded successfully. DocumentPath=D:\DEPLOYED APPLICATIONS\USERAPPLICATIONS\RW & DR Workflow.qvw.

(2012-02-29 07:05:02) Information: Closing the document.

(2012-02-29 07:05:02) Information: Closed the QlikView Engine successfully. ProcessID=3696

(2012-02-29 07:05:02) Error: The task "UserApps/RW & DR Workflow.qvw" failed. Exception:

(2012-02-29 07:05:02) 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=D:\DEPLOYED APPLICATIONS\USERAPPLICATIONS\RW & DR Workflow.qvw.

(2012-02-29 07:05:02) Error:    at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2012-02-29 07:05:02) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2012-02-29 07:05:02) Error:    --- End of inner exception stack trace ---

(2012-02-29 07:05:02) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2012-02-29 07:05:02) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2012-02-29 07:05:02) Error:    --- End of inner exception stack trace ---

(2012-02-29 07:05:02) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2012-02-29 07:05:02) Error:    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2012-02-29 07:05:02) Information: Task Execute Duration=00:00:02.4362520

(2012-02-29 07:05:02) Information: Sending Alert mail

(2012-02-29 07:05:02) Warning: Failed to send mail to

(2012-02-29 07:05:02) Information: TaskResult.status=Finished

(2012-02-29 07:05:02) Information: Notifying all triggers of new state:FinishedWithErrors

(2012-02-29 07:05:02) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2012-02-29 07:05:02) Information: Saving Task Result

[rajeshvaswani77]

Hi, Did you check if the machine is goling down at this time, when your job runs for reloading. Te machine that has the QVD's i meant.

Thanks,

Rajesh Vaswani

[#3]

Hi Rajesh,

Yes – this is not the issue – I have one of these applications attempting to reload hourly and it fails every time – downtime on the .qvd server is not the issue. Could security / password / access be an issue?

Thanks

Paul

[rajeshvaswani77]

Check on access. Could you access the QVD files directly from the server using the same account?