Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

QVD load fail

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

6 Replies
Anonymous
Not applicable
Author

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
avinashelite

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

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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.

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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

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

So double check syntax.