Microsoft KB Archive/919598

= When you try to import a Microsoft Operations Manager 2005 report file, the import process fails =

Article ID: 919598

Article Last Modified on 5/18/2007

-

APPLIES TO


 * Microsoft Operations Manager (MOM) 2005, when used with:
 * Microsoft SQL Server 2005 Reporting Services

-



SYMPTOMS
When you try to import a Microsoft Operations Manager (MOM) 2005 report file by using the Import/Export Management Pack option or the RptUtil.exe utility, the import process fails. Additionally, you receive an error message that resembles the following:

Operation: Import Report

Name:

Status: Failed

Description: Import failed. Report server url: http:// /ReportServer/ReportService.asmx Report import file: < >

Error message: System.Web.Services.Protocols.SoapException: The table `table ' 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 ' 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

This problem occurs if you are using Microsoft SQL Server 2005 Reporting Services.



CAUSE
This problem occurs because SQL Server 2005 Reporting Services imposes a more rigorous XML validation on the report schema. This behavior prevents some reports that were created by using an older schema convention from being imported.

The following Microsoft management pack reports are known to be affected:
 * Microsoft Application Center Management Pack for Microsoft Operations Manager 2005
 * Print Service Management Pack for Microsoft Operations Manager 2005
 * Microsoft Web Sites and Services Management Pack for Microsoft Operations Manager 2005
 * Microsoft Windows Distributed File System Service Management Pack for Microsoft Operations Manager 2005
 * Microsoft Windows DHCP Service Management Pack Management Pack
 * Microsoft Windows File Replication Service Management Pack for MOM 2005
 * Microsoft Windows Terminal Server Management Pack for Microsoft Operations Manager 2005
 * Microsoft Exchange Server 2003 Management Pack for Microsoft Operations Manager 2000 SP1
 * Microsoft Virtual Server 2005 R2 Management Pack



RESOLUTION
To obtain corrected reports, visit the following Microsoft Web site. Then, search for the management pack that includes the report that you want.

http://www.microsoft.com/management/mma/catalog.aspx

All the affected management packs have now had their reports updated.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
The Microsoft management packs that have been updated to correct this problem only contain changes to the report XML schemas. If the management pack and the reports are already installed and an upgrade to SQL Server 2005 is performed, you do not have to re-import the management pack or the reports.

Note Reports that are supplied in management packs from third-party vendors may be affected. If you experience this problem when you try to import reports that are supplied in a management pack from a third-party vendor, contact that vendor for an updated report file.

Keywords: kbtshoot kbprb KB919598

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.