topic If load fails, retry just that part in App Development

If load fails, retry just that part

pedromsouza — Sat, 16 Nov 2024 20:15:15 GMT

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?)?

Re: If load fails, retry just that part

Anil_Babu_Samineni — Sat, 17 Aug 2019 13:24:07 GMT

Too much script needed to build up. But, to thought you can call "Audit logs" or script logs from failed point.

Re: If load fails, retry just that part

simonaubert — Mon, 30 Nov 2020 14:16:16 GMT

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