topic Re: Failed to open file in write mode in App Development

Failed to open file in write mode

oscmandino — Mon, 09 Jul 2018 17:52:56 GMT

Hi Community. I am having the next problem:

I have a load for about 350.000.000 records generating a 13 GB QVD file.

I'm storing the information as follows:

STORE * FROM Fact into [lib://QVD/Fact.qvd](QVD)

On that code I am getting random results (some times success, some times fails). Every time it fails, I've got the next error message:

Failed to open file in write mode for file F:\QVD\Fact.qvd

Error: Failed to open file in write mode for file F:\QVD\Fact.qvd

Any help will be appreciated!

Thank you in advance

Re: Failed to open file in write mode

rubenmarin — Mon, 09 Jul 2018 17:56:55 GMT

Hi Oscar, seems that one process still has the qvd opened, try checking for process that can be reading from that qvd, or scheduled reloads.

Another option is that the permissions of the file doesn't allows the current user to write the file, but in that case it won't be random.

Re: Failed to open file in write mode

oscmandino — Mon, 09 Jul 2018 18:05:38 GMT

Hi Ruben, Thank you for your answer.

There is no other process using that file.

My Fact.qvd file is used only in one application that reads it, appends some information and then tries to store the information.

That QVD file will be useful only for the next step in the task (it will not run in parallel)

Re: Failed to open file in write mode

MK9885 — Mon, 09 Jul 2018 18:07:25 GMT

Store script seem to be incorrect...

Use below Store procedure

STORE Fact into lib://QVD\Fact.qvd;

Re: Failed to open file in write mode

MK9885 — Mon, 09 Jul 2018 18:10:42 GMT

To load this table after storing use

Fact:

Load *

From.....your stored location

Re: Failed to open file in write mode

oscmandino — Mon, 09 Jul 2018 18:15:40 GMT

Hi Shahbaz, I missed the ";" at the end on copy-paste but my code works.

Re: Failed to open file in write mode

MK9885 — Mon, 09 Jul 2018 18:20:45 GMT

Do you have issue with Storing or Reading?

Re: Failed to open file in write mode

oscmandino — Mon, 09 Jul 2018 18:23:40 GMT

The problem occurs some times when storing.

Re: Failed to open file in write mode

MK9885 — Mon, 09 Jul 2018 18:25:50 GMT

I have never seen someone using that type of Store script...

Why not try the one I provided and monitor if you have same issues?

Re: Failed to open file in write mode

oscmandino — Mon, 09 Jul 2018 18:35:34 GMT

You're right, there is an extra "*" in my code just a copy paste problem.

My store sentence works

Re: Failed to open file in write mode

MK9885 — Mon, 09 Jul 2018 18:46:59 GMT

It doesn't really works when it is failing sometimes.

I hope someone else can help you with your Store but problem is it is working for you...

Re: Failed to open file in write mode

Xabinav — Sat, 28 Dec 2019 16:10:44 GMT

Hi, could you please give an example or explanation of the solution?
I have exactly the same problem, the same error. Sometimes the code works and sometimes doesn't.
Thanks