Re: Using Spread for BizTalk – Can’t find matching Schema Error

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Using Spread for BizTalk – Can’t find matching Schema Error › Re: Using Spread for BizTalk – Can’t find matching Schema Error

February 1, 2010 at 2:25 PM #24173
community-content

    HI Daniel,

    I do appreciate your responses.

    This is long before I even get to BizTalk. I have spent they walking through this step by step to see where it might be, so let me see if I can explain my process.

    1) Using the  Spreadsheet schema wizard, create a schema based on the .xls file. Once created, I validate the schema then validate the instance. Both validate successfully. The resulting xml looks like this:

    <id_id>2</id_id>

      <id_client_id_client>15113</id_client_id_client>
      <id_claim_no_id_claim_no>0105-073757-001</id_claim_no_id_claim_no>
      <id_claimid_id_claimid>SIS 151130105073757001</id_claimid_id_claimid>
      <id_brfile_id_brfile>0105-073757</id_brfile_id_brfile>
      <clmt_name_clmt_name>ANDRADE REIGOBER</clmt_name_clmt_name>
      <clmt_age_clmt_age>23</clmt_age_clmt_age>
      <clmt_wage_clmt_wage>520</clmt_wage_clmt_wage>
      <clmt_len_clmt_len>12</clmt_len_clmt_len>
      <cov_major_cov_major>WC</cov_major_cov_major>

     2) Create a pipeline, using the Spreadhseet disassemblere and setting the Document Schema to the schema I created in step 1.

     3) Add an Adapter Service (Generated Item) that creates a schema for my insert stored procedure.

    4) Add a Map. The source schema is my file schema and the Destination schema is the stored procedure schema. I then map a few string columns and save the map.

    5) I then validate the map. This is successful.

    6) I then TEST the map. This fails. I look at the file used for the test map, and it looks like this:

      <ns0:id_id>10</ns0:id_id>
      <ns0:id_client_id_client>10</ns0:id_client_id_client>
      <ns0:id_claim_no_id_claim_no>id_claim_no_id_claim_no_0</ns0:id_claim_no_id_claim_no>
      <ns0:id_claimid_id_claimid>id_claimid_id_claimid_0</ns0:id_claimid_id_claimid>
      <ns0:id_brfile_id_brfile>id_brfile_id_brfile_0</ns0:id_brfile_id_brfile>
      <ns0:clmt_name_clmt_name>clmt_name_clmt_name_0</ns0:clmt_name_clmt_name>
      <ns0:clmt_age_clmt_age>10</ns0:clmt_age_clmt_age>
      <ns0:clmt_wage_clmt_wage>10</ns0:clmt_wage_clmt_wage>
      <ns0:clmt_len_clmt_len>10</ns0:clmt_len_clmt_len>
      <ns0:cov_major_cov_major>cov_major_cov_major_0</ns0:cov_major_cov_major>

    Why are the values for the elements the NAME of the element and not the actual values? This is why I am getting the error i received earlier:

    Output validation error: The ‘http://schemas.microsoft.com/Sql/2008/05/TypedProcedures/dbo:line_of_coverage_type_code_value&#8217; element is invalid – The value ‘cov_major_cov_major_0’ is invalid according to its datatype ‘String’ – The actual length is greater than the MaxLength value.

    cov_major is only 10 characters long. But because it is bringing in the element name as the value, it is failing.

    I am lost at this point. BizTalk isn’t even in the picture yet and i need to find out why the map test is failing, or more specifically, why it is using the element names for the string values and the number 10 for numerical values.