SQL Service Broker External Activator is not invoking the EXE
Hi,I am implementing the Service Broker External Activator.
Below is the trigger sending the messages to the service.
ALTER trigger [dbo].[testTrigger]
on [dbo].[testTable]
after insert
as
declare @h as uniqueIdentifier
--declare @message Varchar(1000)
declare @message XML
--set @message = ' '
--declare @Point varchar(10),@Value float
--select @Point = Point,@Value = Value from inserted with (nolock)
----set @message = @message + 'The value Inserted in the table were '+ Cast(@Point as varchar(10)) + ' and '+ Cast(@Value as varchar(30));
--set @message = @Point
SELECT @message =
N'<Request>
<ProductID>316</ProductID>
<LocationID>10</LocationID>
</Request>';
BEGIN DIALOG CONVERSATION @h
FROM SERVICE TestService TO SERVICE 'TestService', 'CURRENT DATABASE'
ON CONTRACT [TestContract]
with encryption = off;
SEND ON CONVERSATION @h MESSAGE TYPE [TestMessage] (@message)
print @h
SELECT @message
IF EXISTS(select * from sys.conversation_endpoints
where conversation_handle=@h and state='ER')
begin
RAISERROR ('Service Broker in error state',18,127)
rollback transaction
end
else
begin
END CONVERSATION @h WITH CLEANUP;
print 'Clean Up Completed'
end
But External Activator is not invoking the application. I have checked the configuration files & others. Any suggestion please..