MAPPING:EXCEPTION_DURING_EXECUTE

[ravi_reddy1]

Hi Experts,

My scenario is JDBC to proxy,

while testing i am getting following error in moni.

AP:Code area="MAPPING">EXCEPTION_DURING_EXECUTE</SAP:Code>

<SAP:P1>com/sap/xi/tf/_CDR_RefundData_To_ERP_RefundData_</SAP:P1>

<SAP:P2>com.sap.aii.mappingtool.tf7.MessageMappingExceptio</SAP:P2>

<SAP:P3>n: Runtime exception when processing target-field</SAP:P3>

<SAP:P4>mapping /ns1:CDR_RefundData_ERP/row[65]/AOTR_STAT~</SAP:P4>

<SAP:AdditionalText />

<SAP:Stack>Runtime exception occurred during application mapping com/sap/xi/tf/_CDR_RefundData_To_ERP_RefundData_; com.sap.aii.mappingtool.tf7.MessageMappingException: Runtime exception when processing target-fieldmapping /ns1:CDR_RefundData_ERP/row[65]/AOTR_STAT~</SAP:Stack>

<SAP:Retry>M</SAP:Retry>

</SAP:Error>

please tell me the reason why this error occurs.

Regards,

Ravi

AP:

[Former Member]

Hi Venkat,

Could you please brief, what exactly need to be checked in the ECC box from SAP PI point of view.

[former_member308026]

Hello Ravi,

This is definitely an issue with target field "AOTR_STAT" because it clearly shows that under the 65th row your field "AOTR_STAT" is not getting created.

Please follow below steps.

1. Open the Inbound Payload in SXMB_MONI, right click on the payload and choose "View

    Source".

2. Copy the Payload from the displayed Notepad.

3. Take the mapping name from Trace, in this case your mapping name is    

    "CDR_RefundData_To_ERP_RefundData".

4. Go to ESR and click on the option "Find" which is present just below to the Environment Menu   

    bar.

    Put your mapping name in the "Attributes" and click on "Search".

    (The above procedure is to go to the correct mapping and to avoid the conflicts).

5. Once your mapping is opened, go to Test Tab and paste your payload in "Source Text View".

6. Then go to "Definition" tab and then go to target structure and search for your field name

    "AOTR_STAT".

7. Once you are able to see the target field then double click on it to see the mapping in Mapping

    Editor.

8. Then right click on the target field(in Mapping Editor area) and see the queues. Then you should     be able to see the "null" output in 65th position, except that all the other positions(Ex: 1 to 64

    positions) will have some value i.e. the corresponding source filed is not populated the source

    structure in 65th position.

Thanks,

Venkat.

[ravi_reddy1]

Hi Venkat,

Same way I see the display queue for the field.  it display nothing ..

see the screenshot for the same

please do the needful

Regards,

Ravi

[Former Member]

Hello Ravii,

No value is being sent for that node thats why its Null.

Ravi its a data issue clearly.

[former_member308026]

Hi Ravi, This Display Queue is of your target field? Can you please check the Display queue of Node "Row". If that node also shows the same result then there should be some data inconsistency. Thanks Venkat

[ravi_reddy1]

Hi Raghuraman,

means that the field ATOR_STAT is not getting any data from source?

Please replay.

Regards,

Ravi

[Former Member]

Yes Ravi,

Or might be because of some condition in the mapping, that node is not generated.

[Former Member]

Hi Ravi,

Can you paste the mapping for field ATOR_STAT?

Regards,

Praveen.