Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
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.
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.
@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.
Hi @jpnayak ,
Can you explain the step to solve this issue? im facing the same issue and dont know what to do.
Thank you.
Hi
I am facing similar issue since morning. All scheduled reports are stucke at status "Refreshing". Any help would be appreciated.
Thanks in Advance.
User | Count |
---|---|
10 | |
10 | |
3 | |
2 | |
1 |