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_member182412 · Accepted solution]

Hi Ravi,

Check the trace for more information about mapping error, take the payload and test the mapping in repository.

Regards,

Praveen.

[Former Member]

Hi Ravi

Please check SXMB_MONI for proxy monitorting apart from this u need to check smq1 and smq2 for queue monitoring.

Regards

Nagur

[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_member186851]

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_member186851]

Yes Ravi,

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

[former_member182412]

Hi Ravi,

Can you paste the mapping for field ATOR_STAT?

Regards,

Praveen.

[ravi_reddy1]

Hi Praveen/Bhavesh

while testing in ID using Payload in testconfig I am getting error in Operation mapping.

see the screenshot for the same.

please do the needful.

Regards,

Ravi

[former_member182412]

Hi Ravi,

You need to test the mapping in the repository.

Regards,

Praveen.

[ravi_reddy1]

Hi Praveen,

while testing in MM I am getting the following error.

Please do the needful.

Regards

Ravi

[former_member186851]

Hello Ravi,

From SXMB_MONI,Select the payload option then right click->view source.

Use the XML obtained you wont get this error in mapping.

[ravi_reddy1]

Hi Raghuraman,

Same way I checked but no use , same error I am getting.

please see above I shared some screenshots in ID level and Mapping level .

please do the needful

Regards,
Ravi

[former_member186851]

Hello Ravi,

Error is clearly because of the missing field in the target structure.

After which step you took the XML?

Take the inbound message payload(first step in Moni) and view source and test it.

If still getting the error, populate some dummy values in mapping and check. Then you can confirm the incoming data is not coming proper format.

[iaki_vila]

Hi Ravi,

You have not copy properly the XML. That exception is raised because you have not write right the XML declaration (<?xml version="1.0" encoding="UTF-8"?>), may be you have written a blank before the declaration.

Regards.

[ravi_reddy1]

Dear Raghuraman,

I taken payload from first step payload only.

see for your confirmation.

and also I checked in MM using dummy values its working fine. see the same .

[ravi_reddy1]

Hi Vila,

I taken the payload from the moni --> payload---> viewsource.

and also XML declaration is fine

Regards,

Ravi

[former_member182412]

Did you right click on the payload window and click view source and copy the payload and test?

[ravi_reddy1]

Yes Praveen.

Regards,

Ravi

[ravi_reddy1]

Hi Praveen,

while testing in operation mapping using the payload I am getting following error:

Error: "white space is required before the encoding pseudo attribute in the xml declaration"

what is exactly this error?

Regards,

Ravi

[former_member186851]

Hello Ravi,

Did you follow the steps I mentioned.

Give some dummy values and check. If its working then the input XML might be wrong.

[ravi_reddy1]

Hi Raghu,

I am getting same error in other interface also .

I think its payload error?

could you please suggest me compare with first error with now given error.

Regards

Ravi

[former_member186851]

Hello Ravi,

Yes.

What is occurrence of AOTR_STAT, Guess it should be 1.

So this field is expected in target ,Since its not generated it is failing.

[ravi_reddy1]

Hi Raghu,

     actually that field AOTR_STAT is not present in structure.

     I checked in data type in sender and receiver but  I am not seen this field.

     is it really field (AOTR_STAT)??

why I am asking is same error I am getting in two different interfaces?

Please do the needful.

Regards

Ravi

[former_member186851]

Ravi,

Are you using any java mapping as well also check for any parameters in the mapping.

[ravi_reddy1]

Hi Raghu,

its only one to one graphical mapping..

Regards,

Ravi

[nitindeshpande]

Hi Ravi,

This error is due to the space is not provided in between the version and encoding of XML declaration.

It must be this way - <?xml version="1.0"  encoding="UTF-8"?>

But you might have removed the space by mistake and given it this way -

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

Can you also attach the complete XML?

Regards,

Nitin

[anupam_ghosh2]

Hi Ravi,

             Can you show the mapping for the field AOTR_STAT.

Please include the test payload as well, so that exact error can be pointed out.

Regards

Anupam

[ravi_reddy1]

Hi Anupam,

I am not found any field like AOTR_STAT in my mapping.

PFA, my payload for this interface.

please do the needful.

Regards

Ravi

[former_member182412]

Hi Ravi,

The field AOTR_STAT should be in target structure, i think the payload you supplied is sender xml, search for this field in target structure in the mapping then check the mapping.

Regards,

Praveen.

[anupam_ghosh2]

Hi Ravi,

              Please provided the mapping for the field AOTR_STAT.

Regards

Anupam

[bhavesh_kantilal]

Your source for the error is pretty clear.

/ns1:CDR_RefundData_ERP/row[65]/AOTR_STAT

The issue is with the 66th occurrence of ROW field AOTR_STAT. You would need to take the Input Payload and then further process the same through your design time ( ESR ) to understand why the mapping for this field fails.