One of the reports listed on my report server seems to have become corrupt. The only change we are aware of is the upgrade of the report server to the Jan 2020 edition. Before the upgrade, the report had been working for months. Now when you try to do anything involving the report it throws errors.
1. Click to view the report in a browser via a browser returns the error: "An error has occured. Something went wrong. Please try again later"
2. Click the ellipsis to manage the report returns the same error as #1.
3. Attempt to open the file for editing using Power BI Desktop for Reporting Server returns the error: "Error - Can't open file or folder /dir/filename. It may have been moved, renamed, or deleted.
Since this was a production report, I first focused on restoration of functionality and was able to extract the PBIX file from the catalog. Surprisingly the file I extracted was not corrupt and I was able to open, edit and publish it. However, now I have 2 reports with the same name listed on my server. One of them works, the other throws errors and I cannot remove or manage the one that throws errors.
If I can't remove the file through the reporting server gui because of some sort of corruption, how can else can I remove it? I thought about removing it directly from the catalog, but I'm worried I'd cause more problems because of the orphaned rows I'd likely create because I don't understand all the relationships fully.
Anyone else ever seen this before? What did you do to fix it?
