ADFv2 Lookup Activity timeout after 2 hours even after increasing query timeout value

Question

I have a lookup activity that timeouts after the 2 hours (120 mins) which is the default (could be just a coincidence) even after increasing the query timeout to 720 mins. The lookup activity executes a Proc based on an expression.

This is the error

Failure happened on 'Source' side. ErrorCode=UserErrorSourceQueryTimeout,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Query source database timeout after '7200' seconds.,Source=Microsoft.DataTransfer.DataContracts,''Type=System.TimeoutException,Message=,Source=Microsoft.DataTransfer.DataContracts,'

Is there a step that I've missed out somewhere?

Answer 1

There are actually two timeouts in Lookup activity, one is Lookup activity timeout and other is queryTimeout. Please make sure that to set the queryTimeout value lower than the lookup activity timeout value. queryTimeout won't be effective if it is greater than lookup activity timeout (24hrs).

Note: When you use query or stored procedure to lookup data, make sure to return one and exact one result set. Otherwise, Lookup activity fails.

Refer: Lookup activity in Azure Data Factory and Azure Synapse Analytics