Forum Discussion
Scheduled refresh fails; error "Microsoft SQL: An error occurred while receiving the HTTP response"
Hi kstiegler ,
May I know if you refresh your report by on-demand refresh, will you get same issue? As the description, the scheduled refresh time of these reports have overlapped issue. Could you please try to enlarge the time span between them to avoid the overlap? After that, observe the refresh of them to see whether you will get such issue? Thanks in advance!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!
Best Regards,
Community Support Team _ Caiyun
I can conduct on-demand refreshes of all 13 datasets without the HTTP response issue showing up.
I've reconfigured our refresh schedule so that no more than 2 datasets start refreshes on the same half hour. I'll watch for any future errors and report back.
Hi kstiegler ,
May I know did you get the same problem recently after you rearrange of scheduled refresh time? Is this issue still happening?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!
Best Regards,
Community Support Team _ Caiyun
Yes, after I rearranged the refresh schedule, the issue has not recurred. For my purposes, I documented the refresh schedule in Excel so I could see clearly that not more than 2 reports were refreshing at any one time:
Hi kstiegler ,
Thanks for your confirmation! That’s a fabulous idea!
Best Regards,
Community Support Team _ Caiyun