none
"Microsoft.ServiceModel.Channels.Common.MetadataException: Object [dbo].[Filename] of type Stored Procedure does not exist RRS feed

  • Question

  • Hi all,

    I am trying to insert records into SQL using composite Operation , Have checked the stored procedure it is executing fine in SQL , when it comes to BizTalk i am getting ""Microsoft.ServiceModel.Channels.Common.MetadataException: Object [dbo].[Filename] of type Stored Procedure does not exist" Exception ,So can any one let me know solution for this exception.

    Thanks in Advance


    panadi



    • Edited by panadi Wednesday, June 22, 2016 1:52 PM
    Wednesday, June 22, 2016 1:40 PM

Answers

  • Hi Panadi,

    This issue can be caused because of many reasons.

    Try and check following points:

    1. Update the SQL URI with the complete SQL instance name, if you are using the a named instance.

    2. Verify if the user, under which BizTalk host instance in running, have sufficient rights on the target DB to execute the SP.  Make the service account sql login a sysadmin.

    3. Issue can be caused by a mismatch in the namespaces between the composite schema and the imported schema(s). It looks like the Composite Operation is not composed correctly. It has to be a very specific structure with certain namespaces and Operation.

    This Wiki Article explains the process step by step: BizTalk Server: Streamlining WCF SQL and Oracle Messaging-Only and Other Patterns

    4. You might have to regenerate the schemas if there were any changes in the stored procedure post creation of BizTalk schemas. 

    5. Verify the URL, Turns out that that “?” character is automatically appended in the bindings generated by using the Add Generated Items-> Consumer Adapter Service wizard.

    For example: mssql://sql/dev/Mydb?

    Refer: https://jamesfitzsimons.wordpress.com/2012/02/15/cryptic-biztalk-error-object-of-type-storedprocedure-does-not-exist/


    Rachit Sikroria (Microsoft Azure MVP)

    • Marked as answer by panadi Monday, June 27, 2016 1:03 PM
    Wednesday, June 22, 2016 6:05 PM
    Moderator

All replies

  • Hi,


    BizTalk service account permissions on the target database has sufficient access. try login to SQL Server with BizTalk Service account and check if you are able to execute the same stored procedure.

    if database does not have BizTalk service account add it and it should work. It looks like this error causing due to Insufficient Security.

    Hope this Helps!!!

    Please Mark as Answered if you satisfy with Reply.

    Wednesday, June 22, 2016 2:19 PM
  • Hi Panadi

    The error can mean various things, even an access issue for the Host Instance service account on the destination database.

    Try the troubleshooting steps listed here and see if it helps-

    https://social.msdn.microsoft.com/Forums/en-US/8cf3fb36-c769-4daa-b8fb-1eefe492df82/wcf-sql-adapter-metadataexception-object-does-not-exist?forum=biztalkr2adapters


    Thanks Arindam


    Wednesday, June 22, 2016 2:21 PM
    Moderator
  • Hi Panadi,

    This issue can be caused because of many reasons.

    Try and check following points:

    1. Update the SQL URI with the complete SQL instance name, if you are using the a named instance.

    2. Verify if the user, under which BizTalk host instance in running, have sufficient rights on the target DB to execute the SP.  Make the service account sql login a sysadmin.

    3. Issue can be caused by a mismatch in the namespaces between the composite schema and the imported schema(s). It looks like the Composite Operation is not composed correctly. It has to be a very specific structure with certain namespaces and Operation.

    This Wiki Article explains the process step by step: BizTalk Server: Streamlining WCF SQL and Oracle Messaging-Only and Other Patterns

    4. You might have to regenerate the schemas if there were any changes in the stored procedure post creation of BizTalk schemas. 

    5. Verify the URL, Turns out that that “?” character is automatically appended in the bindings generated by using the Add Generated Items-> Consumer Adapter Service wizard.

    For example: mssql://sql/dev/Mydb?

    Refer: https://jamesfitzsimons.wordpress.com/2012/02/15/cryptic-biztalk-error-object-of-type-storedprocedure-does-not-exist/


    Rachit Sikroria (Microsoft Azure MVP)

    • Marked as answer by panadi Monday, June 27, 2016 1:03 PM
    Wednesday, June 22, 2016 6:05 PM
    Moderator