Reporting Services "My Subscriptions" link give error

Question

Reporting Services "My Subscriptions" link give error

SSCrazy

Points: 2081

January 5, 2018 at 1:10 pm

When I go to Reporting Services, on the top right click "My Subscriptions", it should list out the subscriptions I own. Instead I receive an error:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Here is what is listed in the Reporting Services error log:

library!ReportServer_0-185!338c!01/05/2018-13:28:17::i INFO: Call to ListSubscriptionsAction(null, null).

library!ReportServer_0-185!338c!01/05/2018-13:28:17::e ERROR: ThrowingMicrosoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:secDesc != null,Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Aninternal error occurred on the report server. See the error log for moredetails.;

library!ReportServer_0-185!338c!01/05/2018-13:28:17::i INFO: Skipped creating a dump file for the error InternalCatalogException,because a dump with the identical stack trace (with signature 3517591172) wasalready created.

ui!ReportManager_0-186!29ec!01/05/2018-13:28:17::e ERROR: System.Web.Services.Protocols.SoapException:System.Web.Services.Protocols.SoapException: An internal error occurred on thereport server. See the error log for more details. --->Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Aninternal error occurred on the report server. See the error log for moredetails.

atMicrosoft.ReportingServices.Library.ReportingService2010Impl.ListSubscriptions(StringItemPathOrSiteURL, String Owner, SubscriptionImpl[]& SubscriptionItems)

atMicrosoft.ReportingServices.WebServer.ReportingService2010.ListSubscriptions(StringItemPathOrSiteURL, Subscription[]& SubscriptionItems)

at Microsoft.ReportingServices.UI.SubscriptionItems.LoadItems()

atMicrosoft.ReportingServices.UI.SortableItems.Control_Init(Object sender,EventArgs args)

at System.EventHandler.Invoke(Object sender,EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

atSystem.Web.UI.Control.InitRecursive(Control namingContainer)

atSystem.Web.UI.Control.AddedControl(Control control, Int32 index)

atMicrosoft.ReportingServices.UI.SubscriptionPage.Control_Init(Object sender,EventArgs args)

at System.EventHandler.Invoke(Object sender,EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

atSystem.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Control.InitRecursive(ControlnamingContainer)

atSystem.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Control.InitRecursive(ControlnamingContainer)

atSystem.Web.UI.Control.InitRecursive(Control namingContainer)

atSystem.Web.UI.Control.AddedControl(Control control, Int32 index)

atMicrosoft.ReportingServices.UI.SharedArea.Control_Init(Object sender, EventArgsargs)

at System.EventHandler.Invoke(Object sender,EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

atSystem.Web.UI.Control.InitRecursive(Control namingContainer)

atSystem.Web.UI.Control.AddedControl(Control control, Int32 index)

atMicrosoft.ReportingServices.UI.Pages.Subscriptions.Page_Init(Object sender,EventArgs e)

at System.EventHandler.Invoke(Object sender,EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

atSystem.Web.UI.Control.InitRecursive(Control namingContainer)

atSystem.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,Boolean includeStagesAfterAsyncPoint)

ui!ReportManager_0-186!29ec!01/05/2018-13:28:17::e ERROR: HTTP status code --> 200

-------Details--------

System.Web.Services.Protocols.SoapException:System.Web.Services.Protocols.SoapException: An internal error occurred on thereport server. See the error log for more details. --->Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Aninternal error occurred on the report server. See the error log for moredetails.

atMicrosoft.ReportingServices.Library.ReportingService2010Impl.ListSubscriptions(StringItemPathOrSiteURL, String Owner, SubscriptionImpl[]& SubscriptionItems)

atMicrosoft.ReportingServices.WebServer.ReportingService2010.ListSubscriptions(StringItemPathOrSiteURL, Subscription[]& SubscriptionItems)

atMicrosoft.ReportingServices.UI.SubscriptionItems.LoadItems()

at Microsoft.ReportingServices.UI.SortableItems.Control_Init(Objectsender, EventArgs args)

at System.EventHandler.Invoke(Object sender,EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

atSystem.Web.UI.Control.InitRecursive(Control namingContainer)

atSystem.Web.UI.Control.AddedControl(Control control, Int32 index)

atMicrosoft.ReportingServices.UI.SubscriptionPage.Control_Init(Object sender,EventArgs args)

at System.EventHandler.Invoke(Object sender,EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

atSystem.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Control.InitRecursive(ControlnamingContainer)

atSystem.Web.UI.Control.InitRecursive(Control namingContainer)

atSystem.Web.UI.Control.AddedControl(Control control, Int32 index)

atMicrosoft.ReportingServices.UI.SharedArea.Control_Init(Object sender, EventArgsargs)

at System.EventHandler.Invoke(Object sender,EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

atSystem.Web.UI.Control.InitRecursive(Control namingContainer)

atSystem.Web.UI.Control.AddedControl(Control control, Int32 index)

atMicrosoft.ReportingServices.UI.Pages.Subscriptions.Page_Init(Object sender,EventArgs e)

at System.EventHandler.Invoke(Object sender,EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(ControlnamingContainer)

atSystem.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,Boolean includeStagesAfterAsyncPoint)

library!ReportServer_0-185!338c!01/05/2018-13:28:17::i INFO: Call to GetSystemPropertiesAction().

ui!ReportManager_0-186!29ec!01/05/2018-13:28:17::e ERROR: System.Threading.ThreadAbortException: Thread was being aborted.

at System.Threading.Thread.AbortInternal()

at System.Threading.Thread.Abort(ObjectstateInfo)

at System.Web.HttpResponse.End()

atMicrosoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Sue_H SSC Guru Points: 90860 More actions · Answer 1

In the error, it says:
Skipped creating a dump file for the error InternalCatalogException,because a dump with the identical stack trace (with signature 3517591172) was already created.

So you would want to check the server where Reporting Services is installed for a dump file that was already created and try to get more information from there.

Did this ever work correctly? Was the ReportServer database restored recently? Would/Did anyone manually update any of the tables?
Has anything changed with the login you use to connect to Reporting Services?

A couple of other things to check off the top of my head:
Check the keys table in the ReportServer database and make sure you have just one for this server/machine name and instance combination. There is typically another one with NULL for machine name.
Check the subscriptions table to make sure your subscriptions map back to a valid user in the Users table - OwnerID in the subscription table maps to UserID in the Users table.

Sue

sql Sarah SSCrazy Points: 2081 More actions · Answer 2

Thank you Sue for the insight. I understand that data mods for Reporting Services are not recommended, but we needed to disable users for compliance reasons. I had created a data mod for the Users table and set the AuthType field = 0 for the expired users.

There were a few users that had active subscriptions. I created another data mod to change the OwnerID of the Subscriptions to an active user. That fixed it!