Problem with polling TableChangedEvent in Oracle 10g

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Problem with polling TableChangedEvent in Oracle 10g

Viewing 1 reply thread
  • Author
    Posts
    • June 10, 2009 at 12:18 AM #22624
      community-content

        Hello,

        I have an Oracle 10g table with about 50 thousand records in it.
        I want to poll 5 records per minute to BizTalk Server 2006, to process them.
        I have made a Receive Port and Receive Location to do this.

        The Connection Properties for this Receive Location are:
        Delete after poll: True (tested with False)
        Event Max Row Count: 5
        Maximum number of sessions: 40
        Poll SQL Statement: empty
        Polling interval: 60
        Post Poll SQL Statement: empty

        When I activate this Receive Location, it is polling contineous, instead of 1 time per 60 seconds, giving me messages with 5 records each.

        Anybody got a clue?

        Robbish.

      • June 11, 2009 at 11:22 PM #22646
        community-content

          UPDATE:

          When I activate the receive location with no subscribtions to the received message, polling works fine.
          I get a message with 5 records in the MessageBox about every 60 seconds.
          The message get suspended, because there are no subscribtions.

          When I make a subscribtion to this messages by using a direct binded port, messages keep on comming in.
          I get more than 1000 messages, with each 5 records, per second!

          Does anybody have an idee how to solve this problem?

          Robbish.

          • June 1, 2010 at 4:14 AM #24852
            community-content

              Any specific reason why you had to set Event Max Row Count: 5?

              • June 3, 2010 at 9:44 AM #24883
                community-content

                  We did not want to have to many messages of this type at once.

                  We did need to have room and instances for other message types.

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