none
BIZTALK EDIFACT decimal point issues RRS feed

  • Question

  • HI,

    Am getting below error when i pass my EDIFACT file.

    SegmentID: MEA
    Position in TS: 337
    Data Element ID: C17402
    Position in Segment: 4
    Position in Field: 2
    Data Value: 11.557
    37: Invalid character(s) found in data element

    I have defined the properties for that in below image.

    c17402 datatype is EDIFACT_N, does it allow decimals?or could you please tell me where am making wrong?

    Wednesday, June 11, 2014 3:21 PM

Answers

  • Yes and like I wrote, 2 times now, you have to change 0x2C (,) to 0x2E (.)

    Morten la Cour

    • Marked as answer by sandydv85 Thursday, June 12, 2014 1:23 PM
    Thursday, June 12, 2014 12:57 PM

All replies

  • Do you have a UNA segment in the EDIFACT file you are Receiving? If not , is the default, and you will need to change it to . on the Receive Pipeline.

    You would need to change the EFactDelimiter to:

    0x3A, 0x2B, 0x2E, 0x3F, 0x20, 0x27

    instead of 

    0x3A, 0x2B, 0x2C, 0x3F, 0x20, 0x27

    But I would not recommend it. It is not valid to send . in decimals if no UNA is supplied, so it is sort of a hack!

    Morten la Cour


    • Edited by la Cour Wednesday, June 11, 2014 5:21 PM
    Wednesday, June 11, 2014 5:11 PM
  • Hi Cour,

    File is not  being supplied with UNA segment, then how can i get rid of this problem..Needed urgently please..


    Thursday, June 12, 2014 12:17 PM
  • I already told you:

    You would need to change the EFactDelimiter to:

    0x3A, 0x2B, 0x2E, 0x3F, 0x20, 0x27

    instead of 

    0x3A, 0x2B, 0x2C, 0x3F, 0x20, 0x27

    Morten la Cour

    Thursday, June 12, 2014 12:23 PM
  • HI cour, this is present settings in the pipeline.

    0x3A, 0x2B, 0x2C, 0x3F, 0x2A, 0x27, 0x0D, 0x0A

    x0D, 0x0A refers to CRLF, even though it is throwing error

    Thursday, June 12, 2014 12:50 PM
  • Yes and like I wrote, 2 times now, you have to change 0x2C (,) to 0x2E (.)

    Morten la Cour

    • Marked as answer by sandydv85 Thursday, June 12, 2014 1:23 PM
    Thursday, June 12, 2014 12:57 PM