Retrieval of Operation Metadata has failed while building WSDL at ‘TypedProcedure/dbo

Exception:

 Retrieval of Operation Metadata has failed while building WSDL at ‘TypedProcedure/dbo/..’.

This occurs when you generate a request/response schema for a stored procedure using ‘Add adapter metadata’ option.

Cause:

FMTONLY flag of SQL being turned ON is the cause for this error.

Resolution:

Please refer to the following helpful post for resolution.

http://thoughtsofmarcus.blogspot.com/2010/11/calling-stored-procedures-from-biztalk.html