I have a stored procedure activity in my Azure Data Factory pipeline.
The pipeline frequently fails due to the stored procedure activity timing out after duration ~ 01:30:00. However, the pipeline failure very often resolves itself quickly by re-running itself. I would like to find out the cause for the failed pipeline.
The error details are:
Error details
Error code ActionTimedOut
Failure type User configuration issue
Details Activity timed out
Source Pipeline pipeline name
The error details don't tell me very much about what could be the root cause for the error.
Does anybody have a suggestion where I could start debugging the problem and what are common causes for stored procedure timeouts in Azure Data Factory pipelines? Or where I could find more information about the error message?