Mapping Error

[former_member188885]

Hi All,

I have a file to JDBC scenario. After the file is picked up by XI, there is an mapping error.

In Moni, i get the following error:

com.sap.aii.utilxi.misc.api.BaseRuntimeException thrown during application mapping com/sap/xi/tf/_MM_MSDYNAMICS_: RuntimeException in Message-Mapping transformatio~</

Hence when i try to test the mapping in IR, i am getting the following error:

Cannot produce target element /ns0:MT_MSDYNAMICS_OUT/STATEMENT/TABLENAME/ACCESS[2]/SM_Upgrade_Status. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd Cannot produce target element /ns0:MT_MSDYNAMICS_OUT/STATEMENT/TABLENAME/ACCESS[2]/SM_Upgrade_Status. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd

Can you please tell me why this error is occuring and how can this be solved?

[Former Member · Accepted solution]

hi,

this error is occurring because ns0:MT_MSDYNAMICS_OUT/STATEMENT/TABLENAME/ACCESS/SM_Upgrade_Status is a mandatory field and your mapping does not put any value in it.

try using mapwithdefault and it should work.

[former_member208856]

You have your sender side payload.

Pick that payload & use the same in MESSAGE MAPPING Test.

Test Message Mapping using that payload.

Check the error there & change mapping accordingly OR Pick valid Payload.

[Former Member]

Hi Lavanya,

I faced exactly the same issue few days back. This occurs due to:

1. SM_Upgrade_Status is mapped to a field (say F1) in source which is not present. i.e. the node F1 is not present in the source file. Soln: Check the source file to see if the field F1 is present or not. If not, just add a open and close tag to the xml file and test it in IR. It should work (Or throw similar error for another field.. )

2. Also, pls check if the target element/field (SM_Upgrade_Status) is having occurence 1..1 (i.e. min occurs as 1). In this case there should be some value assigned to this field and all other fields with min occurs 1 for mapping to execute successfully. The processing stops at this pipeline step otherwise.

Cheers,

Souvik

[rajasekhar_reddy14]

> Cannot produce target element /ns0:MT_MSDYNAMICS_OUT/STATEMENT/TABLENAME/ACCESS[2]/SM_Upgrade_Status. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd Cannot produce target element /ns0:MT_MSDYNAMICS_OUT/STATEMENT/TABLENAME/ACCESS[2]/SM_Upgrade_Status. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd

>

Second occurance ACCESS[2]/SM_Upgrade_Status is not haing value input data,so please correct the same.

Regards,

Raj