Use QVW to move QVD files from one server to another

[Monkeyb33f]

Hi,

We have Qlikview and Qliksense set up on separate servers, and I have a QVW application which creates a whole bunch of QVD files on the Qlikview server that I'd like to use in Qliksense. I'd like to use QMC to run a scheduled task to do this daily. I can probably get the Qliksense app to read the QVD files from the Qlikview server but for performance purposes i am reluctant to do so.

I created a QVW that simply has a script that goes:

TABLE1:

LOAD * FROM [A:\FILELOCATION\TABLE1.qvd](qvd);

STORE TABLE INTO [B:\FILELOCATION\TABLE1.qvd](qvd);

DROP TABLE TABLE1

And repeats the above for all the QVD files I need.  This works perfectly when I open the QVW file and reload manually. However, when i trigger the job through the QMC, it fails each time.

Does anyone have any ideas why this might be?

[rwunderlich]

Take a look at the script document log to determine why it's failing. 

[Lech_Miszkiewicz · Accepted solution]

It may be that your Qlik Service account does not have rights to store QVD in the other location.

For testing run QlikView desktop as service account (right click +Shift) and "Run as different user". Inspect what is not working.

cheers

[Monkeyb33f]

Thanks,

After checking, I can see the that although I was logged on as a service user, the QMC was actually using a different user. Granting that user permission to the folder fixed the issue.