topic Re: "Failed to open file in write mode for file" on Reload in QlikView

"Failed to open file in write mode for file" on Reload

matthewp — Wed, 14 Jun 2017 10:19:30 GMT

When trying to reload i am getting the error "Failed to open file in write mode for file"

There are no other reloads happening at the same time.

the name for the qvd to be stored is a new file (therefore it cannot be a locked file)

any ideas?

Script is basically:

newqvd:

Load

SQL

SELECT * FROM table;

Store newqvd into $(vQVDDirectory)\newqvd.qvd;

Drop table newqvd;

Re: "Failed to open file in write mode for file" on Reload

stabben23 — Wed, 14 Jun 2017 10:23:50 GMT

Hi Matt, could it be the missing Space that gives you the error?

And does Your user have all permissions to the folder path?

newqvd:

Load

SQL

SELECT * FROM table;

Store newqvd into $(vQVDDirectory)\newqvd.qvd;

Drop table newqvd;

Re: "Failed to open file in write mode for file" on Reload

matthewp — Wed, 14 Jun 2017 10:30:48 GMT

No that was a typo when doing the question.

Yes i can reload other files in into the same folder no problem

Re: "Failed to open file in write mode for file" on Reload

stabben23 — Wed, 14 Jun 2017 10:34:53 GMT

Ok,

try to add (qvd) last, like this

Store newqvd into $(vQVDDirectory)\newqvd.qvd (qvd);

Maybe no effect, but try.

Re: "Failed to open file in write mode for file" on Reload

matthewp — Wed, 14 Jun 2017 10:45:05 GMT

still the same error

Re: "Failed to open file in write mode for file" on Reload

stabben23 — Wed, 14 Jun 2017 10:53:29 GMT

Ok, are you running the script from desktop or server?

Re: "Failed to open file in write mode for file" on Reload

matthewp — Wed, 14 Jun 2017 10:54:22 GMT

tried both

Re: "Failed to open file in write mode for file" on Reload

stabben23 — Wed, 14 Jun 2017 10:58:06 GMT

Is the same Application open in another window? also check that there is no "ghost" process open in task manager that lock the reload.

Re: "Failed to open file in write mode for file" on Reload

stabben23 — Wed, 14 Jun 2017 11:00:50 GMT

Wats is you full path here $(vQVDDirectory)?

Re: "Failed to open file in write mode for file" on Reload

matthewp — Wed, 14 Jun 2017 11:03:23 GMT

typo in variable

Re: "Failed to open file in write mode for file" on Reload

themandrake — Mon, 04 Sep 2017 18:49:10 GMT

its the typo , using brackets [ ] always helps for spaces etc. just dont forget to use the other part of the bracket on the file name.

example

set Qvd_path = '[..\QVD\'; (in the main folder)

then on the store line: STORE qvdtester INTO $(Qvd_path2)tester_201701.qvd] (qvd);

you miss that end bracket it might give you the "Failed to open file in write mode for file"

Re: "Failed to open file in write mode for file" on Reload

olegsluksha — Thu, 07 Feb 2019 14:07:01 GMT

use [ ]

Store newqvd into [$(vQVDDirectory)\newqvd.qvd];

Re: "Failed to open file in write mode for file" on Reload

osvaldoRam — Tue, 12 Mar 2019 18:29:54 GMT

Verify that the path where you saved the qvd file is correct.