Extracting Value from Message Payload of the Failed Messages

[former_member185093]

Hi Experts,

We are working on PI 7.0. We have an asynchronous scenario from JMS to IDOC. Vehicle related data is being sent to SAP.

We have a requirement where in we have to extract the vehicle commission number (a field in message payload) of all the failed messages in sxmb_moni(mapping failure).

Is there a way we can achieve this? Can we write some OS level script to the same.

If yes please help me out here.

This is a critical issue.

Kindly advice.

Regards,

Pooja

[Former Member]

Hi Pooja,

We have done something similar, but instead of the Vehicle Comm Num, we just retrieved our Transaction ID. Please see the links below. These will send out an email if there was an issue with the message mapping.

Regards,

Jannus

[former_member185093]

Thanks all for your reply.

I have done the below:

1) Implemented the UDF in mapping.

2) Created alert catagory as suggested in the thread "http://scn.sap.com/thread/3496625"

3) maintained my ID in SU01 with commu. method as "email".

I tested the scenario in mapping in IR, but I didn't receive any mail.

Do I need to test end to end to get the alert mail? or I might be missing something.

Kindly reply.

Regards,

Pooja

[iaki_vila]

Hi Pooja,

Why dont you try a less ambitious development first?, if i was you i would do a dummy SOAP - MAIL scenario to test the mail connection.

Regards.

[iaki_vila]

Hi Pooja,

You can do it in ABAP program. Check this wiki PI Monitoring Functionality - Fetching Data from SXMB_MONI Standard Tables - Part I - Code Gallery -...

Regards.