Getting the number of records from Debatching an XML file using custom pipeline

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Getting the number of records from Debatching an XML file using custom pipeline

Viewing 1 reply thread
  • Author
    Posts
    • December 13, 2006 at 2:41 AM #16869
      community-content

        Hi,

        I am currently using a custom pipeline to debatch a XML file. How can i get the records count.

        <xml>
        <record1>
        <field>
        </field>
        </record1>
        <record2>
        <field>
        </field>
        </record2>
        </xml>

        I read some where, ths can be done by promoting some fields. But not able to search the post again. Any guidence is much appreciated.

        Thanks in advance.

      • December 13, 2006 at 10:46 AM #16884
        community-content

          Each debatched message will have the BTS.InterchangeSequenceNumber. In the last message this will be equal to the record count. 

          • December 15, 2006 at 3:33 AM #16944
            community-content

              Hi,

              many thanks,

              I shall give this a try.

              Cheers

               

            • December 22, 2006 at 3:34 AM #17055
              community-content

                Hi,

                I am getting this error, am i faling to promote it some where??

                 

                Uncaught exception (see the 'inner exception' below) has suspended an instance of service 'BTSTRACSAPPSNEW.IndividualBookingContextProcessir(fdba5f40-132b-712a-29e4-b2d5cbbb6844)'.
                The service instance will remain suspended until administratively resumed or terminated.
                If resumed the instance will continue from its last persisted state and may re-throw the same unexpected exception.
                InstanceId: 00f765f0-d8cf-4e76-a385-47a50f7d1344
                Shape name: ConstructMessage_1
                ShapeId: aad10d04-f634-4681-9314-497f4f370298
                Exception thrown from: segment 1, progress 28
                Inner exception: There is no value associated with the property 'BTS.InterchangeSequenceNumber' in the message.
                       
                Exception type: MissingPropertyException
                Source: Microsoft.XLANGs.BizTalk.Engine
                Target Site: System.Object GetPropertyValueThrows(System.Type)
                The following is a stack trace that identifies the location where the exception occured

                   at Microsoft.BizTalk.XLANGs.BTXEngine.BTXMessage.GetPropertyValueThrows(Type propType)
                   at

                 

                Thanks in advance

              • January 3, 2007 at 1:34 AM #17108
                community-content

                  Hi I have re-posted the error in another thread. and Steven says it works with flat file disassembler.

                  Does the BTS.InterchangeSequenceNumber work with xml disassember as i am getting the same error.

                   Any help or guidance is much appreciated.

                  Many thanks in advance.

                   

                   

                  • January 9, 2007 at 9:05 AM #17171
                    community-content

                      BTS.InterchangeSequenceNumber

                      Pomoted by the Messaging Engine after receiving a message from the receive adapter and before publishing it into the MessageBox database.

                      xs:int

                      Indicates the sequence number of the document in the interchange. If the document is not part of an interchange that was disassembled into individual documents, then this value will be 1. The property can be read in an orchestration, a send pipeline and send adapter.

                      From: http://msdn2.microsoft.com/en-us/library/aa562116.aspx

                      According to this it should be 1 if nothing else.

                       

                      • January 11, 2007 at 8:10 AM #17207
                        community-content

                          Hi,

                          Thanks for u r post!!!

                           

                          But what should i do to achive this

                           

                          Each debatched message will have the BTS.InterchangeSequenceNumber. In the last message this will be equal to the record count. 

                          Many thanks

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