Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
lisaott
Frequent Visitor

Cannot edit scheduled Refresh in Report Server

Hello,

 

I have a problem with a scheduled refresh. Everything works fine when I create one, but once i try to edit the refresh and save it, I get following error message:

 

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.

 

It seems the change has been saved, because the new time is showing, but the refresh is still starting at the old time.

 

 

1 ACCEPTED SOLUTION
hackcrr
Super User
Super User

Hi, @lisaott 

Ensure that the report server can successfully connect to its database. This is usually a SQL Server database that is used to store report definitions, data source connection information, scheduled tasks, and so on. Check the status of the database server to ensure that it is running and that there are no network issues preventing the Report Server from communicating with it.
As mentioned in the error message, insufficient disk space can also cause this problem. Check that the disk space where the database resides is sufficient. You can check disk usage through SQL Server Management Studio (SSMS) or other database management tools.
Check the log files of the Reporting Server, usually located in the C:\Program Files\Microsoft SQL Server\MSRSxx.MSSQLSERVER\Reporting Services\LogFiles directory.
Sometimes, if database operations take a long time to complete (although this is unlikely to be the direct cause of a scheduled refresh), the timeout setting may cause problems.
If the problem is limited to a specific report, check the definition of that report for any issues that might cause the save to fail. Try creating a new simple report and setting a scheduled refresh for it to see if the problem persists.

 

hackcrr

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

View solution in original post

1 REPLY 1
hackcrr
Super User
Super User

Hi, @lisaott 

Ensure that the report server can successfully connect to its database. This is usually a SQL Server database that is used to store report definitions, data source connection information, scheduled tasks, and so on. Check the status of the database server to ensure that it is running and that there are no network issues preventing the Report Server from communicating with it.
As mentioned in the error message, insufficient disk space can also cause this problem. Check that the disk space where the database resides is sufficient. You can check disk usage through SQL Server Management Studio (SSMS) or other database management tools.
Check the log files of the Reporting Server, usually located in the C:\Program Files\Microsoft SQL Server\MSRSxx.MSSQLSERVER\Reporting Services\LogFiles directory.
Sometimes, if database operations take a long time to complete (although this is unlikely to be the direct cause of a scheduled refresh), the timeout setting may cause problems.
If the problem is limited to a specific report, check the definition of that report for any issues that might cause the save to fail. Try creating a new simple report and setting a scheduled refresh for it to see if the problem persists.

 

hackcrr

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors