Microsoft Knowledge Base Email Alertz
All KB/RSS Links  |  Hot Kb!  |  New Kb!  |  Scott Cate  |  FAQ / KB  |  Web Hosting  |  Unsubscribe  

(884977) - Describes a problem where you cannot successfully enlist a dynamic send port in BizTalk Server 2004 after you register the BizTalk Server Message Queuing Adapter (MSMQT).

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.
Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks
Article ID: 884977 - Last Review: March 20, 2007 - Revision: 1.3

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 (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 (http://msdn2.microsoft.com/en-us/library/ms943911.aspx)
Back to the top
APPLIES TO
  • Microsoft BizTalk Server 2004 Enterprise Edition
  • Microsoft BizTalk Server 2004 Developer Edition
  • Microsoft BizTalk Server 2004 Partner Edition
  • Microsoft BizTalk Server 2004 Standard Edition
Back to the top
Keywords: 
kbtshoot kbprb KB884977
Back to the top
        

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate

Copyright © 2002-2007 KBALERTZ.COM.  All Rights Reserved. Terms / Privacy. Discount ASP.NET Hosting