Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

michaelcostner
New Contributor II

Saving qvd file to a network folder

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

Tags (1)
17 Replies
vishsaggi
Esteemed Contributor III

Re: Saving qvd file to a network folder

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

michaelcostner
New Contributor II

Re: Saving qvd file to a network folder

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

Otherwise I have full access to the server.

vishsaggi
Esteemed Contributor III

Re: Saving qvd file to a network folder

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?

michaelcostner
New Contributor II

Re: Saving qvd file to a network folder

Yes, storing locally on my PC works just fine.

vishsaggi
Esteemed Contributor III

Re: Saving qvd file to a network folder

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

michaelcostner
New Contributor II

Re: Saving qvd file to a network folder

Yes.

krishnacbe
Valued Contributor III

Re: Saving qvd file to a network folder

Try using below Store statement.

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

michaelcostner
New Contributor II

Re: Saving qvd file to a network folder

Thanks for the suggestion, but still no luck.

vishsaggi
Esteemed Contributor III

Re: Saving qvd file to a network folder

Hmm thats strange. Can you rename your table name like

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

Community Browser