parent/child table error in sqlxml

When I try to select with sqlxml I recevie the following error related to on
e
relationship that has a composite key (all none composite key relationships
work).
Schema: the parent/child table of the relationship on
'ProductMetricsBreakDown' does not match.
The xsd is included that is causing the error is included
It is the AnnualBusinessModel_ProductMetricsBreakD
own that is giving me the
error.
Any help would be greatly appreciated.
<?xml version="1.0" encoding="utf-8"?>
<xs:schema elementFormDefault="qualified"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
<xs:annotation>
<xs:appinfo>
<sql:relationship name=" MicrosoftPartnerProfile_AnnualBusinessMo
del"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="AnnualBusinessModel" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_Branch"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Branch"
child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_BusinessFocus"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="BusinessFocus
"
child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_FormUI"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="FormUI"
child-key="AccountID" />
<sql:relationship name=" MicrosoftPartnerProfile_LinksToOtherDocu
ments"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="LinksToOtherDocuments" child-key="AccountID" />
<sql:relationship name=" MicrosoftPartnerProfile_NotesAndConditio
ns"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="NotesAndConditions" child-key="AccountID" />
<sql:relationship name=" MicrosoftPartnerProfile_PartnerAssessmen
t"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerAssessment" child-key="AccountID" />
<sql:relationship name=" MicrosoftPartnerProfile_PartnerCompetenc
y"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerCompetency" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_PartnerGTM"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="PartnerGTM"
child-key="AccountID" />
<sql:relationship name=" MicrosoftPartnerProfile_PartnerIndustryV
ertical"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerIndustryVertical" child-key="AccountID" />
<sql:relationship name=" MicrosoftPartnerProfile_PartnerSalesVert
ical"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerSalesVertical" child-key="AccountID" />
<sql:relationship name=" MicrosoftPartnerProfile_PartnerSpecializ
ation"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerSpecialization" child-key="AccountID" />
<sql:relationship name=" MicrosoftPartnerProfile_RevenueBreakdown
"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="RevenueBreakdown" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_Contact"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Contact"
child-key="AccountID" />
<sql:relationship name=" AnnualBusinessModel_ProductMetricsBreakD
own"
parent="AnnualBusinessModel" parent-key="AccountID CalendarYear"
child="ProductMetricsBreakDown" child-key="AccountID CalendarYear" />
<!--<sql:relationship name=" AnnualBusinessModel_ProductMetricsBreakD
own"
parent="AnnualBusinessModel" parent-key="CalendarYear"
child="ProductMetricsBreakDown" child-key="CalendarYear" /> -->
<!--
<sql:relationship name=" AnnualBusinessModel_ProductMetricsBreakD
own"
parent="AnnualBusinessModel" parent-key="AccountID CalendarYear"
child="ProductMetricsBreakDown" child-key="AccountID CalendarYear" />
<sql:relationship name="RevenueBreakdown_RevenueBreakdownDetail"
parent="RevenueBreakdown" parent-key="AccountID BusinessSectionID
CalendarYear" child="RevenueBreakdownDetail" child-key="AccountID
BusinessSectionID CalendarYear" />
-->
</xs:appinfo>
</xs:annotation>
<xs:element name="MicrosoftPartnerProfile"
sql:relation="MicrosoftPartnerProfile">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="NativeID" sql:field="NativeID" sql:datatype="int" />
<xs:element name="CertificationTierLevelID"
sql:field="CertificationTierLevelID" sql:datatype="varchar" />
<xs:element name="CompanyName" sql:field="CompanyName"
sql:datatype="varchar" />
<xs:element name="DoingBusinessAsName" sql:field="DoingBusinessAsName"
sql:datatype="varchar" />
<xs:element name="GeographicAreaID" sql:field="GeographicAreaID"
sql:datatype="int" />
<xs:element name="Region" sql:field="Region" sql:datatype="varchar" />
<xs:element name="District" sql:field="District" sql:datatype="varchar" />
<xs:element name="MatrixID" sql:field="MatrixID" sql:datatype="int" />
<xs:element name="NumberOfEmployees" sql:field="NumberOfEmployees"
sql:datatype="int" />
<xs:element name="NumberOfSalesProfessionals"
sql:field="NumberOfSalesProfessionals" sql:datatype="int" />
<xs:element name="NumberOfEmployeesPerUPP"
sql:field="NumberOfEmployeesPerUPP" sql:datatype="varchar" />
<xs:element name="NumberOfTechProfessionals"
sql:field="NumberOfTechProfessionals" sql:datatype="int" />
<xs:element name="OrgHQLocationIndicator"
sql:field="OrgHQLocationIndicator" sql:datatype="varchar" />
<xs:element name="NumberOfSalesProfessionalsPerUPP"
sql:field="NumberOfSalesProfessionalsPerUPP" sql:datatype="varchar" />
<xs:element name="GlobalPartner" sql:field="GlobalPartner"
sql:datatype="varchar" />
<xs:element name="ActiveFlag" sql:field="ActiveFlag"
sql:datatype="varchar" />
<xs:element name="NumberOfTechProfessionalsPerUPP"
sql:field="NumberOfTechProfessionalsPerUPP" sql:datatype="varchar" />
<xs:element name="MSOrganizationID" sql:field="MSOrganizationID"
sql:datatype="int" />
<xs:element name="Seg_1_49_Percent" sql:field="Seg_1_49_Percent"
sql:datatype="decimal" />
<xs:element name="Seg_50_999_Percent" sql:field="Seg_50_999_Percent"
sql:datatype="decimal" />
<xs:element name="Seg_1000_14999_Percent"
sql:field="Seg_1000_14999_Percent" sql:datatype="decimal" />
<xs:element name="Seg_15000_Percent" sql:field="Seg_15000_Percent"
sql:datatype="decimal" />
<xs:element name="AddressLine1" sql:field="AddressLine1"
sql:datatype="varchar" />
<xs:element name="AddressLine2" sql:field="AddressLine2"
sql:datatype="varchar" />
<xs:element name="City" sql:field="City" sql:datatype="varchar" />
<xs:element name="PostalCode" sql:field="PostalCode"
sql:datatype="varchar" />
<xs:element name="StateProvinceId" sql:field="StateProvinceId"
sql:datatype="varchar" />
<xs:element name="Phone" sql:field="Phone" sql:datatype="varchar" />
<xs:element name="SiebelID" sql:field="SiebelID" sql:datatype="int" />
<xs:element name="StatusID" sql:field="StatusID" sql:datatype="varchar" />
<xs:element name="ProfileDueDate" sql:field="ProfileDueDate"
sql:datatype="datetime" />
<xs:element name="ManagedBy" sql:field="ManagedBy"
sql:datatype="varchar" />
<xs:element name="ParentAccountID" sql:field="ParentAccountID"
sql:datatype="int" />
<xs:element name="UPPID" sql:field="UPPID" sql:datatype="int" />
<xs:element name="LastModifiedBy" sql:field="LastModifiedBy"
sql:datatype="varchar" />
<xs:element name="LastModifiedDate" sql:field="LastModifiedDate"
sql:datatype="datetime" />
<xs:element name="ParentUPPId" sql:field="ParentUPPId"
sql:datatype="int" />
<xs:element name="CustomCampaign" sql:field="CustomCampaign"
sql:datatype="varchar" />
<xs:element name="PartnerSalesVertical"
sql:relation="PartnerSalesVertical"
sql:relationship=" MicrosoftPartnerProfile_PartnerSalesVert
ical"
maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="SalesVerticalID" sql:field="SalesVerticalID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerIndustryVertical"
sql:relation="PartnerIndustryVertical"
sql:relationship=" MicrosoftPartnerProfile_PartnerIndustryV
ertical"
maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="IndustryVerticalID" sql:field="IndustryVerticalID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerGTM" sql:relation="PartnerGTM"
sql:relationship="MicrosoftPartnerProfile_PartnerGTM" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="GTMFocusID" sql:field="GTMFocusID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerCompetency" sql:relation="PartnerCompetency"
sql:relationship=" MicrosoftPartnerProfile_PartnerCompetenc
y"
maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CompetencyID" sql:field="CompetencyID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="FormUI" sql:relation="FormUI"
sql:relationship="MicrosoftPartnerProfile_FormUI" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CompetencyCheckMode"
sql:field="CompetencyCheckMode" sql:datatype="varchar" />
<xs:element name="SpecializationCheckModel"
sql:field="SpecializationCheckModel" sql:datatype="varchar" />
<xs:element name="ProductsCheckMode" sql:field="ProductsCheckMode"
sql:datatype="varchar" />
<xs:element name="IndustryVerticalsCheckMode"
sql:field="IndustryVerticalsCheckMode" sql:datatype="varchar" />
<xs:element name="MBSVerticalsCheckMode"
sql:field="MBSVerticalsCheckMode" sql:datatype="varchar" />
<xs:element name="GTMSCheckMode" sql:field="GTMSCheckMode"
sql:datatype="varchar" />
<xs:element name="AssessmentsCheckMode"
sql:field="AssessmentsCheckMode" sql:datatype="varchar" />
<xs:element name="AnnualBusinessCurrentMode"
sql:field="AnnualBusinessCurrentMode" sql:datatype="varchar" />
<xs:element name="BusinessPlanCurrentMode"
sql:field="BusinessPlanCurrentMode" sql:datatype="varchar" />
<xs:element name="NavProfileStatus" sql:field="NavProfileStatus"
sql:datatype="varchar" />
<xs:element name="NavCoreInformation" sql:field="NavCoreInformation"
sql:datatype="varchar" />
<xs:element name="NavBusinessFocus" sql:field="NavBusinessFocus"
sql:datatype="varchar" />
<xs:element name="NavContact" sql:field="NavContact"
sql:datatype="varchar" />
<xs:element name="NavBranch" sql:field="NavBranch"
sql:datatype="varchar" />
<xs:element name="NavCompetency" sql:field="NavCompetency"
sql:datatype="varchar" />
<xs:element name="NavSpecialization" sql:field="NavSpecialization"
sql:datatype="varchar" />
<xs:element name="NavIndustryVert" sql:field="NavIndustryVert"
sql:datatype="varchar" />
<xs:element name="NavMBSVert" sql:field="NavMBSVert"
sql:datatype="varchar" />
<xs:element name="NavRevSummary" sql:field="NavRevSummary"
sql:datatype="varchar" />
<xs:element name="NavConditions" sql:field="NavConditions"
sql:datatype="varchar" />
<xs:element name="NavRhythm" sql:field="NavRhythm"
sql:datatype="varchar" />
<xs:element name="NavCampaigns" sql:field="NavCampaigns"
sql:datatype="varchar" />
<xs:element name="NavAssessments" sql:field="NavAssessments"
sql:datatype="varchar" />
<xs:element name="NavLinks" sql:field="NavLinks"
sql:datatype="varchar" />
<xs:element name="NavProducts" sql:field="NavProducts"
sql:datatype="varchar" />
<xs:element name="NavPlanStatus" sql:field="NavPlanStatus"
sql:datatype="varchar" />
<xs:element name="NavGoalSummary" sql:field="NavGoalSummary"
sql:datatype="varchar" />
<xs:element name="NavInvestments" sql:field="NavInvestments"
sql:datatype="varchar" />
<xs:element name="NavSolutionPlan" sql:field="NavSolutionPlan"
sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="LinksToOtherDocuments"
sql:relation="LinksToOtherDocuments"
sql:relationship=" MicrosoftPartnerProfile_LinksToOtherDocu
ments">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="DocumentUrl" sql:field="DocumentUrl"
sql:datatype="varchar" />
<xs:element name="DocumentTitle" sql:field="DocumentTitle"
sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="NotesAndConditions" sql:relation="NotesAndConditions"
sql:relationship=" MicrosoftPartnerProfile_NotesAndConditio
ns">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="MeetingFrequencyID" sql:field="MeetingFrequencyID"
sql:datatype="int" />
<xs:element name="ConditionsOfSatisfaction"
sql:field="ConditionsOfSatisfaction" sql:datatype="varchar" />
<xs:element name="Notes" sql:field="Notes" sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerAssessment" sql:relation="PartnerAssessment"
sql:relationship=" MicrosoftPartnerProfile_PartnerAssessmen
t">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="AssessmentTypeID" sql:field="AssessmentTypeID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AnnualBusinessModel"
sql:relation="AnnualBusinessModel"
sql:relationship=" MicrosoftPartnerProfile_AnnualBusinessMo
del">
<xs:complexType>
<xs:sequence>
<xs:element name="PartnerFiscalYearEndDate"
sql:field="PartnerFiscalYearEndDate" sql:datatype="datetime" />
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CalendarYear" sql:field="CalendarYear"
sql:datatype="int" />
<xs:element name="AnnualRevenueInMillions"
sql:field="AnnualRevenueInMillions" sql:datatype="decimal" />
<xs:element name="RevenueGrowthPercentYOY"
sql:field="RevenueGrowthPercentYOY" sql:datatype="decimal" />
<xs:element name="AnnualRevenuePerUPP"
sql:field="AnnualRevenuePerUPP" sql:datatype="decimal" />
<xs:element name="AnnualMSRevenueInMillions"
sql:field="AnnualMSRevenueInMillions" sql:datatype="decimal" />
<xs:element name="AnnualSoftMSRevenuePerUPP"
sql:field="AnnualSoftMSRevenuePerUPP" sql:datatype="decimal" />
<xs:element name="MSRevenueGrowthPercentYOY"
sql:field="MSRevenueGrowthPercentYOY" sql:datatype="decimal" />
<xs:element name="PercentCRM" sql:field="PercentCRM"
sql:datatype="decimal" />
<xs:element name="PercentERP" sql:field="PercentERP"
sql:datatype="decimal" />
<xs:element name="HighlightedProductSubcategoryID"
sql:field="HighlightedProductSubcategoryID" sql:datatype="int" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="BusinessFocus" sql:relation="BusinessFocus"
sql:relationship="MicrosoftPartnerProfile_BusinessFocus">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="BluePrintQuadrantID"
sql:field="BluePrintQuadrantID" sql:datatype="int" />
<xs:element name="PartnerTypeID" sql:field="PartnerTypeID"
sql:datatype="varchar" />
<xs:element name="DistrictPref1" sql:field="DistrictPref1"
sql:datatype="int" />
<xs:element name="DistrictPref2" sql:field="DistrictPref2"
sql:datatype="int" />
<xs:element name="DistrictPref3" sql:field="DistrictPref3"
sql:datatype="int" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerSpecialization"
sql:relation="PartnerSpecialization"
sql:relationship=" MicrosoftPartnerProfile_PartnerSpecializ
ation">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="SpecializationID" sql:field="SpecializationID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ProductMetricsBreakDown"
sql:relation="ProductMetricsBreakDown"
sql:relationship=" AnnualBusinessModel_ProductMetricsBreakD
own" >
<xs:complexType>
<xs:sequence>
<xs:element name="MetricId" sql:field="MetricId" sql:datatype="int" />
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CalendarYear" sql:field="CalendarYear"
sql:datatype="int" />
<xs:element name="ProductSubCategoryID"
sql:field="ProductSubCategoryID" sql:datatype="int" />
<xs:element name="MetricName" sql:field="MetricName"
sql:datatype="varchar" />
<xs:element name="ProductSubcategoryName"
sql:field="ProductSubcategoryName" sql:datatype="varchar" />
<xs:element name="Half1MSGoal" sql:field="Half1MSGoal"
sql:datatype="decimal" />
<xs:element name="Half1NonMSGoal" sql:field="Half1NonMSGoal"
sql:datatype="decimal" />
<xs:element name="Half1MSActual" sql:field="Half1MSActual"
sql:datatype="decimal" />
<xs:element name="Half1NonMSActual" sql:field="Half1NonMSActual"
sql:datatype="decimal" />
<xs:element name="Half2MSGoal" sql:field="Half2MSGoal"
sql:datatype="decimal" />
<xs:element name="Half2NonMSGoal" sql:field="Half2NonMSGoal"
sql:datatype="decimal" />
<xs:element name="Half2MSActual" sql:field="Half2MSActual"
sql:datatype="decimal" />
<xs:element name="Half2NonMSActual" sql:field="Half2NonMSActual"
sql:datatype="decimal" />
<xs:element name="Total" sql:field="Total" sql:datatype="decimal" />
<xs:element name="TotalPercentage" sql:field="TotalPercentage"
sql:datatype="decimal" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Branch" sql:relation="Branch"
sql:relationship="MicrosoftPartnerProfile_Branch">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="BranchAccountID" sql:field="BranchAccountID"
sql:datatype="nvarchar" />
<xs:element name="ExecuteOnLocalMarketingCampaigns"
sql:field="ExecuteOnLocalMarketingCampaigns" sql:datatype="varchar" />
<xs:element name="BusinessSectionID" sql:field="BusinessSectionID"
sql:datatype="int" />
<xs:element name="BusinessSectionID1" sql:field="BusinessSectionID1"
sql:datatype="int" />
<xs:element name="BusinessSectionID2" sql:field="BusinessSectionID2"
sql:datatype="int" />
<xs:element name="EngagementTypeID" sql:field="EngagementTypeID"
sql:datatype="int" />
<xs:element name="EngagementTypeID1" sql:field="EngagementTypeID1"
sql:datatype="int" />
<xs:element name="EngagementTypeID2" sql:field="EngagementTypeID2"
sql:datatype="int" />
<xs:element name="ExecuteOnMSOpportunityForecasting"
sql:field="ExecuteOnMSOpportunityForecasting" sql:datatype="varchar" />
<xs:element name="AddressLine1" sql:field="AddressLine1"
sql:datatype="varchar" />
<xs:element name="SubDistrictID" sql:field="SubDistrictID"
sql:datatype="int" />
<xs:element name="City" sql:field="City" sql:datatype="varchar" />
<xs:element name="StateProvinceID" sql:field="StateProvinceID"
sql:datatype="varchar" />
<xs:element name="PostalCode" sql:field="PostalCode"
sql:datatype="varchar" />
<xs:element name="NumberOfLocalSalesProfessionals"
sql:field="NumberOfLocalSalesProfessionals" sql:datatype="int" />
<xs:element name="NumberOfLocalTechProfessionals"
sql:field="NumberOfLocalTechProfessionals" sql:datatype="int" />
<xs:element name="BranchName" sql:field="BranchName"
sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>
<!--
<xs:element name="RevenueBreakdown" sql:relation="RevenueBreakdown">
<xs:complexType>
<xs:sequence>
<xs:element name="BusinessSectionID" sql:field="BusinessSectionID"
sql:datatype="int" />
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CalendarYear" sql:field="CalendarYear"
sql:datatype="int" />
<xs:element name="PercentMS" sql:field="PercentMS"
sql:datatype="decimal" />
<xs:element name="PercentNonMS" sql:field="PercentNonMS"
sql:datatype="decimal" />
<xs:element name="PercentOfTotal" sql:field="PercentOfTotal"
sql:datatype="decimal" />
<xs:element name="ChildrenVisible" sql:field="ChildrenVisible"
sql:datatype="varchar" />
<xs:element name="RevenueBreakdownDetail"
sql:relation="RevenueBreakdownDetail"
sql:relationship="RevenueBreakdown_RevenueBreakdownDetail"
maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="BusinessSubsectionID"
sql:field="BusinessSubsectionID" sql:datatype="int" />
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="BusinessSectionID" sql:field="BusinessSectionID"
sql:datatype="int" />
<xs:element name="CalendarYear" sql:field="CalendarYear"
sql:datatype="int" />
<xs:element name="PercentMS" sql:field="PercentMS"
sql:datatype="decimal" />
<xs:element name="PercentNonMS" sql:field="PercentNonMS"
sql:datatype="decimal" />
<xs:element name="PercentOfTotal" sql:field="PercentOfTotal"
sql:datatype="decimal" />
<xs:element name="ChildrenVisible" sql:field="ChildrenVisible"
sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
-->
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>I resolved the problem. Since this productmetrics table was a child of the
annualbusinessmodel table, it had to be nested in the schema.
:>
"jb" wrote:
> When I try to select with sqlxml I recevie the following error related to
one
> relationship that has a composite key (all none composite key relationship
s
> work).
> Schema: the parent/child table of the relationship on
> 'ProductMetricsBreakDown' does not match.
> The xsd is included that is causing the error is included
> It is the AnnualBusinessModel_ProductMetricsBreakD
own that is giving me th
e
> error.
> Any help would be greatly appreciated.
> <?xml version="1.0" encoding="utf-8"?>
> <xs:schema elementFormDefault="qualified"
> xmlns:xs="http://www.w3.org/2001/XMLSchema"
> xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
> <xs:annotation>
> <xs:appinfo>
> <sql:relationship name=" MicrosoftPartnerProfile_AnnualBusinessMo
del"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="AnnualBusinessModel" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_Branch"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Branch"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_BusinessFocus"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="BusinessFoc
us"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_FormUI"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="FormUI"
> child-key="AccountID" />
> <sql:relationship name=" MicrosoftPartnerProfile_LinksToOtherDocu
ments"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="LinksToOtherDocuments" child-key="AccountID" />
> <sql:relationship name=" MicrosoftPartnerProfile_NotesAndConditio
ns"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="NotesAndConditions" child-key="AccountID" />
> <sql:relationship name=" MicrosoftPartnerProfile_PartnerAssessmen
t"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerAssessment" child-key="AccountID" />
> <sql:relationship name=" MicrosoftPartnerProfile_PartnerCompetenc
y"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerCompetency" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerGTM"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="PartnerGTM"
> child-key="AccountID" />
> <sql:relationship name=" MicrosoftPartnerProfile_PartnerIndustryV
ertical
"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerIndustryVertical" child-key="AccountID" />
> <sql:relationship name=" MicrosoftPartnerProfile_PartnerSalesVert
ical"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerSalesVertical" child-key="AccountID" />
> <sql:relationship name=" MicrosoftPartnerProfile_PartnerSpecializ
ation"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerSpecialization" child-key="AccountID" />
> <sql:relationship name=" MicrosoftPartnerProfile_RevenueBreakdown
"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="RevenueBreakdown" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_Contact"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Contact"
> child-key="AccountID" />
> <sql:relationship name=" AnnualBusinessModel_ProductMetricsBreakD
own"
> parent="AnnualBusinessModel" parent-key="AccountID CalendarYear"
> child="ProductMetricsBreakDown" child-key="AccountID CalendarYear" />
> <!--<sql:relationship name=" AnnualBusinessModel_ProductMetricsBreakD
own
"
> parent="AnnualBusinessModel" parent-key="CalendarYear"
> child="ProductMetricsBreakDown" child-key="CalendarYear" /> -->
> <!--
> <sql:relationship name=" AnnualBusinessModel_ProductMetricsBreakD
own"
> parent="AnnualBusinessModel" parent-key="AccountID CalendarYear"
> child="ProductMetricsBreakDown" child-key="AccountID CalendarYear" />
> <sql:relationship name="RevenueBreakdown_RevenueBreakdownDetail"
> parent="RevenueBreakdown" parent-key="AccountID BusinessSectionID
> CalendarYear" child="RevenueBreakdownDetail" child-key="AccountID
> BusinessSectionID CalendarYear" />
> -->
> </xs:appinfo>
> </xs:annotation>
> <xs:element name="MicrosoftPartnerProfile"
> sql:relation="MicrosoftPartnerProfile">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="NativeID" sql:field="NativeID" sql:datatype="int" />
> <xs:element name="CertificationTierLevelID"
> sql:field="CertificationTierLevelID" sql:datatype="varchar" />
> <xs:element name="CompanyName" sql:field="CompanyName"
> sql:datatype="varchar" />
> <xs:element name="DoingBusinessAsName" sql:field="DoingBusinessAsName"
> sql:datatype="varchar" />
> <xs:element name="GeographicAreaID" sql:field="GeographicAreaID"
> sql:datatype="int" />
> <xs:element name="Region" sql:field="Region" sql:datatype="varchar" />
> <xs:element name="District" sql:field="District" sql:datatype="varchar
" />
> <xs:element name="MatrixID" sql:field="MatrixID" sql:datatype="int" />
> <xs:element name="NumberOfEmployees" sql:field="NumberOfEmployees"
> sql:datatype="int" />
> <xs:element name="NumberOfSalesProfessionals"
> sql:field="NumberOfSalesProfessionals" sql:datatype="int" />
> <xs:element name="NumberOfEmployeesPerUPP"
> sql:field="NumberOfEmployeesPerUPP" sql:datatype="varchar" />
> <xs:element name="NumberOfTechProfessionals"
> sql:field="NumberOfTechProfessionals" sql:datatype="int" />
> <xs:element name="OrgHQLocationIndicator"
> sql:field="OrgHQLocationIndicator" sql:datatype="varchar" />
> <xs:element name="NumberOfSalesProfessionalsPerUPP"
> sql:field="NumberOfSalesProfessionalsPerUPP" sql:datatype="varchar" />
> <xs:element name="GlobalPartner" sql:field="GlobalPartner"
> sql:datatype="varchar" />
> <xs:element name="ActiveFlag" sql:field="ActiveFlag"
> sql:datatype="varchar" />
> <xs:element name="NumberOfTechProfessionalsPerUPP"
> sql:field="NumberOfTechProfessionalsPerUPP" sql:datatype="varchar" />
> <xs:element name="MSOrganizationID" sql:field="MSOrganizationID"
> sql:datatype="int" />
> <xs:element name="Seg_1_49_Percent" sql:field="Seg_1_49_Percent"
> sql:datatype="decimal" />
> <xs:element name="Seg_50_999_Percent" sql:field="Seg_50_999_Percent"
> sql:datatype="decimal" />
> <xs:element name="Seg_1000_14999_Percent"
> sql:field="Seg_1000_14999_Percent" sql:datatype="decimal" />
> <xs:element name="Seg_15000_Percent" sql:field="Seg_15000_Percent"
> sql:datatype="decimal" />
> <xs:element name="AddressLine1" sql:field="AddressLine1"
> sql:datatype="varchar" />
> <xs:element name="AddressLine2" sql:field="AddressLine2"
> sql:datatype="varchar" />
> <xs:element name="City" sql:field="City" sql:datatype="varchar" />
> <xs:element name="PostalCode" sql:field="PostalCode"
> sql:datatype="varchar" />
> <xs:element name="StateProvinceId" sql:field="StateProvinceId"
> sql:datatype="varchar" />
> <xs:element name="Phone" sql:field="Phone" sql:datatype="varchar" />
> <xs:element name="SiebelID" sql:field="SiebelID" sql:datatype="int" />
> <xs:element name="StatusID" sql:field="StatusID" sql:datatype="varchar
" />
> <xs:element name="ProfileDueDate" sql:field="ProfileDueDate"
> sql:datatype="datetime" />
> <xs:element name="ManagedBy" sql:field="ManagedBy"
> sql:datatype="varchar" />
> <xs:element name="ParentAccountID" sql:field="ParentAccountID"
> sql:datatype="int" />
> <xs:element name="UPPID" sql:field="UPPID" sql:datatype="int" />
> <xs:element name="LastModifiedBy" sql:field="LastModifiedBy"
> sql:datatype="varchar" />
> <xs:element name="LastModifiedDate" sql:field="LastModifiedDate"
> sql:datatype="datetime" />
> <xs:element name="ParentUPPId" sql:field="ParentUPPId"
> sql:datatype="int" />
> <xs:element name="CustomCampaign" sql:field="CustomCampaign"
> sql:datatype="varchar" />
> <xs:element name="PartnerSalesVertical"
> sql:relation="PartnerSalesVertical"
> sql:relationship=" MicrosoftPartnerProfile_PartnerSalesVert
ical"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="SalesVerticalID" sql:field="SalesVerticalID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varcha
r"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerIndustryVertical"
> sql:relation="PartnerIndustryVertical"
> sql:relationship=" MicrosoftPartnerProfile_PartnerIndustryV
ertical"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="IndustryVerticalID" sql:field="IndustryVerticalID
"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varcha
r"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerGTM" sql:relation="PartnerGTM"
> sql:relationship="MicrosoftPartnerProfile_PartnerGTM" maxOccurs="unbounded
">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="GTMFocusID" sql:field="GTMFocusID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varcha
r"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerCompetency" sql:relation="PartnerCompetency"
> sql:relationship=" MicrosoftPartnerProfile_PartnerCompetenc
y"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="CompetencyID" sql:field="CompetencyID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varcha
r"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="FormUI" sql:relation="FormUI"
> sql:relationship="MicrosoftPartnerProfile_FormUI" maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="CompetencyCheckMode"
> sql:field="CompetencyCheckMode" sql:datatype="varchar" />
> <xs:element name="SpecializationCheckModel"
> sql:field="SpecializationCheckModel" sql:datatype="varchar" />
> <xs:element name="ProductsCheckMode" sql:field="ProductsCheckMode"
> sql:datatype="varchar" />
> <xs:element name="IndustryVerticalsCheckMode"
> sql:field="IndustryVerticalsCheckMode" sql:datatype="varchar" />
> <xs:element name="MBSVerticalsCheckMode"
> sql:field="MBSVerticalsCheckMode" sql:datatype="varchar" />
> <xs:element name="GTMSCheckMode" sql:field="GTMSCheckMode"
> sql:datatype="varchar" />
> <xs:element name="AssessmentsCheckMode"
> sql:field="AssessmentsCheckMode" sql:datatype="varchar" />
> <xs:element name="AnnualBusinessCurrentMode"
> sql:field="AnnualBusinessCurrentMode" sql:datatype="varchar" />
> <xs:element name="BusinessPlanCurrentMode"
> sql:field="BusinessPlanCurrentMode" sql:datatype="varchar" />
> <xs:element name="NavProfileStatus" sql:field="NavProfileStatus"
> sql:datatype="varchar" />
> <xs:element name="NavCoreInformation" sql:field="NavCoreInformation
"
> sql:datatype="varchar" />
> <xs:element name="NavBusinessFocus" sql:field="NavBusinessFocus"
> sql:datatype="varchar" />
> <xs:element name="NavContact" sql:field="NavContact"
> sql:datatype="varchar" />
> <xs:element name="NavBranch" sql:field="NavBranch"
> sql:datatype="varchar" />
> <xs:element name="NavCompetency" sql:field="NavCompetency"
> sql:datatype="varchar" />
> <xs:element name="NavSpecialization" sql:field="NavSpecialization"
> sql:datatype="varchar" />
> <xs:element name="NavIndustryVert" sql:field="NavIndustryVert"
> sql:datatype="varchar" />
> <xs:element name="NavMBSVert" sql:field="NavMBSVert"
> sql:datatype="varchar" />
> <xs:element name="NavRevSummary" sql:field="NavRevSummary"
> sql:datatype="varchar" />
> <xs:element name="NavConditions" sql:field="NavConditions"
> sql:datatype="varchar" />
> <xs:element name="NavRhythm" sql:field="NavRhythm"
> sql:datatype="varchar" />
> <xs:element name="NavCampaigns" sql:field="NavCampaigns"
> sql:datatype="varchar" />
> <xs:element name="NavAssessments" sql:field="NavAssessments"
> sql:datatype="varchar" />
> <xs:element name="NavLinks" sql:field="NavLinks"
> sql:datatype="varchar" />
> <xs:element name="NavProducts" sql:field="NavProducts"
> sql:datatype="varchar" />
> <xs:element name="NavPlanStatus" sql:field="NavPlanStatus"
> sql:datatype="varchar" />
> <xs:element name="NavGoalSummary" sql:field="NavGoalSummary"
> sql:datatype="varchar" />
> <xs:element name="NavInvestments" sql:field="NavInvestments"
> sql:datatype="varchar" />
> <xs:element name="NavSolutionPlan" sql:field="NavSolutionPlan"
> sql:datatype="varchar" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="LinksToOtherDocuments"
> sql:relation="LinksToOtherDocuments"
> sql:relationship=" MicrosoftPartnerProfile_LinksToOtherDocu
ments">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="DocumentUrl" sql:field="DocumentUrl"
> sql:datatype="varchar" />
> <xs:element name="DocumentTitle" sql:field="DocumentTitle"
> sql:datatype="varchar" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="NotesAndConditions" sql:relation="NotesAndConditions
"
> sql:relationship=" MicrosoftPartnerProfile_NotesAndConditio
ns">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="MeetingFrequencyID" sql:field="MeetingFrequencyID"[/color
]