Microsoft KB Archive/319003

= IInterchange::Submit Remains Pending When You Submit a Document to a Distribution List =

Article ID: 319003

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft BizTalk Server 2002 Standard Edition

-



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.

Keywords: kbbug kbfix kbqfe KB319003

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.