Alerting: Use error header [ JDBC Adapter Error ]

[iprieto]

Hi all,

In my scenario when I execute the store procedure I have one error. This error is saved in the error section into the message header.

The question is, I would like to use this error message for sending an alert message but I don't know how to get the tag SAP:AdditionalText contained by SAP:Error xml message.

Example:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

- <!-- Inbound Message

-->

- <SAP:Error xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/" SOAP:mustUnderstand="1">

<SAP:Category>XIAdapterFramework</SAP:Category>

<SAP:Code area="MESSAGE">GENERAL</SAP:Code>

<SAP:P1 />

<SAP:P2 />

<SAP:P3 />

<SAP:P4 />

<SAP:AdditionalText>com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'Create_Well_Finder' (structure 'StatementName'): java.sql.SQLException: ORA-01403: no data found ORA-06512: at "XXXX.XXXXXXXXXXXXXX", line 200 ORA-06512: at line 1</SAP:AdditionalText>

<SAP:Stack />

<SAP:Retry>M</SAP:Retry>

</SAP:Error>

Is it possible to get the exception below in my alert?

com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'Create_Well_Finder' (structure 'StatementName'): java.sql.SQLException: ORA-01403: no data found ORA-06512: at "XXXX.XXXXXXXXXXXXXX", line 200 ORA-06512: at line 1

Thanks in advanced

Iván

Edited by: Mark Smyth on May 28, 2009 11:01 AM

[former_member200962]

create Alert category with variable SXMS_ERROR_CODE and use it in the Long Text section of the alert category....you can even use SXMS_TO_ADAPTER_ERRTXT to get error from AE....check this link for more help:

http://help.sap.com/saphelp_nw70/helpdata/EN/d0/d4b54020c6792ae10000000a155106/content.htm

Regards,

Abhishek.