Solved

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

Posted on 2014-02-04
1
956 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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

I have put this article together as i needed to get all the information that might be available already into one general document that could be referenced once without searching the Internet for the different pieces. I have had a few issues where…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

760 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

19 Experts available now in Live!

Get 1:1 Help Now