Jan. 2022 Report Server new refresh failure behavior

[motoray]

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?

[Anonymous]

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]

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

[Anonymous]

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]

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

[motoray]

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