Big message is cut in pieces. Why?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Big message is cut in pieces. Why?

Viewing 0 reply threads
  • Author
    Posts
    • February 16, 2007 at 3:26 PM #17707
      community-content

        Hi gurus!

        My problems is as follows:

        I use "select …
        for xml auto, binary base64" command that joins several tables to read
        a record from SQL Server DB. However, the output looks strange.

        Instead of:

        <Order xmlns="">

        – <dbo.table_1 ID="1" status="NEW" ATTACHMENTFILENAME="ContractFile"
        ATTACHMENTFILEEXTENTION        ="JPG" ATTACHMENTCONTENT="/9j/4AAQSkZJRgABAQEAYABgAAD/ … //9k=" CONTACTNAME="FIRSTNAME LASTNAME">
        – <dbo.table_2 CUSTOMER_ID="7182920"
        LASTNAME        ="Pupkin" FIRSTNAME="Vasily" BIRTHDATE="1980-05-25">
        – <dbo.table_3 ADDRESS_ID="151164400"
        POSTALPLACE        ="big city" POSTALCODE="11111" STREETNAME="cherrylane">
        – <dbo.table_4
        REQUESTEDINSTALLDATE        ="2006-11-24"
        REQUESTEDINSTALLTIME        ="07:30 – 12:00">
        – <dbo.table_5 PRODUCTLINEID="1"
        PRODUCTNAME="ADSL" ACTIONTYPE="New">
         
          <dbo.table_6 ATTRIBUTEID="111" ATTRIBUTENAME="aaa"
        ATTRIBUTEVALUE        ="101" >  </dbo.table_6>

        <dbo.table_6 ATTRIBUTEID="222" ATTRIBUTENAME="bbb" ATTRIBUTEVALUE="Analog">  </dbo.table_6>
         
          </dbo.table_5>
          </dbo.table_4>
          </dbo.table_3>
          </dbo.table_2>
          </dbo.table_1>
          </Order>

         

        I get: 

        – <Order xmlns="">
        – <dbo.table_1 ID="1" status="NEW" ATTACHMENTFILENAME="ContractFile"
        ATTACHMENTFILEEXTENTION        ="JPG" ATTACHMENTCONTENT="/9j/4AAQSkZJRgABAQEAYABgAAD/ … //9k=" CONTACTNAME="FIRSTNAME LASTNAME">
        – <dbo.table_2 CUSTOMER_ID="7182920"
        LASTNAME        ="Pupkin" FIRSTNAME="Vasily" BIRTHDATE="1980-05-25">
        – <dbo.table_3 ADDRESS_ID="151164400"
        POSTALPLACE        ="big city" POSTALCODE="11111" STREETNAME="cherrylane" >
        – <dbo.table_4
        REQUESTEDINSTALLDATE        ="2006-11-24"
        REQUESTEDINSTALLTIME        ="07:30 – 12:00">
        – <dbo.table_5 PRODUCTLINEID="1"
        PRODUCTNAME="ADSL" ACTIONTYPE="New">
         
          <dbo.table_6 ATTRIBUTEID="111" ATTRIBUTENAME="aaa"
        ATTRIBUTEVALUE        ="101" />
         
          </dbo.table_5>
          </dbo.table_4>
          </dbo.table_3>
          </dbo.table_2>
          </dbo.table_1>
        <dbo.table_1 ID="1" status="NEW" ATTACHMENTFILENAME="ContractFile"
        ATTACHMENTFILEEXTENTION        ="JPG" ATTACHMENTCONTENT="/9j/4AAQSkZJRgABAQEAYABgAAD/ … //9k=" CONTACTNAME="FIRSTNAME LASTNAME">

        – <dbo.table_2 CUSTOMER_ID="7182920"
        LASTNAME        ="Pupkin" FIRSTNAME="Vasily" BIRTHDATE="1980-05-25">
        – <dbo.table_3 ADDRESS_ID="151164400"
        POSTALPLACE        ="big city" POSTALCODE="11111" STREETNAME="cherrylane" >
        – <dbo.table_4
        REQUESTEDINSTALLDATE        ="2006-11-24"
        REQUESTEDINSTALLTIME        ="07:30 – 12:00">
        – <dbo.table_5 PRODUCTLINEID="1"
        PRODUCTNAME="ADSL" ACTIONTYPE="New">
         
        <dbo.table_6 ATTRIBUTEID="222" ATTRIBUTENAME="bbb" ATTRIBUTEVALUE="Analog" />
         
          </dbo.table_5>
          </dbo.table_4>
          </dbo.table_3>
          </dbo.table_2>
          </dbo.table_1>
          </Order>

         The failure is that my order is split into pieces taking only one attribute from table 6 in each piece.

         

        If I remove ATTACHMENTCONTENT image field and "binary base 64" from my select statement, then I get xml which is properly formatted.

         

        Any help is appreciated!

        -Bibi Watson 

    • Author
      Posts
    Viewing 0 reply threads
    • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.