Forum Discussion

cw88's avatar
cw88
Icon for Helper IV rankHelper IV
2 years ago
Solved

Execute warehouse procedure from pipeline error: The SQL pool is warming up. Please try again.

Hello,    i run a pipeline that executes a stored procedure in my warehouse (same workspace) one time a day. Last week, i got the following error on two days:   Execution fail against sql server....
data warehouse
  • v-cboorla-msft's avatar
    v-cboorla-msft
    2 years ago

    Hi cw88 

     

    Thanks for using Microsoft Fabric Community.

    Apologies for the issue that you are facing here.

    The error you're encountering ("42109: The SQL pool is warming up") is likely a transient error, meaning it should resolve itself on the next retry attempt. Transitive errors are temporary issues caused by external factors outside your application or data pipeline. In your case, the warming-up SQL pool is a common example of a transient error. Retrying the operation after a short delay can indeed be a good strategy, as the pool should be ready by then.

    Please refer to the below mentioned document for more details.

    Document Link: MSSQLSERVER_42109

    If the issue still persists please do let us know. Glad to help.

     

    I hope this information helps. 

     

    Thanks.

cw88's avatar
cw88
Icon for Helper IV rankHelper IV
2 years ago

v-cboorla-msft : Thanks for your reply.

I will try to fix it with the retry option of the pipeline activity.