Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

sathish_expo
Contributor

How to schedule daily reload script

Hi

How to schedule daily reload script?

25 Replies
vikasmahajan
Honored Contributor III

Re: How to schedule daily reload script

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

vikas

Re: 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

sathish_expo
Contributor

Re: How to schedule daily reload script

Hi

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

thanks.

sathish_expo
Contributor

Re: How to schedule daily reload script

hi

schedule in QMC.

Re: How to schedule daily reload script

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.

Re: How to schedule daily reload script

give the message

Re: How to schedule daily reload script

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

sathish_expo
Contributor

Re: How to schedule daily reload script

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

Re: How to schedule daily reload script

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

Community Browser