> > Unable to Map 8-Digit Date

Unable To Map EDI 8-Digit Date to Database Field with Clarify 4.6

Clarify Scenario:

We are trying to map the following x12 EDI 940 data into database tables. Specifically the G6202 element.

ST*940*0001^
W05*N*155098*^
G62*10*20170315^
LX*1^
W01*2*BX**VN*BNK-0481^
N9*L1*0001^
LX*2^
W01*1*BX**VN*BNK-0208^
N9*L1*0002^
SE*8*0001^

Clarify Issue:

When we we try the G62 data 20170315 to a database field an error occurs in the Clarify Server Auditor.



Server Error:

Auditor:

Step Messages:
2017-03-16 14:36:00,450 [PERSISTENT] - Starting Transformation Engine
2017-03-16 14:36:00,466 [INFO ] - env.var.Log_of_Interchange_Id ---> 7a16e1cbd89e415abef1b50dffaf9bfb
2017-03-16 14:36:01,034 [ERROR] - Length of value '1489554000000' is greater than '8' specified in the field 'DateFielde'. (Exception running ruleset com.abc.acme.inbound.n940.Acme940EdiToDbRS at rule 52 : new Move().execute(source.Area1.G62.current.G62373) => #[target.Header.current.DateField])
2017-03-16 14:36:01,094 [PERSISTENT] - Ending Transformation Engine; Completed in 634ms.
2017-03-16 14:36:01,094 [PERSISTENT] - Completed Task.

Clarify Resolution:

With Clarify 4.6+, users will not be able to move an EDI date element, into a date field. Users will be required to use the ruleset action: FormatDateTime.
For more information on FormatDateTime, CLICK HERE.
For more assistance or overview of Cleo Clarify 4.6, please feel free to CONTACT OUR GROUP.


By: on