topic Re: why Qlik Replicate task start run very slowly in Qlik Replicate

why Qlik Replicate task start run very slowly

Liam — Fri, 24 May 2024 06:40:02 GMT

why Qlik Replicate task start run very slowly?

The task just have one table and this table just have 44 record data,

why every time start reload or resume to normal running very slowly?

it will take to 10-30 minutes run normal or run failed.

Re: why Qlik Replicate task start run very slowly

john_wang — Fri, 24 May 2024 07:42:24 GMT

Hello @Liam ,

Thanks for reaching out to Qlik Community!

Please set SOURCE_UNLOAD/SOURCE_CAPTURE to Verbose and recreate the behavior then check the task log file to see which step or what SQL took long time.

Regards,

John.

Re: why Qlik Replicate task start run very slowly

praveenad123 — Fri, 24 May 2024 08:29:13 GMT

Hello @Liam ,

Thanks for posting in Qlik community ,

To understand the issue please answer the below queries,

1.What is the qlik replicate version you are in?

2.What is the source and target ?

3.Is the first time you are facing this issue?

4. what is the changes you have been made so far?

please keep us update.

Regards

Praveen Kumar

Re: why Qlik Replicate task start run very slowly

Liam — Fri, 24 May 2024 09:01:33 GMT

The task actually not running, just for starting, starting to normal running for this time take so long time

Re: why Qlik Replicate task start run very slowly

Liam — Fri, 24 May 2024 09:04:07 GMT

1, November 2023

2, source: AS400 DB2 target: Azure SQL Server

3, not first time

4, nothing

Re: why Qlik Replicate task start run very slowly

SushilKumar — Fri, 24 May 2024 09:21:28 GMT

Hello @Liam

We would suggest you to engage Support and upload the Diagnostics package post putting SOURCE_CAPTURE and SOURCE_UNLOAD to verbose .

Please refer to Replicate https://community.qlik.com/t5/Knowledge/How-to-collect-Diagnostics-Package-from-Qlik-Replicate/ta-p/1815056

Regards,

Sushil Kumar

Re: why Qlik Replicate task start run very slowly

john_wang — Sat, 25 May 2024 02:28:03 GMT

Hello @Liam ,

Thanks for the update however it's hard to tell without verbose task log file, one of the possibility is in this article: Qlik Replicate DB2 iSeries Source: Task takes a long time to start.

And also this one: Replicate task keeps waiting for first 20-25 mins.

Hope it helps.

John.

Re: why Qlik Replicate task start run very slowly

SachinB — Sat, 25 May 2024 03:27:17 GMT

Hello @Liam ,

We would like to check the task settings like how much "Transaction consistency timeout" is set and other details, As requested earlier by collogues, please set Source unload and Source capture in verbose and create a support ticket to investigate it further.

Regards,

Sachin B

Re: why Qlik Replicate task start run very slowly

DesmondWOO — Mon, 27 May 2024 14:33:46 GMT

Hi @Liam ,

As SachinB mentioned, "Transaction consistency timeout (seconds)" can be found in Tasks Settings --> Full Load --> Full Load Turning.

Regards,
Desmond