Solved

after SQL 2008R2 report server migration, cannot open "my subscriptions" folder

Posted on 2014-02-04
1
972 Views
Last Modified: 2014-08-21
I migrated a report server from one domain to another domain (all other environment are same). When I tried to open "my subscription" page from
http://localhost/Reports/Pages/Subscriptions.aspx
then I get an error messages:
"An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Invalid character in a Base-64 string.  "

Then I checked the log:
library!ReportServer_0-2!14f0!02/04/2014-16:40:47:: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!14f0!02/04/2014-16:40:47:: Call to ListSubscriptionsAction(null, null).
library!ReportServer_0-2!14f0!02/04/2014-16:40:47:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: , Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.FormatException: Invalid character in a Base-64 string.
   at System.Convert.FromBase64String(String s)
   at Microsoft.ReportingServices.Library.DataProtection.UnprotectDataToString(Int32 version, String protectedData, String tag)
   at Microsoft.ReportingServices.Library.SubscriptionManager.DecryptSubscriptionSettings(Setting[] settingsMetaData, Settings settings, Boolean removePasswords, Int32 version)
   at Microsoft.ReportingServices.Library.SubscriptionManager.PrepareSubscriptionSettingsForClient(SubscriptionImpl subscription, Boolean removePassword)
   at Microsoft.ReportingServices.Library.SubscriptionManager.CheckTimedSubscriptionAccess(SubscriptionImpl s, String user, ExternalItemPath path, Boolean pathIsSiteOrFolder)
   at Microsoft.ReportingServices.Library.SubscriptionManager.ListSubscriptions(String user, ExternalItemPath path, Boolean pathIsSiteOrFolder, SubscriptionType subscriptionType)
   at Microsoft.ReportingServices.Library.ListSubscriptionsAction.PerformActionNow()
   at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
   --- End of inner exception stack trace ---;
library!ReportServer_0-2!14f0!02/04/2014-16:40:49:: i INFO: Exception InternalCatalogException dumped to: C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\Logfiles flags= ReferencedMemory, AllThreads, SendToWatson
ui!ReportManager_0-1!1364!02/04/2014-16:40:49:: e ERROR: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.FormatException: Invalid character in a Base-64 string.
   at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.ListSubscriptions(String ItemPathOrSiteURL, String Owner, Subscription[]& SubscriptionItems)
   at Microsoft.ReportingServices.WebServer.ReportingService2010.ListSubscriptions(String ItemPathOrSiteURL, Subscription[]& SubscriptionItems)
   at Microsoft.ReportingServices.UI.SubscriptionItems.LoadItems()
   at Microsoft.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)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.AddedControl(Control control, Int32 index)
   at Microsoft.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)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.AddedControl(Control control, Int32 index)
   at Microsoft.ReportingServices.UI.SharedArea.Control_Init(Object sender, EventArgs args)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Control.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.AddedControl(Control control, Int32 index)
   at Microsoft.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(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
ui!ReportManager_0-1!1364!02/04/2014-16:40:49:: e ERROR: HTTP status code --> 200
-------Details--------
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.FormatException: Invalid character in a Base-64 string.
   at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.ListSubscriptions(String ItemPathOrSiteURL, String Owner, Subscription[]& SubscriptionItems)
   at Microsoft.ReportingServices.WebServer.ReportingService2010.ListSubscriptions(String ItemPathOrSiteURL, Subscription[]& SubscriptionItems)

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

   at Microsoft.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)

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

   at System.Web.UI.Control.AddedControl(Control control, Int32 index)

   at Microsoft.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)

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

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

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

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

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

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

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

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

   at System.Web.UI.Control.AddedControl(Control control, Int32 index)

   at Microsoft.ReportingServices.UI.SharedArea.Control_Init(Object sender, EventArgs args)

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

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

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

   at System.Web.UI.Control.AddedControl(Control control, Int32 index)

   at Microsoft.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(Control namingContainer)

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
library!ReportServer_0-2!14f0!02/04/2014-16:40:49:: Call to GetSystemPropertiesAction().
ui!ReportManager_0-1!1364!02/04/2014-16:40:49:: e ERROR: System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

is there any expert can provide me a clue to solve this problem?

Thanks
0
Comment
Question by:Mitch Small
1 Comment
 
LVL 2

Accepted Solution

by:
Computer Egghead earned 100 total points
ID: 39845694
One possibility is that the users are not the same.  See this for more information:  Subscriptions failing after migrating a Native mode SSRS Report Server database

Another reason could be the user is missing the exec role.  See this for more information: Not able to Add/Delete/Change subscriptions after migrating SSRS from on sql 2005 server to another

It is critical that all steps published by Microsoft are followed.  How to: Migrate a Reporting Services Installatio
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Back in July, I blogged about how Microsoft's new server pricing model, combined with the end of the Small Business Server package, would result in significant cost increases for many small businesses (see SBS End of Life: Microsoft Punishes Small B…
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now