cancel
Showing results for 
Search instead for 
Did you mean: 

How to catch errors watched in sxmb_moni through abap program??

santhosh_sontha2
Explorer
0 Kudos

Dear Gents,

I have one scenario which is proxy -> xi -> jdbc. Scenario works fine when every thing is good, but if there are any errors in XI usually we catch the exception after calling the proxy as :

TRY.

CALL METHOD cl_rfq_sapin->mios_rfq_sapin

EXPORTING

output = output

IMPORTING

input = input.

COMMIT WORK.

CATCH cx_ai_system_fault INTO cl_system_fault .

gv_system_fault = 'X'.

CATCH cx_ai_application_fault INTO cl_application_fault.

gv_application_fault = 'X'.

ENDTRY.

But by this code we are able to know whether it is system error or application error. But we cant get actual error. To see the actual error we need to go to SXMB_MONI in XI. The some sample error in sxmb_moni is as follows :

<?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.aii.af.ra.ms.api.DeliveryException: Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://10.56.5.79:1433;databaseName=SXD': SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The requested instance is either invalid or not running.</SAP:AdditionalText>

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack />

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

</SAP:Error>

So is there any way we can catch the above error in the abap program ??

Your responeses were highly appreciated.

Regards,

Santhosh

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Did alerts not helped you...

Rajesh

MichalKrawczyk
Active Contributor
0 Kudos

hi,

did you try using acknowledgments?

http://help.sap.com/saphelp_nwpi71/helpdata/en/f4/8620c6b58c422c960c53f3ed71b432/content.htm

(code at the bottom of this page)

Regards,

Michal Krawczyk

santhosh_sontha2
Explorer
0 Kudos

Dear Michel,

The link which you suggested is for async scenario. But in my case it is synchs proxy->XI->JDBC. Please let me know will that work for synchronous scenario as well.

Regards,

Santhosh

Former Member
0 Kudos

Check these links for synch jdbc adapter reciever

JDBC Stored Procedures:

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

JDBC Receiver Adapter -- Synchronous Select u2013 Step by Step

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step