topic Re: Latency on Target Aurora Postgres in Qlik Replicate

Latency on Target Aurora Postgres

FrancoHR — Tue, 26 Sep 2023 02:07:33 GMT

A task was fully loaded with a table but the changes are not being replicated for 2-3 days, they remained on disk. I stop the task and execute it with the advanced options option since the day no changes arrive, it applies some changes but then stops.
What could be happening?
I set performance at the trace level and there is latency with the origin, which is a logstream task of 8 sec, and the target and handling latency is the current latency, which is 3 days.

00012056: 2023-09-25T21:06:09:625970 [PERFORMANCE ]T: Source latency 13.03 seconds, Target latency 250830.63 seconds, Handling latency 250817.60 seconds (replicationtask.c:3700)

Regards,

Re: Latency on Target Aurora Postgres

SushilKumar — Tue, 26 Sep 2023 04:52:00 GMT

Hello Team,

Thanks for reaching out to Qlik via Qlik Community Support page. As per your issue it mentioned as (Target latency 250830.63 seconds, Handling latency 250817.60 seconds )

We consider it as Target latency . Seems you need to check on the target side why changes are not being applied. To get assistance on it you have to engage TSE via Support case.

Please stop the task enable logging below"

PERFORMANCE -> TRACE

TARGET_APPLY -> VERBOSE

Please resume the task. Let the task run for 10-20 minutes, download and zip log and upload for review

Reagrds,

Sushil Kumar

Re: Latency on Target Aurora Postgres

sureshkumar — Tue, 26 Sep 2023 04:54:10 GMT

Hello @FrancoHR
Thanks for posting in the Qlik Community Forum.

Kindly set TARGET_APPLY = TRACE, let the task run for 15-20 minutes and check the logs for any errors, bulk failed, whether task applying one-to-one. If there is no useful information in the enhanced logs means, please raise a support ticket with us to analyze further.

Regards,

Suresh

Re: Latency on Target Aurora Postgres

Dana_Baldwin — Tue, 26 Sep 2023 14:12:27 GMT

Hi @FrancoHR

If one of the replies helped to resolve the issue, please mark it as a solution & like it to make it easier for others to find.
Thanks in advance!

Re: Latency on Target Aurora Postgres

FrancoHR — Tue, 26 Sep 2023 15:42:47 GMT

@SushilKumar

Ok, I'll do that.

The task is in transactional mode because it contains a table without PK, is it correct to replicate or should I try batch mode?