Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

STORE command not working on server

Does anyone have an idea what permission/access may be necessary to run the STORE command on the server?

I have no problem running the script from my local machine, and I was told I have full control of the folder I am writing to on the server.

Thanks,

Jimmy

1 Solution

Accepted Solutions
Not applicable
Author

You guys are going to laugh. I did....

Using this directory path worked:

Set DataDir='D:\Qlikview\Datasources\QVDs_Dev';

This one did not:

Set DataDir='\\computer1\Qlikview\Datasources\QVDs_Dev';

-this method is nice if you are loading data from the server to a local machine but doesn't seem to work for STORE

View solution in original post

7 Replies
danielrozental
Master II
Master II

Seems a bit obvious but Read/Write permissions.

Store fails running Qv.exe or running the reload through QvServer?

Try deleting the file first, I think windows UAC will cause store to fail if the file was originally created by another user.

Not applicable
Author

Running qv.exe on the server.

That is obvious and all boxes are checked (including full control) under the Security/Permissions tab of the folder.

I changed the name of the file and I create the qvw as well, so it wasn't created by anyone but me.

danielrozental
Master II
Master II

can you create a file in the same folder? can you post the store command line you are using?

Miguel_Angel_Baeyens

In addition to what Daniel asks, note that the account the Server is running under must have write permissions in the directory where you are storing into. Note as well that in Windows, the most restrictive permissions prevails, so if your user or the user running services belongs to several security groups, they may be conflicting.

Sometimes the antivirus software keeps some files open so they cannot be overwritten even with sufficient permissions. Is there any chance this is happening?

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Not applicable
Author

yes, I can create/save a file there. here is the store and directory lines:

Set DataDir='\\computer1\Qlikview\Datasources\QVDs_Dev';

STORE Campaign into $(DataDir)\Campaign.qvd;

Not applicable
Author

Thanks for those suggestions. I will pass that along to our IT team.

Not applicable
Author

You guys are going to laugh. I did....

Using this directory path worked:

Set DataDir='D:\Qlikview\Datasources\QVDs_Dev';

This one did not:

Set DataDir='\\computer1\Qlikview\Datasources\QVDs_Dev';

-this method is nice if you are loading data from the server to a local machine but doesn't seem to work for STORE