article Qlik Replicate: Query timeout expired in Official Support Articles

Qlik Replicate: Query timeout expired

Steve_Nguyen — Tue, 20 Jun 2023 09:10:36 GMT

A Qlik Replicate task fails with error

Query timeout expired

Resolution

The error occurs when Qlik Replicate is working on a query to the source or target and the query takes longer than anticipated, leading to the timeout.

Edit the source or target endpoint and within the Advanced properties and add a new Internal Parameter named cdcTimeout.

Stop the task.
Open source or target endpoint depending on the error from the query source or target and add the following Internal Parameter:

cdcTimeout (default 600); (some endpoints do not have this value)
executeTimeout (default 60)
loadTimeout (default 1200).

Try 10x the default value. Values are in seconds.

See Qlik Replicate: How to set Internal Parameters and what are they for? for more information.
Save the endpoint
Try to resume task and see if we still have a timeout issue.

Environment

Re: Query timeout expired

charlesrinaldini_colas — Wed, 22 Sep 2021 17:00:16 GMT

This does not appear to change anything on the Microsoft Azure Databricks Delta endpoint. On a full load, query execution times out after 60 seconds not matter what. This completely negates the use of this product if we cannot load our larger tables.

Re: Query timeout expired

Sonja_Bauernfeind — Fri, 01 Oct 2021 09:32:15 GMT

Hello @charlesrinaldini_colas

It sounds like you need assistance with this particular setup. Please contact support so that we can help you accordingly!

All the best,
Sonja

Re: Qlik Replicate: Query timeout expired

Mark_CR — Sun, 01 Jun 2025 15:24:14 GMT

Can this be set at the endpoint level and have it apply to all the tasks that use that endpoint?

Re: Qlik Replicate: Query timeout expired

Dana_Baldwin — Mon, 02 Jun 2025 15:55:59 GMT

Yes @Mark_CR, these internal parameters are set at the endpoint level and are used for every task that uses that endpoint. Tasks need to be stopped and resumed after setting these parameters before they become effective (endpoint parameters are read & processed upon task startup).

Thanks,

Dana