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 automatically reload document

Hi,

     how to schedule automatically reload document.how to use distributed E-mail option.

Labels (1)
22 Replies
amit_saini
Master III
Master III

Hi  Sathish,

QlikView server product known as QlikView Publisher provides an interface known as QlikView Management Console.

In the Management console.

1. You login and go to Document tab> Source document

2. Select your QVW file

3. Create a Task by clicking on the Add Task Manually

4. Enable Reload in your task and select a time schedule (Trigger) when you want the Publisher to do the data load from Data Source to your QVW.

5. Based on the Time defined in the Task, the Publisher will run the Script present in the QVW and loads data from external Data Sources to your QVW file.

This process is Automatic Reload based on a schedule.

OR

you should create a command file (open Notepad.exe and save as a new file with CMD file extension, instead of txt) with one command: "C:\Program Files\QlikView\Qv.exe" /r "\\roise\Qlikview\ProjectFiles\test.qvw". Save this file with *.cmd file extension. After that you can schedule this CMD file fith windows task scheduller.

Thanks,

AS

sundarakumar
Specialist II
Specialist II

U have to Schedule the task in your QMC...

topost.PNG.png

topost1.PNG.png'

Hope this helps

_sundar

sunilkumarqv
Specialist II
Specialist II

Make use of scheduler what before posts says

or

make use of batch file

If you add a /r switch (notice the front-leaning slash) then the command will open the report, run the reload function (executing the loadscript), and then save and close the report:

in notepad .BAT file extension

C:\File.qvw replace with your qlikview document file


"C:\Program Files\QlikView10\qv.exe" /r "C:\File.qvw" 

Anonymous
Not applicable
Author

Hi amit,

     Thanks for your Support.

     But the task status detail showing failed.how to resolve this issue.

Anonymous
Not applicable
Author

Hi Sundar,

   thanks for your information.

    But the status showing failed.

sundarakumar
Specialist II
Specialist II

Check the logs for getting the reason for failure.

Click show task detail and log.

If u can run the task again.

Post the log so that we can help u to fix the issue.

-Sundar

its_anandrjs

Hi,

Check the log file of the application and in which line the reload fails.

Hope this helps

Thanks & Regards

its_anandrjs

Hi,

Use QMEC for auto reload other wise use task scheduler to add reload task for application and ose bat file to reload the application like.

In bat file write like

"C:\Program Files\QlikView11\qv.exe" /r "C:\YourQVWfile.qvw" 


Hope this helps

Thanks & Regards

Anonymous
Not applicable
Author

hi sundar,

Here is my error log.

(2014-03-21 12:31:18) Information: Closed the QlikView Engine successfully. ProcessID=3908

(2014-03-21 12:31:18) Error: The task "Debtors" failed. Exception:

(2014-03-21

12:31:18) Error: QDSMain.Exceptions.DistributionFailedException:

Distribute failed with errors to follow. --->

  1. QDSMain.Exceptions.ReloadFailedException: Reload failed --->
  2. QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT

reloaded successfully.

DocumentPath=E:\qlikview\Documents\Temp-InternationalDebtorsReceivables-Feb'14-Extracted

From System.qvw.

(2014-03-21 12:31:18) Error:    at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2014-03-21

12:31:18) Error:    at QDSMain.ReloadTask.Reload(String fileName,

TaskResult taskResult, String sectionAccessUserName, String

sectionAccessPassword, eReloadOptions reloadOption, String variableName,

String variableValue, Boolean moniterCpuUsage)

(2014-03-21 12:31:18) Error:    --- End of inner exception stack trace ---

(2014-03-21

12:31:18) Error:    at QDSMain.ReloadTask.Reload(String fileName,

TaskResult taskResult, String sectionAccessUserName, String

sectionAccessPassword, eReloadOptions reloadOption, String variableName,

String variableValue, Boolean moniterCpuUsage)

(2014-03-21 12:31:18) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-03-21 12:31:18) Error:    --- End of inner exception stack trace ---

(2014-03-21 12:31:18) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-03-21 12:31:18) Error:    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2014-03-21 12:31:18) Information: Task Execute Duration=00:00:01.8437146

(2014-03-21 12:31:18) Information: TaskResult.status=Finished

(2014-03-21 12:31:18) Information: Notifying all triggers of new state:FinishedWithErrors

(2014-03-21 12:31:18) Information: Notifying all triggers of new state:FinishedWithErrors - completed

  (2014-03-21 12:31:18) Information: Saving Task Result