Error in JDBC_Request structure unable to find where the error is existing

[Former Member]

I am doing SOAP to JDBC scenario

the error while sending soap request to server is like this....

status of adapter monitor and sxmb_moni is also same as above

Adapter Monitor (SOAP adapter is green and jdbc adapter is red)

<b> 2006-12-20 18:38:17 IST: Error: TransformException error in xml processor class: Error processing request in sax parser: Error when executing statement for table/stored proc. 'TEST1' (structure 'STATEMENT'): java.sql.SQLException: FATAL ERROR document format: structure 'STATEMENT', no key element found

- 2006-12-20 18:38:17 IST: Processing started</b>

sxmb_moni showing error

<b> <SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'TEST1' (structure 'STATEMENT'): java.sql.SQLException: FATAL ERROR document format: structure 'STATEMENT', no key element found</SAP:AdditionalText>

<SAP:ApplicationFaultMessage namespace="" /></b>

[Former Member]

pushparaju,

The error is very clearly saying that the request JDBC structure does not have the key tag which is mandatory for "SELECT" operation. Ref to the blog I referred in the other thread and redsign the request in the way shown in the blog.

Regards,

Jai Shankar

[Former Member]

Thanks JaiShankar,

I have changed my JDBC_request strucutre accordingly, its working fine....

JDBC adapter and soap adapter are working fine...

its fetching data from database... but unable to map it to soap response.... as jdbc response(selected data from database) is visible in sxmb moni....

This is selected data from database....

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

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

<STATEMENT_response>

<row>

<BPID>8</BPID>

<REQ_CUST_NUM>234</REQ_CUST_NUM>

<MATERIAL_NUMBER>1067</MATERIAL_NUMBER>

<QTY>45</QTY>

<SUPP_CUST_NUM>456</SUPP_CUST_NUM>

</row>

</STATEMENT_response>

</ns0:MT_Jdbc_request1_response></b>

But this is the error i am facing in SXMB_MONI its saying that mapping transformation was not happen properly....

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack>com.sap.aii.utilxi.misc.api.BaseRuntimeException thrown during application mapping com/sap/xi/tf/_MM_Jdbc_Response_Soap_Response1_: RuntimeException in Message-Mapping transformatio~</SAP:Stack>

<SAP:Retry>N</SAP:Retry>

This is my mapping transormation in MM_Jdbc_Response_Soap_Response1

MT_JDBC_request_Response1 1..1 MT_soapresponse

Statement_response 1..1

Row 0..Unbound Row

Bpid 1..1 -

---

> Bpid

req_cust_num 1..1 -

---

> req_cust_num

material_number 1..1 -

---

> material_number

qty 1..1 -

---

> qty

supp_cust_num 1..1 -

---

> supp_cust_num

Regads,

Pushparaju.B.

[Former Member]

Glad you got it.

Now your second mapping (response) fails use the XML JDBC response from SXMB_MONI(you pasted in your reply) to test your mapping in IR.

Ref:/people/michal.krawczyk2/blog/2005/09/16/xi-how-to-test-your-mapping-in-real-life-scenarios

Michal can come to your rescue now...

Regards,

Jai Shankar

[Former Member]

Hi ,

Check your message interface, tags and namespaces. Could be a problem there.

cheers,

Prashanth

P.S Please mark helpful answers

[Former Member]

its showing the following error while i tested the view source of sxmb_moni reponse message with my MM_jdbc_response...

<b>Cannot produce target element /ns0:MT_Soap_response. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd</b>

Can u solve my problem.....

Regards.,

Pushparaju.B.

[Former Member]

Pushparaju,

May be if you can give us the JDBC response and SOAP response along with your mapping, we can help you. But the error clearly says, your mapping fails. You need to look into that.

P.S: Close the previous threads and avoid posting multiple threads for the same topic.

Regards,

Jai Shankar

[Former Member]

this is message mapping between MT_jdbc_request1_response and MT_Soap_Response.....

MT_jdbc_request1_response -

---

> MT_soap_response

Statement_response -

---

> Response

Row 0..Unbound -

---

> Row

BPID 1..1 -

---

> BPID

REQ_CUST_NUM 1..1 -

---

> REQ_CUST_NU

MATERIAL_NUMBER 1..1 -

---

> MATERIAL_NU

QTY 1..1 -

---

> QTY

SUPP_CUST_NUM 1..1 -

---

> SUPP_CUST_N

This is mapping structure and message mapping of jdbc response to soap response.......

I am unable to find where the error is there in this mapping

I did straight one to one mapping...

Regards,

Pushparaju.B

[Former Member]

Hi,

Your JDBC message type structure is wrong . Cross check your structure with the structure in the following link.

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

Post your JDBC type.

Regards,

Sudheer.

Message was edited by:

sudheer