Ningún monitor de aplicación habilitado está en nombre de la cola XYZ
Creé una aplicación de consola que será utilizada por el servicio "Service Broker External Activator". El archivo de configuración en "C: \ Archivos de programa \ Service Broker \ External Activator \ Config" se ha modificado, pero escribe una excepción para registrar el archivo como se muestra a continuación.
ERROR DE EXCEPCIÓN = 32, el monitor de la aplicación no habilitada está en nombre de la cola
Aquí está mi configuración
<NotificationServiceList>
<NotificationService name="ExternalActivatorService" id="100" enabled="true">
<Description>My test notification service</Description>
<ConnectionString>
<!-- All connection string parameters except User Id and Password should be specificed here -->
<Unencrypted>Data Source=localhost;Initial Catalog=Chapter4_ExternalActivation;Application Name=External Activator;Integrated Security=True;</Unencrypted>
</ConnectionString>
</NotificationService>
</NotificationServiceList>
<ApplicationServiceList>
<ApplicationService name="ProcessingApplication" enabled="true">
<OnNotification>
<ServerName>localhost</ServerName>
<DatabaseName>Chapter4_ExternalActivation</DatabaseName>
<SchemaName>dbo</SchemaName>
<QueueName>ExternalActivatorQueue</QueueName>
</OnNotification>
<LaunchInfo>
<ImagePath>D:\Temp\ServiceBroker\9781590599990\Samples\Chapter4\02 ExternalProcessingApplication\ProcessingApplication\bin\Debug\ProcessingApplication.exe</ImagePath>
<CmdLineArgs></CmdLineArgs>
<WorkDir>D:\Temp\ServiceBroker\9781590599990\Samples\Chapter4\02 ExternalProcessingApplication\ProcessingApplication\bin\Debug</WorkDir>
</LaunchInfo>
<Concurrency min="1" max="1" />
</ApplicationService>
</ApplicationServiceList>
Y aquí está el SQL.
CREATE DATABASE Chapter4_ExternalActivation
GO
ALTER DATABASE Chapter4_ExternalActivation
SET ENABLE_BROKER;
GO
USE Chapter4_ExternalActivation
GO
--*********************************************
--* Create the message type "RequestMessage"
--*********************************************
CREATE MESSAGE TYPE
[http://ssb.csharp.at/SSB_Book/c04/RequestMessage]
VALIDATION = WELL_FORMED_XML
GO
--*********************************************
--* Create the message type "ResponseMessage"
--*********************************************
CREATE MESSAGE TYPE
[http://ssb.csharp.at/SSB_Book/c04/ResponseMessage]
VALIDATION = WELL_FORMED_XML
GO
--************************************************
--* Create the contract "HelloWorldContract"
--************************************************
CREATE CONTRACT [http://ssb.csharp.at/SSB_Book/c04/HelloWorldContract]
(
[http://ssb.csharp.at/SSB_Book/c04/RequestMessage] SENT BY INITIATOR,
[http://ssb.csharp.at/SSB_Book/c04/ResponseMessage] SENT BY TARGET
)
GO
--********************************************************
--* Create the queues "InitiatorQueue" and "TargetQueue"
--*********************************************************
CREATE QUEUE InitiatorQueue
WITH STATUS = ON
GO
CREATE QUEUE TargetQueue
GO
--**************************************************************
--* Create the services "InitiatorService" and "TargetService"
--***************************************************************
CREATE SERVICE InitiatorService
ON QUEUE InitiatorQueue
(
[http://ssb.csharp.at/SSB_Book/c04/HelloWorldContract]
)
GO
CREATE SERVICE TargetService
ON QUEUE TargetQueue
(
[http://ssb.csharp.at/SSB_Book/c04/HelloWorldContract]
)
GO
--******************************************************************
--* Deactivate the internal activation on the queue (if necessary)
--*******************************************************************
ALTER QUEUE TargetQueue
WITH ACTIVATION (DROP)
GO
--*********************************************
--* Create the event notification queue
--*********************************************
CREATE QUEUE ExternalActivatorQueue
GO
--*********************************************
--* Create the event notification service
--*********************************************
CREATE SERVICE ExternalActivatorService
ON QUEUE ExternalActivatorQueue
(
[http://schemas.microsoft.com/SQL/Notifications/PostEventNotification]
)
GO
--***********************************************************************
--* Subscribe to the QUEUE_ACTIVATION event on the queue "TargetQueue"
--***********************************************************************
CREATE EVENT NOTIFICATION EventNotificationTargetQueue
ON QUEUE TargetQueue
FOR QUEUE_ACTIVATION
TO SERVICE 'ExternalActivatorService', 'current database';
GO
Cuando envío un mensaje a TargetService, un nuevo mensaje llega a ExternalActivatorQueue. Cuando inicio el servicio "Service Broker External Activator", aparece un error. ¿Alguna idea para averiguar la fuente de este problema?