January 14, 2009 at 12:53 pm
Hi All,
I've created all the service broker objects and trying to send a message between 2 databases in different servers.
While sending the message it shows successfully executed
But in the target queue I couldn't see the message.
Ive seen the following message in the transmission_status column of
sys.transmission_queue catalog view
"Service Broker received an error message on this conversation. Service Broker will not transmit the message; it will be held until the application ends the conversation."
What could be the reason for this error?
January 14, 2009 at 1:00 pm
You need to check the Initiator's response queue (it's the "other" service that you have to specifiy in the Begin Dialog statement) for error messages from Service Broker.
Also check my Code Camp presentation at my Blog for tips of troubleshooting Service Broker problems.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply