July 5, 2007 at 11:50 am
I have a dialog between two servers. I am sending updates to a table via an XML message. I successfully tested this between two databases on the same server. Now, I have it deployed between two servers on the same network.
My messages get delivered to the target database. They end up in the target queue like they are supposed to. The problem is, the stored procedure that is supposed to process the message does not fire. Can anyone give me some advice on how to troubleshoot this or what to do next? My script for the queue is below for reference. I have already made sure that the user has 'god' permissions on the sp.
/****** Object: ServiceQueue [dbo].[SiteChangeNotifyReceiveQueue] Script Date: 07/05/2007 13:48:32 ******/
CREATE QUEUE [dbo].[SiteChangeNotifyReceiveQueue] WITH STATUS = ON , RETENTION = ON , ACTIVATION ( STATUS = ON , PROCEDURE_NAME = [dbo].[SiteChangeQueueReader] , MAX_QUEUE_READERS = 10 , EXECUTE AS N'sqlservices' ) ON [PRIMARY]
July 6, 2007 at 7:36 am
July 6, 2007 at 10:43 am
I found the topic in BOL on "Troubleshooting Routing and Message Delivery" to be helpful (see http://msdn2.microsoft.com/en-us/library/ms166044.aspx)
Also remember that if there is a problem with the SP in the queue, after 5 errors the queue is disabled.
Hope this helps
Mark
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply