Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2014-02-04
1
Medium Priority
?
1,095 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 400 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

610 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