why Qlik Replicate task start run very slowly

[Liam]

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.

[john_wang]

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.

[praveenad123]

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

[Liam]

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

[Liam]

1, November 2023

2, source: AS400 DB2 target: Azure SQL Server

3, not first time

4, nothing

[SushilKumar]

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/...

Regards,

Sushil Kumar

[john_wang · Accepted solution]

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.

[SachinB]

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

[DesmondWOO]

Hi @Liam ,

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

Regards,
Desmond