OpsMgr, SCE And MOM Blog

Posts in this blog are provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified in the Terms of Use

Blogs

Failure to import some MOM reports with SQL Reporting Services 2005

  • Comments 4
  • Likes

This is documented in a small section at the bottom of http://support.microsoft.com/?kbid=917615 (The MOM 2005 Service Pack 1 operational database and Reporting data warehouse now support SQL Server 2005)

  • Microsoft has identified issues that occur when you import reports into a MOM 2005 Reporting Server installation that is using SQL Server 2005. These issues occur because of more rigorous XML validation requirements in SQL Server 2005 Reporting Services. Microsoft is currently working on a solution for these issues.

The error received during the attempting installation of one of the reports is as follows :-

Detail Information

Operation: Import Report

Name: <path and name of report.XML>

Status: Failed

Description: Import failed. Report server url: http://<ReportServername>/ReportServer/ReportService.asmx Report import file: <path and name of report.XML> Error message: System.Web.Services.Protocols.SoapException: The table `table<n>' is in the report body but the report has no data set. Data regions are not allowed in reports without datasets. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The table `table<n>' is in the report body but the report has no data set. Data regions are not allowed in reports without datasets. at Microsoft.ReportingServices.ReportProcessing.ReportPublishing.CreateIntermediateFormat(CatalogItemContext reportContext, Byte[] definition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, PublishingErrorContext errorContext, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions, String& description, String& language, ParameterInfoCollection& parameters, DataSourceInfoCollection& dataSources, UserLocationFlags& userReferenceLocation, ArrayList& dataSetsName, Boolean& hasExternalImages, Boolean& hasHyperlinks) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CompileReport(CatalogItemContext reportContext, Byte[] reportDefinition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, PublishingErrorContext errorContext, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions, String& reportDescription, String& reportLanguage, ParameterInfoCollection& parameters, DataSourceInfoCollection& dataSources, UserLocationFlags& userReferenceLocation, ArrayList& dataSetsName, Boolean& hasExternalImages, Boolean& hasHyperlinks)

at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CreateIntermediateFormat(CatalogItemContext reportContext, Byte[] reportDefinition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions)

at Microsoft.ReportingServices.Library.CreateReportAction.ConvertToIntermediate(Byte[] definition, Boolean usePermanentSnapshot, ItemProperties properties, CatalogItemContext reportContext, DateTime currentDate, Boolean checkAccessForSharedDatasources, ReportSnapshot& intermediateSnapshot, ParameterInfoCollection& parameters, Warning[]& warnings, DataSourceInfoCollection& dataSources, PageProperties& pageProperties)

at Microsoft.ReportingServices.Library.SetReportDefinitionAction._SetReportDefinition(String report, Byte[] definition)

at Microsoft.ReportingServices.Library.ReportCreator.UpdateExistingItem(String itemPath)

at Microsoft.ReportingServices.Library.CatalogItemCreator.CreateItem() at Microsoft.ReportingServices.Library.CreateReportAction._CreateReport(String report, String parent, Boolean overwrite, Byte[] definition, Property[] properties) at Microsoft.ReportingServices.Library.CreateReportAction.CreateReport(CallParameters parameters) at Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId)

at Microsoft.ReportingServices.WebServer.ReportingService.ExecuteBatch() --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService.ExecuteBatch()

*************************************************

There are nine affected Microsoft Management Packs.

They are:

The only changes made to these management packs are the updates to the report schema. If you already have the management pack installed and are not experiencing problems there is no need to reinstall the management pack. There are no new features or reports.

A KB article documenting this will be released shortly.

Comments
Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment