topic Re: Scheduled refresh stuck or delay in Report Server

Scheduled refresh stuck or delay

Dearc — Thu, 07 Jul 2022 03:23:01 GMT

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

Re: Scheduled refresh stuck or delay

v-henryk-mstf — Mon, 11 Jul 2022 09:27:01 GMT

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.

Re: Scheduled refresh stuck or delay

Dearc — Wed, 13 Jul 2022 06:03:50 GMT

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.

Re: Scheduled refresh stuck or delay

Dearc — Tue, 19 Jul 2022 03:23:36 GMT

Stacked in "Started Data Refresh"

In database shows "rsInternalError"

There're more than 18000+ records in [PowerBiReportServer].[dbo].[Event]

Re: Scheduled refresh stuck or delay

Dearc — Tue, 19 Jul 2022 07:26:44 GMT

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.

Re: Scheduled refresh stuck or delay

M_nwadibia — Mon, 12 Jun 2023 14:57:33 GMT

Hello Dearc,

I am facing similar challenge. Can you provide me the steps you followed to achieve this?

Re: Scheduled refresh stuck or delay

Dearc — Tue, 20 Jun 2023 00:57:18 GMT

Hi,
May be you can try

1. 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 empty

4. Check view [dbo].[ExecutionLog3] to see what happen while refresh for each report

Hope it works

Re: Scheduled refresh stuck or delay

M_nwadibia — Thu, 22 Jun 2023 15:39:02 GMT

Hello Dearc,

How do I locate files in step 3 and 4 ?

Re: Scheduled refresh stuck or delay

Dearc — Wed, 28 Jun 2023 07:53:57 GMT

May be you should contact the IT guy to help you find where the PowerBI RS database located.

Once you have the rights to access the database, your can find the tables via tools e.g. SQL Server Management Studio.

Re: Scheduled refresh stuck or delay

M_nwadibia — Tue, 18 Jul 2023 13:03:08 GMT

Thank You,

I resolved this problem for some of the reports by simply deleting the reports and uploading them again