Cryptic BizTalk error – Object […] of type StoredProcedure does not exist

Just had an annoying BizTalk error that I’ll probably run into again so jotting this down for posterity.

I was getting a warning in the event log like so: (names of objects changed to protect the innocent).
The adapter failed to transmit message going to send port "FooBar" with URL "mssql://sql/dev/Mydb?". It will be retransmitted after the retry interval specified for this Send Port. Details:"Microsoft.ServiceModel.Channels.Common.MetadataException: Object [dbo].[My_stored_procedure] of type StoredProcedure does not exist

Turns out that that “?” character at the end of the wcf-custom adapter url was the cause of all the fuss. That’s automatically appended in the bindings generated by using the Add Generated Items-> Consumer Adapter Service wizard.

Remove the question mark and all is well!

Also, don’t forget to update your port operation names as detailed in this blog post

One thought on “Cryptic BizTalk error – Object […] of type StoredProcedure does not exist

  1. Nope, removing the question mark was not the solution in my case; it made no difference. Correcting SQL user membership for the biztalk user resolved it for me, even after restoring the “?” in the URI.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s