azure sql database – 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.
This is the error
Failure happened on ‘Source’ side.
source database timeout after ‘7200’
Is there a step that I’ve missed out somewhere?
Read more here: Source link