Re: SQL: Poll While Data Found

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

March 26, 2010 at 10:25 AM #24468
community-content

    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