JDBC PL/SQL exception not shown in System Alert email

[Former Member]

Hi expert,

The PL/SQL exception caught in the communication channeli do not show up in the alert emails. What could be the reason behind it?

We configured the SXMS_TO_ADAPTER_ERRLINES to capture the error message in alert category and configured the alert rule accordingly also. The system alert mail is show as below:

If that is the PL/SQL error(Adapter Framework exception: null):

Adapter type: JDBC

Error text from the Adapter Engine:

If that is the exception captured in Adapter Framework, not PL/SQL error:

Adapter type: JDBC

Error text from the Adapter Engine: Error when attempting to get processing resources: com.sap.aii.af.lib. util.concurrent.ResourcePoolException: Unable to create new pooled res ource: DriverManagerException: Can not establish connection:: SQLExcep tion: ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist IBM AIX RISC System/6000 Error: 2: No such file or direc tory

Is that because the system alert only can print out the detail error message captured in Adapter Framework? Is there any way to capture all of the possible errors in adapter engine?

[Former Member · Accepted solution]

Hi Ruby,

Please use the container variable "SXMS_TO_ADAPTER_ERRTXT" in your alert category configuration to get the error text from Adapter Engine.

The details of the container variable can be found at this link:

http://help.sap.com/saphelp_nw04/helpdata/en/d0/d4b54020c6792ae10000000a155106/content.htm

Regards, Gaurav.

[Former Member]

I have tried "SXMS_TO_ADAPTER_ERRTXT" to catch the error message, facing the same issue with using "SXMS_TO_ADAPTER_ERRLINES".