• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1122
  • Last Modified:

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

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
Mitch Small
Asked:
Mitch Small
1 Solution
 
Computer EggheadCommented:
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

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now