Forum Discussion
Solved
New scheduled refresh stuck at refreshing
I have PBI RS Jan 2020 and there are more than 15 scheduled refreshes already working, but none of the newly created schedules created now works.. It just sticks at refreshing and nothing happens. Th...
For some weird reason, all the events piled up in Reportserver database event table. The count was in million. I had to remove those events to allow new schedules to start.
You may check the event table item count in reportserver database . If you see too many records delete them . Simple database query I used
USE ReportServer
SELECT COUNT(*) FROM Event
DELETE FROM Event
Hope it helps.
jpnayak - Can you help what is the action that should be performed when u say remove the events. please provide the steps for this issue.
Thanks
You may check the event table item count in reportserver database . If you see too many records delete them . Simple database query I used
USE ReportServer
SELECT COUNT(*) FROM Event
DELETE FROM Event
Hope it helps.