Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
sathish_expo
Contributor

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
Honored Contributor III

Re: how to automatically reload document

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
Valued Contributor II

Re: how to automatically reload document

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

topost.PNG.png

topost1.PNG.png'

Hope this helps

_sundar

sunilkumarqv
Valued Contributor II

Re: how to automatically reload document

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" 

sathish_expo
Contributor

Re: how to automatically reload document

Hi amit,

     Thanks for your Support.

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

sathish_expo
Contributor

Re: how to automatically reload document

Hi Sundar,

   thanks for your information.

    But the status showing failed.

sundarakumar
Valued Contributor II

Re: how to automatically reload document

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

Re: how to automatically reload document

Hi,

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

Hope this helps

Thanks & Regards

Re: how to automatically reload document

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

sathish_expo
Contributor

Re: how to automatically reload document

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

Community Browser