SSRS Report Exception when uploaded to new Report Server

Question

Hi,

I have a problem where a report that works when deployed via Visual Studio throws an exception when copied to a different report server.

Here is an extract from the error dump (any help would be appreciated). I can see there a null reference exception but can't see what is missing.

Thanks in advance.

System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
library!WindowsService_416!19c0!01/14/2013-10:09:20:: i INFO: Call to CleanBatch()
library!WindowsService_416!19c0!01/14/2013-10:09:20:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
library!WindowsService_416!19c0!01/14/2013-10:09:20:: i INFO: Call to CleanBatch() ends
library!WindowsService_416!19c0!01/14/2013-10:19:20:: i INFO: Call to CleanBatch()
library!WindowsService_416!19c0!01/14/2013-10:19:20:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
library!WindowsService_416!19c0!01/14/2013-10:19:20:: i INFO: Call to CleanBatch() ends
library!ReportServer_0-439!1b74!01/14/2013-10:26:06:: Call to GetPermissionsAction(/RSFolder).
library!ReportServer_0-439!1b74!01/14/2013-10:26:06:: Call to GetPropertiesAction(/RSFolder, PathBased).
library!ReportServer_0-439!1b74!01/14/2013-10:26:06:: Call to GetPropertiesAction(/RSFolder, PathBased).
library!ReportServer_0-439!1b74!01/14/2013-10:26:06:: Call to GetSystemPermissionsAction().
library!ReportServer_0-439!1b74!01/14/2013-10:26:06:: Call to ListChildrenAction(/RSFolder, False).
library!ReportServer_0-439!1b74!01/14/2013-10:26:06:: Call to GetSystemPropertiesAction().
library!ReportServer_0-439!1b74!01/14/2013-10:26:06:: Call to GetSystemPropertiesAction().
library!ReportServer_0-439!1b74!01/14/2013-10:26:06:: Call to GetSystemPropertiesAction().
library!ReportServer_0-439!1b74!01/14/2013-10:26:08:: Call to GetPermissionsAction(/RSFolder/r2).
library!ReportServer_0-439!1b74!01/14/2013-10:26:08:: Call to GetPropertiesAction(/RSFolder/r2, PathBased).
library!ReportServer_0-439!1b74!01/14/2013-10:26:08:: Call to GetPropertiesAction(/RSFolder/r2, PathBased).
library!ReportServer_0-439!1b74!01/14/2013-10:26:08:: Call to GetSystemPermissionsAction().
library!ReportServer_0-439!1b74!01/14/2013-10:26:08:: Call to ListChildrenAction(/RSFolder/r2, False).
library!ReportServer_0-439!1b74!01/14/2013-10:26:08:: Call to GetSystemPropertiesAction().
library!ReportServer_0-439!1b74!01/14/2013-10:26:08:: Call to GetSystemPropertiesAction().
library!ReportServer_0-439!1b74!01/14/2013-10:26:08:: Call to GetSystemPropertiesAction().
library!ReportServer_0-439!1b74!01/14/2013-10:26:08:: Call to GetSystemPropertiesAction().
library!ReportServer_0-439!155c!01/14/2013-10:26:12:: Call to GetPermissionsAction(/RSFolder/r2).
library!ReportServer_0-439!155c!01/14/2013-10:26:12:: Call to GetPropertiesAction(/RSFolder/r2, PathBased).
library!ReportServer_0-439!155c!01/14/2013-10:26:12:: Call to GetPropertiesAction(/RSFolder/r2, PathBased).
library!ReportServer_0-439!155c!01/14/2013-10:26:12:: Call to GetSystemPermissionsAction().
library!ReportServer_0-439!155c!01/14/2013-10:26:12:: Call to ListChildrenAction(/RSFolder/r2, False).
library!ReportServer_0-439!155c!01/14/2013-10:26:12:: Call to GetSystemPropertiesAction().
library!ReportServer_0-439!155c!01/14/2013-10:26:12:: Call to GetSystemPropertiesAction().
library!ReportServer_0-439!155c!01/14/2013-10:26:12:: Call to GetSystemPropertiesAction().
library!ReportServer_0-439!155c!01/14/2013-10:26:12:: Call to GetSystemPropertiesAction().
library!ReportServer_0-439!1238!01/14/2013-10:26:42:: Call to GetPermissionsAction(/RSFolder/r2).
library!ReportServer_0-439!1238!01/14/2013-10:26:42:: Call to GetPropertiesAction(/RSFolder/r2, PathBased).
library!ReportServer_0-439!1238!01/14/2013-10:26:42:: Call to GetPropertiesAction(/RSFolder/r2, PathBased).
library!ReportServer_0-439!1238!01/14/2013-10:26:42:: Call to GetSystemPermissionsAction().
library!ReportServer_0-439!1238!01/14/2013-10:26:42:: Call to ListChildrenAction(/RSFolder/r2, False).
library!ReportServer_0-439!1238!01/14/2013-10:26:42:: Call to GetSystemPropertiesAction().
library!ReportServer_0-439!1238!01/14/2013-10:26:42:: Call to GetSystemPropertiesAction().
library!ReportServer_0-439!1238!01/14/2013-10:26:42:: Call to GetSystemPropertiesAction().
library!ReportServer_0-439!1238!01/14/2013-10:26:42:: Call to GetSystemPropertiesAction().
library!ReportServer_0-439!1238!01/14/2013-10:26:42:: Call to GetSystemPropertiesAction().
library!ReportServer_0-439!155c!01/14/2013-10:27:37:: Call to GetSystemPropertiesAction().
library!ReportServer_0-439!15cc!01/14/2013-10:27:37:: Call to GetItemTypeAction(/RSFolder/r2/CopiedReport).
library!ReportServer_0-439!15cc!01/14/2013-10:27:38:: Call to GetItemTypeAction(/RSFolder/r2/CopiedReport).
library!ReportServer_0-439!15cc!01/14/2013-10:27:38:: Call to GetReportDefinitionAction(/RSFolder/r2/CopiedReport).
library!ReportServer_0-439!15cc!01/14/2013-10:27:43:: Call to GetItemDataSourcesAction(/RSFolder/r2/CopiedReport).
library!ReportServer_0-439!155c!01/14/2013-10:27:43:: Call to GetItemTypeAction(/RSFolder/r2/CopiedReport).
library!ReportServer_0-439!155c!01/14/2013-10:27:43:: Call to GetReportItemReferencesAction(/RSFolder/r2/CopiedReport).
library!ReportServer_0-439!15cc!01/14/2013-10:27:43:: Call to GetItemTypeAction(/RSFolder/r2/CopiedReport).
library!ReportServer_0-439!15cc!01/14/2013-10:27:43:: Call to GetReportParametersAction(/RSFolder/r2/CopiedReport).
library!ReportServer_0-439!15cc!01/14/2013-10:27:43:: Call to GetPropertiesAction(/RSFolder/r2/CopiedReport, PathBased).
library!ReportServer_0-439!15cc!01/14/2013-10:27:43:: 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.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.ReportingServices.Library.RSService.CombineDataSources(DataSetInfoCollection dataSets, DataSourceInfoCollection existingDataSources)
   at Microsoft.ReportingServices.Library.RSService.ProcessingGetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, DataSetInfoCollection thisReportDataSets, Boolean checkIfUsable, RuntimeDataSourceInfoCollection& runtimeDataSources, RuntimeDataSetInfoCollection& runtimeDataSets)
   at Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, BaseReportCatalogItem report, ReportSnapshot intermediateSnapshot, Boolean checkIfUsable, RuntimeDataSourceInfoCollection& runtimeDataSources, RuntimeDataSetInfoCollection& runtimeDataSets)
   at Microsoft.ReportingServices.Library.RSService.GetAllDataSources(BaseReportCatalogItem report, Boolean checkIfUsable, Boolean useServiceConnectionForRepublishing, ReportSnapshot& compiledDefinition, RuntimeDataSourceInfoCollection& runtimeDataSources, RuntimeDataSetInfoCollection& runtimeDataSets)
   at Microsoft.ReportingServices.Library.BaseReportCatalogItem.DeriveProperties()
   at Microsoft.ReportingServices.Library.GetPropertiesAction.PerformActionNow()
   at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
   --- End of inner exception stack trace ---;

Answer 1

Looks like the data source may not have been deployed with the report...or at least when deployed it has not joined the 2 together

---

Rgds Geoff
----------------------------------------------------------
Mark as Answer if this resolves your problem or "Vote as Helpful" if you find it helpful.

Answer 2

Thanks Geoff - I get an exception when trying to "manage" the report in report manager, any suggestions on how I can get the report and dataset(s) to join?

Answer 3

I presume you used the standard "right click" and deploy option from VS?

If so, is "overwrite data sources" set to true or false in teh project properties

Can you see the data source in report manager?

Can you have a look in the reportserver database catalog table and see if the report exists there? If it does can you also see if the data source exists in the datasource table?

---

Rgds Geoff
----------------------------------------------------------
Mark as Answer if this resolves your problem or "Vote as Helpful" if you find it helpful.

Answer 4

Hi Steven,

From your description, do you mean the issue occurs when clicking the “Manage” tab of the report or running the report?

If the former, please check the other reports to make sure you can manage them from the report manager, otherwise, the issue may be related to the report manager itself. If the other reports on the report server work well, please delete the report, and then re-upload the report and configure the data source of the report again. You can also try to publish the report to the new server directly from Report Designer in BIDS.

If the latter, the issue may occur due to one of the following factors:

• The data source of the report is not mapped properly after moving to the new server. To do this, please manage the report, and set the data source.
• If you use SSRS 2008, it might be the known issue - FIX: Error message when you try to view a report in SQL Server 2008 Reporting Services: "Object reference not set to an instance of an object. (rsRuntimeErrorInExpression)".

If the issue persists, please post the related error message in the Reporting Services Log file which is located in the <Drive>:\Program Files\Microsoft SQL Server\MSRS10.<Instance Name>\Reporting Services\LogFiles folder.

Regards,

---

Mike Yin
TechNet Community Support

Answer 5

Hi Guys,

Thanks for you responses. We have multiple report servers and need to be able to deploy from Visual Studio to Dev then upload the report to our other report servers. When I deploy the reports to development (using Visual Studio) the report works fine. If I deploy to any environment from Visual Studio the report works fine. But if I upload the rdl (using report manager) to a different report server than the one that it was deployed to from Visual Studio I get this exception.

The report exists in the catalog table and the datasource in the DataSource table (we have 100+ reports all using this datasource). If I join the 2 tables on ItemID I can see that the report and the datasource are linked. I should mention that the report uses a lot of shared datasets (but all our other reports use the same ones). This report is just a copy of another report that works when deployed from Visual Studio and when manually uploaded.

Mike, my initial post contains the error taken from the log file in (I will look into the hotfix you provided, stange that all our other reports are fine) <Drive>:\Program Files\Microsoft SQL Server\MSRS10.<Instance Name>\Reporting Services\LogFiles

library!ReportServer_0-439!15cc!01/14/2013-10:27:43:: Call to GetPropertiesAction(/RSFolder/r2/CopiedReport, PathBased).

library!ReportServer_0-439!15cc!01/14/2013-10:27:43:: 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.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.ReportingServices.Library.RSService.CombineDataSources(DataSetInfoCollection dataSets, DataSourceInfoCollection existingDataSources)
   at Microsoft.ReportingServices.Library.RSService.ProcessingGetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, DataSetInfoCollection thisReportDataSets, Boolean checkIfUsable, RuntimeDataSourceInfoCollection& runtimeDataSources, RuntimeDataSetInfoCollection& runtimeDataSets)
   at Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, BaseReportCatalogItem report, ReportSnapshot intermediateSnapshot, Boolean checkIfUsable, RuntimeDataSourceInfoCollection& runtimeDataSources, RuntimeDataSetInfoCollection& runtimeDataSets)
   at Microsoft.ReportingServices.Library.RSService.GetAllDataSources(BaseReportCatalogItem report, Boolean checkIfUsable, Boolean useServiceConnectionForRepublishing, ReportSnapshot& compiledDefinition, RuntimeDataSourceInfoCollection& runtimeDataSources, RuntimeDataSetInfoCollection& runtimeDataSets)
   at Microsoft.ReportingServices.Library.BaseReportCatalogItem.DeriveProperties()
   at Microsoft.ReportingServices.Library.GetPropertiesAction.PerformActionNow()
   at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
   --- End of inner exception stack trace ---;

Thanks again,

Steven

Answer 6

Sorry, forgot to say this same exception occurs when I try to run the report in report manager and when I try to "manage" the report in report manager.

Answer 7

Are there multiple data sources for this report? seperate ones for some parameters maybe? I only ask as the  error is indicating that it is occurring when trying to get all  data sources for the report...

---

Rgds Geoff
----------------------------------------------------------
Mark as Answer if this resolves your problem or "Vote as Helpful" if you find it helpful.

Answer 8

Hi Geoff,

The report has 3 datasources, and 20 or so parameters that's values are populated by shared datasets, which use one of the reports datasources.

Regards,

Steven