topic Re: Failure when trying to save qvd in QlikView

Failure when trying to save qvd

elie_issa — Wed, 04 May 2016 13:19:30 GMT

Dear All,

I have a script working without any error for more than 2 weeks.

Today the script failed. Below is the log :

store FBInventory into qvds\FBInventory_BH.qvd(qvd)

04/05/2016 4:19:44 PM: General Script Error

04/05/2016 4:19:44 PM: Execution Failed

The weird issue is that if I change the name of the qvd for example store FBInventory into qvds\FBInventory_BAH.qvd(qvd).

the script will succeed.

N.B : I am doing an incremental load and the qvd FBInventory_BH is already found and i am restoring the data again in the same file.

Thanks for your help.

Re: Failure when trying to save qvd

settu_periasamy — Wed, 04 May 2016 18:27:10 GMT

Hi,

Have you tried the below discussions suggested?

General Script error - storing QVD file

Avoid General Script Error in STORE command

General Script Error during STORE, but no locks on the QVD file‌

Re: Failure when trying to save qvd

alexdataiq — Wed, 04 May 2016 18:29:27 GMT

That sound like the file is getting locked by another process. Are you reading the same QVD in another application? Maybe they're running to close and they overlap locking the access to the file.

Re: Failure when trying to save qvd

Peter_Cammaert — Wed, 04 May 2016 18:54:50 GMT

Sometimes the STORE may fail because the file "appears" to be locked by another process, but no other process is actually using or accessing the file.

Simply deleting the file and restarting the task which will perform a full load will solve the issue. A platform reboot may also remove any leftover NTFS locks.

Peter

Re: Failure when trying to save qvd

trdandamudi — Wed, 04 May 2016 19:04:01 GMT

Looks like the file (QVD) got locked...

Re: Failure when trying to save qvd

elie_issa — Thu, 05 May 2016 06:50:20 GMT

I am not able to delete the file.

I am getting the below pop up :

"The action can't be completed because the file is open in Qlikview 11.20 SR5"

Any idea how to remove the lock without restarting the server ?

Thanks.

Re: Failure when trying to save qvd

elie_issa — Thu, 05 May 2016 09:38:48 GMT

Thanks guys.

The problem was solved . I killed all the running qv.exe in task manager.

Re: Failure when trying to save qvd

Peter_Cammaert — Thu, 05 May 2016 14:35:40 GMT

So there were QV Desktop processes still running in the background (i.e. not present on the Desktop) or going haywire and keeping your QVDs locked?

Re: Failure when trying to save qvd

elie_issa — Thu, 05 May 2016 17:03:25 GMT

yes it seems that there were QV Desktop processes still running in the background.