Forum Discussion

Dearc's avatar
Dearc
Helper 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
Helper II
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.

  • M_nwadibia's avatar
    M_nwadibia
    Resolver III
    3 years ago

    Hello Dearc,

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

    • Dearc's avatar
      Dearc
      Helper II
      3 years ago

      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

      • M_nwadibia's avatar
        M_nwadibia
        Resolver III
        3 years ago

        Hello Dearc,

        How do I locate files in step 3 and 4 ?