SQL Receive location error – "This is not a valid schema generated by the SQL Schema Wizard"

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL Receive location error – "This is not a valid schema generated by the SQL Schema Wizard"

Viewing 1 reply thread
  • Author
    Posts
    • December 6, 2006 at 1:59 AM #16742
      community-content

        Hello,
        I want Biztalk 2004 to call a stored procedure from a SQL Receive Location, but get the error "This is not a valid schema generated by the SQL Schema Wizard".

        This happens when I am creating a SQL Receive Location and select the SQL Command in the SQL Transport Properties pop up to pick a schema to use. The XMLDATA-tag is removed from the SQL stored procedure after the generation of the schema was done.

        Anyone having experience of this? How do I troubleshoot this?

         

         

         

      • December 6, 2006 at 2:32 PM #16752
        community-content

          That should work.  Check to make sure you haven’t made any changes to the schema after is was auto generated by the wizard (is was auto generated right?).  Then, ensure your schema is deployed and host is restarted.  Also, make sure your connection string is correct.

           

          If all else fails, I’d try regenerating the schema again.

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.