Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How to schedule daily reload script?
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
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.
You can schedule in QMC and Windows Scheduler where you want to schedule ?
vikas
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
Hi
we've done everything.but the task showing failed.how to resolved this issue.
thanks.
hi
schedule in QMC.
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.
give the message
In the upper right corner there is a show task detail link, look there and try (in log) to understand
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
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