This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 8%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
I have a stored procedure activity in a pipeline that is triggered daily. This activity seems to be executing once, but for some reason the procedure itself executes multiple times and causing a deadlock.
The retry value is set to 0, so I am not sure what would be causing this behavior.
{
"name": "Erroring stored procedure",
"description": "Call a Stored Procedure",
"type": "SqlServerStoredProcedure",
"dependsOn": [
{
"activity": "ForEachProductionTable",
"dependencyConditions": [
"Succeeded"
]
}
],
"policy": {
"timeout": "7.00:00:00",
"retry": 0,
"retryIntervalInSeconds": 30,
"secureOutput": false,
"secureInput": false
},
"userProperties": [],
"typeProperties": {
"storedProcedureName": "[dbo].[MyStoredProcedure]"
},
"linkedServiceName": {
"referenceName": "<redacted>",
"type": "LinkedServiceReference"
}
}
Hi @Matthew Pruett ,
Welcome to Microsoft Q&A Platform. Thank you for posting your query here.
Could you please check below once. And share updates to understand issue better. Thank you.
That's the odd thing. The stored procedure activity is not part of a foreach activity.
Hi @Matthew Pruett ,
It would be great if you can share your entire pipeline json along with pipeline snippets to understand better and help on resolution. Thank you.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 57.00000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
I am facing the same issue, having one execute pipeline activity and inside that I have multiple stored procedures in series. these are getting executed multiple times
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 74%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
I have the same issue: stored procedure execution in ADF, retry set to 0 and it is executed twice (i.e. a second time when the first execution is still running, leading of course to errors). The monitoring screen in ADF is more or less providing me evidence of this double execution as you can see in the screenshot where the execution duration was about 39 minutes, whereas the details in the task rather show about 27 minutes (which is according to our logging to time the second execution started):
What ended up working for me was splitting the primary stored procedure up into multiple procedures. I don't think ADF handles very well the case of a single monolithic procedure that calls many other procedures.
Hi @Matthew Pruett ,
Could you please accept below as answer? Accepting answer will help community too. Thank you.
Could you please share your entire pipeline json to try at our end too. Also, you mean your stored procedure internally calling many other store procedures too? Kindly confirm.
Hi @Matthew Pruett ,
Could you please accept below as answer? Accepting answer will help community too. Thank you.