EDN Admin
Well-known member
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.
Dont 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<br/>
<br/>
System.Xml.XmlException: Data at the root level is invalid. Line 127, position 16.<br/>
at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)<br/>
at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace()<br/>
at System.Xml.XmlTextReaderImpl.ParseDocumentContent()<br/>
at System.Xml.XmlReader.ReadEndElement()<br/>
at System.Data.DataSet.ReadXml(XmlReader reader, Boolean denyResolving)<br/>
at System.Data.DataSet.ReadXml(String fileName)<br/>
at Kinship.IDERT.Audit.AuditMetaData..ctor(String tableName)<br/>
at Kinship.IDERT.Audit.AuditBuilderFactory.GetColumnAuditBuilders(DataSet dsToAudit, DataTable tableToAudit, Dictionary`2 paramValues)<br/>
at Kinship.IDERT.Audit.AuditEngine.AuditDataTable(DataSet dsToAudit, DataTable tableToAudit, Dictionary`2 paramValues, AuditDS auditXmlDS)<br/>
at Kinship.IDERT.Audit.AuditEngine.GetAuditXmlDS(DataSet dsToAudit, Dictionary`2 propertyValues)<br/>
********************************************************************************************************
<pre class="prettyprint <?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" msdatarimaryKey="true
<xs:selector xpath=".//mstns:ColumnDefinition" />
<xs:field xpath="mstns:ColumnName" />
</xs:unique>
- <xs:unique name="Enumeration_Constraint1" msdata:ConstraintName="Constraint1" msdatarimaryKey="true
<xs:selector xpath=".//mstns:Enumeration" />
<xs:field xpath="mstns:EnumerationId" />
</xs:unique>
- <xs:unique name="Prefetch_Constraint1" msdata:ConstraintName="Constraint1" msdatarimaryKey="true
<xs:selector xpath=".//mstnsrefetch" />
<xs:field xpath="mstnsrefetchId" />
</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>[/code]
<br/>
<br/>
<
Manikandan Murugeshan
View the full article
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.
Dont 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<br/>
<br/>
System.Xml.XmlException: Data at the root level is invalid. Line 127, position 16.<br/>
at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)<br/>
at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace()<br/>
at System.Xml.XmlTextReaderImpl.ParseDocumentContent()<br/>
at System.Xml.XmlReader.ReadEndElement()<br/>
at System.Data.DataSet.ReadXml(XmlReader reader, Boolean denyResolving)<br/>
at System.Data.DataSet.ReadXml(String fileName)<br/>
at Kinship.IDERT.Audit.AuditMetaData..ctor(String tableName)<br/>
at Kinship.IDERT.Audit.AuditBuilderFactory.GetColumnAuditBuilders(DataSet dsToAudit, DataTable tableToAudit, Dictionary`2 paramValues)<br/>
at Kinship.IDERT.Audit.AuditEngine.AuditDataTable(DataSet dsToAudit, DataTable tableToAudit, Dictionary`2 paramValues, AuditDS auditXmlDS)<br/>
at Kinship.IDERT.Audit.AuditEngine.GetAuditXmlDS(DataSet dsToAudit, Dictionary`2 propertyValues)<br/>
********************************************************************************************************
<pre class="prettyprint <?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" msdatarimaryKey="true
<xs:selector xpath=".//mstns:ColumnDefinition" />
<xs:field xpath="mstns:ColumnName" />
</xs:unique>
- <xs:unique name="Enumeration_Constraint1" msdata:ConstraintName="Constraint1" msdatarimaryKey="true
<xs:selector xpath=".//mstns:Enumeration" />
<xs:field xpath="mstns:EnumerationId" />
</xs:unique>
- <xs:unique name="Prefetch_Constraint1" msdata:ConstraintName="Constraint1" msdatarimaryKey="true
<xs:selector xpath=".//mstnsrefetch" />
<xs:field xpath="mstnsrefetchId" />
</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>[/code]
<br/>
<br/>
<
Manikandan Murugeshan
View the full article