Forum Discussion

cw88's avatar
cw88
Helper IV
2 years ago

Subscription error on paginated report

Hi,  i set up subscription on a paginated report. The report is based on a sematic model from a fabric warehouse. The subscription ran perfectly on a daily base for the last month.    Yesterday i ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, cw88 

This can happen if your SQL pool has been inactive for a while and needs time to warm up before it can process requests. You can try to warm up the SQL pool by running a simple query or a light task before triggering the subscription. This helps ensure that SQL pool is ready to handle subscription requests. You can refer to the following link:

Azure Synapse SQL pool is warming up error - Microsoft Q&A

 

SQL Pool Warming Up: What It Is and How to Fix It (hatchjs.com)

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

cw88's avatar
cw88
Helper IV
1 year ago

Hello Anonymous ,

thanks for your reply, but i don't think that this is a good workaroud, because user can create subscriptions themselves, so times for the subscriptions can change every day. It is not possible to check every day when subscriptions run and schedule tasks before that...