Error Handling in JDBC Adaptor - Without BPM

[Former Member]

Hi friends,

My problem is like this. Scenario is File -> Xi -> JDBC.

here i didn't used BPM at all.

My interface is working fine.

right now i am not doing any error handling for 'Primary key violation, refrential intigrity etc.. '.

if this type errors encountered i going to adapter monitoring and looking out the issue.

Now the client requirment is

whenever this type of errors occured Client should be notified Via email along with error description.

Is there anyway to do this ?

[Former Member]

Hi Suresh,

You can setup the Alerting framework of XI to trigger alerts. Alert rules can be set to raise alerts in case of JDBC Adapter Errors.

Check these links....

http://help.sap.com/saphelp_nw04/helpdata/en/3f/81023cfa699508e10000000a11402f/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/80/942f3ffed33d67e10000000a114084/frameset.htm

Thanks & Regards,

Renjith

An addition to what i just said...You have to be on SP14 for this...

Message was edited by: Renjith Andrews

[Former Member]

Renjith

But i am on SP12 only.

is this possible through SP12.

Thanks

[udo_martens]

Hi suresh,

yes, you can handle that with a busines process, which can react in case of errors.

plz look to my weblog, where the business process is nearly what you need :

/people/udo.martens/blog/2005/09/30/one-logical-system-name-for-serveral-bpm-acknowledgements

Regards,

Udo

[Former Member]

Hi Suresh,

To get notified via e-mail along with error description, you need to use BPM. These are the cases when we require to use BPM:

1.) To control/monitor messages in XI.

2.) To multicast a message.

3.) Send an Alert.

4.) Split the message in XI.

So, the feature you have mentioned can be achieved through BPM.

Regards,

Ravikiran.