Send e-mail on successful delivery of Message (File to File Interface)

[former_member210091]

Hey Friends,

We are on PI 7.11. we have a simple File to File interface, we pick up a file from FTP server, do some transformation in PI and send it across to another FTP server. we have a requirement that once the file is transmitted successfully to the receiver FTP server, we should send e-mail to a business user.

I was thinking of adding a e-mail interface in Interface Determination and checking "Maintain Order at runtime". File Interface will be the first and e-mail will be second. In this way if File interface fails, e-mail interface will not be executed.

Will my solution work or is there any better solution to achieve my requirement.

Appreciate your feedback.

Thanks

Saif

[former_member181962 · Accepted solution]

Hi Saif,

The fool-proof way is to go for a ccBPM.

Have a receive step to receive the file, followed by the tranformation step and send step.

Put the send step in block step, so that you can receive exception if you have any error sending the file.

After the block step, you can have a control step, where you can trigger an alert to send an email.

Best Regards,

Ravikanth Talagana

[former_member210091]

Yes, the approach to configure additional E-Mail receiver works fine.

When the FTP process fails, FTP Interface goes to "Waiting" Status, this makes the E-Mail interface go to "Holding" Status.

E-Mail is only send when the FTP Interface has successfully finished.

Managing Queue is very important in this approach.

Thanks

[Former Member]

Hi,

Your approach looks perfect...i.e sending of mail once the file has been delivered using EOIO concept...

Only drawback in this approach is the monitoring required for clearing of queues whenenver the error occurs...need some care for clearing of the queues...

you can use the Messaging System EOIO Queue Monitor for knowing the blocked queues or failed queues..for monitoring..

HTH

Rajesh

[Former Member]

Hi Saif,

Develop a script to trigger the mail and define the script in Run Operating System Command After Message Processing.

[Former Member]

There is no default way to raise alerts for a successful execution of the scenario. However, you can create alerts from the mapping program, according to the blog below.

/people/bhavesh.kantilal/blog/2006/07/25/triggering-xi-alerts-from-a-user-defined-function

Also, if you need exceptions to be thrown in the mapping, you can then check the blog below.

/people/alessandro.guarneri/blog/2006/01/26/throwing-smart-exceptions-in-xi-graphical-mapping