none
EDIFACT file failing to send via EDI assembler in send pipeline - Invalid character issue RRS feed

  • Question

  • hi Team,

    This is regarding the EDI error which is being faced at BizTalk, while sending the EDIFACT output file to the destination location using the role links.

    This is actually a migration project where the source is being changed from DB2 to SQL server. The existing code is working fine and the EDIFACT files are being passed regularly. The data contains Swedish characters as this data belongs to a Swedish client.

    I have to send an EDIFACT file via role links to the destination location (FILE/FTP). Maps are validating successfully but when the file goes to the EDI assembler shape in the send pipeline, it says as below. COuld you please help in resolving this issue. i am unable to figure out how to overcome this. :(

    FYI : The EDI assembler contains X12 character set as UTF-8.

    "

    Error details: Unable to read the stream produced by the pipeline.

     Details: Error: 1 (Field level error)

                                 SegmentID: MOA

                                 Position in TS: 19

                                 Data Element ID: C51602

                                 Position in Segment: 2

                                 Position in Field: 2

                                 Data Value:

                                 37: Invalid character(s) found in data element  "

    Thanks,

    Veena


    • Edited by Veena H Wednesday, February 15, 2017 7:08 AM Added additional points
    Wednesday, February 15, 2017 7:06 AM

Answers

  • Well, the error is pretty clear, MOA02 has invalid content.  What you need to do is test the actual input in Visual Studio.

    If you enable tracking on the Send Port, you can save the specific message that is causing this.  To make this easier, you can use a PassThrough Pipeline as well.

    Wednesday, February 15, 2017 1:21 PM
  • It seems like you are trying to enter an empty string into a monetary field, which is not allowed.

    The element C51602 (Monetary amount 5004) is of type: EDIFACT_N (can only contain numbers) and has a minimum length of 1 and a maximum length of 18.

    http://www.stylusstudio.com/edifact/D96A/MOA_.htm

    However: The element is optional (minOccurs = 0), so if you really don't have the amount, you just need to make sure that you are not mapping the element (C51602)

    Morten la Cour


    • Edited by la Cour Thursday, February 16, 2017 12:45 PM
    • Proposed as answer by SMSVikasK Sunday, February 19, 2017 4:13 PM
    • Marked as answer by Rachit SikroriaModerator Saturday, February 25, 2017 2:34 PM
    Thursday, February 16, 2017 12:41 PM

All replies

  • Well, the error is pretty clear, MOA02 has invalid content.  What you need to do is test the actual input in Visual Studio.

    If you enable tracking on the Send Port, you can save the specific message that is causing this.  To make this easier, you can use a PassThrough Pipeline as well.

    Wednesday, February 15, 2017 1:21 PM
  • It seems like you are trying to enter an empty string into a monetary field, which is not allowed.

    The element C51602 (Monetary amount 5004) is of type: EDIFACT_N (can only contain numbers) and has a minimum length of 1 and a maximum length of 18.

    http://www.stylusstudio.com/edifact/D96A/MOA_.htm

    However: The element is optional (minOccurs = 0), so if you really don't have the amount, you just need to make sure that you are not mapping the element (C51602)

    Morten la Cour


    • Edited by la Cour Thursday, February 16, 2017 12:45 PM
    • Proposed as answer by SMSVikasK Sunday, February 19, 2017 4:13 PM
    • Marked as answer by Rachit SikroriaModerator Saturday, February 25, 2017 2:34 PM
    Thursday, February 16, 2017 12:41 PM