the broker conversation_endpoints state is "DO"

Question

in initiator database ,i use this t-sql:

select * from sys.transmission_queue;

find some messages didn't send.the to_broker_instance is null.

i use :

select * from sys.conversation_endpoints;

find this message's  endpoints state is 'CO'.

I use  conversation_id to select * from  sys.conversation_endpoints in traget dabase.find that's conversation_endpoints state is 'DO'.

and I find the same message is sended twice！the first message's conversation is not found,the second message's conversation  is same as above! 

so,what can I do ?

Answer 1

what's the sql server version? Are both target and initiator on the same instance? 

---

smiling~

Answer 2

Please capture the profiler traces (on both sender and target instances)with all the broker events and some RPC statement events. It will help you to understand the reason why the messages are not being sent:

Here is a very good link :-  http://rusanu.com/2005/12/20/troubleshooting-dialogs/ to understand service broker issues.

---

Kind regards| Harsh Chawla | Personal Blog:- SQL-blogs
|Team Blog:- Team Blog