BPM-Raise Exception does not work

[Former Member]

I have designed the BPM in following way.

1. Receive step - Receive Asynchronous message

2. Defined the Block - DB

3. Send step 'A' to JDBC - inside the Block-'DB' - Acknowledgement-Transport, Exceptions System Error-DB, Receiver from-Send context.

4. Created an exception handler and Selected 'DB' as exception handler for the property of the exception handler branch.

5. Inserted the Send step-'B' to send mail inside the exception handler branch by using the MAIL receiver adapter.

We want send the message to update database by using JDBC adapter but if it fails to update database then we want send an e-mail to outlook.

But it looks like it is not working when it fails to update database.

Can someone please help me?

Thanks in advance!

[Former Member]

Manish,

Thank you very much for your quick replies!

What situations system errors occurs in BPM and in what situations application errors occurs in BPM? What is the difference between these errors?

I want to send an e-mail to outlook when XI message fails to send message to database system, Do I need to use Acknowledgement = "Transport" in the "SEND" step of the JDBC adapter? If I don't use it then how would it impact the exception handling in BPM?

How I can design BPM for handling application erros in BPM?

Mrudula

[Former Member]

Hi,

According to the SAP online help documentation for the receiver JDBC adapter:

<i>The receiver JDBC adapter supports system acknowledgments but not application acknowledgments.</i>

What you will need to do is either get a system error triggerred by the adapter (which basically throws up the red flag and tells XI that the message could ot be delivered successfully) , or get the application to trigger a fault message back to the adapter. I have not worked with the JDBC adapter, so I cant tell you in more detail.

Here are some links that I have been able to find that might help you...

Statuses in the monitor :

http://help.sap.com/saphelp_nw04/helpdata/en/ea/2f053d39177608e10000000a114084/frameset.htm

Dealing with Exceptions in BPM

http://help.sap.com/saphelp_nw04/helpdata/en/33/4a773f12f14a18e10000000a114084/frameset.htm

Cheers

Manish

[Former Member]

Manish,

Thanks for your reply.

How would I know whether it raises the system error when it fails to update databse by using JDBC adapter?

If it does not raises the system error then how should I design BPM to send an email to MS-Outlook when it fails to update database?

Thanks in advance!

Mrudula

[Former Member]

Hi,

You should be able to see a system error in the Adapter monitor. If it is not a system error, you will have to use a fault message type to accept an application error, and trigger the BPM exception on that fault message rather than on system errors.

Cheers

Manish

[Former Member]

When the JDBC adapter fails to update the database, does it raise a system error? If it does not, then your exception handler willnot be triggered.

Cheers

Manish