What the error means in XML file?

Wednesday, January 16, 2013 1:42 PM

Hi Every one ,

What is the below error tells? I got this error in production environment. but not able to generate again in local system. Erro line indicates the that last line of the last word of the XML file.

Don't know what is the root cause. I searched in internet. but didnt get the solution . Please help me to come out of this?

Screen : Audit Engine

System.Xml.XmlException: Data at the root level is invalid. Line 127, position 16.
at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace()
at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
at System.Xml.XmlReader.ReadEndElement()
at System.Data.DataSet.ReadXml(XmlReader reader, Boolean denyResolving)
at System.Data.DataSet.ReadXml(String fileName)
at Kinship.IDERT.Audit.AuditMetaData..ctor(String tableName)
at Kinship.IDERT.Audit.AuditBuilderFactory.GetColumnAuditBuilders(DataSet dsToAudit, DataTable tableToAudit, Dictionary`2 paramValues)
at Kinship.IDERT.Audit.AuditEngine.AuditDataTable(DataSet dsToAudit, DataTable tableToAudit, Dictionary`2 paramValues, AuditDS auditXmlDS)
at Kinship.IDERT.Audit.AuditEngine.GetAuditXmlDS(DataSet dsToAudit, Dictionary`2 propertyValues)
********************************************************************************************************

 <?xml version="1.0" standalone="yes" ?> 
- <TableRulesDS xmlns="http://tempuri.org/TableRulesDS.xsd">
- <xs:schema id="TableRulesDS" targetNamespace="http://tempuri.org/TableRulesDS.xsd" xmlns:mstns="http://tempuri.org/TableRulesDS.xsd" xmlns="http://tempuri.org/TableRulesDS.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
- <xs:element name="TableRulesDS" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
- <xs:complexType>
- <xs:choice minOccurs="0" maxOccurs="unbounded">
- <xs:element name="ColumnDefinition">
- <xs:complexType>
- <xs:sequence>
  <xs:element name="ColumnId" type="xs:int" minOccurs="0" /> 
  <xs:element name="ColumnName" type="xs:string" /> 
  <xs:element name="DisplayName" type="xs:string" minOccurs="0" /> 
  <xs:element name="Mandatory" type="xs:int" minOccurs="0" /> 
  <xs:element name="ColumnType" type="xs:int" minOccurs="0" /> 
  <xs:element name="EnumerationId" type="xs:int" minOccurs="0" /> 
  <xs:element name="PrefetchId" type="xs:int" minOccurs="0" /> 
  <xs:element name="DependOnField" type="xs:string" minOccurs="0" /> 
  <xs:element name="DependantEnums" type="xs:string" minOccurs="0" /> 
  <xs:element name="ValueSeperation" type="xs:int" minOccurs="0" /> 
  </xs:sequence>
  </xs:complexType>
  </xs:element>
- <xs:element name="Enumeration">
- <xs:complexType>
- <xs:sequence>
  <xs:element name="EnumerationId" type="xs:int" /> 
  <xs:element name="EnumerationTable" type="xs:string" minOccurs="0" /> 
  </xs:sequence>
  </xs:complexType>
  </xs:element>
- <xs:element name="Prefetch">
- <xs:complexType>
- <xs:sequence>
  <xs:element name="PrefetchId" type="xs:int" /> 
  <xs:element name="SqlQuery" type="xs:string" minOccurs="0" /> 
  </xs:sequence>
  </xs:complexType>
  </xs:element>
- <xs:element name="ParentRelations">
- <xs:complexType>
- <xs:sequence>
  <xs:element name="ParentTable" type="xs:string" minOccurs="0" /> 
  <xs:element name="ChildTable" type="xs:string" minOccurs="0" /> 
  <xs:element name="ParentColumns" type="xs:string" minOccurs="0" /> 
  <xs:element name="ChildColumns" type="xs:string" minOccurs="0" /> 
  <xs:element name="ColumnName" type="xs:string" minOccurs="0" /> 
  </xs:sequence>
  </xs:complexType>
  </xs:element>
- <xs:element name="Hierarchy">
- <xs:complexType>
- <xs:sequence>
  <xs:element name="Hierarchy" type="xs:int" minOccurs="0" /> 
  </xs:sequence>
  </xs:complexType>
  </xs:element>
  </xs:choice>
  </xs:complexType>
+ <xs:unique name="Constraint1" msdata:PrimaryKey="true">
  <xs:selector xpath=".//mstns:ColumnDefinition" /> 
  <xs:field xpath="mstns:ColumnName" /> 
  </xs:unique>
- <xs:unique name="Enumeration_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  <xs:selector xpath=".//mstns:Enumeration" /> 
  <xs:field xpath="mstns:EnumerationId" /> 
  </xs:unique>
- <xs:unique name="Prefetch_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  <xs:selector xpath=".//mstns:Prefetch" /> 
  <xs:field xpath="mstns:PrefetchId" /> 
  </xs:unique>
  </xs:element>
  </xs:schema>
- <ColumnDefinition>
  <ColumnId>1</ColumnId> 
  <ColumnName>ANALYSISID</ColumnName> 
  <DisplayName>ANALYSIS</DisplayName> 
  <Mandatory>1</Mandatory> 
  <ColumnType>3</ColumnType> 
  <PrefetchId>2</PrefetchId> 
  </ColumnDefinition>
- <ColumnDefinition>
  <ColumnId>11</ColumnId> 
  <ColumnName>CREATEDDATE</ColumnName> 
  <DisplayName>CREATED DATE</DisplayName> 
  <Mandatory>0</Mandatory> 
  <ColumnType>1</ColumnType> 
  <DependOnField /> 
  <DependantEnums /> 
  </ColumnDefinition>
- <ColumnDefinition>
  <ColumnId>5</ColumnId> 
  <ColumnName>DATASETLABEL</ColumnName> 
  <DisplayName>DATASET LABEL</DisplayName> 
  <Mandatory>0</Mandatory> 
  <ColumnType>1</ColumnType> 
  </ColumnDefinition>
- <ColumnDefinition>
  <ColumnId>4</ColumnId> 
  <ColumnName>DATASETNAME</ColumnName> 
  <DisplayName>DATASET NAME</DisplayName> 
  <Mandatory>0</Mandatory> 
  <ColumnType>1</ColumnType> 
  </ColumnDefinition>
- <ColumnDefinition>
  <ColumnId>9</ColumnId> 
  <ColumnName>ENGINENAME</ColumnName> 
  <DisplayName>ENGINE NAME</DisplayName> 
  <Mandatory>0</Mandatory> 
  <ColumnType>1</ColumnType> 
  </ColumnDefinition>
- <ColumnDefinition>
  <ColumnId>14</ColumnId> 
  <ColumnName>GENERATIONNO</ColumnName> 
  <DisplayName>GENERATION NO</DisplayName> 
  <Mandatory>0</Mandatory> 
  <ColumnType>1</ColumnType> 
  </ColumnDefinition>
- <ColumnDefinition>
  <ColumnId>12</ColumnId> 
  <ColumnName>LASTMODIFIEDDATE</ColumnName> 
  <DisplayName>LAST MODIFIED DATE</DisplayName> 
  <Mandatory>0</Mandatory> 
  <ColumnType>1</ColumnType> 
  <DependOnField /> 
  <DependantEnums /> 
  </ColumnDefinition>
- <ColumnDefinition>
  <ColumnId>8</ColumnId> 
  <ColumnName>LIBRARYMEMBERNAME</ColumnName> 
  <DisplayName>LIBRARY MEMBER NAME</DisplayName> 
  <Mandatory>1</Mandatory> 
  <ColumnType>1</ColumnType> 
  </ColumnDefinition>
- <ColumnDefinition>
  <ColumnId>16</ColumnId> 
  <ColumnName>LOCATIONREFERENCE</ColumnName> 
  <DisplayName>LOCATION REFERENCE</DisplayName> 
  <Mandatory>0</Mandatory> 
  <ColumnType>1</ColumnType> 
  </ColumnDefinition>
- <ColumnDefinition>
  <ColumnId>13</ColumnId> 
  <ColumnName>MAXNOOFGENERATIONS</ColumnName> 
  <DisplayName>MAX NO OF GENERATIONS</DisplayName> 
  <Mandatory>0</Mandatory> 
  <ColumnType>1</ColumnType> 
  </ColumnDefinition>
- <ColumnDefinition>
  <ColumnId>15</ColumnId> 
  <ColumnName>NEXTGENERATIONNO</ColumnName> 
  <DisplayName>NEXT GENERATION NO</DisplayName> 
  <Mandatory>0</Mandatory> 
  <ColumnType>1</ColumnType> 
  </ColumnDefinition>
- <ColumnDefinition>
  <ColumnId>10</ColumnId> 
  <ColumnName>OBSERVATIONSINDATASET</ColumnName> 
  <DisplayName>OBSERVATIONS IN DATASET</DisplayName> 
  <Mandatory>0</Mandatory> 
  <ColumnType>1</ColumnType> 
  </ColumnDefinition>
- <ColumnDefinition>
  <ColumnId>6</ColumnId> 
  <ColumnName>STUDYID</ColumnName> 
  <DisplayName>STUDY CODE</DisplayName> 
  <Mandatory>0</Mandatory> 
  <ColumnType>3</ColumnType> 
  <PrefetchId>1</PrefetchId> 
  <DependOnField /> 
  <DependantEnums /> 
  </ColumnDefinition>
- <ColumnDefinition>
  <ColumnId>3</ColumnId> 
  <ColumnName>STUDYMETADATAID</ColumnName> 
  <DisplayName>STUDYMETADATAID</DisplayName> 
  <Mandatory>0</Mandatory> 
  <ColumnType>0</ColumnType> 
  </ColumnDefinition>
- <ColumnDefinition>
  <ColumnId>2</ColumnId> 
  <ColumnName>STUDYMETADATARTYPE</ColumnName> 
  <DisplayName>STUDY METADATA RELATION TYPE</DisplayName> 
  <Mandatory>1</Mandatory> 
  <ColumnType>2</ColumnType> 
  <EnumerationId>1</EnumerationId> 
  </ColumnDefinition>
- <ColumnDefinition>
  <ColumnId>7</ColumnId> 
  <ColumnName>STUDYMETADATATYPE</ColumnName> 
  <DisplayName>STUDY METADATA TYPE</DisplayName> 
  <Mandatory>1</Mandatory> 
  <ColumnType>2</ColumnType> 
  <EnumerationId>2</EnumerationId> 
  </ColumnDefinition>
+ <Enumeration>
  <EnumerationId>1</EnumerationId> 
  <EnumerationTable>STUDYMETADATARTYPE</EnumerationTable> 
  </Enumeration>
- <Enumeration>
  <EnumerationId>2</EnumerationId> 
  <EnumerationTable>STUDYMETADATATYPE</EnumerationTable> 
  </Enumeration>
- <Prefetch>
  <PrefetchId>1</PrefetchId> 
  <SqlQuery>Select StudyCode from Study where studyID =?</SqlQuery> 
  </Prefetch>
- <Prefetch>
  <PrefetchId>2</PrefetchId> 
  <SqlQuery>select analysiscode from STUDYANALYSIS where analysisid =?</SqlQuery> 
  </Prefetch>
- <Hierarchy>
  <Hierarchy>1</Hierarchy> 
  </Hierarchy>
  </TableRulesDS>

Manikandan Murugeshan

Changed Type Manikandan Murugeshan Wednesday, January 16, 2013 1:43 PM Wrong entry
Moved by Bob Wu-MTMicrosoft Contingent Staff, Moderator Friday, January 18, 2013 7:16 AM

All Replies

Wednesday, January 16, 2013 3:42 PM

0
If the sporadic "+"s and "-"s are not just a copy error, and they are actually in the XML file, then this is the likely cause of your issue.
It would be greatly appreciated if you would mark any helpful entries as helpful and if the entry answers your question, please mark it with the Answer link.
- Proposed As Answer by TSoftware Thursday, January 24, 2013 3:51 AM
- Reply
- Quote