Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Todd Carrier
Starting Member
4 Posts |
 Posted - 2007-11-09 : 13:20:02
|
| We lost our Datawarehouse developer that set up this application for us, so I am now in charge... ick, and don't know what I'm doing really.Lately no messages leaving sys.transmission_queue... all have transmission_status of: "One or more messages could not be delivered to the local service targeted by this dialog."Setup looks like this:CREATE MESSAGE TYPE XmlSubmission VALIDATION = WELL_FORMED_XML;CREATE CONTRACT XmlContract (XmlSubmission SENT BY INITIATOR);CREATE QUEUE ReceiverXmlQueue WITH STATUS = ON, ACTIVATION (PROCEDURE_NAME = MMRS.MMRS.WrapXmlProcessor, MAX_QUEUE_READERS = 1, EXECUTE AS SELF );CREATE QUEUE SenderXmlQueue;CREATE SERVICE Sender ON QUEUE SenderXmlQueue;CREATE SERVICE Receiver ON QUEUE ReceiverXmlQueue(XmlContract);ALTER QUEUE ReceiverXmlQueue WITH STATUS = onService Broker is enabled on database, and I've tried dropping and recreating these objects to no avail.When functioning, these messages get recieved and procecessed into a staging SQL table, storing the XML to be loaded up into the relational tables.Any ideas or clues for troubleshooting would be greatly appreciated! |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-11-09 : 13:59:07
|
| checked that the messages contained well formed xml? anything in your error logs? |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
|
|
Service Broker Woes...