topic Re: QVD load fail in QlikView

QVD load fail

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

While loading data from database and storing in QVDs, frequently we are getting error as "Error: Failed to open file in write mode ".

This error occurs for 1 QVD only while running STORE command, others are loaded successfully, and we were loading this qvd 1st and then others.

Please help to resolve this issue

Thanks

Re: QVD load fail

Anonymous — Mon, 22 May 2017 08:35:07 GMT

Have a look:

Failed to open file in write mode for file D:\NQVD\sales.qvd

Hope it helps!!

Re: QVD load fail

Anil_Babu_Samineni — Mon, 22 May 2017 08:37:34 GMT

First try to pull the data from DB then store as QVD.

Re: QVD load fail

avinashelite — Mon, 22 May 2017 09:59:51 GMT

Your first QVD is opened by some other process and hence your getting this error , check the process once

Re: QVD load fail

Peter_Cammaert — Mon, 22 May 2017 10:07:21 GMT

On average, multiple reload jobs can read a single QVD all at the same time without any problems. But a QVD cannot be rewritten when someone else is still reading data from it. Check which tasks are accessing this QVD simultaneously, and reorganise your task chains so that every Readers waits for the Writer to finish.

It could also be an anti-virus scanner, or some other process that isn't directly connected to QlikView acitivities.

Re: QVD load fail

Anonymous — Tue, 23 May 2017 09:23:41 GMT

Hi,

I was getting the same error. To fix this, the user running the script should have permission to access that folder where the QVD's are stored. Go to the folder, right-click and open properties. Go to security and add the user to the users list and give that user permissions to that folder

Re: QVD load fail

Anonymous — Wed, 31 Jan 2018 13:49:07 GMT

I was missing (;) at end of STORE INTO statement.

Once added at end this allowed access to the file folder.

So double check syntax.