Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to schedule daily reload script

Hi

How to schedule daily reload script?

2 Solutions

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

Do you have publisher?

If so, go to the documents tab, there yuo'll find all your documents in original directories, select it and press on the upper right.

Give a name intask name, then if document has not section access go to the distribute tab and press

add users.

in document information tab select a category or add a new one (you will see the category in access point)

finally oin triggers tab define your schedule

View solution in original post

Colin-Albert

If you have QlikView server, save your QVW to the Access Point folder or mounted folder.

The QMC documents tab then has options to schedule the reload.

If you have publisher, save the QVW to the source documents folder.

Then in the QMC configure a reload task, distribute the reloaded document, and set a trigger to schedule the task.

View solution in original post

25 Replies
vikasmahajan

You can schedule in QMC and Windows Scheduler where you want to schedule ?

vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
alexandros17
Partner - Champion III
Partner - Champion III

Do you have publisher?

If so, go to the documents tab, there yuo'll find all your documents in original directories, select it and press on the upper right.

Give a name intask name, then if document has not section access go to the distribute tab and press

add users.

in document information tab select a category or add a new one (you will see the category in access point)

finally oin triggers tab define your schedule

Anonymous
Not applicable
Author

Hi

we've  done  everything.but the task showing failed.how to resolved this issue.

thanks.

Anonymous
Not applicable
Author

hi

schedule in QMC.

Colin-Albert

If you have QlikView server, save your QVW to the Access Point folder or mounted folder.

The QMC documents tab then has options to schedule the reload.

If you have publisher, save the QVW to the source documents folder.

Then in the QMC configure a reload task, distribute the reloaded document, and set a trigger to schedule the task.

alexandros17
Partner - Champion III
Partner - Champion III

give the message

alexandros17
Partner - Champion III
Partner - Champion III

In the upper right corner there is a show task detail link, look there and try (in log) to understand

Anonymous
Not applicable
Author

Hi

This is the error msg

(2014-03-27 11:53:00) Information: Starting task 'Debtors'. Id:d3e803d2-e8b7-4abd-9e4d-1fe73ea748fd. Triggered by 'ScheduleTrigger'. Id:1b534a29-b60a-40c4-9682-ae17a5883d3a

(2014-03-27 11:53:00) Information: Entering Task Execution.

(2014-03-27 11:53:00) Information: ClusterID=1

(2014-03-27 11:53:00) Information: QDSID=102f223c-1608-ee0f-17d1-015032975d1f

(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

alexandros17
Partner - Champion III
Partner - Champion III

It seems there is an error in section access ... enable log writeing of your document (Settings -> document properties -> general  check generate logfile and run it again