x

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
324 31 47 58

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][1]' from MS as a guide?

[1]: http://msdn.microsoft.com/en-us/library/ms156421(v=sql.100).aspx
more ▼

answered Apr 03 '12 at 02:34 PM

Kev Riley gravatar image

Kev Riley ♦♦
50.5k 43 49 76

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x111

asked: Apr 03 '12 at 12:44 PM

Seen: 999 times

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