I think I finally have the broker set up correctly. I have a bunch of
entries on the transmission queue and would like to clear them out. I tried
the following and it works to a point but doesn't work on older
conversations. I see the conversation on the queue but when I try and end it
I get the following error. How do I get rid of all these conversations?
The conversation handle "A3B5C2D8-FEC2-DC11-94CB-00123FFF2501" is not found
END CONVERSATION 'A3B5C2D8-FEC2-DC11-94CB-00123FFF2501'
WITH ERROR = 127 DESCRIPTION = N'Unable to process message.' ;
Found the answer it is.
END CONVERSATION '8EBFD527-E1C2-DC11-94CB-00123FFF2501' WITH CLEANUP ;
Thanks Anyway,
jc
I see you've found the solution, but I think you still might have some work
to do. It sounds like your conversations are getting ended by one side, and
not by the other side. Ending a conversation, just like any other SSB
activity, is a two-way thing. Much like saying goodbye on the phone; it's
rude to simply hang up :-) ... your SSB programs should watch for
EndConversation messages, and end the conversation on that end if one is
received from the other end.

Signature
Adam Machanic
SQL Server MVP - http://sqlblog.com
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
>I think I finally have the broker set up correctly. I have a bunch of
>entries on the transmission queue and would like to clear them out. I tried
[quoted text clipped - 8 lines]
>
> WITH ERROR = 127 DESCRIPTION = N'Unable to process message.' ;
Hi John,
I, too, am getting an accumulation of rows in sys.conversation_endpoints on
the target side of my communications.
Adam is right, that you need to handle the end dialog messages.
Here's an excerpt from a service process on the target side:
SEND ON CONVERSATION @lclConversationID
MESSAGE TYPE [http://schemas.musicbeat.com/sam/RegResponseMsg (
@lclResponseMessage
);
-- End the conversation
END CONVERSATION @lclConversationID;
Here's an excerpt from a service process on the initiator queue
IF (@lclMsgName = 'http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog')
BEGIN
END CONVERSATION @lclConversationID;
END
I'm using this pattern, but continue to get an accumulation of rows in
sys.conversation_endpoints. I have been digging for a bit on this, and
suspect (though I'm not certain) that I might be seeing bug #50001503:
http://support.microsoft.com/kb/940287
The description of this bug seems to match my symptoms. Does it seem to
match yours?
I have begun to run through the list of possible workarounds described in
the bug, as I'm reluctant to apply the hotfix until I'm positive that I'm
really seeing this bug.
The hotfix is not in the Cumulative update package 5 for SQL Server 2005
Service Pack 2.
http://support.microsoft.com/kb/943656/en-us
I would appreciate learning if you're seeing the same thing in your
application. And if you are seeing any effect from the workarounds or the
hotfix (if you're more courageous than me about applying such things).
Thanks,
--Craig.
> I think I finally have the broker set up correctly. I have a bunch of
> entries on the transmission queue and would like to clear them out. I tried
[quoted text clipped - 7 lines]
>
> WITH ERROR = 127 DESCRIPTION = N'Unable to process message.' ;
John Cantley - 30 Jan 2008 22:04 GMT
Craig, sorry for the delay, been deep into it and have most of it working.
Still having troubles but that is another message.
I read over the kb and did get those errors but they were more related to
the security context of the users i was using. My queue is not filling up
anymore, when it does it is a result of me testing and not having the queues
turned on.
John
> Hi John,
>
[quoted text clipped - 59 lines]
>>
>> WITH ERROR = 127 DESCRIPTION = N'Unable to process message.' ;