topic failed to apply bulk into audit table? in Qlik Replicate

failed to apply bulk into audit table?

MoeE — Thu, 19 Sep 2024 06:46:48 GMT

Hi support,

I hope you are doing good. I wanted to post here just in case someone knew anything about this issue. It looks like Replicate is failing to apply changes to the audit table. This happened 3 days ago and since, the table almost appears as if it is in one-by-one mode, and the latency is almost 3 days. weird. Has anyone seen this before?

Regards,

Mohammed

Re: failed to apply bulk into audit table?

john_wang — Thu, 19 Sep 2024 06:53:58 GMT

Hello Mohammed, @MoeE

Thanks for reaching out to Qlik Community!

It seems the query timed out after 2 minutes, would you please add the internal parameter executeTimeout to the target endpoint and set the value to a reasonable value eg 300 (seconds) to see if the problem is solved.

Thanks,

John.

Re: failed to apply bulk into audit table?

MoeE — Thu, 19 Sep 2024 06:58:08 GMT

Hi John,

We increased the timeout settings, and slowly the tables are starting to be picked up again. I will keep monitoring.

generally, is there a particular cause to these timeouts? etc target endpoint is overloaded/network speeds/replicate not sending the changes? Also how exactly does the query timeout occur, as in what exactly is timing out? The apply operation on the target side?

Thanks,

Mohammed

Re: failed to apply bulk into audit table?

john_wang — Thu, 19 Sep 2024 09:22:41 GMT

Hello Mohammed, @MoeE

You are correct—there are several factors that can cause an update query to time out, as you've mentioned. Generally, Qlik Replicate sends the query to the target database (e.g., INSERT INTO ... SELECT FROM, MERGE, etc.). If the query doesn't complete within a specified time, Qlik Replicate considers it a timeout. This time limit can be adjusted through an internal parameter.

Hope this helps.

John.