Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
First try to pull the data from DB then store as QVD.
Your first QVD is opened by some other process and hence your getting this error , check the process once
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.
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
I was missing (;) at end of STORE INTO statement.
Once added at end this allowed access to the file folder.
So double check syntax.