IInterchange::Submit() Remains Pending When You Submit a Document to a Distribution List (319003)

The information in this article applies to:

Microsoft BizTalk Server 2002

This article was previously published under Q319003

SYMPTOMS

If you call IInterchange::Submit() to submit a document to a distribution list that has a large number of ports, the operation remains pending and prevents other Submit calls from completing until one document for each port is populated in the Scheduled queue. If the other Submit call is from a Web application, a timeout error results.

CAUSE

The cs_create_scheduledQ stored procedure contains unnecessary code.

RESOLUTION

To resolve this problem, follow these steps:

Open SQL Enterprise Manager, and then select the SQ database.
Click Stored Procedures, and then edit the cs_create_scheduledQ stored procedure.

Comment out the following code:

        IF (@nQueue <> 0) 
	BEGIN
		if (@nQueue = 1)
		BEGIN
			DELETE FROM cs_WorkQ WITH (ROWLOCK) WHERE nID = @nID
		END
		else if (@nQueue = 2)
		BEGIN
			DELETE FROM cs_RetryQ WITH (ROWLOCK) WHERE nID = @nID
		END
	END

STATUS

This problem is scheduled to be fixed in BizTalk 2002 Service Pack 1.

Modification Type:	Major	Last Reviewed:	10/16/2002
Keywords:	kbbug kbQFE KB319003