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

SSRS_Schlep 20 Reputation points
2023-07-27T13:58:29.23+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,324 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,738 questions
0 comments No comments
{count} votes

Accepted answer
  1. AniyaTang-MSFT 12,216 Reputation points Microsoft Vendor
    2023-07-31T01:41:27.28+00:00

    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


1 additional answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,216 Reputation points Microsoft Vendor
    2023-07-28T01:23:41.5766667+00:00

    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