MSBTS_MessageInstance.ReferenceType: Consumed

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › MSBTS_MessageInstance.ReferenceType: Consumed

Viewing 1 reply thread
  • Author
    Posts
    • August 27, 2009 at 12:08 PM #23133
      community-content

        Hello,

        I am creating a .net component which runs WMI sentences in order to find out if there are pending messages into MessageBox Database.

        I am interested only in messages that are waiting to be processed. They are already in BizTalkMsgBoxDb.  

        I checked the permissible values for property:  MSBTS_MessageInstance.ReferenceType , and found the following below.

        My question is: Should I Filter by ReferenceType equals 2?

        Thank You..Pablo

        Delivered, not consumed: 1
        Consumed:  2
        Suspended: 4
        Abandoned: 8

         

        Select * from MSBTS_MessageInstance where ReferenceType = 2

         

         

      • August 31, 2009 at 5:23 AM #23169
        community-content

          You probably want to use ReferenceType = 1.
          Delivered, not consumed means it has been published to the message box, but no subscribers have read the message.
          Consumed means a subscriber (orchestration or send port) has read the message and started processing it.

          Delivered, not consumed should be a transitory state, i.e. BizTalk is busy but will get eventually get to it.

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