Error i see in sxmb_moni, can u solve it

[Former Member]

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

- <ns0:MT_Jdbc_request xmlns:ns0="http://soaptojdbcsync.com/demo">

- <STATEMENTNAME>

- <TEST1>

<action>0</action>

<TABLE>0</TABLE>

- <access>

<bpid>1</bpid>

<customer_num>0</customer_num>

<supp_dist_num>456</supp_dist_num>

<req_distri_num>234</req_distri_num>

<qty>500</qty>

</access>

</TEST1>

</STATEMENTNAME>

</ns0:MT_Jdbc_request>

Response Message:

<?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: Database connection could not be established</SAP:AdditionalText>

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack />

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

</SAP:Error></b>

These are the two messages appeared in my XML message processing list.

I am dng SOAP to JDBC synchronous scenario.

I dunno how to solve this issue, can u please resolve it.

Thanks & Regards,

Pushparaju.B.

[bhavesh_kantilal]

Hi,

Check your target datatype,

ACTION is an elelment, It should be an ATTRIBUTE,

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

<ns0:MT_Jdbc_request xmlns:ns0="http://soaptojdbcsync.com/demo">

<STATEMENTNAME>

<b> <TEST1 ACTION = "INSERT"></b>

<b><TABLE>GIVE THE TABLENAME HERE</TABLE></b>

<ACCESS>

<bpid>1</bpid>

<customer_num>0</customer_num>

<supp_dist_num>456</supp_dist_num>

<req_distri_num>234</req_distri_num>

<qty>500</qty>

</ACCESS>

</TEST1>

</STATEMENTNAME>

</ns0:MT_Jdbc_request>

Regards

Bhavesh

[Former Member]

<b><u>Response XML Message</u>

<?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: Database connection could not be established</SAP:AdditionalText>

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack />

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

</SAP:Error>

<u>Request XML Message</u>

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

- <ns0:MT_Jdbc_request xmlns:ns0="http://soaptojdbcsync.com/demo">

- <STATEMENTNAME>

- <TEST1 action="SELECT">

<TABLE>TEST1</TABLE>

- <access>

<bpid>1</bpid>

<req_cust_num>234</req_cust_num>

<material_num>1067</material_num>

<qty>25</qty>

<supp_cust_num>456</supp_cust_num>

</access>

</TEST1>

</STATEMENTNAME>

</ns0:MT_Jdbc_request></b>

This is the error in XML message processing in SXMB_MONI

and

<b>HTTP Error : could not post file

'XISoapAdapter/...............'

this is the error while i am connecting to SOAP Server</b>

Can u please solve my issue...

Thanks & Regards.,

Pushparaju.B.

[bhavesh_kantilal]

Hi,

For JDBC select , please take a look at my blog and create thge request and response strcutures,

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

Regards

Bhavesh

[Former Member]

Hi,

For using select statement at receiver adapter, you need the access elements empty(do not fill them in your mapping). Add <b>key</b> node and give the conditions here. Your request xml should be some thing like this

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

- <ns0:MT_Jdbc_request xmlns:ns0="http://soaptojdbcsync.com/demo">

- <STATEMENTNAME>

- <TEST1 action="SELECT">

<TABLE>TEST1</TABLE>

- <access>

<bpid></bpid>

</req_cust_num>

</material_num>

</qty>

</supp_cust_num>

</access>

<b><key>

<bpid>25</bpid>

</key</b>

</TEST1>

</STATEMENTNAME>

</ns0:MT_Jdbc_request>

Regards,

Jai Shankar

[Former Member]

Hi,

Your request message type has problems in it.

Action should be an attribute of Test1. It should have a value 'select' if u r using a select query.

Is Test1 your table name, then you can remove <table> element.

Modify these two and try.

Go thro the following link for proper message type:

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Reagrds,

P.Venkat

Message was edited by:

Venkataramanan