Newbie: Flat file input sequence does not match Schema

Home Page Forums BizTalk 2004 – BizTalk 2010 Newbie: Flat file input sequence does not match Schema

Viewing 1 reply thread
  • Author
    Posts
    • #16606

      Hello,

      I created an Invoice schema using the flat file wizard after reading the "Creating a Flat file Schema from a document instance walkthrough". 

      My flat file may have one or more product records per invoice, a serial number record may or may not exist for each product record, none or multiple freight records may exists for each invoice. A sample of file record sequence is listed below:

      IVA (Invoice)

      IVB (product)

      IVS (serial#)

      IVB (product)

      IVF (freight)

      IVF (freight)

      IVA (Invoice)

      IVB (product)

      IVF (freight)

      When I tested this using validate instance in Visual Studio it failed with error message :

      error BEC2004: Unexpected data found while looking for:

      'IVF'

      'IVS'

      The current definition being parsed is Base. The stream offset where the error occured is 405. The line number where the error occured is 4. The column where the error occured is 0.

      C:\BizInvoice\BzInvoiceSolution\BizInvoiceSchemas\IMInvoice.xsd: error BEC2004: Validate Instance failed for schema IMInvoice.xsd, file:

       

      Component invocation succeeded.

      I think if failed because it was not expecting another IVB in line 4.  How do I set up the schema for multiple IVB records? 

       

      I have also tried creating a schema where:

      • IVB is a child record of IVA
      • IVS is a child record of IVB
      • IVF is a child record of IVA

      But I think it was confused with the child delimiter (not recognising the CRLF).

       

      Any help would be much appreciated.

       

      Cheers

       

    • #16610

      Is it possible to email me your schema and a sample flat file

      • #16647

        Hello Greg,

        Thanks for your offer.  I actually found the solution in a reply that you made to post #3557 that you made to someone else!

        Cheers

         

        • #22185

          Hi Greg,

          If you are interested, I have a flat file similar to the one above and having lots of trouble creating a schema in biztalk for it. If I could send you through a sample of the flat file do you think you could pass on some help with how to create the schema.

          Thanks

           

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