Error while processing EDI File

Hi,

The scenario is inbound. I am using Sender File adapter with NFS protocol. The channel is picking the file. it is successful in Adapter engine but in Moni it is giving mapping error. the mapping error is coming due to some missing value in the field but the value in the field is there in the payload. I suspect the change in the structure. when i tried to copy the inbound payload and went to test in message mapping, whole structure is in red. I am using localejbs/X12ConverterModule in module config.

Please suggest.

SAP Managed Tags:
SAP Process Integration

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (2)

Hi Sherwin,

Please check and compare the structure of the inbound message and the structure that you get in the test tab of mapping [the initial structure before you paste your payload in the test tab]. You will get to know if there is a difference in the structure.

Thanks and Regards,

Satanik

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

HI Satanik,

Yes I can see the change in the structure but i dont know how to correct it. Please check the error and successful screenshot of the message. please note that it was successful when it was sent from RWB not by sender file channel. it was never successful when went by sender file channel.

Error

successful screenshot when sent from RWB

Hi Sherwin,

There is a namespace difference in the successful and failed payload.

Please paste the structure that you get in the test tab of mapping [the initial structure before you paste your payload in the test tab].

You would get a reason for the structure being in error in mapping.

Also, from a different front what is the expected number of occurrences for the field TrackingMainID in the target structure. Please check if a value is getting populated for every occurrence.

Thanks and Regards,

Satanik

HI,

Please find the structure below. yes, there is a namespace difference, Should i use AF_Modules/XMLAnonymizerBean ?

<?xml version="1.0" encoding="UTF-8"?>

<ns0:ASC214_004010 xmlns:ns0="http://sap.com">

<S_ISA>

<D_DATAELEMENTSEPARATOR/>

<D_I01/>

<D_I02/>

<D_I03/>

<D_I04/>

<D_I05/>

<D_I06/>

<D_I05_2/>

<D_I07/>

<D_I08/>

<D_I09/>

<D_I10/>

<D_I11/>

<D_I12/>

<D_I13/>

<D_I14/>

<D_I15/>

<D_SEGMENTTERMINATOR/>

<S_GS>

<D_479/>

<D_142/>

<D_124/>

<D_373/>

<D_337/>

<D_28/>

<D_455/>

<D_480/>

<S_ST>

<D_143/>

<D_329/>

<S_B10>

<D_127/>

<D_145/>

<D_140/>

<D_71/>

<D_128/>

<D_127_2/>

<D_1073/>

</S_B10>

<S_L11>

<D_127/>

<D_128/>

<D_352/>

</S_L11>

<S_MAN>

<D_88/>

<D_87/>

<D_87_2/>

<D_88_2/>

<D_87_3/>

<D_87_4/>

</S_MAN>

<S_K1>

<D_61/>

<D_61_2/>

</S_K1>

<L_0100>

<S_N1>

<D_98/>

<D_93/>

<D_66/>

<D_67/>

<D_706/>

<D_98_2/>

</S_N1>

<S_N2>

<D_93/>

<D_93_2/>

</S_N2>

<S_N3>

<D_166/>

<D_166_2/>

</S_N3>

<S_N4>

<D_19/>

<D_156/>

<D_116/>

<D_26/>

<D_309/>

<D_310/>

</S_N4>

<S_G61>

<D_366/>

<D_93/>

<D_365/>

<D_364/>

<D_443/>

</S_G61>

<S_G62>

<D_432/>

<D_373/>

<D_176/>

<D_337/>

<D_623/>

</S_G62>

<S_L11>

<D_127/>

<D_128/>

<D_352/>

</S_L11>

</L_0100>

<S_MS3>

<D_140/>

<D_133/>

<D_19/>

<D_91/>

<D_156/>

</S_MS3>

<L_0200>

<S_LX>

<D_554/>

</S_LX>

<L_0205>

<S_AT7>

<D_1650/>

<D_1651/>

<D_1652/>

<D_1651_2/>

<D_373/>

<D_337/>

<D_623/>

</S_AT7>

<S_MS1>

<D_19/>

<D_156/>

<D_26/>

<D_1654/>

<D_1655/>

<D_1280/>

<D_1280_2/>

</S_MS1>

<S_MS2>

<D_140/>

<D_207/>

<D_40/>

<D_761/>

</S_MS2>

</L_0205>

<S_L11>

<D_127/>

<D_128/>

<D_352/>

</S_L11>

<S_MAN>

<D_88/>

<D_87/>

<D_87_2/>

<D_88_2/>

<D_87_3/>

<D_87_4/>

</S_MAN>

<S_Q7>

<D_33/>

<D_211/>

<D_80/>

</S_Q7>

<S_K1>

<D_61/>

<D_61_2/>

</S_K1>

<S_AT5>

<D_152/>

<D_560/>

<D_153/>

</S_AT5>

<S_AT8>

<D_187/>

<D_188/>

<D_81/>

<D_80/>

<D_80_2/>

<D_184/>

<D_183/>

</S_AT8>

<L_0210>

<S_CD3>

<D_187/>

<D_81/>

<D_619/>

<D_34/>

<D_284/>

<D_108/>

<D_122/>

<D_58/>

<D_122_2/>

<D_58_2/>

<D_284_2/>

<D_284_3/>

<D_591/>

<D_26/>

</S_CD3>

<S_L11>

<D_127/>

<D_128/>

<D_352/>

</S_L11>

<L_0215>

<S_AT7>

<D_1650/>

<D_1651/>

<D_1652/>

<D_1651_2/>

<D_373/>

<D_337/>

<D_623/>

</S_AT7>

<S_MS1>

<D_19/>

<D_156/>

<D_26/>

<D_1654/>

<D_1655/>

<D_1280/>

<D_1280_2/>

</S_MS1>

<S_MS2>

<D_140/>

<D_207/>

<D_40/>

<D_761/>

</S_MS2>

</L_0215>

<S_NM1>

<D_98/>

<D_1065/>

<D_1035/>

<D_1036/>

<D_1037/>

<D_1038/>

<D_1039/>

<D_66/>

<D_67/>

<D_706/>

<D_98_2/>

</S_NM1>

<S_Q7>

<D_33/>

<D_211/>

<D_80/>

</S_Q7>

<S_AT8>

<D_187/>

<D_188/>

<D_81/>

<D_80/>

<D_80_2/>

<D_184/>

<D_183/>

</S_AT8>

<S_MAN>

<D_88/>

<D_87/>

<D_87_2/>

<D_88_2/>

<D_87_3/>

<D_87_4/>

</S_MAN>

<L_0220>

<S_N1>

<D_98/>

<D_93/>

<D_66/>

<D_67/>

<D_706/>

<D_98_2/>

</S_N1>

<S_N2>

<D_93/>

<D_93_2/>

</S_N2>

<S_N3>

<D_166/>

<D_166_2/>

</S_N3>

<S_N4>

<D_19/>

<D_156/>

<D_116/>

<D_26/>

<D_309/>

<D_310/>

</S_N4>

<S_L11>

<D_127/>

<D_128/>

<D_352/>

</S_L11>

</L_0220>

</L_0210>

<L_0230>

<S_PRF>

<D_324/>

<D_328/>

<D_327/>

<D_373/>

<D_350/>

<D_367/>

<D_92/>

</S_PRF>

<L_0231>

<S_N1>

<D_98/>

<D_93/>

<D_66/>

<D_67/>

<D_706/>

<D_98_2/>

</S_N1>

<S_N2>

<D_93/>

<D_93_2/>

</S_N2>

<S_N3>

<D_166/>

<D_166_2/>

</S_N3>

<S_N4>

<D_19/>

<D_156/>

<D_116/>

<D_26/>

<D_309/>

<D_310/>

</S_N4>

<S_L11>

<D_127/>

<D_128/>

<D_352/>

</S_L11>

</L_0231>

<L_0233>

<S_CD3>

<D_187/>

<D_81/>

<D_619/>

<D_34/>

<D_284/>

<D_108/>

<D_122/>

<D_58/>

<D_122_2/>

<D_58_2/>

<D_284_2/>

<D_284_3/>

<D_591/>

<D_26/>

</S_CD3>

<S_L11>

<D_127/>

<D_128/>

<D_352/>

</S_L11>

<L_0240>

<S_AT7>

<D_1650/>

<D_1651/>

<D_1652/>

<D_1651_2/>

<D_373/>

<D_337/>

<D_623/>

</S_AT7>

<S_MS1>

<D_19/>

<D_156/>

<D_26/>

<D_1654/>

<D_1655/>

<D_1280/>

<D_1280_2/>

</S_MS1>

<S_MS2>

<D_140/>

<D_207/>

<D_40/>

<D_761/>

</S_MS2>

</L_0240>

<S_MAN>

<D_88/>

<D_87/>

<D_87_2/>

<D_88_2/>

<D_87_3/>

<D_87_4/>

</S_MAN>

</L_0233>

</L_0230>

<L_0250>

<S_SPO>

<D_324/>

<D_127/>

<D_355/>

<D_380/>

<D_188/>

<D_81/>

<D_647/>

<D_127_2/>

</S_SPO>

<S_SDQ>

<D_355/>

<D_66/>

<D_67/>

<D_380/>

<D_67_2/>

<D_380_2/>

<D_67_3/>

<D_380_3/>

<D_67_4/>

<D_380_4/>

<D_67_5/>

<D_380_5/>

<D_67_6/>

<D_380_6/>

<D_67_7/>

<D_380_7/>

<D_67_8/>

<D_380_8/>

<D_67_9/>

<D_380_9/>

<D_67_10/>

<D_380_10/>

<D_310/>

</S_SDQ>

</L_0250>

<L_0260>

<S_EFI>

<D_786/>

<D_933/>

<D_797/>

<D_799/>

<D_802/>

<D_799_2/>

<D_801/>

<D_799_3/>

<D_800/>

<D_789/>

<D_803/>

<D_804/>

<D_787/>

<D_788/>

<D_799_4/>

<D_1570/>

</S_EFI>

<S_BIN>

<D_784/>

<D_785/>

</S_BIN>

</L_0260>

</L_0200>

<S_SE>

<D_96/>

<D_329/>

</S_SE>

</S_ST>

<S_GE>

<D_97/>

<D_28/>

</S_GE>

</S_GS>

<S_IEA>

<D_I16/>

<D_I12/>

</S_IEA>

</S_ISA>

</ns0:ASC214_004010>

HI,

Please find the structure below. yes, there is a namespace difference, Should i use AF_Modules/XMLAnonymizerBean ?

<?xml version="1.0" encoding="UTF-8"?>

<ns0:ASC214_004010 xmlns:ns0="http://sap.com">

<S_ISA>

<D_DATAELEMENTSEPARATOR/>

<D_I01/>

<D_I02/>

<D_I03/>

<D_I04/>

<D_I05/>

<D_I06/>

<D_I05_2/>

<D_I07/>

<D_I08/>

<D_I09/>

<D_I10/>

<D_I11/>

<D_I12/>

<D_I13/>

<D_I14/>

<D_I15/>

<D_SEGMENTTERMINATOR/>

<S_GS>

<D_479/>

<D_142/>

<D_124/>

<D_373/>

<D_337/>

<D_28/>

<D_455/>

<D_480/>

<S_ST>

<D_143/>

<D_329/>

<S_B10>

<D_127/>

<D_145/>

<D_140/>

<D_71/>

<D_128/>

<D_127_2/>

<D_1073/>

</S_B10>

<S_L11>

<D_127/>

<D_128/>

<D_352/>

</S_L11>

<S_MAN>

<D_88/>

<D_87/>

<D_87_2/>

<D_88_2/>

<D_87_3/>

<D_87_4/>

</S_MAN>

<S_K1>

<D_61/>

<D_61_2/>

</S_K1>

<L_0100>

<S_N1>

<D_98/>

<D_93/>

<D_66/>

<D_67/>

<D_706/>

<D_98_2/>

</S_N1>

<S_N2>

<D_93/>

<D_93_2/>

</S_N2>

<S_N3>

<D_166/>

<D_166_2/>

</S_N3>

<S_N4>

<D_19/>

<D_156/>

<D_116/>

<D_26/>

<D_309/>

<D_310/>

</S_N4>

<S_G61>

<D_366/>

<D_93/>

<D_365/>

<D_364/>

<D_443/>

</S_G61>

<S_G62>

<D_432/>

<D_373/>

<D_176/>

<D_337/>

<D_623/>

</S_G62>

<S_L11>

<D_127/>

<D_128/>

<D_352/>

</S_L11>

</L_0100>

<S_MS3>

<D_140/>

<D_133/>

<D_19/>

<D_91/>

<D_156/>

</S_MS3>

<L_0200>

<S_LX>

<D_554/>

</S_LX>

<L_0205>

<S_AT7>

<D_1650/>

<D_1651/>

<D_1652/>

<D_1651_2/>

<D_373/>

<D_337/>

<D_623/>

</S_AT7>

<S_MS1>

<D_19/>

<D_156/>

<D_26/>

<D_1654/>

<D_1655/>

<D_1280/>

<D_1280_2/>

</S_MS1>

<S_MS2>

<D_140/>

<D_207/>

<D_40/>

<D_761/>

</S_MS2>

</L_0205>

<S_L11>

<D_127/>

<D_128/>

<D_352/>

</S_L11>

<S_MAN>

<D_88/>

<D_87/>

<D_87_2/>

<D_88_2/>

<D_87_3/>

<D_87_4/>

</S_MAN>

<S_Q7>

<D_33/>

<D_211/>

<D_80/>

</S_Q7>

<S_K1>

<D_61/>

<D_61_2/>

</S_K1>

<S_AT5>

<D_152/>

<D_560/>

<D_153/>

</S_AT5>

<S_AT8>

<D_187/>

<D_188/>

<D_81/>

<D_80/>

<D_80_2/>

<D_184/>

<D_183/>

</S_AT8>

<L_0210>

<S_CD3>

<D_187/>

<D_81/>

<D_619/>

<D_34/>

<D_284/>

<D_108/>

<D_122/>

<D_58/>

<D_122_2/>

<D_58_2/>

<D_284_2/>

<D_284_3/>

<D_591/>

<D_26/>

</S_CD3>

<S_L11>

<D_127/>

<D_128/>

<D_352/>

</S_L11>

<L_0215>

<S_AT7>

<D_1650/>

<D_1651/>

<D_1652/>

<D_1651_2/>

<D_373/>

<D_337/>

<D_623/>

</S_AT7>

<S_MS1>

<D_19/>

<D_156/>

<D_26/>

<D_1654/>

<D_1655/>

<D_1280/>

<D_1280_2/>

</S_MS1>

<S_MS2>

<D_140/>

<D_207/>

<D_40/>

<D_761/>

</S_MS2>

</L_0215>

<S_NM1>

<D_98/>

<D_1065/>

<D_1035/>

<D_1036/>

<D_1037/>

<D_1038/>

<D_1039/>

<D_66/>

<D_67/>

<D_706/>

<D_98_2/>

</S_NM1>

<S_Q7>

<D_33/>

<D_211/>

<D_80/>

</S_Q7>

<S_AT8>

<D_187/>

<D_188/>

<D_81/>

<D_80/>

<D_80_2/>

<D_184/>

<D_183/>

</S_AT8>

<S_MAN>

<D_88/>

<D_87/>

<D_87_2/>

<D_88_2/>

<D_87_3/>

<D_87_4/>

</S_MAN>

<L_0220>

<S_N1>

<D_98/>

<D_93/>

<D_66/>

<D_67/>

<D_706/>

<D_98_2/>

</S_N1>

<S_N2>

<D_93/>

<D_93_2/>

</S_N2>

<S_N3>

<D_166/>

<D_166_2/>

</S_N3>

<S_N4>

<D_19/>

<D_156/>

<D_116/>

<D_26/>

<D_309/>

<D_310/>

</S_N4>

<S_L11>

<D_127/>

<D_128/>

<D_352/>

</S_L11>

</L_0220>

</L_0210>

<L_0230>

<S_PRF>

<D_324/>

<D_328/>

<D_327/>

<D_373/>

<D_350/>

<D_367/>

<D_92/>

</S_PRF>

<L_0231>

<S_N1>

<D_98/>

<D_93/>

<D_66/>

<D_67/>

<D_706/>

<D_98_2/>

</S_N1>

<S_N2>

<D_93/>

<D_93_2/>

</S_N2>

<S_N3>

<D_166/>

<D_166_2/>

</S_N3>

<S_N4>

<D_19/>

<D_156/>

<D_116/>

<D_26/>

<D_309/>

<D_310/>

</S_N4>

<S_L11>

<D_127/>

<D_128/>

<D_352/>

</S_L11>

</L_0231>

<L_0233>

<S_CD3>

<D_187/>

<D_81/>

<D_619/>

<D_34/>

<D_284/>

<D_108/>

<D_122/>

<D_58/>

<D_122_2/>

<D_58_2/>

<D_284_2/>

<D_284_3/>

<D_591/>

<D_26/>

</S_CD3>

<S_L11>

<D_127/>

<D_128/>

<D_352/>

</S_L11>

<L_0240>

<S_AT7>

<D_1650/>

<D_1651/>

<D_1652/>

<D_1651_2/>

<D_373/>

<D_337/>

<D_623/>

</S_AT7>

<S_MS1>

<D_19/>

<D_156/>

<D_26/>

<D_1654/>

<D_1655/>

<D_1280/>

<D_1280_2/>

</S_MS1>

<S_MS2>

<D_140/>

<D_207/>

<D_40/>

<D_761/>

</S_MS2>

</L_0240>

<S_MAN>

<D_88/>

<D_87/>

<D_87_2/>

<D_88_2/>

<D_87_3/>

<D_87_4/>

</S_MAN>

</L_0233>

</L_0230>

<L_0250>

<S_SPO>

<D_324/>

<D_127/>

<D_355/>

<D_380/>

<D_188/>

<D_81/>

<D_647/>

<D_127_2/>

</S_SPO>

<S_SDQ>

<D_355/>

<D_66/>

<D_67/>

<D_380/>

<D_67_2/>

<D_380_2/>

<D_67_3/>

<D_380_3/>

<D_67_4/>

<D_380_4/>

<D_67_5/>

<D_380_5/>

<D_67_6/>

<D_380_6/>

<D_67_7/>

<D_380_7/>

<D_67_8/>

<D_380_8/>

<D_67_9/>

<D_380_9/>

<D_67_10/>

<D_380_10/>

<D_310/>

</S_SDQ>

</L_0250>

<L_0260>

<S_EFI>

<D_786/>

<D_933/>

<D_797/>

<D_799/>

<D_802/>

<D_799_2/>

<D_801/>

<D_799_3/>

<D_800/>

<D_789/>

<D_803/>

<D_804/>

<D_787/>

<D_788/>

<D_799_4/>

<D_1570/>

</S_EFI>

<S_BIN>

<D_784/>

<D_785/>

</S_BIN>

</L_0260>

</L_0200>

<S_SE>

<D_96/>

<D_329/>

</S_SE>

</S_ST>

<S_GE>

<D_97/>

<D_28/>

</S_GE>

</S_GS>

<S_IEA>

<D_I16/>

<D_I12/>

</S_IEA>

</S_ISA>

</ns0:ASC214_004010>

Hi Sherwin,

First try to manually change the namespace in the payload and place it in the test tab to check if you are still receiving the structure error. Also, validate the other fields properly.

If your testing works out then you can try using the XMLAnonymizerBean and check if are still having the issues.

Thanks and Regards,

Satanik

HI Satanik,

Thanks for the reply. I tried changing the namespace but its not working. It is showing some structure error. I mean the xml nodes are not proper. How to rectify this issue? should I ask EDi gut to create proper EDI? how to check if the EDI he is sending is correct? any way to test EDI message?

Thanks,

Sherwin

You need to change the namespace while generating the XSD from Toolkit and then use the xsd in mapping, no need to apply any beans.

Hi Sherwin,

If the EDI XML structure does not match with the expected source structure then it is better if you reach out to the EDI point of contact.

It would also help if you can specifically call out the fields to the EDI poc that are different in the expected structure and the incoming data.

Thanks and Regards,

Satanik

Thank you Satanik. I will get back once I have the update. Thanks again.

HI Manoj,

I am new into EDI. Can you please tell me where I need to go in order to change the namsapce?

Thanks,

Sherwin

Check this blog :

An also there is no need to ask third party guys whether the EDI correct or not , you can validate it by converting EDI to EDI-XML directly in the toolkit.If any issue with EDI file then you can see the error in toolkit itself. Try using ANSIX12 to XML converter in B2B toolkit

Thank you so much Manoj.

Hi Sherwin,

Can you provide the error logs? for which fields it is throwing the error? Please also check the version of X12 file and XSD version.

regards,

Harish

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

hi,

Please find the error log below

(DefaultEJBProxyInvocationHandler.java:99) at com.sun.proxy.$Proxy1220.processFunction(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.sap.engine.services.rfcengine.RFCDefaultRequestHandler.handleRequest(RFCDefaultRequestHandler.java:214) at com.sap.engine.services.rfcengine.RFCJCOServer$J2EEApplicationRunnable.run(RFCJCOServer.java:214) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:185) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:302) Caused by: com.sap.aii.mappingtool.tf7.IllegalInstanceException: Cannot create target element /TrackedProcessEventNotification/ns1:TrackedProcessEventNotificationCreateRequest/TrackingMainID. Values missing in queue context. Target XSD requires a value for this element, but the target-field mapping does not create one. Check whether the XML instance is valid for the source XSD, and whether the target-field mapping fulfils the requirement of the target XSD at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:405) at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:452) at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:452) at com.sap.aii.mappingtool.tf7.AMappingProgram.start(AMappingProgram.java:555) at com.sap.aii.mappingtool.tf7.Transformer.start(Transformer.java:152) at com.sap.aii.mappingtool.tf7.AMappingProgram.transform(AMappingProgram.java:693) at com.sap.aii.ib.server.mapping.execution.JavaMapping.executeStep(JavaMapping.java:112) ...

How to check the version os X12 file and xsd version?

I am not even sure if the EDi file which they are sending is correct.

Hi Sherwin,

the error is

IllegalInstanceException: Cannot create target element /TrackedProcessEventNotification/ns1:TrackedProcessEventNotificationCreateRequest/TrackingMainID. Values missing in queue context. Target XSD requires a value for this element, but the target-field mapping does not create one.

The message is pretty clear. Can you post the mapping in place and the screen shot of queue so that actual reason of error can be found.

Regards

Anupam

HI Anupam,

Thanks for the reply. I understand the error. it is coming for the field TrackingMainID. it is showing like the value in th e field TrackingMainID is missing but if I see the payload value is there for the field TrackingMainID. I tried to take the payload and test it in message mapping but then i see mapping structure is in red. Please see the mapping screenshot below. do i need to use anything else in module config for sender file channel?

Please let me know if you need any more info.

Thanks,

Sherwin.

can you post the screen shot of that specific target field? from mapping we need to trace the input field. Secondly do you have a payload which was processed successfully in past, that payload should be compared to present one to find the difference.

Regards

Anupam

HI Anupam,

It is mapped to D_145 under B10. The value is there. Please check the below screenshots as well in the thread.

Hi Sherwin,

If this is direct mapping without any node functions then the issue is with context mismatch. The payload has the value in source but not in proper level wrt to target field.

Regards

Anupam

Thanks Anupam, But why the structure is in RED? it should be in red right? Please check the xml payloads. right one is the error one and the left pic is successful one. Please suggest.

Message was edited by: Sherwin Singh

Ask a Question

Top Q&A Solution Author

User

Count