Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm working on a script that load data from a sql server database through a vpn connection (slow). Many times the connection fails after one or two table loads. Is it possible to script in a way that if one table load fails it will retry to load automatically from that point (and I wouldn't have to reload the whole thing?)?
Too much script needed to build up. But, to thought you can call "Audit logs" or script logs from failed point.
Hello,
I wrote such a script but that works within our framework. There is a max retry parameter (so that no infinite loop) in a config file and a log is generated in qvd every time it fails. Not too hard to build if you play wih the errormode.
Note that you can also vote for this idea :
https://community.qlik.com/t5/Ideas/Retry-at-query-and-connection-not-only-at-task/idi-p/1765080
Best regards,
Simon