X12 00401 867 Receiving EDI Document fails with Invalid character in data element

Question

Hello,

 

I am use X12 4010 867 (BizTalk Server 2006 R2) to send a report. 

 

I have the All Parties to “Allow Leading and Trailing Zeroes and Spaces”.

 

I customized the X12_00401_867  ITA07 field to be X12_R (SimpleType).

 

When generating the XML of the 867 the ITA07 is a ####0.00 string value. 

 

The message is sent thru the Send Port successfully, but I then read back in the EDI file ( for batching ) and it fails with below.

 

Event Type: Error

Event Source:     BizTalk Server 2006 EDI

Event Category:   None

Event ID:   8116

Date:       6/3/2008

Time:       3:30:32 PM

User:       N/A

Description:

The batch element is being suspended as it failed validation. The error is : Stopping after the first error !!

Error: 1 (Field level error)

      SegmentID: ITA

      Position in TS: 16

      Data Element ID: ITA07

      Position in Segment: 7

      Data Value: 0.40

      6: Invalid character in data element

 

If I remove the trailing zero in this field it successfully reads the EDI file.

 

This there any way to change this behavior?

 

 

Thank,

Toby

Answer 1

Your party properties for EDI contains a checkbox under sender properties that you can check to allow leading and trailing zeros and spaces.  Under Validation and ACK Generation.  Checking that box will allow the trailing space.

 

Answer 2

Hello,

 

Yes, I have the All Parties to “Allow Leading and Trailing Zeroes and Spaces” on both Sending and Receiving Validation and ACK Generation Sections.

 

-Toby

Answer 3

EDI Pipeline is able to receive it successfully after setting "allow Leading and trailing zeros and spaces..". The error is coming while validating the document during batching. I will find out if there is any way to turnoff batch validation for it.

Answer 4

Currently in batching there is no way to enable 'allow leading and trailing zeros and spaces'.

 

Thanks,

Koushik

 

Answer 5

what the best way to handle these un-predictable spaces?

---

amit kumar

Answer 6

Has anyone found a workaround for this?  I have an 810 that will not batch because the EDI batching orchestrations do not like the decimals and/or leading and trialing zero's in my EDI document.