updategram has blank attributes,value missing in updategram

Home Page Forums BizTalk 2004 – BizTalk 2010 updategram has blank attributes,value missing in updategram

Viewing 1 reply thread
  • Author
    Posts
    • #24320

      hi all

      i have an orchestration in which i am getting records from the sql which has all the records,
      now i am using xpath to go through node by node so that i can insert one by one row as it is my need,
      now when i loop through the nodes i have following in my xmldocument at a time

       <userDetails xmlns=”http://SqlRowLooping“>
              <userID>1</userID>
              <fName>niladri</fName>
              <lName>Roy</lName>
              <department>hr</department>
      </userDetails>

      now i have new schema created for above xml which has same namespace as shown in xml onroot node userDetails
      and elements like above,now if i’ve construct shape as i want to map this schema with updategram,
      so i am mapping this singleNode schema with updategram schema,so in map input msg is singleNode and output msg
      is updategram msg,but when this shape executes the out msg has blank attributes,it means in after shape it has

      <ns0:Get_Emp xmlns:ns0=”http://SqlRowLooping“>
           <ns0:sync>
              <ns0:after>
             <ns0:HRDepartment FName=”” LName=””  Department=”” />
        </ns0:after>
       </ns0:sync>
        </ns0:Get_Emp>

      so it is inserting blank rows instead of the data present in xml

      but when i debug the map and see output xml it has perfect updategram generated with sample data

      plz help….

    • #24436

      Can you try Setting the property “Child Element Format” to Unqualified in the  SQL Schema get_Emp and try again. Test the map first in Visual Studio using Validate Map Output set to  true.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.