Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. An error message is logged in the event log when you try to enlist a dynamic send port in BizTalk Server 2004

An error message is logged in the event log when you try to enlist a dynamic send port in BizTalk Server 2004

View products that this article applies to.

Symptoms

When you try to enlist either a dynamic one-way send port or a dynamic solicit-response send port in Microsoft BizTalk Server 2004, an error that is similar to the following is logged in the event log:
The following stored procedure call failed: " { call [dbo].[]( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}". SQL Server returned error string: "The statement has been terminated.;Cannot insert the value NULL into column 'uidSubID', table 'BizTalkMsgBoxDb.dbo.Subscription'; column does not allow nulls. INSERT fails.
Note Only dynamic send ports experience this problem.

↑ Back to the top

Cause

This problem occurs when you register the BizTalk Server Message Queuing Adapter (MSMQT) after the dynamic send port is created.

↑ Back to the top

Workaround

To work around this problem, follow these steps:
  1. Remove either the dynamic one-way port or the dynamic solicit-response port that was created before the MSMQT was registered.
  2. Re-create the dynamic one-way port or the dynamic solicit-response port.
Note When you enlist the dynamic send port, the enlistment is now successful.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

More information

Steps to reproduce the behavior

  1. Before you register the MSMQT adapter, add either a dynamic one-way send port or a dynamic solicit-response send port.
  2. Enlist and then start the dynamic send port. Notice that no error is reported in the event log.
  3. Stop and then unenlist the dynamic send port.
  4. Register the MSMQT adapter in BizTalk Server Administration.
  5. Enlist the dynamic send port. The error message is reported in the event log.

↑ Back to the top

References

For more information, visit the following Microsoft Developer Network (MSDN) Web sites:
About the BizTalk Message Queuing Adapter
http://msdn2.microsoft.com/en-us/library/ms943324.aspx

Managing Send Ports and Send Port Groups
http://msdn2.microsoft.com/en-us/library/ms943911.aspx

↑ Back to the top

Keywords: KB884977, kbprb, kbtshoot

↑ Back to the top

Article Info
Article ID : 884977
Revision : 4
Created on : 3/20/2007
Published on : 3/20/2007
Exists online : False
Views : 288