I received a call from a user today saying he was getting 'there was a problem executing your request. Please contact your system admin' message when trying to launch a report.
This puzzled me for a while as other users could run the report ok and the permissions are correct.
What I discovered had/is happening is that I created a new version of the report, moved the original report to a folder named Obsolete and removed all user permissions from the original report.
What I didn't appreciate was that if a user had previously marked the original report as a Favourite the link to the now obsolete report was still live and visible to the user. He was, rightly, trying to launch the report from his Favourites tab and then getting the above error. If he ran the report, the newer version, from a main Category then it ran OK.
Do you have or can you advise a way to remove reports from Users' Favourites when they no longer have permission to run the report?
I normally always keep previous versions of reports in case of having to roll-back.
Hope you follow that