Solved

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

Posted on 2014-02-04
1
1,004 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

733 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