CODEWITHSUNDEEP
biztalkbiztalk-2010
k.omar
k.omar

Reputation: 11

Error in BizTalk server 2010 administation

I am trying to poll data from SQL server and receive data in a receive message who have the schema from the table in SQL, then I use a loop to each row by row and transfer each row to file.

In administrator I found an error, the error is:

The Messaging engine failed to process a message submitted by adapter:WCF-SQL Source URL:mssql://win-f7kl176gt9v//user?InboundId=id2. Details:The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure.

Upvotes: 1

Views: 2211

Answers (1)

Nigel B
Nigel B

Reputation: 3597

Run a query to look at your active subscriptions and identify your receive port: Active Subscriptions

Then check against your messages promoted properties. The usual case is that your receive port has the wrong filter i.e. message type etc.

Subscription Detail

Upvotes: 3

Related Questions