Forum Discussion

Dearc's avatar
Dearc
Icon for Helper II rankHelper II
4 years ago
Solved

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 s...
Schedule refresh not working
  • Dearc's avatar
    Dearc
    4 years ago

    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.

Dearc's avatar
Dearc
Icon for Helper II rankHelper II
4 years ago

Stacked in "Started Data Refresh" 

 

 

In database shows "rsInternalError"

 

 

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