CODEWITHSUNDEEP
azure-sql-databaselookupazure-data-factoryquery-timeout
Geezer
Geezer

Reputation: 497

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

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.

enter image description here

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,'

enter image description here

enter image description here

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

Upvotes: 3

Views: 3831

Answers (1)

Utkarsh Pal
Utkarsh Pal

Reputation: 4544

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

Upvotes: 1

Related Questions