cancel
Showing results for 
Search instead for 
Did you mean: 

Alerts for JDBC adapter

Former Member
0 Kudos

Hi,

I have a receiver JDBC adapter and I wish to have alerts raised for the communication channel errors with this adapter. For example, if the insert fails due to Unique constraint violation , I want the same error message that is shown in the RWB, as a part of the alert message raised. Is this possible?

I currently have set up the alert config to catch all the AE errors and am successful in displaying the information

Message ID : &SXMS_MSG_GUID&

Error Desc: &SXMS_ERROR_CODE&

Sender Service: &SXMS_FROM_SERVICE&

Sender Namespace: &SXMS_FROM_NAMESPACE&

Sender Interface:&SXMS_FROM_INTERFACE&

Receiver Service: &SXMS_TO_SERVICE&

Receiver Namespace: &SXMS_TO_NAMESPACE&

Receiver Interface: &SXMS_TO_INTERFACE&

SXMS_ERROR_CODE always either evaluates to <b>PROCESSING_ERROR</b> or <b>GENERAL_ERROR</b>

Any clues?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Amol,

Many times I faced the same problem but so far I have not found any clue "how to reaise an Alert from AE".

I am not sure but it might be possible with AdapterModule...i.e nothing but with the help of Java API's

Thanks

Farooq

Former Member
0 Kudos

Amol,

Just try these 2 ABAP data types also hope it will give something meaning full.

Add the below container variable in your Alert category and try to raise an Adapter specific alerts.

Specific Error Information from the Adapter Engine:

Container Element

ABAP Dictionary Data Type

Meaning

<b>SXMS_TO_ADAPTER_TYPE</b>

CHAR70

Adapter type

<b>SXMS_TO_ADAPTER_ERRTXT</b>

CHAR70

Error text from the Adapter Engine

Use this link for the same : http://help.sap.com/saphelp_nw04/helpdata/en/d0/d4b54020c6792ae10000000a155106/content.htm

Thanks

Farooq.

Former Member
0 Kudos

Amol one more thing just for your notice:

Alert Configuration and Rules cannot be transported from DEV to *

Thanks

Farooq.

Former Member
0 Kudos

HI,

You can raise the alert for Integration server and Adapter engine related errors by creating an alert rule through RWB.

Please refer the below link.

http://help.sap.com/saphelp_nw2004s/helpdata/en/56/d5b54020c6792ae10000000a155106/frameset.htm

Thanks and Regards,

Chirag Gohil

Former Member
0 Kudos

thanks farooq,

SXMS_TO_ADAPTER_ERRTXT helped. I could see the same error msg as in RWB , at least in the report ALRTDISP, not sure why the same does not show up correctly in Alert inbox.

Former Member
0 Kudos

Cool:)

Try to take the help of Basis folks and look on this...why it is not coming to AlertInbox(RWB). Hope there might be any SAP note that need to apply.

Thanks

Farooq.

Answers (0)