SSRS SQL Server 2016 - Error when trying to customize security for a folder

Question

We are constantly getting errors when trying to customize security on folders in SSRS 2016 standard edition.

To start, because we're using SQL Server 2016 standard, the SSRS site is currently on the same server as its associated database.

When we click on the "Customize security" button, we get an error that states, "An internal error occurred on the report server. See the error log for more details."

We have tried repairing the database, changing settings in Report Configuration Manager and nothing as worked thus far. The only other item to add is that we previous tried connecting the same reporting database to a SSRS instance on a different server ..... not knowing that we could not do this with SQL Server 2016 standard edition. Also, the SSRS instance on the other machine was a newer SSRS edition so we're wondering if that messed something up in the ReportServer database we're trying to use now.

Below is the error we're seeing in the dump file.

Microsoft.ReportingServices.Portal.WebHost!library!3!07/27/2023-08:28:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Wrong number of tasks found for roleBrowser, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.;

Microsoft.ReportingServices.Portal.WebHost!library!3!07/27/2023-08:28:31:: e ERROR: Report server dump occured. Exception: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Message: , Unhandled Exception: False

Microsoft.ReportingServices.Portal.WebHost!library!3!07/27/2023-08:28:31:: e ERROR: Report server unique dump occured. Exception: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Message: , Unhandled Exception: False

Answer 1

Hi @SSRS_Schlep

From what I've searched, this could be some problem with your report server database. Maybe you can try to reinstall.

For more details, you can refer to these links:

https://community.fabric.microsoft.com/t5/Report-Server/Not-able-to-assign-item-permissions-to-user-from-BI-reporting/m-p/204710

https://dba.stackexchange.com/questions/163519/getting-error-message-when-opening-report-server-home-page-found-163-but-162-n

To be honest, since we can’t check the status of your server in the forum, this type of issue is usually difficult to resolve. Just judging from the error log, it looks strange. I suggest you consider using the phone support service provided by Microsoft which can usually help you resolve your issue.
https://support.microsoft.com/en-us/help/4051701/global-customer-service-phone-numbers
https://support.microsoft.com/en-us/supportforbusiness/productselection

Best regards,

Aniya

Answer 2

Hi @SSRS_Schlep

This is a generic error message that doesn't seem to provide much more valid information. Can you check the report server trace log for details? The log path is generally C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles.

For more details, you can refer to this link: https://learn.microsoft.com/en-us/sql/reporting-services/troubleshooting/rsinternalerror-reporting-services-error?view=sql-server-ver16.

Best regards,

Aniya