Promoted property issue when debatching XML data

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Promoted property issue when debatching XML data

Viewing 1 reply thread
  • Author
    Posts
    • October 31, 2008 at 5:07 PM #21111
      community-content

         Hi,

        I have a BizTalk application that receives XML data  (envelope) containing a list of records from a database via SQL Adapter & stored procedure.

        After the XML disassembler split the envelope into individual messages (DataSchema), they are put in the MsgBox.

        I have an Orchestration listening to these types of messages and start to process them.

        Now I have promoted a property (Code), used by the orchestration filter expression (Code == “XXXX”), in the DataSchema.

        The issue is that the property doesn’t get promoted at all and the orchestration doesn’t pick up those messages.

        I get the following error: The published message could not be routed because no subscribers were found.

        Have anyone ever experienced the issue re property don’t get promoted in debatching XML?

        Any help would be appreciated. Thanks

         

      • November 1, 2008 at 2:31 PM #21116
        community-content

          I think that to handle this kind of scenario you would need an envelope schema and a document schema with the promoted properties in the document schema.  Then you would need to use the XML Receive pipeline to debatch the messages and promote the properties.  Is this the kind of setup you are using?

          • November 3, 2008 at 4:51 AM #21127
            community-content

              Russell, 

              Thanks for the reply.

              Yes. I have that kind of set up.  followed Richard’s blog (http://seroter.wordpress.com/2007/01/03/debatching-inbound-messages-from-biztalk-sql-adapter/)

              In the document schema, I quick promote the field element (Code) which creates the PropertySchema with that field

              When I deploy and run and look at the supended messages the Code property is not there (not promoted).

               

              Cheers,

               

              Walid

              • November 4, 2008 at 6:56 PM #21149
                community-content

                  Strange.  If the debatching is working, I would assume the property promotion should work too.  Here’s a test that might shed some light on things.  Set up a file receive location with the XML receive pipeline.  Drop in an instance of the record schema and see if the properties get promoted.  This will isolate the property promotion issue from the debatching so you will have a better idea of where the issue lies.

                  • November 6, 2008 at 5:22 AM #21160
                    community-content

                      Hi Russell,

                      Thanks for the insight.

                      it seems I had a problem with the namespaceing in the xml. 

                      Also I forgot to set the Element FormDefault property to Qualified in the document schema.

                      It now all work fine.

                      Cheers,

                      Walid

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