In our first video blog, we discuss how to gracefully pause and stop QlikView scripts, so that execution can be resumed later without existing script progress being lost!
I often found that when I would reload a QlikView application from my laptop, I would become tethered in place until the script finished. If I put my computer in Sleep mode, or disconnected it from the network (when the script required network access), the script would fail. Fortunately, I was able to win my freedom by implementing a simple trick, which I share in the following video:
Using this approach, you can safely put your computer into Sleep mode or disconnect from the network; when you wake it or reconnect to the network, the script can be un-paused and execution will resume normally! The supporting files used in the video are available for download here:
Please feel free to share in the comments section below your personal success stories using our approach! And, as always, happy Qliking!
Small correction: the “SLEEP 200” statement in the video actually will cause a pause of 1/5 of a second, rather than 2 seconds. “SLEEP 2000” will cause a pause of 2 seconds. My apologies for the confusion.
Cool idea. Will come in use.
Does it try after interval again and again till the execution completes?
Example: We are extracting data from SAP , but due to some reasons (unknown), frequently SAP connector in qlik doesn’t work and it never extracts data form SAP, but this we notice after 8-10 hours. if i use Sleep command at the beginning of the script, will this work? i mean, will this be continues trying until qlik connects to SAP ?
Sounds like what you want is a loop combined with ErrorMode = 0. Possibly a very long loop with ENDFOR. I have scripts where random unexplained failures happen, but will succeed on retry. So I use these types of loops to try several times and check for success every time (usually by querying the number of rows in a table). If it didn’t succeed, try again. If it did, break out of the loop. You can certainly combine this type of thing with a sleep delay.