none
Problem while using SQL Adopter in BizTalk application RRS feed

  • Question

  • I am developing and application which uses SQL Adapter to insert Customer information in a table using a store procedure.

    I developed the following BizTalk artifacts:

    1- Created a CustomerMaster schema

    2- Added a Generated Item so that I may use the SQL Adapter later on. It created another schema SQLService according to table structure and an orchestration.

    3- Created a Map to map CustomerMaster and SQLService elements.

    4- I then developed the Orchestration which receives CustomerMaster and then transform into SQLService request to interact with DB.

    5- After deployment I created Physical Ports and bind it with Orchestration artifact accordingly.

    Now, when I put the CustomerMaster instance on Receive Location on the disk for processing, it logs following error in Event log and suspend the message.

    Event Type: Error
    Event Source: BizTalk Server 2006
    Event Category: BizTalk Server 2006
    Event ID: 5719
    Date:  8/8/2010
    Time:  1:12:00 AM
    User:  N/A
    Computer: .
    Description:
    There was a failure executing the receive pipeline: "Microsoft.BizTalk.DefaultPipelines.XMLReceive, Microsoft.BizTalk.DefaultPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Source: "XML disassembler" Receive Port: "rcvpSPCustomerMaster" URI: "E:\Data\BizTalk\SQLAdapterTest\SQLCustomerPort\Receive_SPCustomerMaster\*.xml" Reason: Finding the document specification by message type "http://SQLAdapterTest.CustomerMaster#CustomerMaster" failed. Verify the schema deployed properly.

    What is the solution of this problem?

    Saturday, August 7, 2010 8:52 PM

Answers

  • Hi,

    If there is no schema deployed in BizTalk that match the MessageType of the input message, it simply throws an error you are seeing. There are a few steps you can do in that case:

    • un-deploy and redeploy the assemblies you are using;
    • make sure all your maps and pipelines are set correctly after you redeploy;
    • check the GAC and ensure that the schema is there, be sure the version numbers are the same;
    • make sure you are restarting all the hosts.

    Finally you can also Management Database as explained in this post.

    HTH

    Regards,

    Steef-Jan Wiggers - MVP & MCTS BizTalk Server
    blog: http://soa-thoughts.blogspot.com/
    If this answers your question please mark it accordingly


    BizTalk
    • Marked as answer by Muhammad_Arif Sunday, August 8, 2010 7:35 PM
    Sunday, August 8, 2010 9:17 AM
    Moderator
  • Thanks all for your support especiall Steef-Jan Wigger as your post solved my issue.

    Infact the namespace in my message was not maching with the one that was deployed. The followoing post is helpful if you want to see that your schema is deployed correctly or not and your message instance should have the same namespace.

    http://abdulrafaysbiztalk.wordpress.com/2009/08/19/verifyingschemas-after-deployment/

    Regards,

    Muhammad Arif

     

    • Marked as answer by Muhammad_Arif Sunday, August 8, 2010 7:41 PM
    Sunday, August 8, 2010 7:41 PM

All replies

  • Hi,

    If there is no schema deployed in BizTalk that match the MessageType of the input message, it simply throws an error you are seeing. There are a few steps you can do in that case:

    • un-deploy and redeploy the assemblies you are using;
    • make sure all your maps and pipelines are set correctly after you redeploy;
    • check the GAC and ensure that the schema is there, be sure the version numbers are the same;
    • make sure you are restarting all the hosts.

    Finally you can also Management Database as explained in this post.

    HTH

    Regards,

    Steef-Jan Wiggers - MVP & MCTS BizTalk Server
    blog: http://soa-thoughts.blogspot.com/
    If this answers your question please mark it accordingly


    BizTalk
    • Marked as answer by Muhammad_Arif Sunday, August 8, 2010 7:35 PM
    Sunday, August 8, 2010 9:17 AM
    Moderator
  • In general this error says that the message the pipeline received does not match your xml schema definition. Did you compare your input XML message to the schema you created? Do they really match?
    If you like my post or consider it as a valid answer, please use the buttons to show me - Oliver

    http://biztalk.hauth.me

    Sunday, August 8, 2010 11:08 AM
  • Thanks all for your support especiall Steef-Jan Wigger as your post solved my issue.

    Infact the namespace in my message was not maching with the one that was deployed. The followoing post is helpful if you want to see that your schema is deployed correctly or not and your message instance should have the same namespace.

    http://abdulrafaysbiztalk.wordpress.com/2009/08/19/verifyingschemas-after-deployment/

    Regards,

    Muhammad Arif

     

    • Marked as answer by Muhammad_Arif Sunday, August 8, 2010 7:41 PM
    Sunday, August 8, 2010 7:41 PM