Abap Proxy to JDBC scenario - handle JDBC Adapters Errors

[Former Member]

In scenario could happened to ERP side try to insert an already saved record in receiver side SQL Server. when this happens XI returns a message structure like :

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

<!-- Call Adapter

-->

<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 processing request in sax parser: Error when executing statement for table/stored proc. 'dbo.ZZTest01' (structure 'Statement_aux'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Violation of PRIMARY KEY constraint 'PK_ZZTest01'. Cannot insert duplicate key in object 'ZZTest01'.</SAP:AdditionalText>

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack />

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

</SAP:Error>

But i need to read this error message and map to Abap Proxy response structure, how can i do that?

[henrique_pinto · Accepted solution]

Do you have fault message for the receiver structure?

You could input fault message types in both proxy and jdbc sync interfaces and then you would have the fault message persisted in the client abap proxy.

Regards,

Henrique.

[Former Member · Accepted solution]

No, I don't.

How do I do it?

Do I need to use a message mapping to make the transformation of the message?

Regards,

Joã

[henrique_pinto · Accepted solution]

I'm not so sure on how it would work for JDBC adapters... sorry.

I'll let the other colleagues to advice on this matter.

Regards,

Henrique.