topic Re: Logfile says 'General Script Error' in QlikView

Logfile says 'General Script Error'

Wed, 09 Dec 2015 09:41:43 GMT

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?

Re: Logfile says 'General Script Error'

Anonymous — Wed, 09 Dec 2015 09:44:46 GMT

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 ?

Re: Logfile says 'General Script Error'

Wed, 09 Dec 2015 09:54:45 GMT

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.

Re: Logfile says 'General Script Error'

Anonymous — Wed, 09 Dec 2015 10:37:20 GMT

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.

Re: Logfile says 'General Script Error'

Wed, 09 Dec 2015 11:56:52 GMT

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.