azure sql database – ADFv2 Lookup Activity timeout after 2 hours even after increasing query timeout value

admin

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?

Read more here: Source link