November 29, 2013 at 5:11 am
Hi all,
I have just done an upgrade of our SSRS environment in development from SQL 2005 to SQL 2012 (SP1).
The process I followed was that documented by Microsoft, basically backup and restore database and encryption key, however we have an issue in that certain reports are not loading.
Reports created using a data source work without any issues however reports using reporting models are not working, well, some of them are some of them aren't. Reading through articles on the web I can see that report build 3 does not support reporting models, based on this I can accept that if we needed to edit these then we would have to make some changes and then re-deploy the report, I'm fine with that, however I would expect that we should be able to open the reports at least however when we do we get an error saying;
"An error has occurred during report processing. (rsProcessingAborted)
An internal error occurred on the report server. See the error log for more details. (rsInternalError)"
Taking a look at the log and it reveals;
"processing!ReportServer_0-5!33fc!11/29/2013-12:05:04:: e ERROR: Data source 'dataSource1': An error has occurred. Details: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details."
The stack dump also has this in it;
"library!ReportServer_0-2!13a4!12/02/2013-09:50:53:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Unsupported object type: System.Uri, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.;"
I've gone over the data source and everything looks fine, no signs of login issues or alike. As I said some of the models work but some don't.
Does anyone have any ideas as to what the cause of the issue may be? Any help would be appreciated. If you need any more info/files then just let me know.
Thanks,
Nic
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply