Wednesday, June 20, 2012 3:48 PM
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.
Wednesday, June 20, 2012 6:00 PM
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/
- Marked As Answer by Iric WenModerator Thursday, June 28, 2012 9:53 AM