We wanted to know how you guys are handling (or will handle if asked) error handling for below scenario:
We have sync scenario (soap-jdbc) from a web which sends a request to PI to call SPROC in DB and need to send the response back to web. This scenario works fine as long as there are no errors in PI. However if message fails in PI, Web is giving "We are sorry...." exception as part soap exception. We want to send some graceful message back to web if message fails in PI as similar to we send response from SPROC. Lets say if message fails because of mapping, sending response as "Message failed in PI with the error: error from PI". How to implement this in PI?
I think Alerts is not an option here as we don't want to send an email to anyone but we want to send back response to Web Services as message failed in PI immediately as user is waiting in front of screen.