Getting different value with different payload in message mapping

[former_member399424]

Hi All,

I have a  source field 'land' which is directly mapped to target field 'countryname'. When executing the mapping with payload having 30+ records i am getting the desired output but when executing the same mapping with large payload having 1000+ records i am getting a different result.

Appreciate your help in resolving this issue.

Regards,

Farooq

[former_member187010]

Hi Mohammed,

As you said for 900+ record your scenario is working fine and for 1500 it is creating issue, so want you to check the payload.

For the 1500 record, split the record in two half and then process the payloads. Careful in splitting payload. split using root node CVG_SAP_IndicativeData as reference.

Hope you already have checked it, if so please share your testing results.

Regards

Jitender

[former_member191435]

Hi,

It seems there are some source fields are not coming in the payload..........   so it is mismatching the structure.

Use below mapping

Source field  -----> Mapwithdefault  ---->  Target Field.

Thanks,

Sreenivas

[Former Member]

Hi,

Have tried to test 1000+ records at run-time if not, plz test and let us the know the result.

[Former Member]

Hi,

I agree with Mark, this is related to the context.

Please check the context of your source and if possible provide clips of the mapping and structure.

Regards,

Pooja

[markangelo_dihiansan]

Hi,

It has something to do with queuing. For example. the 1000+ records might not have the land field always present in the source XML. As a workaround, add mapWithDefault just after the land field so that the contexts are maintained.

Regards,

Mark

[former_member399424]

Hi Mark/Experts,

This is how the filed is mapped..

As suggested above let me try with mapWithDefault function.

Thanks,

Farooq

[former_member191435]

Hi  Farooq,

Here we have to change the context and the mapping like below.....

Here use LANDX50 as the same context not the Root Context....

Use LANDX50 ----> Map with default ------> target Field..

Thanks,

Sreenivas.

[former_member399424]

Hi Sreenivas/Team,

I tried as suggested above by having mapWithDefault & changing the context but no luck .

I am passing value as "USA" in source field 'LANDX50' and i am getting as "Brazil" in 'CountryName'. Same result as before..

Let me know is there any other options to try out.

Regards,

Farooq

[markangelo_dihiansan]

Hi,

Would it be possible to paste your source+target structure and the payload that you are using?

Regards,

Mark

[former_member399424]

Hi Mark,

PFB the requested details...

Regards,

Farooq

[former_member191435]

Can you please send me the payload and  the target root node mapping

Thanks,

Sreenivas

[markangelo_dihiansan]

Hi,

I'm afraid the information you provided is not enough. Are my occurrences correct?

What is the mapping for Employee, GHRTExt and Addresses? In this thread, please attach the xml that you are using for testing.

Hi Sreenivas,

Please refrain from email communication.

Regards,

Mark

[former_member399424]

Hi,

Here you go..

I am not supposed to share the xml payload, sorry for that..

Regards,

Farooq

[former_member191435]

Hi Farooq...

If your address node is populating properly..

Then use below mapping...

Here field2 is the value you have to use the check condition of Address root tag mapping.

Field3 is your source field and E_uid is your target....

Let me know still face an issue...

Thanks,

Sreenivas          

[former_member399424]

Mark,

When i am executing the data with 900+ records, i am getting the desired output but for the original data which has almost 1500 records output is deviating.

Thanks,

Farooq

[former_member399424]

Sreeni,

I did not understand about the field2, if you dont mind please explain in a bit detail..

Thanks,

Farooq

[former_member191435]

SUBTY not equals to some value u have given right....

i mean field2 = SUBTY not equals EMC...

[former_member399424]

Hi Sreeni,

Could you please help me out by taking the exact fields, i am bit confused with the logic you provided.

Current mapping..

Appreciate your help in resolving the issue.

Thanks

[former_member191435]

Hi Farooq,

For the field  country name please do below mapping...

try this...

Field 2  = SUBTY field.

Field 3 = Your source field.

Please do the necessary Context changes as per the your structure.

Thanks,

Sreenivas

[former_member399424]

Hi Sreeni,

The reason for the mismatch is, In the input payload some 3 employee records node P0006 was missing, now we have communicated the issue with the concerned team but we need to fix the issue as the node is not mandatory to occur (cardinality is 0..unbounded). Seems there is context error.

I will try the logic you suggested and will update shortly.

Thanks,

Farooq

[manigram]

HI ,

Post your test case screenshot .

Regards,

Manigandan