Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm new to Service Broker. Our existing Service Broker suddenly stops working and I can't figure out why.

When I try to enable Service Broker (which is already enabled) I get this in SQL error log:

An error occurred in the service broker manager
Error: 3602, State: 25.

Also tried creating new message queues. I am able to see the created queues under sys.service_queues and sys.objects but not in sys.dm_broker_queue_monitors.

share

migration rejected from stackoverflow.com Dec 16 '13 at 18:16

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Paul White, Kin, bluefeet, RolandoMySQLDBA, swasheck Dec 16 '13 at 18:16

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Paul White, Kin, bluefeet, RolandoMySQLDBA, swasheck
If this question can be reworded to fit the rules in the help center, please edit the question.

6  
Contact product support. –  Remus Rusanu May 17 '13 at 6:37
    
Hi Sir, Does this mean I wont be able to fix this on my end? Thanks! –  Eman Masalunga May 17 '13 at 6:54
3  
@Eman: it means you have a problem that's possibly a bug and you should contact MS Support. It also means you can't get a better answer here. Remus is our most authoritative figure for Service Broker. –  Marian May 17 '13 at 16:00
1  
Have you seen this or this? –  Aaron Bertrand May 17 '13 at 16:45
    
Have a look at ssbdiagnose Utility (Service Broker) (technet.microsoft.com/en-us/library/bb934450.aspx) –  Kin Aug 18 '13 at 15:44

1 Answer 1

I've recently encountered this error again today after server restart and I was able to fix it.

What I did was open/modify the message queue and execute the ALTER QUEUE command again and voila, the queue re appears on the sys.dm_broker_queue_monitors and messages are being processed again. Now what I need to know is why do I need to do this in order to get it functioning again. :)

share

Not the answer you're looking for? Browse other questions tagged or ask your own question.