Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
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.
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.
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
Hi Charlie,
I have same problem which you have when I try generate QVD files.
You solve your problem? How?
Thanks.
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.
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.
This can happen if you have several unrelated batch streams running concurrently. Are there any other non-dependent jobs running at the same time?
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
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.