SQL: Poll While Data Found

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL: Poll While Data Found

Viewing 1 reply thread
  • Author
    Posts
    • #22295

      Hi All,

      I use “Poll While Data Found” = True in an SQL Receive Location. But regardless number of records waiting in SQL Server for pickup, the receive location polls at pooling interval only. I’ve tried set the property to False/True – no difference.

      Have anyone had any issues with “Pool While Data Found” option?

      My settings are: Pooling interval = 30 sec.
      SQL command: a stored procedure reading first 10 records and changing their status.

      Any ideas are highly appreciated.

      Regards,

    • #24468

      I had the same problem.

      In my case it was a locking-hint (UPDLOCK) in the SP that caused the problem.

      I changed from:

      SET TRANSACTION ISOLATION LEVEL READ COMMITTED
      SET NOCOUNT ON
      SELECT TOP 1 @PostGUID = PostGUID 
      FROM <tablename> WITH (READCOMMITTED,READPAST,UPDLOCK) 
      INNER JOIN ………

      to:

      SET TRANSACTION ISOLATION LEVEL READ COMMITTED
      SET NOCOUNT ON
      SELECT TOP 1 @PostGUID = PostGUID 
      FROM <tablename> WITH (READCOMMITTED,READPAST) 
      INNER JOIN ………

       

      // Jonas

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