Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Liam
Contributor II
Contributor II

why Qlik Replicate task start run very slowly

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.

Labels (1)
1 Solution

Accepted Solutions
john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

8 Replies
john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
praveenad123
Employee
Employee

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
Contributor II
Contributor II
Author

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

Liam
Contributor II
Contributor II
Author

1, November 2023

2, source: AS400 DB2 target: Azure SQL Server

3, not first time

4, nothing

SushilKumar
Support
Support

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
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
SachinB
Support
Support

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
Support
Support

Hi @Liam ,

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

Regards,
Desmond

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!