Remove a corrupt report from on premise server?

MNMark — Wed, 05 Feb 2020 15:01:38 GMT

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?

Re: Remove a corrupt report from on premise server?

MNMark — Thu, 06 Feb 2020 21:38:07 GMT

Posting my solution just in case someone else runs into this.

For simplicity assume my folder is named "exampleFolder"

1. Document all security setting for each report and folder within exampleFolder

2. Move all contents of exampleFolder (expect the problem report) to tempFolder outside of the exampleFolder hierarchy.

3. Delete exampleFolder

4. Recreate exampleFolder

5. Apply appropriate security to exampleFolder

6. Move all contents from tempFolder back into exampleFolder

7. Double check all security setting are correct

Hope this helps someone.

topic Remove a corrupt report from on premise server? in Report Server

Remove a corrupt report from on premise server?

Re: Remove a corrupt report from on premise server?