Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
The QVWs in our server are scheduled to run at specified intervals and more often than not they complete successfully. Randomly we do get a notification mentioning a reload has failed which is ignored. However, one QVW in particular had failed continuously over the weekend and we decided to get to the bottom of it. I enabled log file generation from the QVW to trace into the problem. The log file created in the instance of a failure states 'General Script Error'... this does not give out much information to work with. Does anyone know what could lead to 'General Script Error' randomly?
Try putting a Sleep(8000) after the Store command, to wait for 9 seconds.
I have found that sometimes even though the QlikView Store thinks it has finished, underneath in the os the data has not yet been fully flushed from cache to disc and causes this kind of symptom.
That can often be caused by contention / locks on qvd files.
Are there any qvd stores / loads shortly before the failure ?
Can you share the log file ?
Lock on QVD file is possible as this generates a QVD after execution which is then picked up roughly 2 minutes later.
I've attached the log file for your reference but due to company policies I have to take out the SQL script.
Try putting a Sleep(8000) after the Store command, to wait for 9 seconds.
I have found that sometimes even though the QlikView Store thinks it has finished, underneath in the os the data has not yet been fully flushed from cache to disc and causes this kind of symptom.
Thanks Bill,
I've set the sleep to 9 seconds as advised. Also thanks for the tip on the possible confusion between Qlikview and OS after the QVD is stored. I'll keep you updated.