x
login about faq Site discussion (meta-askssc)

ssrs - folder recover problem

Recently we have migrated the reporting services, we have taken backup of the old server reportserver and restored in new server. Due to some problem's one folder is not recovered in the new server. To recover that folder, we have copied those folder reports rows from catalog table to new server. The folder has been recovered in new server but if i am trying to opening the table, it is giving the error...What could be the reason

more ▼

asked Apr 03 '12 at 12:44 PM in Default

Mohan gravatar image

Mohan
314 18 30 43

What is the error message?

Apr 03 '12 at 01:03 PM Kev Riley ♦♦

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

I have seen errorlog,but i did not figure out...

Apr 03 '12 at 01:11 PM Mohan

And what is in the error log?

Apr 03 '12 at 01:43 PM Kev Riley ♦♦

-------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. at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.ListChildren(String Item, Boolean Recursive, CatalogItem[]& CatalogItems) at Microsoft.ReportingServices.WebServer.ReportingService2010.ListChildren(String ItemPath, Boolean Recursive, CatalogItem[]& CatalogItems)

at Microsoft.ReportingServices.UI.FolderItems.LoadItems()

Apr 03 '12 at 02:19 PM Mohan
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

You say that one folder has not been restored properly. Have you tried to rerun the restore?

Have you used the article 'Moving the Report Server Databases to Another Computer' from MS as a guide?

more ▼

answered Apr 03 '12 at 02:34 PM

Kev Riley gravatar image

Kev Riley ♦♦
46.1k 38 43 69

yes, but not able to restore...

Apr 03 '12 at 02:44 PM Mohan

Why are you not able to restore? Do you get an error from the restore operation?

Apr 04 '12 at 07:46 AM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x95

asked: Apr 03 '12 at 12:44 PM

Seen: 531 times

Last Updated: Apr 04 '12 at 07:46 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.