none
Biztalk EDI Receive Pipe Line Error RRS feed

  • Question

  • Hi,

    I have an issue in Processing EDI File using EDI Receive Pipeline , please help me to fix the below issue

    A message received by adapter "FILE" on receive location "rcvedi" with URI "C:\bzt\Projects\x12850Prj\x12850ediprj\ProcessEDI_TestLocations\EdiRec\*.txt" is suspended.

    Error details: An output message of the component "Unknown " in receive pipeline "Microsoft.BizTalk.Edi.DefaultPipelines.EdiReceive, Microsoft.BizTalk.Edi.EdiPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" is suspended due to the following error:

    Error encountered during parsing. The X12 transaction set with id '0001' contained in functional group with id '1', in interchange with id '000000025', with sender id 'THEM ', receiver id 'US ' is being suspended with following errors:

    Error: 1 (Field level error)

    SegmentID: BEG

    Position in TS: 2

    Data Element ID: BEG05

    Position in Segment: 5

    Data Value: 950727

    8: Invalid Date

    Error: 2 (Field level error)

    SegmentID: DTM

    Position in TS: 4

    Data Element ID: DTM02

    Position in Segment: 2

    Data Value: 970523

    8: Invalid Date

    .

    The sequence number of the suspended message is 2.

    MessageId: {AB4972D2-3ED3-4791-9A1E-D707C5908527}

    InstanceID: {0515D711-080E-4DB9-9D50-AA9158E20247}

    Thanks

    Jaison

    Monday, September 9, 2013 1:57 PM

Answers

  • Hi,

    PO1*72*25*EA*3.12*PE*ST*M3PE515*CL*80083***IZ*1SZ***UP*883936384792*PT*CP*PO*251519*LI*72~
    Qualifier PO122 - LI is not expected please check the Enumaration values of this element in the EDI 850 schema

    REF*HTS*7117.19.9000~ here HTS is not expected please check the Enumaration value it should have been HS/HT whatsoever you want

    so on and so forth check the other errors too.

    Thanks/Dhiraj

    I hope this helps to you, if it does please mark this post as answered.

    • Proposed as answer by Dhiraj Bhavsar Tuesday, September 10, 2013 11:40 AM
    • Marked as answer by JaisonAntony Tuesday, September 10, 2013 1:13 PM
    Tuesday, September 10, 2013 11:40 AM
  • Hi Jaison,

    Dhiraj has pointed out the correct areas, are you able to resolve the issue?



    I hope this helps!!!!!!

    Maheshkumar S. Tiwari|BizTalk Developer Interview Questions and Answers

    http://tech-findings.blogspot.com/


    • Marked as answer by JaisonAntony Tuesday, September 10, 2013 1:13 PM
    Tuesday, September 10, 2013 12:38 PM

All replies

  • Hi Jaison ,

    From the error it appears "Date" is problem. Can you check the BEG05 element and see what's the date format.

    Normally Date is  expected  as "CCYYMMDD" where CC represents the first two digits of the calendar year.

    e.g., 20130909



    I hope this helps!!!!!!

    Maheshkumar S. Tiwari|BizTalk Developer Interview Questions and Answers

    http://tech-findings.blogspot.com/



    Monday, September 9, 2013 2:45 PM
  • Hi Mahesh,

    Thank you very much for your quick reply

    I have changed  BEG date and got same error message

    please check below sample edi

    ISA*00*          *00*          *ZZ*THEM           *ZZ*US             *991221*1226*U*00401*000000025*0*T*>
    GS*PO*THEM*US*19991221*1226*1*X*004010
    ST*850*0001
    BEG*00*NE*3859199838**20130909***IBM
    PER*AA*Andrew Carlson*TE*(708) 555-2930
    DTM*002*970523
    PO1*1*93*BX*145.39**CB*KOW-20392-10
    PID*F****Uninterruptible Power System
    PER*AA*Camilla Anderson*TE*(708) 555-2011
    PO1*2*25*EA*35.68**CB*1093-4927-001
    PID*F****High Volume Printer Stand
    PER*AA*Miranda Cappelan*TE*(708) 555-1111
    PO1*3*4*PC*2002.91**CB*ABX-2001
    PID*F****Electronics Cabinet Package (56" High)
    CTT*3
    SE*14*0001
    GE*1*1
    IEA*1*000000025

    Thanks

    Jaison

    Monday, September 9, 2013 3:04 PM
  • Hi Jaison,

    BEG segment has 6 data elements.Also your DTM02 needs date in correct format.

    BEG*00*NE*3859199838**20130909*IBM

    DTM*002*20130909

    . Can you add above in your sample file and try. Let us know what you get.


    I hope this helps!!!!!!

    Maheshkumar S. Tiwari|BizTalk Developer Interview Questions and Answers

    http://tech-findings.blogspot.com/




    Monday, September 9, 2013 3:17 PM
  • Hi ,

    Thanks for your reply I have added  date and BEG values . I am getting result with some errors . Can you please check my samples

    A message received by adapter "FILE" on receive location "rcvtxtloc" with URI "C:\bzt\Projects\InbndTest\ProcessEDI_TestLocations\Scenario A\fromTHEM\*.txt" is suspended.

    Error details: An output message of the component "Unknown " in receive pipeline "Microsoft.BizTalk.Edi.DefaultPipelines.EdiReceive, Microsoft.BizTalk.Edi.EdiPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" is suspended due to the following error:

    The interchange with id '000000025', with sender id 'THEM ', receiver id 'US ' had structural error in/before the first functional group.

    The sequence number of the suspended message is 2.

    MessageId: {ABA317EA-253B-418E-B266-ECA305329D14}

    InstanceID: {610D9C46-93EB-49E3-9196-A6E01D09A55E}

    ISA*00*          *00*          *ZZ*THEM           *ZZ*US             *991221*1226*U*00401*000000025*0*T*>
    GS*PO*THEM*US*19991221*1226*1*X*004010
    ST*850*0001
    BEG*00*SA*251519**20130313*IBM
    CUR*BY*USD
    REF*AAY*FA13
    REF*8X*FOB
    REF*XY*HOT PERM USNJ1
    FOB*MX
    ITD*01***********LETTER OF CREDIT
    DTM*010*20130509
    DTM*001*20130523
    TD5*****2
    N1*VN*BOW*92*048
    N3*NO. 16 XIECHENG ROAD.*LIUTING GONGYEYUAN CHENGYANG
    N4*QINGDAON, SHANDONG**2666108*CN
    N1*LG*TRADELINK ONE*92*TLO
    N4****US
    N1*DV*MARC WOMENS JEWELRY*92*MWJ
    N2*MARC WOMENS JEWELRY
    N3*72 SPRING STREET
    N4*NEW YORK*NY*10012*US
    PO1*72*25*EA*3.12*PE*ST*M3PE515*CL*80083***IZ*1SZ***UP*883936384792*PT*CP*PO*251519*LI*72
    PID*F*08***ZIP IT STUDS
    PID*F*73***ARGENTO
    PID*F*74***1SZ
    REF*HTS*7117.19.9000
    REF*SH*1
    DTM*037*20130502
    DTM*038*20130509
    DTM*AAG*20130523
    N1*MP**92*025
    N1*ST*TRANS WORLD SHIPPING SPA*92*TWSI
    N3*CONTRADA BRANCADORO*VIA GALILEO GALILEI
    N4*S. ELPIDIO A MARE (FM)**63011*IT
    N1*AG*WILLIAM E CONNOR - MBM ACC*92*048
    AMT*1*78
    PO1*73*65*EA*4.31*PE*ST*M3PE515*CL*80096***IZ*1SZ***UP*883936384808*PT*CP*PO*251519*LI*73
    PID*F*08***ZIP IT STUDS
    PID*F*73***ORO
    PID*F*74***1SZ
    REF*HTS*7117.19.9000
    REF*SH*1
    DTM*037*20130502
    DTM*038*20130509
    DTM*AAG*20130523
    N1*MP**92*025
    N1*ST*TRANS WORLD SHIPPING SPA*92*TWSI
    N3*CONTRADA BRANCADORO*VIA GALILEO GALILEI
    N4*S. ELPIDIO A MARE (FM)**63011*IT
    N1*AG*WILLIAM E CONNOR - MBM ACC*92*048
    AMT*1*280.15
    SE*51*0001

    Thanks

    Jaison

    Tuesday, September 10, 2013 6:39 AM
  • Hi Jaison,

    What is the segment separator you are using? 

    Can you try with below message(I have used "~" as a segment separator)

    ISA*00*          *00*          *ZZ*THEM           *ZZ*US             *991221*1226*U*00401*000000025*0*T*>~
    GS*PO*THEM*US*19991221*1226*1*X*004010~
    ST*850*0001~
    BEG*00*SA*251519**20130313*IBM~
    CUR*BY*USD~
    REF*AAY*FA13~
    REF*8X*FOB~
    REF*XY*HOT PERM USNJ1~
    FOB*MX~
    ITD*01***********LETTER OF CREDIT~
    DTM*010*20130509~
    DTM*001*20130523~
    TD5*****2~
    N1*VN*BOW*92*048~
    N3*NO. 16 XIECHENG ROAD.*LIUTING GONGYEYUAN CHENGYANG~
    N4*QINGDAON, SHANDONG**2666108*CN~
    N1*LG*TRADELINK ONE*92*TLO~
    N4****US~
    N1*DV*MARC WOMENS JEWELRY*92*MWJ~
    N2*MARC WOMENS JEWELRY~
    N3*72 SPRING STREET~
    N4*NEW YORK*NY*10012*US~
    PO1*72*25*EA*3.12*PE*ST*M3PE515*CL*80083***IZ*1SZ***UP*883936384792*PT*CP*PO*251519*LI*72~
    PID*F*08***ZIP IT STUDS~
    PID*F*73***ARGENTO~
    PID*F*74***1SZ~
    REF*HTS*7117.19.9000~
    REF*SH*1~
    DTM*037*20130502~
    DTM*038*20130509~
    DTM*AAG*20130523~
    N1*MP**92*025~
    N1*ST*TRANS WORLD SHIPPING SPA*92*TWSI~
    N3*CONTRADA BRANCADORO*VIA GALILEO GALILEI~
    N4*S. ELPIDIO A MARE (FM)**63011*IT~
    N1*AG*WILLIAM E CONNOR - MBM ACC*92*048~
    AMT*1*78~
    PO1*73*65*EA*4.31*PE*ST*M3PE515*CL*80096***IZ*1SZ***UP*883936384808*PT*CP*PO*251519*LI*73~
    PID*F*08***ZIP IT STUDS~
    PID*F*73***ORO~
    PID*F*74***1SZ~
    REF*HTS*7117.19.9000~
    REF*SH*1~
    DTM*037*20130502~
    DTM*038*20130509~
    DTM*AAG*20130523~
    N1*MP**92*025~
    N1*ST*TRANS WORLD SHIPPING SPA*92*TWSI~
    N3*CONTRADA BRANCADORO*VIA GALILEO GALILEI~
    N4*S. ELPIDIO A MARE (FM)**63011*IT~
    N1*AG*WILLIAM E CONNOR - MBM ACC*92*048~
    AMT*1*280.15~
    SE*51*0001~
    GE*1*1~
    IEA*1*000000025~




    I hope this helps!!!!!!

    Maheshkumar S. Tiwari|BizTalk Developer Interview Questions and Answers

    http://tech-findings.blogspot.com/



    Tuesday, September 10, 2013 8:04 AM
  • Hi Mahesh,

    I appreciate your valuable help . When I try above edi data in my project  I am getting below error message Can you please check and let me know how to fix it

    A message received by adapter "FILE" on receive location "rcv850fileloc" with URI "K:\bzt\Projects\x12850ediprj\ProcessEDI_TestLocations\RcvFlatFileEDI\*.txt" is suspended.

    Error details: An output message of the component "Unknown " in receive pipeline "Microsoft.BizTalk.Edi.DefaultPipelines.EdiReceive, Microsoft.BizTalk.Edi.EdiPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" is suspended due to the following error:

    Error encountered during parsing. The X12 transaction set with id '0001' contained in functional group with id '1', in interchange with id '000000025', with sender id 'THEM ', receiver id 'US ' is being suspended with following errors:

    Error: 1 (Field level error)

    SegmentID: PO1

    Position in TS: 21

    Data Element ID: PO122

    Position in Segment: 22

    Data Value: LI

    7: Invalid code value

    Error: 2 (Field level error)

    SegmentID: REF

    Position in TS: 25

    Data Element ID: REF01

    Position in Segment: 1

    Data Value: HTS

    7: Invalid code value

    Error: 3 (Field level error)

    SegmentID: PO1

    Position in TS: 36

    Data Element ID: PO122

    Position in Segment: 22

    Data Value: LI

    7: Invalid code value

    Error: 4 (Field level error)

    SegmentID: REF

    Position in TS: 40

    Data Element ID: REF01

    Position in Segment: 1

    Data Value: HTS

    7: Invalid code value

    .

    The sequence number of the suspended message is 1.

    MessageId: {DA9D1F9D-C88A-4F7C-A3CC-3A9535BC8A71}

    Thanks

    Jaison

    Tuesday, September 10, 2013 8:50 AM
  • Hi,

    PO1*72*25*EA*3.12*PE*ST*M3PE515*CL*80083***IZ*1SZ***UP*883936384792*PT*CP*PO*251519*LI*72~
    Qualifier PO122 - LI is not expected please check the Enumaration values of this element in the EDI 850 schema

    REF*HTS*7117.19.9000~ here HTS is not expected please check the Enumaration value it should have been HS/HT whatsoever you want

    so on and so forth check the other errors too.

    Thanks/Dhiraj

    I hope this helps to you, if it does please mark this post as answered.

    • Proposed as answer by Dhiraj Bhavsar Tuesday, September 10, 2013 11:40 AM
    • Marked as answer by JaisonAntony Tuesday, September 10, 2013 1:13 PM
    Tuesday, September 10, 2013 11:40 AM
  • Hi Dhiraj,

    Thank You very much for your quick reply

    Thanks

    Jaison

    Tuesday, September 10, 2013 12:34 PM
  • Hi Jaison,

    Dhiraj has pointed out the correct areas, are you able to resolve the issue?



    I hope this helps!!!!!!

    Maheshkumar S. Tiwari|BizTalk Developer Interview Questions and Answers

    http://tech-findings.blogspot.com/


    • Marked as answer by JaisonAntony Tuesday, September 10, 2013 1:13 PM
    Tuesday, September 10, 2013 12:38 PM
  • Yes Thank You very much
    Tuesday, September 10, 2013 1:14 PM