Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
cjzimm76
Partner - Creator
Partner - Creator

General Script Error issue

I have a .qvw file and its only purpose is the generate multiple .qvd files.  The task will run on the server successfully for weeks at a time, and then unexpectedly, I get the "General Script Error  Execution Failed". message in the middle of the task.  All of the .qvds are creating from the same data source and stored in the same folder.  After some time passes, I can run the task again without making any changes to the .qvw script and it will run successfully.  There is plenty of disk space available.  Folder permissions should not be an issue as the task will create the first couple .qvds but then the error comes in the middle of the script.  Any ideas on how to solve or trouble shoot this would be appreciated.

23 Replies
Not applicable

Then it could be a ram issue;

Try to do a partial reload and check if it executes fine with out any error

hope it helps!

VishalWaghole
Specialist II
Specialist II

Hi Charlie,

If this error is coming with server auto reload, then please try it by manual reload.

I don't know you purpose to create multiple Qvd's using single Qvw.

If possible then please try to use single Qvw for single Qvd,

by doing this you will diagnose where the actual problem was occurred.

Hope you understand...

--Thanks and Regards,

Vishal Waghole.

cjzimm76
Partner - Creator
Partner - Creator
Author

Its a different .qvd each time.  The code never changes.  Most of the times it runs as it should.  Just once or twice a month It will stop at one of the Store statements.

swuehl
MVP
MVP

Hi Charlie,

I think I am not the only one who assumes that some process is occasionally blocking the write access to your QVDs.

I would start looking at the usual suspects, anti-virus, backup tools etc.

Brainstroming 5 minutes with your system admin (or reading the server docs...) may reveal some processes that may lock your files.

Or have a look at Microsoft's Process Monitor

http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx

And here is a short introduction how you can make use of it:

http://answers.perforce.com/articles/KB_Article/Using-Process-Monitor-to-Monitor-File-Access

Not applicable

Hi Charlie,

I have same problem which you have when I try generate QVD files.

You solve your problem? How?

Thanks.

jeremy_fourman
Creator
Creator

A big contributor to this is when a QVD is being created and another QVW is trying to read it or vice-versa, as others have mentioned it is a read/write lock on a file. This can usually be sorted out by dependency chaining tasks properly within the QMC.

Anonymous
Not applicable

I have come across this before.

I sorted it by putting a sleep(5000) after every STORE command to make it pause for 5 seconds to give some time for everything to be fully flushed to disc before continuing.

roger_stone
Creator III
Creator III

This can happen if you have several unrelated batch streams running concurrently. Are there any other non-dependent jobs running at the same time?

mvivanco
Contributor III
Contributor III

I had a similar case. My source file was unique, but the data were updated periodically. The problem presented when reading and writing the file coincided. I solved creating "Active source file" and "Inactive source File" that were switched periodically. All updates of the data I did in the "Inactive source File", and my .qwv read the "Active source file".

I hope to expand the idea of the solution

jeremy_fourman
Creator
Creator

Good call on this too, I have done the same. We have used Supporting Tasks in the QMC, the task just reloads a QVW that has nothing in it more than a sleep(x) call. All tasks (within reason) that create a QVD would have chained to them this supporting task. Allows us to tune the sleep time if needed from a single place.