Microsoft KB Archive/312755

= BUG: BizTalk Server Receive Function Fails to Submit to Channel After You Change the Case of the Channel Name =

Article ID: 312755

Article Last Modified on 6/4/2003

-

APPLIES TO


 * Microsoft BizTalk Server 2000 Standard Edition
 * Microsoft BizTalk Server 2002 Standard Edition

-



This article was previously published under Q312755



SYMPTOMS
If you try to submit a document to a BizTalk Messaging Channel for processing, the BizTalk Server receive function generates one of the following error messages:

An error occurred in BizTalk Server.

Details:

--

The channel has been removed from the database. Avoid deleting objects

when documents might exist in the queues which reference these objects.

A channel with the name &quot;CHANNELNAME&quot; cannot be located.

-or-

The channel &quot;CHANNELNAME&quot; specified for receive function &quot;receiveFunction&quot;

has been removed from the BizTalk Messaging Management database.



CAUSE
These errors occur if you change the case of a BizTalk Channel name in the BizTalk Messaging Manager after you specify the channel in the receive function and if the Microsoft SQL Server that houses your InterchangeBTM database uses a binary sort order.

When you create a BizTalk Messaging Channel, the name of the channel is stored in the bts_channel table of the InterchangeBTM database in SQL Server. When you create a BizTalk Server receive function and select a channel, BizTalk stores the channel name that the receive function uses in the adm_ReceiveService table of the InterchangeBTM database in SQL Server.

When a BizTalk Server receive function tries to submit a document to a channel, it compares the name of the channel in the adm_ReceiveService table to the list of channels in the bts_channel table. If BizTalk Server finds a match, the receive function submits the document to the specified channel. If BizTalk Server does not find a match, you receive one of the above-mentioned error messages.

If you change the case of the channel name in Messaging Manager after you specify that channel in a receive function, and if the InterchangeBTM database uses a binary sort order, the receive function reports an error when it tries to submit a document to this channel. The receive function generates this error because the case-sensitive channel name does not match a channel name in the bts_channel table.



RESOLUTION
If you change the case of a channel name in the BizTalk Messaging Manager, make sure that you also change the case of the channel name in any BizTalk receive functions that reference that channel.

This is only necessary if the InterchangeBTM database that is used by BizTalk Server uses a binary sort order.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

Additional query words: uppercase lowercase

Keywords: kbbug kbnofix KB312755

-

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

© Microsoft Corporation. All rights reserved.