Share via

SQL Server Reporting Services 2019 - Home Folder Error - Could not load folder Contents. Something went wrong

Daim Yakub 1 Reputation point
2021-01-08T04:07:19.897+00:00

Hi.
As stated in the title,
when I try to open report manager
http://compreports/reports
I got an error, Could not Load Folder Contents. Something Went Wrong

I can add new folder but it is not visible
If I search whatever folder I have before I can see, open it and even open whatever report I have inside.
But whenever I go back to Home folder, I still got that error.
It works fine last week but suddenly become like this.

My supervisor did clone this server to a new server instance.
Could that lead to this problem?
Please help.

Checking the log I got these errors. 

OData exception occurred: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AuthorizationExtensionException: An error occurred when invoking the authorization extension. ---> System.InvalidOperationException: (security): secDesc != null
   at Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.DefaultRSTraceInternal.Fail(String componentName, String message)
   at Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean condition, String message)
   at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, FolderOperation requiredOperation)
   at Microsoft.ReportingServices.Library.Security.<>c__DisplayClass51_1.<CheckAccess>b__0()
   at Microsoft.ReportingServices.Diagnostics.ExtensionBoundary.Invoke(Method m)
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.Diagnostics.ExtensionBoundary.Invoke(Method m)
   at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, FolderOperation fldOper, ExternalItemPath folderPath)
   at Microsoft.ReportingServices.Library.SecurityCheckCache.CheckAccessForCachedPolicy(ItemType type)
   at Microsoft.ReportingServices.Library.CatalogItemDescriptorFactory.BuildFromDbRow(IDataReader reader, CatalogItemDescriptor& itemDescriptor)
   at Microsoft.ReportingServices.Library.DBInterface.FindFavoriteableItems(InstrumentedSqlCommand command, FavoriteableCatalogItemList& result, Security secMgr, IPathTranslator pathTranslator, Boolean appendMyReports)
   at Microsoft.ReportingServices.Library.DBInterface.FindFavoriteableItemsNonRecursive(ExternalItemPath objectName, FavoriteableCatalogItemList& children, Security secMgr, IPathTranslator pathTranslator, Boolean appendMyReports)
   at Microsoft.ReportingServices.Library.ListFavoriteableItemsAction.PerformActionNow()
   at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
   at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.TraverseFolder(IPrincipal userPrincipal, String itemPath, Boolean recursive)
   at Model.FolderRepository.LoadCatalogItems()
   at Model.Folder.get_CatalogItems()
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.SegmentHandlers.PropertySegmentHandler.Handle(Object source, ODataPathSegment segment)
   at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.ReflectionODataController`1.Get(ODataPath oDataPath)
   at lambda_method(Closure , Object , Object[] )
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.<GetExecutor>b__2(Object instance, Object[] methodParameters)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext().| RequestID = s_a3a4a4fa-1fd5-4d1b-a1d5-e3c49da5900c
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,640 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,911 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,576 Reputation points
    2021-01-08T07:31:14.837+00:00

    Hi @Daim Yakub ,

    An error occurred when invoking the authorization extension

    You first check whether run-as profiles are setup correctly. And make sure the account used has proper permissions on your database server.
    You may also look into operationsmanager event log on your management server and also the database server and check any error message related.
    You could try to log in as an administrator and reset the role, then log in as a specific user in another browser and test.
    Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
  2. Vinith Singh 0 Reputation points
    2023-09-07T17:19:45.2733333+00:00

    You can follow this below article to get your issue resolved: https://kingfishertechtips.in/could-not-load-folder-contents-in-portal-url/

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.