Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Service Broker / January 2008

Tip: Looking for answers? Try searching our database.

transmission_queue ?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John Cantley - 15 Jan 2008 18:33 GMT
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.' ;
John Cantley - 16 Jan 2008 17:28 GMT
Found the answer it is.
END CONVERSATION '8EBFD527-E1C2-DC11-94CB-00123FFF2501' WITH CLEANUP ;

Thanks Anyway,
jc
Adam Machanic - 18 Jan 2008 00:40 GMT
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.' ;
Craig Thomas - 24 Jan 2008 01:21 GMT
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.' ;
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.