Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
how to schedule automatically reload document.how to use distributed E-mail option.
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
U have to Schedule the task in your QMC...
'
Hope this helps
_sundar
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"
Hi amit,
Thanks for your Support.
But the task status detail showing failed.how to resolve this issue.
Hi Sundar,
thanks for your information.
But the status showing failed.
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
Hi,
Check the log file of the application and in which line the reload fails.
Hope this helps
Thanks & Regards
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
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. --->
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