StoredProc Activity Returns Error 2011

[digitalbrain]

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?

[digitalbrain]

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.

[Anonymous]

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:

Known issue - Concurrent stored procedures block each other in data warehouse - Microsoft Fabric | M...

Regards,

Xiaoxin Sheng

[digitalbrain]

@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. 

[Anonymous]

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 Learn

Regards,

Xiaoxin Sheng

[Anonymous]

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