none
Unable to map WCF-SQL Composite Operation RRS feed

  • Question

  • Hello everyone.

    I used the Adapter Metadata generator to pull CRUD table operations on 3 tables : F47171 (order_header), F47172 (order_detail), F47173 (order_detail2).  I then pulled everything into one schema, inserting F47172 and then F47172/F47173 in a single transaction as shown in 'CODE BLOCK 1'.  The inbound schema is shown in 'CODE BLOCK 2'.  I then attemp to create a map from CODE_BLOCK_2 to CODE_BLOCK_1.  I can successfully map F47171 -> ns1:Insert/tables:F47171, but when I try to loop through F47172, it won't let me set the target.

    Am I doing something wrong?

    CODE BLOCK 1

    <?xml version="1.0" encoding="utf-16"?>
    <xs:schema xmlns:ns2="http://schemas.microsoft.com/Sql/2008/05/TableOp/CNVDTA/F47172" xmlns:array="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns:b="http://schemas.microsoft.com/BizTalk/2003" xmlns="http://iConnectEdi.TableOperation" xmlns:ns3="http://schemas.microsoft.com/Sql/2008/05/TableOp/CNVDTA/F47173" xmlns:tables="http://schemas.microsoft.com/Sql/2008/05/Types/Tables/CNVDTA" xmlns:ns1="http://schemas.microsoft.com/Sql/2008/05/TableOp/CNVDTA/F47171" targetNamespace="http://iConnectEdi.TableOperation" xmlns:xs="http://www.w3.org/2001/XMLSchema">
      <xs:import schemaLocation=".\TableOperation.CNVDTA.F47171.xsd" namespace="http://schemas.microsoft.com/Sql/2008/05/TableOp/CNVDTA/F47171" />
      <xs:import schemaLocation=".\TableOperation.CNVDTA.F47173.xsd" namespace="http://schemas.microsoft.com/Sql/2008/05/TableOp/CNVDTA/F47173" />
      <xs:import schemaLocation=".\TableOperation.CNVDTA.F47172.xsd" namespace="http://schemas.microsoft.com/Sql/2008/05/TableOp/CNVDTA/F47172" />
      <xs:import schemaLocation=".\SimpleTypeArray.xsd" namespace="http://schemas.microsoft.com/2003/10/Serialization/Arrays" />
      <xs:import schemaLocation=".\Table.CNVDTA.xsd" namespace="http://schemas.microsoft.com/Sql/2008/05/Types/Tables/CNVDTA" />
      <xs:annotation>
        <xs:appinfo>
          <b:references>
            <b:reference targetNamespace="http://schemas.microsoft.com/2003/10/Serialization/Arrays" />
            <b:reference targetNamespace="http://schemas.microsoft.com/Sql/2008/05/TableOp/CNVDTA/F47171" />
            <b:reference targetNamespace="http://schemas.microsoft.com/Sql/2008/05/TableOp/CNVDTA/F47172" />
            <b:reference targetNamespace="http://schemas.microsoft.com/Sql/2008/05/Types/Tables/CNVDTA" />
            <b:reference targetNamespace="http://schemas.microsoft.com/Sql/2008/05/TableOp/CNVDTA/F47173" />
          </b:references>
        </xs:appinfo>
      </xs:annotation>
      <xs:element name="CNVDATA_Inbound">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="ns1:Insert" />
            <xs:element ref="ns2:Insert" />
            <xs:element ref="ns3:Insert" />
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="CNVDATA_InboundResponse">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="ns1:InsertResponse" />
            <xs:element ref="ns2:InsertResponse" />
            <xs:element ref="ns3:InsertResponse" />
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:schema>

    CODE BLOCK 2

    <?xml version="1.0" encoding="UTF-8"?>
    <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
      <xs:import namespace="http://www.w3.org/2001/XMLSchema-instance" schemaLocation="xsi.xsd"/>
      <xs:element name="NewDataSet">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="F47171"/>
            <xs:element ref="F47172"/>
            <xs:element maxOccurs="unbounded" ref="F47173"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="F47171">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="ESEDTY"/>
            <xs:element ref="ESEDSQ"/>
            <xs:element ref="ESEKCO"/>
            <xs:element ref="ESEDOC"/>
            <xs:element ref="ESEDCT"/>
            <xs:element ref="ESEDLN"/>
            <xs:element ref="ESEDST"/>
            <xs:element ref="ESEDFT"/>
            <xs:element ref="ESEDDT"/>
            <xs:element ref="ESEDER"/>
            <xs:element ref="ESEDDL"/>
            <xs:element ref="ESEDSP"/>
            <xs:element ref="ESEDBT"/>
            <xs:element ref="EHMCU"/>
            <xs:element ref="EHAN8"/>
            <xs:element ref="EHSHAN"/>
            <xs:element ref="EHTPUR"/>
            <xs:element ref="EHRLSNO"/>
            <xs:element ref="EHRLSDJ"/>
            <xs:element ref="EHRLSTM"/>
            <xs:element ref="EHHZSD"/>
            <xs:element ref="EHHZED"/>
            <xs:element ref="EHEDTCTDJ"/>
            <xs:element ref="EHEDTCTTM"/>
            <xs:element ref="EHPID"/>
            <xs:element ref="EHUPMJ"/>
            <xs:element ref="EHTDAY"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="EHMCU" type="xs:NCName"/>
      <xs:element name="EHAN8" type="xs:integer"/>
      <xs:element name="EHSHAN" type="xs:integer"/>
      <xs:element name="EHTPUR" type="xs:integer"/>
      <xs:element name="EHRLSNO" type="xs:integer"/>
      <xs:element name="EHRLSDJ">
        <xs:complexType>
          <xs:simpleContent>
            <xs:extension base="xs:NMTOKEN">
              <xs:attribute ref="xsi:nil" use="required"/>
            </xs:extension>
          </xs:simpleContent>
        </xs:complexType>
      </xs:element>
      <xs:element name="EHRLSTM" type="xs:integer"/>
      <xs:element name="EHHZSD">
        <xs:complexType>
          <xs:simpleContent>
            <xs:extension base="xs:NMTOKEN">
              <xs:attribute ref="xsi:nil" use="required"/>
            </xs:extension>
          </xs:simpleContent>
        </xs:complexType>
      </xs:element>
      <xs:element name="EHHZED">
        <xs:complexType>
          <xs:simpleContent>
            <xs:extension base="xs:NMTOKEN">
              <xs:attribute ref="xsi:nil" use="required"/>
            </xs:extension>
          </xs:simpleContent>
        </xs:complexType>
      </xs:element>
      <xs:element name="EHEDTCTDJ">
        <xs:complexType>
          <xs:simpleContent>
            <xs:extension base="xs:NMTOKEN">
              <xs:attribute ref="xsi:nil" use="required"/>
            </xs:extension>
          </xs:simpleContent>
        </xs:complexType>
      </xs:element>
      <xs:element name="EHEDTCTTM" type="xs:integer"/>
      <xs:element name="EHPID" type="xs:NCName"/>
      <xs:element name="EHUPMJ" type="xs:NMTOKEN"/>
      <xs:element name="EHTDAY" type="xs:integer"/>
      <xs:element name="F47172">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="ESEDTY"/>
            <xs:element ref="ESEDSQ"/>
            <xs:element ref="ESEKCO"/>
            <xs:element ref="ESEDOC"/>
            <xs:element ref="ESEDCT"/>
            <xs:element ref="ESEDLN"/>
            <xs:element ref="ESEDST"/>
            <xs:element ref="ESEDFT"/>
            <xs:element ref="ESEDDT"/>
            <xs:element ref="ESEDER"/>
            <xs:element ref="ESEDDL"/>
            <xs:element ref="ESEDSP"/>
            <xs:element ref="ESEDBT"/>
            <xs:element ref="EDCITM"/>
            <xs:element ref="EDDKID"/>
            <xs:element ref="EDLCRCVDJ"/>
            <xs:element ref="EDLCRCVQTY"/>
            <xs:element ref="EDLCRCVTM"/>
            <xs:element ref="EDLCRCVUOM"/>
            <xs:element ref="EDLCSHPDJ"/>
            <xs:element ref="EDLCSHPQTY"/>
            <xs:element ref="EDLCSHPTM"/>
            <xs:element ref="EDLCSHPUOM"/>
            <xs:element ref="EDCCUMRQY"/>
            <xs:element ref="EDCCUMRDJ"/>
            <xs:element ref="EDCCUMRTM"/>
            <xs:element ref="EDCRQQYFM"/>
            <xs:element ref="EDCRQSDJFM"/>
            <xs:element ref="EDCRQSTMFM"/>
            <xs:element ref="EDCRQEDJFM"/>
            <xs:element ref="EDCRQETMFM"/>
            <xs:element ref="EDASBLNFD"/>
            <xs:element ref="EDASBLNLOC"/>
            <xs:element ref="EDTRSRTE"/>
            <xs:element ref="EDPID"/>
            <xs:element ref="EDUPMJ"/>
            <xs:element ref="EDTDAY"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="EDCITM" type="xs:NMTOKEN"/>
      <xs:element name="EDDKID" type="xs:integer"/>
      <xs:element name="EDLCRCVDJ">
        <xs:complexType>
          <xs:attribute ref="xsi:nil" use="required"/>
        </xs:complexType>
      </xs:element>
      <xs:element name="EDLCRCVQTY">
        <xs:complexType/>
      </xs:element>
      <xs:element name="EDLCRCVTM" type="xs:integer"/>
      <xs:element name="EDLCRCVUOM">
        <xs:complexType/>
      </xs:element>
      <xs:element name="EDLCSHPDJ">
        <xs:complexType>
          <xs:attribute ref="xsi:nil" use="required"/>
        </xs:complexType>
      </xs:element>
      <xs:element name="EDLCSHPQTY">
        <xs:complexType/>
      </xs:element>
      <xs:element name="EDLCSHPTM" type="xs:integer"/>
      <xs:element name="EDLCSHPUOM">
        <xs:complexType/>
      </xs:element>
      <xs:element name="EDCCUMRQY" type="xs:integer"/>
      <xs:element name="EDCCUMRDJ">
        <xs:complexType>
          <xs:simpleContent>
            <xs:extension base="xs:NMTOKEN">
              <xs:attribute ref="xsi:nil" use="required"/>
            </xs:extension>
          </xs:simpleContent>
        </xs:complexType>
      </xs:element>
      <xs:element name="EDCCUMRTM" type="xs:integer"/>
      <xs:element name="EDCRQQYFM" type="xs:integer"/>
      <xs:element name="EDCRQSDJFM">
        <xs:complexType>
          <xs:simpleContent>
            <xs:extension base="xs:NMTOKEN">
              <xs:attribute ref="xsi:nil" use="required"/>
            </xs:extension>
          </xs:simpleContent>
        </xs:complexType>
      </xs:element>
      <xs:element name="EDCRQSTMFM" type="xs:integer"/>
      <xs:element name="EDCRQEDJFM">
        <xs:complexType>
          <xs:simpleContent>
            <xs:extension base="xs:NMTOKEN">
              <xs:attribute ref="xsi:nil" use="required"/>
            </xs:extension>
          </xs:simpleContent>
        </xs:complexType>
      </xs:element>
      <xs:element name="EDCRQETMFM" type="xs:integer"/>
      <xs:element name="EDASBLNFD">
        <xs:complexType/>
      </xs:element>
      <xs:element name="EDASBLNLOC" type="xs:string"/>
      <xs:element name="EDTRSRTE">
        <xs:complexType/>
      </xs:element>
      <xs:element name="EDPID" type="xs:NCName"/>
      <xs:element name="EDUPMJ" type="xs:NMTOKEN"/>
      <xs:element name="EDTDAY" type="xs:integer"/>
      <xs:element name="F47173">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="ESEDTY"/>
            <xs:element ref="ESEDSQ"/>
            <xs:element ref="ESEKCO"/>
            <xs:element ref="ESEDOC"/>
            <xs:element ref="ESEDCT"/>
            <xs:element ref="ESEDLN"/>
            <xs:element ref="ESEDST"/>
            <xs:element ref="ESEDFT"/>
            <xs:element ref="ESEDDT"/>
            <xs:element ref="ESEDER"/>
            <xs:element ref="ESEDDL"/>
            <xs:element ref="ESEDSP"/>
            <xs:element ref="ESEDBT"/>
            <xs:element ref="ESEDSLN"/>
            <xs:element ref="ESREQFRQ"/>
            <xs:element ref="ESCSTDMDPT"/>
            <xs:element ref="ESREQTYP"/>
            <xs:element ref="ESRSDJ"/>
            <xs:element ref="ESRSDT"/>
            <xs:element ref="ESRQSJ"/>
            <xs:element ref="ESRQSHPQTY"/>
            <xs:element ref="ESUOM"/>
            <xs:element ref="ESRSHT"/>
            <xs:element ref="ESPID"/>
            <xs:element ref="ESUPMJ"/>
            <xs:element ref="ESTDAY"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="ESEDSLN" type="xs:integer"/>
      <xs:element name="ESREQFRQ" type="xs:NCName"/>
      <xs:element name="ESCSTDMDPT">
        <xs:complexType/>
      </xs:element>
      <xs:element name="ESREQTYP" type="xs:NCName"/>
      <xs:element name="ESRSDJ">
        <xs:complexType>
          <xs:simpleContent>
            <xs:extension base="xs:NMTOKEN">
              <xs:attribute ref="xsi:nil" use="required"/>
            </xs:extension>
          </xs:simpleContent>
        </xs:complexType>
      </xs:element>
      <xs:element name="ESRSDT" type="xs:integer"/>
      <xs:element name="ESRQSJ">
        <xs:complexType>
          <xs:simpleContent>
            <xs:extension base="xs:NMTOKEN">
              <xs:attribute ref="xsi:nil" use="required"/>
            </xs:extension>
          </xs:simpleContent>
        </xs:complexType>
      </xs:element>
      <xs:element name="ESRQSHPQTY" type="xs:integer"/>
      <xs:element name="ESUOM" type="xs:NCName"/>
      <xs:element name="ESRSHT" type="xs:integer"/>
      <xs:element name="ESPID" type="xs:NCName"/>
      <xs:element name="ESUPMJ" type="xs:NMTOKEN"/>
      <xs:element name="ESTDAY" type="xs:integer"/>
      <xs:element name="ESEDTY" type="xs:integer"/>
      <xs:element name="ESEDSQ">
        <xs:complexType/>
      </xs:element>
      <xs:element name="ESEKCO" type="xs:integer"/>
      <xs:element name="ESEDOC" type="xs:integer"/>
      <xs:element name="ESEDCT" type="xs:NCName"/>
      <xs:element name="ESEDLN" type="xs:string"/>
      <xs:element name="ESEDST" type="xs:NCName"/>
      <xs:element name="ESEDFT">
        <xs:complexType/>
      </xs:element>
      <xs:element name="ESEDDT">
        <xs:complexType>
          <xs:simpleContent>
            <xs:extension base="xs:NMTOKEN">
              <xs:attribute ref="xsi:nil" use="required"/>
            </xs:extension>
          </xs:simpleContent>
        </xs:complexType>
      </xs:element>
      <xs:element name="ESEDER" type="xs:NCName"/>
      <xs:element name="ESEDDL" type="xs:integer"/>
      <xs:element name="ESEDSP" type="xs:string"/>
      <xs:element name="ESEDBT">
        <xs:complexType/>
      </xs:element>
    </xs:schema>
    

    Thursday, June 27, 2013 9:08 PM

Answers

  • SOLVED

    "Pitfall

    Because you have multiple destination nodes with the same name, you will need to set the BizTalk map grid property Ignore Namespaces for Links to No. Otherwise, your map will not successfully compile due to namespace confusion." -SOA Patterns with BizTalk Server, Chapter 9, Executing composite transactions


    • Marked as answer by fixitchris Friday, June 28, 2013 3:35 AM
    Friday, June 28, 2013 3:35 AM

All replies

  • SOLVED

    "Pitfall

    Because you have multiple destination nodes with the same name, you will need to set the BizTalk map grid property Ignore Namespaces for Links to No. Otherwise, your map will not successfully compile due to namespace confusion." -SOA Patterns with BizTalk Server, Chapter 9, Executing composite transactions


    • Marked as answer by fixitchris Friday, June 28, 2013 3:35 AM
    Friday, June 28, 2013 3:35 AM
  • Hi,

    We are happy that your issue has been resolved. And thanks for sharing solution with us.

    Friday, June 28, 2013 10:26 AM