topic Re: Saving qvd file to a network folder in QlikView

Saving qvd file to a network folder

Anonymous — Tue, 26 Sep 2017 19:48:39 GMT

Hi Everyone,

I'm having trouble storing a qvd file to a network folder.

My script is fairly straightforward. I'm trying to load an .xml stored on a server, then save the loaded data as a .qvd to the same server.

The gist of my script is below:

MyTable:

load *

from [\\serverName\datafolder\file.xml];

store MyTable into \\serverName\qvdfolder\MyTable.qvd (QVD);

I am able to load the data OK but receive "failed to open file in write mode for file \\serverName\qvdfolder\MayTable.qvd" when trying to store the .qvd file. I have read/write access to the folder I'm trying to save to. I've also tried using the server IP address in lieu of the server name.

Any thoughts on what is causing the error? I am fairly new to qvd storage, any thoughts or comments would be appreciated.

Thanks!

Michael

Re: Saving qvd file to a network folder

vishsaggi — Tue, 26 Sep 2017 20:01:16 GMT

Can you get to that server and see your qvd file?

Re: Saving qvd file to a network folder

Anonymous — Tue, 26 Sep 2017 20:03:14 GMT

No, I receive an error before the qvd is saved.

Otherwise I have full access to the server.

Re: Saving qvd file to a network folder

vishsaggi — Tue, 26 Sep 2017 20:25:45 GMT

Ok can you run the same script to you local drive like

store MyTable into C:\Foldername\MyTable.qvd (qvd);

And can you get to that folder from your windows explorer?

Re: Saving qvd file to a network folder

Anonymous — Tue, 26 Sep 2017 20:30:45 GMT

Yes, storing locally on my PC works just fine.

Re: Saving qvd file to a network folder

vishsaggi — Tue, 26 Sep 2017 20:32:41 GMT

Ok and can you get to that network folder from your windows explorer?

Re: Saving qvd file to a network folder

Anonymous — Tue, 26 Sep 2017 20:34:07 GMT

Yes.

Re: Saving qvd file to a network folder

krishnacbe — Tue, 26 Sep 2017 20:37:27 GMT

Try using below Store statement.

store MyTable into [\\serverName\qvdfolder\MyTable.qvd](QVD);

Re: Saving qvd file to a network folder

Anonymous — Tue, 26 Sep 2017 20:42:06 GMT

Thanks for the suggestion, but still no luck.

Re: Saving qvd file to a network folder

vishsaggi — Tue, 26 Sep 2017 20:49:53 GMT

Hmm thats strange. Can you rename your table name like

store MyTable into \\serverName\qvdfolder\Table.qvd (qvd);

Re: Saving qvd file to a network folder

Anonymous — Tue, 26 Sep 2017 20:58:52 GMT

Still receiving the same error 😕

Re: Saving qvd file to a network folder

vishsaggi — Tue, 26 Sep 2017 21:03:38 GMT

Can you share you actual store command you are running like, if you dont want to show the server name just give some random name and share your actual path you are using.

Re: Saving qvd file to a network folder

Anonymous — Tue, 26 Sep 2017 21:06:55 GMT

Sure thing.

store SystemMetrics into [\\myServer\I\vSync\Metrics\QVD\System\SystemQVD.qvd] (QVD);

Where myServer is the server name and the folder is located on the I: drive.

Re: Saving qvd file to a network folder

vishsaggi — Tue, 26 Sep 2017 21:18:58 GMT

I is a drive on your server? I doubt you can use that I drive like that.Not sure. Ok can you screen shot the windows explorer address bar when you try to get to that I drive System folder just the address bar screen shot can you send it.

Re: Saving qvd file to a network folder

vishsaggi — Tue, 26 Sep 2017 21:25:28 GMT

try this ?

Store SystemMetrics INTO \\myServer\I$\vSync\Metrics\QVD\System\SystemQVD.qvd(qvd);

use a $ symbol after I.

Re: Saving qvd file to a network folder

Anonymous — Tue, 26 Sep 2017 21:42:34 GMT

No luck with using "$".

I think there may be some kind of firewall blocking the qvd from being stored. I'm able to use a different server on our network with the exact same store statement and it works fine.

Thanks for the response.

Re: Saving qvd file to a network folder

vishsaggi — Tue, 26 Sep 2017 21:47:46 GMT

Oh cool.Probably touch base with your IT guys. That could be one of the reasons too.

Re: Saving qvd file to a network folder

kenphamvn — Wed, 27 Sep 2017 01:42:54 GMT

Please check folder permission with QlikView service user (maybe not login user )

Re: Saving qvd file to a network folder

diego_barboza — Tue, 22 Jan 2019 12:07:16 GMT

You need to "Add a network location" so your network drive is mapped to a local address on your pc, in that way QlikView engine will be capable to reach it. Once you map your shared folder on your PC, remember to use the new access to enable the read/write of the network folder.

The same applies if QlikView is installed on a server and you need to reach files that are not loaded locally, this is an standard proccedure if you have a large QV server with one or more backend servers and one frontend servers, since this enable the communication between them.