Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Report Services SQL 2000 Installation Expand / Collapse
Author
Message
Posted Tuesday, September 3, 2013 4:05 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 26, 2013 12:26 AM
Points: 47, Visits: 180
Hi Guys,

I have had a hectic month trying to resolve this.

We have reporting services 2000 on two different servers, namely Production and Test, this are all operational and the for Test server it was done by someone else who no longer workers with us.

The DR server did not have reporting services installed. i therefore installed it and created new reporting databases. Later when it was all installed i asked the DBA to copy over the ReportServer and ReportServerTempDB from the production server onto the DR in order to make use on the database and i dont have to create the millions of reports from scratch. That was done and i point reporting services to make use of the databases copied over, when i open the url i could see all the reports but i cant execute them nor vied the data sources.

Please save me time in getting this reports to show on the DR site server?
Below is a log file that i obtained but i cant understand whats going on.

The last thing i did was, detach all the ReportServer db, then reattach but still no hope.

<Header>
<Product>Microsoft SQL Server Reporting Services Version 8.00.743.00</Product>
<Locale>en-US</Locale>
<TimeZone>South Africa Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServerWebApp__09_03_2013_10_30_00.log</Path>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!ui!428!9/3/2013-10:30:00:: e ERROR: System.Web.Services.Protocols.SoapException: An unexpected error occurred in Report Processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.d.f()
at Microsoft.ReportingServices.ReportProcessing.Persistence.d.as()
at Microsoft.ReportingServices.ReportProcessing.Persistence.d.am()
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.GetAllDataSources(CatalogItemContext reportContext, GetReportChunk getCompiledDefinitionCallback, SubReportDataSourcesCallback subReportCallback, DataSourceInfoCollection dataSources, Boolean checkIfUsable, Boolean isSurrogatePresent)
at Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean checkIfUsable)
at Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, Guid reportID, Boolean checkIfUsable)
at Microsoft.ReportingServices.Library.RSService.GetAllDataSources(CatalogItemContext reportContext, Boolean checkIfUsable, ReportSnapshot& compiledDefinition)
at Microsoft.ReportingServices.Library.RSService._GetProperties(ItemNamespaceEnum itemNamespace, String item, Property[] requestedProperties)
at Microsoft.ReportingServices.Library.RSService.GetProperties(ItemNamespaceEnum itemNamespace, String item, Property[] properties)
at Microsoft.ReportingServices.WebServer.ReportingService.GetProperties(String Item, Property[] Properties, Property[]& Values)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService.GetProperties(String Item, Property[] Properties, Property[]& Values)
w3wp!ui!428!9/3/2013-10:30:00:: e ERROR: HTTP status code --> 200
-------Details--------
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An unexpected error occurred in Report Processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.d.f()
at Microsoft.ReportingServices.ReportProcessing.Persistence.d.as()
at Microsoft.ReportingServices.ReportProcessing.Persistence.d.am()
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.GetAllDataSources(CatalogItemContext reportContext, GetReportChunk getCompiledDefinitionCallback, SubReportDataSourcesCallback subReportCallback, DataSourceInfoCollection dataSources, Boolean checkIfUsable, Boolean isSurrogatePresent)
at Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean checkIfUsable)
at Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, Guid reportID, Boolean checkIfUsable)
at Microsoft.ReportingServices.Library.RSService.GetAllDataSources(CatalogItemContext reportContext, Boolean checkIfUsable, ReportSnapshot& compiledDefinition)
at Microsoft.ReportingServices.Library.RSService._GetProperties(ItemNamespaceEnum itemNamespace, String item, Property[] requestedProperties)
at Microsoft.ReportingServices.Library.RSService.GetProperties(ItemNamespaceEnum itemNamespace, String item, Property[] properties)
at Microsoft.ReportingServices.WebServer.ReportingService.GetProperties(String Item, Property[] Properties, Property[]& Values)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService.GetProperties(String Item, Property[] Properties, Property[]& Values)

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices.ReportingService.GetProperties(String Item, Property[] Properties)

at Microsoft.SqlServer.ReportingServices.RSConnection.GetProperties(String Item, Property[] Properties)

at Microsoft.ReportingServices.UI.ReportingWebControl.GetItemProperties(String itemPath, String[] properties)

at Microsoft.ReportingServices.UI.ReportWrapperPage.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.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!428!9/3/2013-10:30:00:: e ERROR: Exception in ShowErrorPage: 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 System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
w3wp!ui!b44!9/3/2013-10:30:53:: e ERROR: 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.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.DecryptData(Byte[] pCipherText)
at Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectString(Byte[] protectedData)
at Microsoft.ReportingServices.DataExtensions.DataSourceInfo.GetConnectionString()
at Microsoft.ReportingServices.Library.Soap.DataSourceDefinition.DataSourceInfoToThis(DataSourceInfo dsi, Boolean getPassword)
at Microsoft.ReportingServices.Library.Soap.DataSourceDefinition.DataSourceInfoToThis(DataSourceInfo dsi)
at Microsoft.ReportingServices.Library.RSService.GetDataSourceContents(String path)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Library.RSService.GetDataSourceContents(String path)
at Microsoft.ReportingServices.WebServer.ReportingService.GetDataSourceContents(String DataSource, DataSourceDefinition& Definition)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService.GetDataSourceContents(String DataSource, DataSourceDefinition& Definition)
w3wp!ui!b44!9/3/2013-10:30:53:: 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.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.DecryptData(Byte[] pCipherText)
at Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectString(Byte[] protectedData)
at Microsoft.ReportingServices.DataExtensions.DataSourceInfo.GetConnectionString()
at Microsoft.ReportingServices.Library.Soap.DataSourceDefinition.DataSourceInfoToThis(DataSourceInfo dsi, Boolean getPassword)
at Microsoft.ReportingServices.Library.Soap.DataSourceDefinition.DataSourceInfoToThis(DataSourceInfo dsi)
at Microsoft.ReportingServices.Library.RSService.GetDataSourceContents(String path)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Library.RSService.GetDataSourceContents(String path)
at Microsoft.ReportingServices.WebServer.ReportingService.GetDataSourceContents(String DataSource, DataSourceDefinition& Definition)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService.GetDataSourceContents(String DataSource, DataSourceDefinition& Definition)

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices.ReportingService.GetDataSourceContents(String DataSource)

at Microsoft.SqlServer.ReportingServices.RSConnection.GetDataSourceContents(String DataSource)

at Microsoft.ReportingServices.UI.DataSourceProperties.LoadSharedDataSourceFromServer()

at Microsoft.ReportingServices.UI.DataSourceProperties.Control_Load(Object sender, EventArgs args)

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

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

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!b44!9/3/2013-10:30:53:: e ERROR: Exception in ShowErrorPage: 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 System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
Post #1490857
Posted Tuesday, September 3, 2013 10:09 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:12 PM
Points: 2,916, Visits: 2,515
You cannot simply restore a reporting services database from another SSRS installation over the top of the SSRS database of another installation. This is because SSRS encrypts parts of the content of the database and the database restore process does not know about this.

The steps for doing this can be found in this article : http://support.microsoft.com/kb/842425



Post #1491129
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse