com.sap.aii.af.ra.ms.api.DeliveryException using BPM

[pansy_leung]

I try to set up BPM. The process is to receive a inbound message from JDBC then execute a stored procedure in AS/400 and finally pass back the output value of the stored procedure to other DB for updating.

Just start the inbound processing which send a message to BPM. It got below error. Does anyone can help

?

<?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</SAP:AdditionalText>

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack />

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

</SAP:Error>

Pansy

[former_member200962 · Accepted solution]

The error message does not give any information...try to find more details about your error and post it here.

Meanwhile did you perform baisc checks before testing your BPM? Like Cache, return code, correlation (if applicable)

Regards,

Abhishek.

[pansy_leung]

Thanks Sateesh. I think I should clarify something in order NOT to mislead you.

As I mentioned before,

the process is to

(1) receive a inbound message via JDBC

(2) execute a stored procedure in AS/400 and the stored procedure will pass out 2 parameters

(field name = cu_trx_type and cu_trx_num)

(3) UPDATE another DB using the 2 output paramters via JDBC.

I got error in Step 3.

I try 3 XML structures

(A)

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

- <ns0:MT_ZXX2_CXXSS_PS_PG1IAWD_Response xmlns:ns0="http://xxx.exx.xx/zxxssspgs/jdbc">

- <root>

- <statement>

- <px_cx_px1iawd action="UPDATE">

<table>px_cx_px1iawd</table>

- <access>

<cu_retrieved_by>ABC</cu_retrieved_by>

<cu_action_cd>P</cu_action_cd>

</access>

- <key>

<cu_trx_type>001</cu_trx_type>

<cu_trx_num>101049</cu_trx_num>

</key>

</px_cx_px1iawd>

</statement>

</root>

</ns0:MT_ZXX2_CXXSS_PS_PG1IAWD_Response>

(B)

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

- <ns0:MT_ZXX2_CXXSS_PS_PG1IAWD_Response xmlns:ns0="http://xxx.exx.xx/zxxssspgs/jdbc">

- <root>

- <statement>

- <px_cx_px1iawd>

<action>UPDATE</action>

<table>px_cx_px1iawd</table>

- <access>

<cu_retrieved_by>ABC</cu_retrieved_by>

<cu_action_cd>P</cu_action_cd>

</access>

- <key>

<cu_trx_type>001</cu_trx_type>

<cu_trx_num>101049</cu_trx_num>

</key>

</px_cx_px1iawd>

</statement>

</root>

</ns0:MT_ZXX2_CXXSS_PS_PG1IAWD_Response>

(c)

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

- <ns0:MT_ZXX2_CXXSS_PS_PG1IAWD_Response xmlns:ns0="http://xxx.exx.xx/zxxssspgs/jdbc">

- <root>

- <px_cx_px1iawd action="UPDATE">

<table>px_cx_px1iawd</table>

- <access>

<cu_retrieved_by>ABC</cu_retrieved_by>

<cu_action_cd>P</cu_action_cd>

</access>

- <key>

<cu_trx_type>001</cu_trx_type>

<cu_trx_num>101049</cu_trx_num>

</key>

</px_cx_px1iawd>

</root>

</ns0:MT_ZXX2_CXXSS_PS_PG1IAWD_Response>

for A and B, I got below error.

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException:

Error processing request in sax parser: No 'action' attribute found in XML document

(attribute "action" missing or wrong XML structure)

for C , I got below error. I am sure that 'cu_retrieved_by' is a column of table px_cx_px1iawd

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException:

Error processing request in sax parser: Error when executing statement for table/stored proc.

'px_cx_px1iawd' (structure 'root'): java.sql.SQLException:

FATAL ERROR: Column 'cu_retrieved_by' does not exist in table 'px_cx_px1iawd'

[pansy_leung]

Hi all,

Thanks Sateesh. I have a more clearing understanding when I look into the

"Communication Channel Monitoring" and some errors were solved.

As I mentioned before,

the process is to

(1) receive a inbound message via JDBC

(2) execute a stored procedure in AS/400 and

(3) finally pass back the output value (2 parameters) of the stored procedure to other DB via JDBC.

Now step (3) was NOT successfully. The error is listed below. the column "cu_retrieval_dt" is actually a column in table ps_cu_pg1iawd.

I also attached the XML message for your reference. many thanks.

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException:

Error processing request in sax parser: Error when executing statement for table/stored proc.

'ps_cu_pg1iawd' (structure 'statement'): java.sql.SQLException: FATAL ERROR: Column 'cu_retrieval_dt'

does not exist in table 'ps_cu_pg1iawd'

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

- <ns0:MT_ZCResponse xmlns:ns0="http://xxx.xx.hk/zxxxxx/jdbc">

- <statement>

- <PS_CU_PG1IAWD action="UPDATE">

<table>ps_cu_pg1iawd</table>

- <access>

<cu_retrieval_dt>2010/09/17</cu_retrieval_dt>

<cu_retrieved_by>XXX</cu_retrieved_by>

<cu_action_cd>P</cu_action_cd>

</access>

- <key_1>

<cu_trx_type>001</cu_trx_type>

</key_1>

- <key_2>

<cu_trx_num>101049</cu_trx_num>

</key_2>

</PS_CU_PG1IAWD>

</statement>

</ns0:MT_ZCResponse>

Pansy

[Former Member]

Hi,

java.sql.SQLException: FATAL ERROR: Column 'cu_retrieval_dt'

does not exist in table 'ps_cu_pg1iawd'

It clearly says that there is no said column in the database...

Can u please check in the database table for the column cu_retrieval_dt...

Babu

[Former Member]

Hi Pansy,

3) finally pass back the output value (2 parameters) of the stored procedure to other DB via JDBC.

You said, Back to the output value of Stored procedure,You Statement Structure looking like "UPDATE", There is no output parameters in this structure,. how it can get back the value from stored procedure.

Thank you,

Sateesh

[Former Member]

Hi Pansy,

For clear understand of this error, You just check with your communication channel status.Then you must know the this error.

RWB-Component monitorning-Adatpter Engine-Communication Channel Monitoring

Thank you,

Sateesh