Skip to Content
avatar image
Former Member

Alert Email with Reason of failure as content needs to go to Business User

Dear Friends,

My scenario is simple:

Source CSV File -


When they send Source file to PI by Missing Mandatory field for eg say Last Name.

i have created Alert for this Interface it gives as as usual all techincal jargon and error due to MApping_execution_Runtime.

My requiremnt is When they miss any Mandatory field in source.I should send a Alert to Business user with Resonn of failure.

In this example : Alert should go to end user as : Last name is Missing...... some understanable content to user.

Not our Techincal content .

Kindly tell me how to send Non Techincal Content alert to Business User for this Interface.

Take care,


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 11, 2009 at 03:42 AM

    You can achieve this in following ways:

    1) Create a condition in Receiver Determination to check the existence/ non-existance of the req node.....then select the receiver based on this node....if node exists then proceed as normal...if not then define anoter flow which will send the message directly to the user.....the advantage is that you are avoinding the pipeline steps...

    2) use this alert container variable to raise the alert: SXMS_ERROR_CODE......this will give you the required alert text wqhich will be understood by the non-technical person.....this text is taken from SXMB_MONI....for more info refer:



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I am not able to understand tht blog... Why i need to go for Lookup...

      When any of the fields in Source is manadatory field in PI then PI should give alert to end user the correposnding FIELDin the particukar row and record is missing.

      this is my exact requirement.

      CSV file contains 100 records

      For eg: Last name in source file is miising then PI shoul throw alert to end user as :

      Last name is missing in 50 th record.

      This is my exact requiremnt.

      File ->PI -->ECC

      Take care.