Forum Discussion
StoredProc Activity Returns Error 2011
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.
HI digitalbrain,
What data amount the source table stroud and will be processed by Stored Proc ? AFAIK, if the shutdown status can be triggered if your operation exceeed to the endpoint/api limitations.
Limitations - Microsoft Fabric | Microsoft Learn
Data Factory limitations overview - Microsoft Fabric | Microsoft Learn
Also did this table attached into the semantic model? If that is the case, it can also be effect by the model/memory size and limit:
What is Power BI Premium? - Power BI | Microsoft LearnRegards,
Xiaoxin Sheng