topic Auto Reload on QlikView V10 server in QlikView

Auto Reload on QlikView V10 server

Wed, 26 Oct 2011 10:29:16 GMT

Hi All

This may seem trival but we are having problems with trying to reload data into a QV document at a specific point of the day using the auto reload function in the server.

Could anyone explain how they have got this to work, so i can check our set up?

Emma

Auto Reload on QlikView V10 server

MEllinghausen — Wed, 02 Nov 2011 15:14:35 GMT

Hey Emma,

I Think the Reload funktion ist not to load new data from your DB to the qvw File, this funktion load the document new in the RAM of the server.

If you want to load new data you should run the script. You can also do this with a batch file like "C:\Program Files\QlikView\Qv.exe" /r D:\Document.qvw

Marcus

Auto Reload on QlikView V10 server

Fri, 16 Dec 2011 15:37:05 GMT

But i have been told this function is avaliable.

The QlikView document is connected via an OLE DB to a SQL Server which i want to automate the process of pulling that data through to the QlikView document.

Currently i am having to reload the document manually on the server everyday. If you could give me any suggestions that would be great.

Thanks

Emma

Re: Auto Reload on QlikView V10 server

isaiah82 — Fri, 16 Dec 2011 15:52:18 GMT

emmabirdsey wrote:
This may seem trival but we are having problems with trying to reload data into a QV document at a specific point of the day using the auto reload function in the server.

What is the specific problem that you're having? Have you tried to set this up in QEMC? -Isaiah

Re: Auto Reload on QlikView V10 server

Fri, 16 Dec 2011 15:57:47 GMT

The document fails to load.

I have scheduled this on the QMC and ensured that the box is ticked in the document properties.

I have looked on the QMEC but it shows the settings that i have set up for that document in the QMC. Am i missing a step?

Re: Auto Reload on QlikView V10 server

isaiah82 — Fri, 16 Dec 2011 16:00:17 GMT

When you say the document fails to load > is the reload starting and failing, -OR- is it just not starting at all?

Re: Auto Reload on QlikView V10 server

Thu, 05 Jan 2012 16:12:00 GMT

It appears to start to load but then an error messgae appears on the QMC:

The Source Document was NOT reloaded successfully. DocumentPath=D:\PLICS\Information\TestReloadv1.qvw.
Aborting Reload. Error=QDSMain.TaskResult
Reload failed.
Reload failed. Distribution skipped.
The task "Information/TestReloadv1.qvw" failed. ErrorCount=4

Is there anything that needs to be written into the script?

Kind Regards

Emma

Re: Auto Reload on QlikView V10 server

isaiah82 — Thu, 05 Jan 2012 16:19:38 GMT

You need to enable logging in the QVW (Settings > Document Properties > General > Enable Logfile) if it's not already and check that log file for more info. It'll be the same as the qvw filename but with an additional ".log"

Are you using Section Access in the QVW? If so, does the service account running the Distribution Service have access? You can test this by logging into the box using those credentials, and trying to open the QVW locally.

-Isaiah