Forum Discussion
Scheduled refresh stuck or delay
Hello PBRS team,
I'm using the version 1.14.8179.37378 (2022, May). Two server grouped as scale-out.
Recently I found that scheduled refresh delayed and stuck when mannlly triggeredand then successfully refresed after few hours later.
What I'm trying
- Edit the rsconfig file to set one server with larger RAM to provide refresh service -- not work
- Stopped some big dataset refresh job -- not work
- Found error in logs -- nothing specical
- Restart server and SQL agent service -- not work
- Delete rows of "Events" table in powerbi database -- not work, and the rows grows every day, currently more than 600+
- Upgrade version from 2021. Sep -- not work
Help please
I think I found the root cause.
Some reports set refresh plan each mintune that makes so many tasks are queued and make [dbo].[Event] full.
Once I rescheduled these planns and delete all from the [dbo].[Event] table, schduled refresh plan work again and on time finished.
9 Replies
Hi Dearc ,
Are you viewing a refresh-related log file that doesn't show specific refresh information?
Also, you can read below troubeshooting for more details.
Troubleshoot scheduled refresh in Power BI Report Server - Power BI | Microsoft Docs
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Yes I checked logs. Nothing specical found only the strange refresh timing
I set 3 scheduled refresh plan, 2 of them refresh daily in 7am and 8:20am. And the other refresh each hour.
Logs show as below, none of them exectued in right timing.
There're 6900+ records in [PowerBiReportServer].[dbo].[Event] table and still growing. I' m not sure if this related with the problem.
Stacked in "Started Data Refresh"
In database shows "rsInternalError"
There're more than 18000+ records in [PowerBiReportServer].[dbo].[Event]
I think I found the root cause.
Some reports set refresh plan each mintune that makes so many tasks are queued and make [dbo].[Event] full.
Once I rescheduled these planns and delete all from the [dbo].[Event] table, schduled refresh plan work again and on time finished.
Hello Dearc,
I am facing similar challenge. Can you provide me the steps you followed to achieve this?
Hi,
May be you can try1. Check the scheduled refresh plan for each report, make sure there're no plan set too frequently
2. Check is there any reports take too long for refresh especailly for some import huge data lines from SQL server or other data source
3. Check table [dbo].[Event], normally it is empty4. Check view [dbo].[ExecutionLog3] to see what happen while refresh for each report
Hope it works
