topic Re: how to automatically reload document in QlikView

how to automatically reload document

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

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

Re: how to automatically reload document

amit_saini — Fri, 21 Mar 2014 06:08:32 GMT

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.

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,

Re: how to automatically reload document

sundarakumar — Fri, 21 Mar 2014 06:09:43 GMT

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

Hope this helps

_sundar

Re: how to automatically reload document

sunilkumarqv — Fri, 21 Mar 2014 06:30:38 GMT

Make use of scheduler what before posts says

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"

Re: how to automatically reload document

Anonymous — Fri, 21 Mar 2014 06:33:15 GMT

Hi amit,

Thanks for your Support.

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

Re: how to automatically reload document

Anonymous — Fri, 21 Mar 2014 06:36:34 GMT

Hi Sundar,

thanks for your information.

But the status showing failed.

Re: how to automatically reload document

sundarakumar — Fri, 21 Mar 2014 06:40:00 GMT

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

its_anandrjs — Fri, 21 Mar 2014 06:45:44 GMT

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

its_anandrjs — Fri, 21 Mar 2014 06:49:25 GMT

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

Re: how to automatically reload document

Anonymous — Fri, 21 Mar 2014 07:07:18 GMT

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

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

Re: how to automatically reload document

sundarakumar — Fri, 21 Mar 2014 07:10:48 GMT

The source document is failing to reload.. There may be some prob with the application...

Go to the source path where u have put the application in the server..

Open the application and try reloading it by pressing ctrl+R.. See what error it is showing. maybe it is some prob like table not found, missing fild , etc... the prob may be with the application...

-Sundar

Re: how to automatically reload document

Anonymous — Fri, 21 Mar 2014 07:13:15 GMT

Hi,

Thanks Sundar.

Re: how to automatically reload document

sundarakumar — Fri, 21 Mar 2014 07:14:24 GMT

You welcome

Re: how to automatically reload document

its_anandrjs — Fri, 21 Mar 2014 07:16:46 GMT

Hi,

Check your table source location the tables that you are reading is properly there or not also its name is correct in application or not and as Sunder say reload it manually by pressing Ctrl+R.

Hope this helps

Thanks & Regards

Re: how to automatically reload document

Anonymous — Fri, 21 Mar 2014 08:07:47 GMT

Thanks for your support.

Re: how to automatically reload document

its_anandrjs — Fri, 21 Mar 2014 08:13:39 GMT

Thanks & Welcome

Hope this helps

Thanks & Regards

Re: how to automatically reload document

Bill_Britt — Fri, 21 Mar 2014 12:19:21 GMT

Hi,

Has the task every worked?

Is DocumentPath=E:\qlikview\Documents\ a mapped drive?

What does the document log show the error is?

Bill

Re: how to automatically reload document

Anonymous — Mon, 24 Mar 2014 09:49:35 GMT

Hi sundarakumar ,

We had created a DNS Configuration in our qlikview server also as the same we did in developers machine .But Still it is failing to reload the tables data from DB

Re: how to automatically reload document

sundarakumar — Mon, 24 Mar 2014 12:04:36 GMT

Do u have different environment for development and production?

-Sundar

Re: how to automatically reload document

vikasmahajan — Mon, 24 Mar 2014 12:06:58 GMT

Pfa Attach Bunch will explain how to Send Email and export and schedule.

Vikas