does not have a corresponding mapping in the schema

I am trying to update several tables using an Updategram. I get the followin
g
error:
HRESULT="0x80004005" Description="Specified attribute or element ('USR')
does not have a corresponding mapping in the schema, and no overflow field
defined"
The Schema is:
<?xml version="1.0" encoding="utf-8" ?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
<xsd:annotation>
<xsd:appinfo>
<sql:relationship name="USRMerge" parent="USR" parent-key="USRID"
child="MergeHdr" child-key="USRID" />
<sql:relationship name="MergeMergeList" parent="MergeHdr"
parent-key="MergeID" child="MergeList" child-key="MergeID" />
</xsd:appinfo>
</xsd:annotation>
<xsd:element name="USR" sql:relation="USR" sql:key-field="USRID">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="USRID" type="xsd:integer" nillable="true"
sql:identity="ignore" />
<xsd:element name="USRTitle" type="xsd:string" minOccurs="1" />
<xsd:element name="USRStatusID" type="xsd:integer" sql:datatype="int"
nillable="true" />
<xsd:element name="CSRID" type="xsd:integer" sql:datatype="int"
nillable="true" />
<xsd:element name="CustomerID" type="xsd:integer" sql:datatype="int"
nillable="true" />
<xsd:element name="CustUSRRef" type="xsd:string" nillable="true" />
<xsd:element name="CustContact" type="xsd:string" nillable="true" />
<xsd:element name="ProjectID" type="xsd:integer" sql:datatype="int"
nillable="true" />
<xsd:element name="ReleaseID" type="xsd:integer" sql:datatype="int"
nillable="true" />
<xsd:element name="ModuleID" type="xsd:integer" sql:datatype="int"
nillable="true" />
<xsd:element name="KeyWords" type="xsd:string" nillable="true"
sql:use-cdata="1" />
<xsd:element name="Expected" type="xsd:string" nillable="true"
sql:use-cdata="1" />
<xsd:element name="Observed" type="xsd:string" nillable="true"
sql:use-cdata="1" />
<xsd:element name="Steps" type="xsd:string" nillable="true" />
<xsd:element name="Billable" type="xsd:boolean" nillable="true"
default="false" />
<xsd:element name="IsFree" type="xsd:boolean" default="1" />
<xsd:element name="UserID" type="xsd:integer" sql:datatype="int"
minOccurs="1" />
<xsd:element name="VersionRef" type="xsd:string" nillable="true" />
<xsd:element name="ProductID" type="xsd:integer" nillable="true" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="MergeHdr" sql:relation="MergeHdr" sql:key-field="MergeID"
>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="MergeID" type="xsd:integer" nillable="true"
sql:identity="ignore" />
<xsd:element name="USRID" type="xsd:integer" nillable="true"
sql:datatype="int" />
<xsd:element name="ScreenChange" type="xsd:boolean" nillable="true"
default="false" />
<xsd:element name="Translation" type="xsd:boolean" nillable="true"
default="false" />
<xsd:element name="MenuChange" type="xsd:boolean" nillable="true"
default="false" />
<xsd:element name="SecurityChange" type="xsd:boolean" nillable="true"
default="false" />
<xsd:element name="JobSetupChange" type="xsd:boolean" nillable="true"
default="false" />
<xsd:element name="MessageFileChange" type="xsd:boolean" nillable="true"
default="false" />
<xsd:element name="ManualCodeTableChange" type="xsd:boolean"
nillable="true" default="false" />
<xsd:element name="DatabaseChange" type="xsd:boolean" nillable="true"
default="false" />
<xsd:element name="DictionaryChange" type="xsd:boolean" nillable="true"
default="false" />
<xsd:element name="DataBomb" type="xsd:boolean" nillable="true"
default="false" />
<xsd:element name="CoreReports" type="xsd:boolean" nillable="true"
default="false" />
<xsd:element name="PlanetPressJetForm" type="xsd:boolean"
nillable="true" default="false" />
<xsd:element name="ConfigurationFile" type="xsd:boolean" nillable="true"
default="false" />
<xsd:element name="XSLTFile" type="xsd:boolean" nillable="true"
default="false" />
<xsd:element name="SQLFile" type="xsd:boolean" nillable="true"
default="false" />
<xsd:element name="ExtractFile" type="xsd:boolean" nillable="true"
default="false" />
<xsd:element name="DevCompleteDate" type="xsd:dateTime" nillable="true"
sql:datatype="dateTime" />
<xsd:element name="TestCompleteDate" type="xsd:dateTime" nillable="true"
sql:datatype="dateTime" />
<xsd:element name="Notes" type="xsd:string" nillable="true"
sql:use-cdata="1" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="MergeList" sql:relation="MergeHdr"
sql:key-field="MergeListID">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="MergeListID" type="xsd:string" nillable="true"
sql:identity="ignore" />
<xsd:element name="MergeID" type="xsd:integer" nillable="true" />
<xsd:element name="Environment" type="xsd:string" nillable="true" />
<xsd:element name="CodeReviewUserID" type="xsd:integer" nillable="true" />
<xsd:element name="Patch" type="xsd:string" nillable="true" />
<xsd:element name="WhoMergedUserID" type="xsd:integer" nillable="true" />
<xsd:element name="DateMerged" type="xsd:dateTime"
sql:datatype="dateTime" nillable="true" />
<xsd:element name="TestImperialUserID" type="xsd:integer"
nillable="true" />
<xsd:element name="TestMetericUserID" type="xsd:integer" nillable="true"
/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>
The Update Gram is:
<root xmlns:updg="urn:schemas-microsoft-com:xml-updategram">
<sync mapping-schema="..\templates\USRMapSchema.xml"
xmlns="urn:schemas-microsoft-com:xml-updategram">
<updg:before>
<USR updg:id="USR1">
<USRID>1</USRID>
<USRTitle>New USR</USRTitle>
<Billable>false</Billable>
<IsFree>true</IsFree>
<UserID>1</UserID>
</USR>
</updg:before>
<updg:after>
<USR updg:id="USR1">
<USRID>1</USRID>
<USRTitle>updated title usr 1</USRTitle>
<Billable>false</Billable>
<IsFree>true</IsFree>
<UserID>1</UserID>
</USR>
</updg:after>
<updg:before>
<MergeHdr updg:id="MergeHdr1">
<MergeID>1</MergeID>
<USRID>1</USRID>
<ScreenChange>false</ScreenChange>
<Translation>false</Translation>
<MenuChange>false</MenuChange>
<SecurityChange>false</SecurityChange>
<JobSetupChange>false</JobSetupChange>
<MessageFileChange>false</MessageFileChange>
<ManualCodeTableChange>false</ManualCodeTableChange>
<DatabaseChange>false</DatabaseChange>
<DictionaryChange>false</DictionaryChange>
<DataBomb>false</DataBomb>
<CoreReports>false</CoreReports>
<PlanetPressJetForm>false</PlanetPressJetForm>
<ConfigurationFile>false</ConfigurationFile>
<XSLTFile>false</XSLTFile>
<SQLFile>false</SQLFile>
<ExtractFile>false</ExtractFile>
</MergeHdr>
</updg:before>
<updg:after>
<MergeHdr updg:id="MergeHdr1">
<MergeID>1</MergeID>
<USRID>1</USRID>
<ScreenChange>true</ScreenChange>
<Translation>true</Translation>
<MenuChange>true</MenuChange>
<SecurityChange>false</SecurityChange>
<JobSetupChange>false</JobSetupChange>
<MessageFileChange>false</MessageFileChange>
<ManualCodeTableChange>false</ManualCodeTableChange>
<DatabaseChange>false</DatabaseChange>
<DictionaryChange>false</DictionaryChange>
<DataBomb>false</DataBomb>
<CoreReports>false</CoreReports>
<PlanetPressJetForm>false</PlanetPressJetForm>
<ConfigurationFile>false</ConfigurationFile>
<XSLTFile>false</XSLTFile>
<SQLFile>false</SQLFile>
<ExtractFile>false</ExtractFile>
</MergeHdr>
</updg:after>
<updg:before>
<MergeList updg:id="MergeList1">
<MergeListID>1</MergeListID>
<MergeID>1</MergeID>
<DateMerged>2005-01-17T17:27:36.4470000-08:00</DateMerged>
</MergeList>
</updg:before>
<updg:after>
<MergeList updg:id="MergeList1">
<MergeListID>1</MergeListID>
<MergeID>1</MergeID>
<Environment>new item usr 1</Environment>
</MergeList>
</updg:after>
</sync>
</root>
Thanks in advance!In your updategram, you define a default namespase:

> xmlns="urn:schemas-microsoft-com:xml-updategram">
That will put all the elments to this namespace which is different than
declared in schema.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Squiggs" <Squiggs@.discussions.microsoft.com> wrote in message
news:5B75E7C4-CB9A-4707-82FF-C42034ED9D89@.microsoft.com...
> I am trying to update several tables using an Updategram. I get the
following
> error:
> HRESULT="0x80004005" Description="Specified attribute or element ('USR')
> does not have a corresponding mapping in the schema, and no overflow field
> defined"
> The Schema is:
> <?xml version="1.0" encoding="utf-8" ?>
> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
> <xsd:annotation>
> <xsd:appinfo>
> <sql:relationship name="USRMerge" parent="USR" parent-key="USRID"
> child="MergeHdr" child-key="USRID" />
> <sql:relationship name="MergeMergeList" parent="MergeHdr"
> parent-key="MergeID" child="MergeList" child-key="MergeID" />
> </xsd:appinfo>
> </xsd:annotation>
> <xsd:element name="USR" sql:relation="USR" sql:key-field="USRID">
> <xsd:complexType>
> <xsd:sequence>
> <xsd:element name="USRID" type="xsd:integer" nillable="true"
> sql:identity="ignore" />
> <xsd:element name="USRTitle" type="xsd:string" minOccurs="1" />
> <xsd:element name="USRStatusID" type="xsd:integer" sql:datatype="int"
> nillable="true" />
> <xsd:element name="CSRID" type="xsd:integer" sql:datatype="int"
> nillable="true" />
> <xsd:element name="CustomerID" type="xsd:integer" sql:datatype="int"
> nillable="true" />
> <xsd:element name="CustUSRRef" type="xsd:string" nillable="true" />
> <xsd:element name="CustContact" type="xsd:string" nillable="true" />
> <xsd:element name="ProjectID" type="xsd:integer" sql:datatype="int"
> nillable="true" />
> <xsd:element name="ReleaseID" type="xsd:integer" sql:datatype="int"
> nillable="true" />
> <xsd:element name="ModuleID" type="xsd:integer" sql:datatype="int"
> nillable="true" />
> <xsd:element name="KeyWords" type="xsd:string" nillable="true"
> sql:use-cdata="1" />
> <xsd:element name="Expected" type="xsd:string" nillable="true"
> sql:use-cdata="1" />
> <xsd:element name="Observed" type="xsd:string" nillable="true"
> sql:use-cdata="1" />
> <xsd:element name="Steps" type="xsd:string" nillable="true" />
> <xsd:element name="Billable" type="xsd:boolean" nillable="true"
> default="false" />
> <xsd:element name="IsFree" type="xsd:boolean" default="1" />
> <xsd:element name="UserID" type="xsd:integer" sql:datatype="int"
> minOccurs="1" />
> <xsd:element name="VersionRef" type="xsd:string" nillable="true" />
> <xsd:element name="ProductID" type="xsd:integer" nillable="true" />
> </xsd:sequence>
> </xsd:complexType>
> </xsd:element>
> <xsd:element name="MergeHdr" sql:relation="MergeHdr"
sql:key-field="MergeID">
> <xsd:complexType>
> <xsd:sequence>
> <xsd:element name="MergeID" type="xsd:integer" nillable="true"
> sql:identity="ignore" />
> <xsd:element name="USRID" type="xsd:integer" nillable="true"
> sql:datatype="int" />
> <xsd:element name="ScreenChange" type="xsd:boolean" nillable="true"
> default="false" />
> <xsd:element name="Translation" type="xsd:boolean" nillable="true"
> default="false" />
> <xsd:element name="MenuChange" type="xsd:boolean" nillable="true"
> default="false" />
> <xsd:element name="SecurityChange" type="xsd:boolean" nillable="true"
> default="false" />
> <xsd:element name="JobSetupChange" type="xsd:boolean" nillable="true"
> default="false" />
> <xsd:element name="MessageFileChange" type="xsd:boolean" nillable="true"
> default="false" />
> <xsd:element name="ManualCodeTableChange" type="xsd:boolean"
> nillable="true" default="false" />
> <xsd:element name="DatabaseChange" type="xsd:boolean" nillable="true"
> default="false" />
> <xsd:element name="DictionaryChange" type="xsd:boolean" nillable="true"
> default="false" />
> <xsd:element name="DataBomb" type="xsd:boolean" nillable="true"
> default="false" />
> <xsd:element name="CoreReports" type="xsd:boolean" nillable="true"
> default="false" />
> <xsd:element name="PlanetPressJetForm" type="xsd:boolean"
> nillable="true" default="false" />
> <xsd:element name="ConfigurationFile" type="xsd:boolean" nillable="true"
> default="false" />
> <xsd:element name="XSLTFile" type="xsd:boolean" nillable="true"
> default="false" />
> <xsd:element name="SQLFile" type="xsd:boolean" nillable="true"
> default="false" />
> <xsd:element name="ExtractFile" type="xsd:boolean" nillable="true"
> default="false" />
> <xsd:element name="DevCompleteDate" type="xsd:dateTime" nillable="true"
> sql:datatype="dateTime" />
> <xsd:element name="TestCompleteDate" type="xsd:dateTime" nillable="true"
> sql:datatype="dateTime" />
> <xsd:element name="Notes" type="xsd:string" nillable="true"
> sql:use-cdata="1" />
> </xsd:sequence>
> </xsd:complexType>
> </xsd:element>
> <xsd:element name="MergeList" sql:relation="MergeHdr"
> sql:key-field="MergeListID">
> <xsd:complexType>
> <xsd:sequence>
> <xsd:element name="MergeListID" type="xsd:string" nillable="true"
> sql:identity="ignore" />
> <xsd:element name="MergeID" type="xsd:integer" nillable="true" />
> <xsd:element name="Environment" type="xsd:string" nillable="true" />
> <xsd:element name="CodeReviewUserID" type="xsd:integer" nillable="true" />
> <xsd:element name="Patch" type="xsd:string" nillable="true" />
> <xsd:element name="WhoMergedUserID" type="xsd:integer" nillable="true" />
> <xsd:element name="DateMerged" type="xsd:dateTime"
> sql:datatype="dateTime" nillable="true" />
> <xsd:element name="TestImperialUserID" type="xsd:integer"
> nillable="true" />
> <xsd:element name="TestMetericUserID" type="xsd:integer" nillable="true"
> />
> </xsd:sequence>
> </xsd:complexType>
> </xsd:element>
> </xsd:schema>
> The Update Gram is:
> <root xmlns:updg="urn:schemas-microsoft-com:xml-updategram">
> <sync mapping-schema="..\templates\USRMapSchema.xml"
> xmlns="urn:schemas-microsoft-com:xml-updategram">
> <updg:before>
> <USR updg:id="USR1">
> <USRID>1</USRID>
> <USRTitle>New USR</USRTitle>
> <Billable>false</Billable>
> <IsFree>true</IsFree>
> <UserID>1</UserID>
> </USR>
> </updg:before>
> <updg:after>
> <USR updg:id="USR1">
> <USRID>1</USRID>
> <USRTitle>updated title usr 1</USRTitle>
> <Billable>false</Billable>
> <IsFree>true</IsFree>
> <UserID>1</UserID>
> </USR>
> </updg:after>
> <updg:before>
> <MergeHdr updg:id="MergeHdr1">
> <MergeID>1</MergeID>
> <USRID>1</USRID>
> <ScreenChange>false</ScreenChange>
> <Translation>false</Translation>
> <MenuChange>false</MenuChange>
> <SecurityChange>false</SecurityChange>
> <JobSetupChange>false</JobSetupChange>
> <MessageFileChange>false</MessageFileChange>
> <ManualCodeTableChange>false</ManualCodeTableChange>
> <DatabaseChange>false</DatabaseChange>
> <DictionaryChange>false</DictionaryChange>
> <DataBomb>false</DataBomb>
> <CoreReports>false</CoreReports>
> <PlanetPressJetForm>false</PlanetPressJetForm>
> <ConfigurationFile>false</ConfigurationFile>
> <XSLTFile>false</XSLTFile>
> <SQLFile>false</SQLFile>
> <ExtractFile>false</ExtractFile>
> </MergeHdr>
> </updg:before>
> <updg:after>
> <MergeHdr updg:id="MergeHdr1">
> <MergeID>1</MergeID>
> <USRID>1</USRID>
> <ScreenChange>true</ScreenChange>
> <Translation>true</Translation>
> <MenuChange>true</MenuChange>
> <SecurityChange>false</SecurityChange>
> <JobSetupChange>false</JobSetupChange>
> <MessageFileChange>false</MessageFileChange>
> <ManualCodeTableChange>false</ManualCodeTableChange>
> <DatabaseChange>false</DatabaseChange>
> <DictionaryChange>false</DictionaryChange>
> <DataBomb>false</DataBomb>
> <CoreReports>false</CoreReports>
> <PlanetPressJetForm>false</PlanetPressJetForm>
> <ConfigurationFile>false</ConfigurationFile>
> <XSLTFile>false</XSLTFile>
> <SQLFile>false</SQLFile>
> <ExtractFile>false</ExtractFile>
> </MergeHdr>
> </updg:after>
> <updg:before>
> <MergeList updg:id="MergeList1">
> <MergeListID>1</MergeListID>
> <MergeID>1</MergeID>
> <DateMerged>2005-01-17T17:27:36.4470000-08:00</DateMerged>
> </MergeList>
> </updg:before>
> <updg:after>
> <MergeList updg:id="MergeList1">
> <MergeListID>1</MergeListID>
> <MergeID>1</MergeID>
> <Environment>new item usr 1</Environment>
> </MergeList>
> </updg:after>
> </sync>
> </root>
> Thanks in advance!