Qlik Community

QlikView Documents

Documents for QlikView related information.

Avoid General Script Error in STORE command

hugmarcel
Contributor III

Avoid General Script Error in STORE command

The STORE command throws a General Script Error when the file to be stored is accessed by another process simultaneously.
E.g., when a LOAD command for the same file is being executed at the same time.

I am using Sysinternals handle.exe to avoid the error. Process is:

1.) Create a logfile of all open file handles using Sysinternals handle.exe
2.) Read the logfile before storing a QVD file.
    -> If the logfile contains the QVD file to be stored, pause and retry later in a loop.

It's done using subroutines in 1 qvw loadfile, which executes the handle-batchfile as well.

See ZIPFILE ATTACHED, and

Ressources:
https://community.qlik.com/message/555207#555207
https://community.qlik.com/ideas/3443
https://technet.microsoft.com/en-gb/sysinternals/bb896655.aspx

Hope this might be helpful to you!

Regards - Marcel

Attachments
Comments

Pretty nifty. This may save the day for a lot of QlikView users, as the General Script Error message is one of the most obscure failure messages in the entire QlikView kingdom.

Peter

hugmarcel
Contributor III

Thank you Peter!

I like the word "nifty" . In german it means "elegant" or "schick".

The fact that makes this process nifty is that it is short and concise.

Marcel

miha_pucelj
New Contributor II

Thank you for sharing.

I am wondering if this I'should also work with Publisher? I'm trying to set up but unsuccessfully.

There are processes Handle.exe handle64.exe that apperar and hung. Publisher task waits until processes are killed.

Has anyone managed to set up this working?

hugmarcel
Contributor III

Hi Miha

You should call handle.exe and handle64.exe on the CMD command line MANUALLY under every Windows account you are using. You will then experience a LICENCE WINDOW popping up requesting for your Agreement. The licence window cannot be answered when executed via Publisher.

Of course, we are using the Utility mainly via Publisher (what Windows account are you running the Distribution Service with)?

Regards - Marcel

miha_pucelj
New Contributor II

Hi Marcel, than you for that info. I'll try this. Windows account is Local Administrator (It does have profile).

jkampmeijer
New Contributor II

Thanks. We have occasionaly an general script error during a store command.

See if your sollution can avoid this.

Not applicable

Hi hugmarcel,

I have installed handle software and I could see the qvds that were open/running in command prompt. However I couldn't follow your document on how to get all the handles that were open into a log file. Any help here would be really great

Thanks,

Shiva.

ahaahaaha
Honored Contributor

Hi Marcel,

Thanks for the useful information.

Regards,

Andrey

Version history
Revision #:
1 of 1
Last update:
‎08-17-2015 08:16 AM
Updated by: