Monday, May 18, 2009

Unable to find Stored Procedure

After changing a message flow from loosely coupled to not, I had to, I experienced "Unable to find Stored Procedure" in the event log.

Using SQL Profiler I noticed two calls for every message. One doing the correct thing and another "Exec [A name very similar to the root node of internal message used]".

Of course! The filter previously used by the send port was still there, subscribing to the internal message type :)

Removing the filter and everything worked like a charm.

No comments: