25 Replies Latest reply: Mar 27, 2014 8:15 AM by Sathish Kumar RSS

    How to schedule daily reload script

    Sathish Kumar

      Hi

      How to schedule daily reload script?

        • Re: How to schedule daily reload script
          vikas mahajan

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

           

          vikas

          • Re: How to schedule daily reload script
            Alessandro Saccone

            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

              • Re: How to schedule daily reload script
                Sathish Kumar

                Hi

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

                thanks.

                  • Re: How to schedule daily reload script
                    Alessandro Saccone

                    give the message

                      • Re: How to schedule daily reload script
                        Alessandro Saccone

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

                        • Re: How to schedule daily reload script
                          Sathish Kumar

                          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
                              Alessandro Saccone

                              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

                                • Re: How to schedule daily reload script
                                  Sathish Kumar

                                  (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
                          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.

                          • Re: How to schedule daily reload script
                            Ravi Kumar

                            HI,

                             

                            Can you debug and check your application manually.