topic Re: Store QVD on two servers in QlikView

Store QVD on two servers

agsearle — Wed, 14 Nov 2012 15:01:49 GMT

We have two Qlikview servers, one for development work, and one to host 'live' reports.

I am therefore trying to save QVD's on both servers at the same time when they are reloaded.

For example:

CUSTOM CONNECT TO......

QPCT:

LOAD *

SQL SELECT *

FROM QPCT;

STORE QPCT INTO [\\10.100.19.52\Reports\DATA QVD'S\QPCT.qvd]

STORE QPCT INTO ;

DROP TABLE QPCT;

How can I save the QVD automatically on each server?

When done manually opening a Qlikview session and reloading it works fine, but it fails to store anything when using the QEMC which is what I want to use.

Re: Store QVD on two servers

saimahasan — Fri, 12 Feb 2016 06:36:09 GMT

You can use the IP of both the servers when storing the QVD.

Re: Store QVD on two servers

its_anandrjs — Fri, 12 Feb 2016 07:40:36 GMT

Hi,

Try to use variavles here

Let vStoreLocation1 = '\\10.100.19.52\Reports\DATA QVD'S\';

Let vStoreLocation2 = 'D:\Qlik View\Reports\DATA QVD'S\';

QPCT:

LOAD *

SQL SELECT *

FROM QPCT;

STORE QPCT INTO $(vStoreLocation1)QPCT.qvd;

STORE QPCT INTO $(vStoreLocation2)QPCT.qvd;

DROP TABLE QPCT;

Regards

Anand

Re: Store QVD on two servers

kaushiknsolanki — Fri, 12 Feb 2016 08:12:24 GMT

Hi,

You can enable to document logs to check which script is giving error and then you can concentrate on that to resolve the issue.

Regards,

Kaushik Solanki

Re: Store QVD on two servers

marcus_sommer — Fri, 12 Feb 2016 08:37:03 GMT

You need to check if from the qv-server the path to the second server is available (you will probably need an unc-path) and accessable (meant not blocked by security measures and the proper access-rights for the server-user).

An alternatively which I use is not store everything twice I use robocopy to keep the production- und test-environment synchron: Robocopy - Wikipedia, the free encyclopedia.

- Marcus

Re: Store QVD on two servers

Mark_Little — Fri, 12 Feb 2016 08:52:08 GMT

Hi,

From what you have explained, i would guess the user set up for the QMC services does not have access to the second location.

Check the services and what user is set up to run QMC and then log on as that user and try to browse to the second location.

Mark