I need some help please, new to BizTalk 2013...
Using the original XML created by BizTalk from Passing in a 837 file and having it convert to XML. I keep getting this error when passing the file back in from SQL.
If I change the sendport to Passthru I can see the XML file is being created just fine. But once I change to EDISend I start getting an error. Mapping from a created XML schema to the standard x12_837_P schema.
Error: 1 (Miscellaneous error)
7: Missing or invalid transaction set control number
Error: 2 (Miscellaneous error)
3: Transaction Set Control Number Mismatch
Error: 3 (Miscellaneous error)
4: Number of included segments do not match
Error: 4 (Field level error)
SegmentID: ST
Position in TS: 1
Data Element ID: ST01_TransactionSetIdentifierCode
Position in Segment: 1
Data Value:
1: Mandatory data element missing
Error: 5 (Field level error)
SegmentID: ST
Position in TS: 1
Data Element ID: ST02_TransactionSetControlNumber
Position in Segment: 2
Data Value:
1: Mandatory data element missing
Error: 6 (Field level error)
SegmentID: ST
Position in TS: 1
Data Element ID: ST03_ImplementationGuideVersionName
Position in Segment: 3
Data Value:
1: Mandatory data element missing
Error: 7 (Field level error)
SegmentID: BHT
Position in TS: 2
Data Element ID: BHT01_HierarchicalStructureCode
Position in Segment: 1
Data Value:
1: Mandatory data element missing
Error: 8 (Field level error)
SegmentID: BHT
Position in TS: 2
Data Element ID: BHT02_TransactionSetPurposeCode
Position in Segment: 2
Data Value:
1: Mandatory data element missing
Error: 9 (Field level error)
SegmentID: BHT
Position in TS: 2
Data Element ID: BHT03_OriginatorApplicationTransactionIdentifier
Position in Segment: 3
Data Value:
1: Mandatory data element missing
Error: 10 (Field level error)
SegmentID: BHT
Position in TS: 2
Data Element ID: BHT04_TransactionSetCreationDate
Position in Segment: 4
Data Value:
1: Mandatory data element missing
ECT...
Start of XML..
<ns0:X12_00501_837_P xmlns:ns0="http://Company.BizTalk.SQLSource">
<ST>
<ST01_TransactionSetIdentifierCode>837</ST01_TransactionSetIdentifierCode>
<ST02_TransactionSetControlNumber>2227576</ST02_TransactionSetControlNumber>
<ST03_ImplementationGuideVersionName>005010X222A1</ST03_ImplementationGuideVersionName>
</ST>
<ns0:BHT_BeginningofHierarchicalTransaction>
<BHT01_HierarchicalStructureCode>0019</BHT01_HierarchicalStructureCode>
<BHT02_TransactionSetPurposeCode>00</BHT02_TransactionSetPurposeCode>
<BHT03_OriginatorApplicationTransactionIdentifier>2227576</BHT03_OriginatorApplicationTransactionIdentifier>
<BHT04_TransactionSetCreationDate>20150722</BHT04_TransactionSetCreationDate>
<BHT05_TransactionSetCreationTime>2305</BHT05_TransactionSetCreationTime>
<BHT06_ClaimorEncounterIdentifier>CH</BHT06_ClaimorEncounterIdentifier>
</ns0:BHT_BeginningofHierarchicalTransaction>
<ns0:NM1_SubLoop>
<ns0:TS837_1000A_Loop>
<ns0:NM1_SubmitterName>
<NM101_EntityIdentifierCode>41</NM101_EntityIdentifierCode>
<NM102_EntityTypeQualifier>2</NM102_EntityTypeQualifier>