External Activator not launching Application

Question

Hello

I am setup an External Activator solution . I think I got everything as it should be, but the application is just not launching on the QUEUE_ACTIVATION event

External Activator service start successfully and its shows a RECEIVES_OCCURRING status in sys.dm_broker_queue_monitors.

The sys.transmission_queue is empty and I can see the messages appearing in sys.conversation_endpoints with a state of CONVERSING

If I run my Application manually it completes the “Receive” command and reply a message without error.

Any ideas?

Regards, WDV

Answer 1

You might start by turning on verbose tracing.  Change the LogSettings in the EAService.config to the following so that all activity is logged at the verbose level:

  <LogSettings>
    <LogFilter>
	<TraceFlag>All Levels</TraceFlag>
	<TraceFlag>All Modules</TraceFlag>
	<TraceFlag>All Entities</TraceFlag>
	<TraceFlag>Verbose</TraceFlag>
    </LogFilter>
  </LogSettings>

After successful activation, the log should contain messages like:

6/20/2012 9:36:50 AM	VERBOSE	Received event notification for [MyServer].[MyDatabase].[dbo].[MyTargetQueue].
6/20/2012 9:36:50 AM	VERBOSE	Application process C:\Program Files\MyApplication\MyApplication.EXE was created: id = 7552.
6/20/2012 9:36:50 AM	VERBOSE	Application process id = 7552 has exited: exit code = 0, exit time = 6/20/2012 9:36:50 AM.

---

Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/