Forum Discussion
StoredProc Activity Returns Error 2011
A fabric data warehouse SP has returned 2011 error code via StoredProc acitivity. I know it is related to the connection that has been closed due to "Shutdown in progress", but why did this shutdown happen? Shouldn't it be avaiale all the time?
5 Replies
Hi digitalbrain,
Can you please share some more detail information about your opration and the issue? They should help us clarify your scenario and test to troubleshoot.
Regards,
Xiaoxin Sheng
Hi Anonymous, the StoredProc activity was used in the data pipline to execute a data warehouse SP which takes a few parameters and update a reocrd in the table. The pipeline runs every hour. I found only single instance of this kind of failure in monitor, so it seems like a rare case, however, I'm interested to know the cause of shutdown.
HI digitalbrain,
Currently there is a known issue about data warehouse with SP, you can take a look at the following link if it meets to your scenario:
Regards,
Xiaoxin Sheng
Anonymous Thank you for sharing the link. It talks about the slow performance when same stored procedure is executed in parellel as each stored procedure takes an exclusive lock during plan generation. However, my question is related to Shutdown error.
