Failed to open file in write mode for file

[Anonymous]

Hey Community,

i load data from OLE DB Sql Server when i use the function "Store table into ...." at the first load every thing work perfect no error.

but when i run again i always get this msg Failed to open file in write mode for file

any idea ?

[swuehl]

This error message seems to be quite new, which QV version are you using?

In older versions, we just got a general script error when QV was not able to write to the QVD.

Could you check if there is a lock on the QVD?

How to Find Out Which Windows Process is Using a File | Gizmo's Freeware

Or maybe you already know if any other QVW tries to read from the QVD while you are running your script?

Is the user running your script able to delete the QVD manually?

[Anonymous]

Im using Qv 12 R1 64 bit version.

I have permission to delete the file the user is Admin.

[Colin-Albert]

This looks like the QVD is locked.

Can you rename the QVD file to test this?

Are any other Qlik apps accessing the QVD file at the time you are trying to update the file with your store command?

[Anonymous]

When i Rename the file its seems to be ok as i say at the first run it is also work good, But why he locked only this file ?

How can i unlock the file by properties.

David

[Colin-Albert]

Does the error occur when running the task on a schedule?

The QVD is in a user folder, does the QlikView distribution service account have change permissions to that folder?

It would be better to create set of folders for your QVD files that are not in your user folders.

[Anonymous]

Does the error occur when running the task on a schedule? >>>> No its work every time i run reload the data.

The QVD is in a user folder, does the QlikView distribution service account have change permissions to that folder? >> Yes My account have all the permissions to do changes.

Something i dont understand is why qv is lock only this file what is the different between this file and the other file ?

Thanks David

[Colin-Albert]

Are there any other qv.exe or qvb.exe processes running that could also be loading from that QVD?

[swuehl]

Are you doing kind of incremental load and load from the QVD directly before trying to store to the same?

Then try adding a

Sleep 5000;

script statement between the LOAD and the STORE.

[Anonymous]

No this is the only QV.EXE that runing at this time on my machine, P.s i use only Desktop Version not Publisher\Server.