Problem in creating an Input Schema for the Positional Flat File

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Problem in creating an Input Schema for the Positional Flat File

Viewing 0 reply threads
  • Author
    Posts
    • #16116

      I am facing problems in creating the input schema for the given inputs (types defined below).

       

      The Input Schema has been defined as:

       

      OrderRoot

              | – Order Records                         (Repeating – max Occurs = Unbounded)

                           |— Header Rec               (Non Repeating – max Occurs = 1)

                           |— Parent Rec                (Non Repeating – max Occurs = 1, min Occurs = 0)           

                           |— Child                         (Repeating)

                                      |— Child Rec         (Non-Repeating)   

                                      |— Grandchild 1 (Non-Repeating)

                                      |— Grandchild 2 (Repeating)  

                           |— Trailer Rec                  (Non-Repeating)

                                        

      There can be many occurrences of Order Records and many Child records for a Parent Rec and many Grandchild 2 Rec for a single Child.

       

       

      There can be 2 kinds of Inputs:

       

      A Parent Order would look like

      ‘00’ Header

      ‘05’ Parent

      ‘10’ Child 1

      ‘15’ Grandchild 1A for Child 1

      ‘20’ Grandchild 2A for Child 1

      ‘20’ Grandchild 2B for Child 1

      ‘10’ Child 2

      ‘15’ Grandchild 1B for Child 2

      ‘20’ Grandchild 2C for Child 2

      ‘20’ Grandchild 2D for ‘Child 2

      ‘99’ Trailer

       

      And a Child Only Order would look like

      ‘00’ Header

      ‘10’ Child

      ‘15’ Grandchild for Child

      ‘20’ Grandchild 2A for Child

      ‘20’ Grandchild 2B for Child

      ‘99’ Trailer

       

      That is

      Child has a record ChildRec.

      It has 2 children of which one (grandchild2) has many occurrences.

       

      The flat file consists of many Orders ( mixture of Parent Orders and Child Only Orders).

       

       

      The concern:

       

      Parent Rec has to be made Optional. Despite making min Occurs for Parent Rec as 0 , the Input schema fails for Child Only Order type Inputs. I tried manipulating other properties like Group min occurs and use Group Order sequence as choice, but the Child Only Order Input does fail. (Throwing Errors like – Incomplete Content: missing parent records or errors like found unexpected data while searching for ‘05’). The Input Schema works fine when Parent Order type Inputs are given.                           

       

      I would like to know what modifications must be done to the input schema so that both the inputs succeed against the schema. 

      Thanks

      Ankit 

       

       

       

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