Forum Discussion

motoray's avatar
motoray
Advocate V
4 years ago

Jan. 2022 Report Server new refresh failure behavior

Since we upgraded to the Jan. 2022 version of the report server, I've noticed higher than usual number of data refresh errors. It's a new pattern--the error message is simply "Started Data Refresh" but it never gets any farther. When I go in and force the refresh it works fine. Has anyone else seen this?

Refresh
Server

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi motoray ,

     

    During the investigation we found that after a previous version update, users had the same experience as you.

    His solution was to check and clean up the Reportserver database event table.

     

    For more you can refer to：New scheduled refresh stuck at refreshing 

     

    Best Regards,
    Community Support Team _ Caitlyn

    • motoray's avatar
      motoray
      Advocate V
      4 years ago

      Thanks for that suggestion. I'm having our DBA take a look at the event table on the report server.

      • motoray's avatar
        motoray
        Advocate V
        4 years ago

        Didn't fix it. In fact there was nothing in the events table.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi motoray ,

     

    Please try connect to your server via SSMS - Server Type: Reporting Services, Server Name: http://YourReportServer/ReportServer > find  "ModelExpirationMinutes"settings in Server Properties, Advanced page.>set the ModelExpirationMinutes sufficiently long ( For example, 60 minutes, 360 minutes, etc.) 

     


    Hope it helps,

    Best Regards,
    Community Support Team _ Caitlyn

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

    • motoray's avatar
      motoray
      Advocate V
      4 years ago

      I've changed it from the default of 15 to 60 minutes and will monitor. Thanks for the tip.