BizTalk TypePolling receive port silently fails

Question

I've created a SQL stored procedure to use with a TypedPolling receive port. It silently fails and I have no clue why. It posts no messages and does not produce errors in the event log.

I used the tutorial here to create the schema and receive port:

I have the sql server profiler connected when I enable the receive location:

The SPROC works correctly when executed manually and the execution time matches the time the profile shows. I've turned on "Enable Routing for failed messages" and created a send port with a filter matching the MessageType.

Any ideas?

question from:https://stackoverflow.com/questions/66051513/biztalk-typepolling-receive-port-silently-fails

Answer 1

The answer is: "Patience." There was nothing wrong with the setup.

I waited several minutes for results and when nothing happened I disabled the port. Disabling the port aborts the process. It took more than the minutes I waited after the SPROC completed for a message to be returned.

Thank you for your help gentlemen!