Handling Errors

[Former Member]

Hi guys,

I am developing a scenario where i am fetching the data from Oracle database and sending the data to Sap.

I wld like to know how i could handle the error if i couldnt fetch any record from Oracle or the Oracle server is down.

Any sort of help wld be appreciated.

Thanks,

Nilakantan.S

[Former Member]

Thanks to all.

[Former Member]

Hi,

>>I wld like to know how i could handle the error if i couldnt fetch any record from Oracle or the Oracle server is down.

You can find out the Errors in JDBC Sender CC monitoring, if the sender JDBC Adapter is not able to pull the records from Dbase...

Use RWB for this..Here it will say clearly wat will be the error while pulling the records from Oracle

Regards

Seshagiri

[Former Member]

Thanks for your Reply.

But the the thing is i will have to trigger a mail if i dont get any records from D.B with a customized Message saying "The Server Is Down".

I cant ask the end-user to go and check in the RWB.

[dharamveer_gaur2]

If record r not found like message u want to send, can use simple message send or alert trigger.

If your Oracle server is down then, system error would be shown in SXMB_MONI.

[Former Member]

How wld u handle errors with alerts ??

Can u give an eg??

Thanks,

Nilakantan.S

[dharamveer_gaur2]

hi we can send exception using alerts,search lot of blog on SDN.

[prateek]

No system errors would be shown in XI moni until any data is picked up. In ur case, RWB audit log would be the right place to check for the errors.

Regards,

Prateek