How to schedule daily reload script

[Anonymous]

Hi

How to schedule daily reload script?

[Anonymous]

(2014-03-27 11:53:00) Information: TaskID=d3e803d2-e8b7-4abd-9e4d-1fe73ea748fd

(2014-03-27 11:53:00) Information: MaxRunTime=1.00:00:00

(2014-03-27 11:53:00) Information: MachineName=BIS

(2014-03-27 11:53:00) Information: Max attempts:1

(2014-03-27 11:53:00) Information: Current Attempt=0

(2014-03-27 11:53:00) Information: Task Dependencies are OK

(2014-03-27 11:53:00) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2014-03-27 11:53:00) Information: Opening "E:\qlikview\Documents\Temp-InternationalDebtorsReceivables-Feb'14-Extracted From System.qvw"

(2014-03-27 11:53:00) Information: Allocating new QlikView Engine. Current usage count=0 of 4 (of type non-reader).

(2014-03-27 11:53:00) Information: Max retries:5

(2014-03-27 11:53:00) Information: Attempt:01

(2014-03-27 11:53:00) Information: Opened the QlikView Engine successfully. ProcessID=6032

(2014-03-27 11:53:00) Information: Allocated QlikView Engine successfully. Current usage count=1 of 4 (of type non-reader). Ticket number=18.

(2014-03-27 11:53:00) Information: Loading document "E:\qlikview\Documents\Temp-InternationalDebtorsReceivables-Feb'14-Extracted From System.qvw" (0.27 Mb)

(2014-03-27 11:53:01) Information: Physical FileSize=0.27 Mb. Memory Allocation Delta for this file=7.10 Mb. Available Physical Memory Before Open=1574.75 Mb. Available Physical Memory After Open=1564.65 Mb. Total Physical Memory=4094.60 Mb.

(2014-03-27 11:53:01) Information: Attempted to load the document without data.

(2014-03-27 11:53:01) Information: The document was loaded successfully.

(2014-03-27 11:53:01) Information: Document was opened successfully

(2014-03-27 11:53:01) Information: Starting reload

(2014-03-27 11:53:01) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

(2014-03-27 11:53:01) Information: The Source Document is being reloaded. DocumentPath=E:\qlikview\Documents\Temp-InternationalDebtorsReceivables-Feb'14-Extracted From System.qvw

(2014-03-27 11:53:02) Information: Reloading.

(2014-03-27 11:53:03) Information: Reloading..

(2014-03-27 11:53:04) Information: Reloading...

(2014-03-27 11:53:05) Information: Reloading....

(2014-03-27 11:53:06) Information: Reloading.....

(2014-03-27 11:53:07) Information: Reloading......

(2014-03-27 11:53:08) Information: Reloading.......

(2014-03-27 11:53:09) Information: Reloading........

(2014-03-27 11:53:10) Information: Reloading.........

(2014-03-27 11:53:10) Information: The Source Document reload complete. DocumentPath=E:\qlikview\Documents\Temp-InternationalDebtorsReceivables-Feb'14-Extracted From System.qvw

(2014-03-27 11:53:10) Information: Memory Allocation Delta for this file=0.19 Mb. Available Physical Memory Before Reload=1564.64 Mb. Available Physical Memory After Reload=1541.71 Mb. Total Physical Memory=1541.71 Mb.

(2014-03-27 11:53:10) Error: The Source Document was NOT reloaded successfully. DocumentPath=E:\qlikview\Documents\Temp-InternationalDebtorsReceivables-Feb'14-Extracted From System.qvw.

(2014-03-27 11:53:10) Information: Closing the document.

(2014-03-27 11:53:11) Information: Closed the QlikView Engine successfully. ProcessID=6032

(2014-03-27 11:53:11) Error: The task "Debtors" failed. Exception:

(2014-03-27 11:53:11) 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=E:\qlikview\Documents\Temp-InternationalDebtorsReceivables-Feb'14-Extracted From System.qvw.

(2014-03-27 11:53:11) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2014-03-27 11:53:11) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2014-03-27 11:53:11) Error: --- End of inner exception stack trace ---

(2014-03-27 11:53:11) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2014-03-27 11:53:11) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-03-27 11:53:11) Error: --- End of inner exception stack trace ---

(2014-03-27 11:53:11) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-03-27 11:53:11) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2014-03-27 11:53:11) Information: Task Execute Duration=00:00:10.8436112

(2014-03-27 11:53:11) Information: TaskResult.status=Finished

(2014-03-27 11:53:11) Information: Notifying all triggers of new state:FinishedWithErrors

(2014-03-27 11:53:11) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2014-03-27 11:53:11) Information: Saving Task Result

[arsal_90]

Hi

You have to provide the User Id as ADMIN in Section access in QMC

Go to QMC then go to the tab where u scheduled for time here u see section access

[Anonymous]

hi

failed status resolved. but now showing waiting.

when will we get success msg.

Thanks.

[Anonymous]

hi

failed status resolved. but now showing waiting status

Thanks.

[Colin-Albert]

Waiting is the correct status.

It shows that the previous execution ran without errors, and the job is waiting to run again when the next execution time is reached.

[Anonymous]

Thanks Colin,

but i've run again this job.it is showing waiting.

[#8]

HI,

Can you debug and check your application manually.

[Anonymous]

Hi,

manually it is working fine.

[maleksafa]

Hi, if the reload is working file manually, then try to set the logging level to high on the document and from the access point, then reload it from the Access point and check the log files, the only reason i can think about is the section access but since you added this to the configuration you should have a problem.

[#11]

Can you run and see the same task for the application to reload from QMC for any errors