Reporting Services Error when exporting AC report to XML format: An XML element with the name already exists inside of the current parent node. (NETIQKB72157)

  • 7772157
  • 23-Mar-2010
  • 09-Nov-2010

Environment

NetIQ Analysis Center 2.7
Microsoft SQL Server 2005
Microsoft SQL Server Reporting Services

Situation

Reporting Services Error when exporting AC report to XML format: An XML element with the name already exists inside of the current parent node.
Reporting Services Error
--------------------------------------------------------------------------------
An unexpected error occurred in Report Processing. (rsInternalError) Get Online Help
Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.
An XML element with the name ?CCM_x003A__x0020__x005B_NHSBT-IPT-CUCM-PUB_x005D__x0020__x005B_NHSBT-IPT-CUCM-PUB-Cluster_x005D_? already exists inside of the current parent node.

Resolution

Use the following to work around and export the report to XML:

  •  Open the report in SSRS
  •  Open properties Tab.
  •  Select to Edit under General ? Report Definition
  •  Save the RDL to system.
  •  Open the RDL for edit.
  •  Under the <SeriesGroupings> - <SeriesGrouping>- <StaticSeries> you can see multiple  <StaticMember> having same values for the Label.
  •  One can append some text to make these labels different.
    • For example, you can leave the first label as  CCM: [NHSBT-IPT-CUCM-PUB] [NHSBT-IPT-CUCM-PUB-Cluster] and append 1 to the next label CCM: [NHSBT-IPT-CUCM-PUB] [NHSBT-IPT-CUCM-PUB-Cluster]1 and 2 to the next CCM: [NHSBT-IPT-CUCM-PUB] [NHSBT-IPT-CUCM-PUB-Cluster]2 and so on.
  •  Save the RDL
  •  Select to Update under General ? Report Definition and browse for the modified RDL and click ok.
  •  Now the report should be ok to export to XML

Cause

The issue is reproducible in reports where chart series have the same name for different x-axis data series members.

When we try to export this report to XML, SQL Server Reporting Services picks up these series names to create data series nodes and xml cannot have nodes with same name, so an error is thrown.  This is per Export design in SQL Server Reporting Services.

Additional Information

Formerly known as NETIQKB72157