RE: Error in soap to jdbc synchronous

[Former Member]

I am doing webservice to jdbc scenario....

My data is getting inserted into database, but its showing soap response in XML Spy....

This is the error while i copy input XML file from SXMB_MONI to test tab of Integration Repository and executed in debug mode....

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

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

<STATEMENTNAME>

<TEST1 action="INSERT">

<TABLE>TEST1</TABLE>

-<access>

<BPID>00008</BPID>

<REQ_CUST_NUM>00234</REQ_CUST_NUM>

<MATERIAL_NUMBER>00000000000000001068</MATERIAL_NUMBER>

<QTY>00250</QTY>

<SUPP_CUST_NUM>00456</SUPP_CUST_NUM>

</access>

</TEST1>

</STATEMENTNAME>

</ns0:MT_Jdbc_request>

error in Repository

12:37:52 Start of test

Document start

Start tag [ns0:MT_Jdbc_request]

Add raw attribute [ xmlns:ns0="http://soaptojdbcsync.com/demo"]

Start tag [STATEMENTNAME]

Start tag [TEST1]

Add attribute: [action]=[INSERT]

Start tag [TABLE]

Put value [TEST1]

Close tag [TABLE]

Start tag [access]

Cannot produce target element /ns0:MT_Jdbc_request/STATEMENTNAME/TEST1/access/BPID. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd Cannot produce target element /ns0:MT_Jdbc_request/STATEMENTNAME/TEST1/access/BPID. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd

12:37:52 End of test

[Former Member]

Hi,

Could you please post the target MT here?

Looks like you donot have a <TABLE> tag in your target MT. If so,there might be a context change required, before you map source <access> tag to target <access> tag.

Regards,

Smitha.

[Former Member]

Hi,

Do you get an error in mapping?

The XML you have posted is copied from SXMB_MONI? If so, then your request message mapping works fine. You need to check the reaponse message mapping.

While executing the sceanrio, wehre do you get the error? Post the JDBC response structure. GIve more details to get better help.

Regards,

Jai Shankar

[Former Member]

Hi Jai,

I am getting the same error. In my JDBC response, the source message (the actual JDBC response from the database) is in one SWCV and the target message is in another SWCV. Is this a problem?

The following is the response from JDBC which is not mapping to the target message, which is abstract.

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

- <ns1:insert_olac_za_response xmlns:ns1="urn:bp:xi:dwn:re:cust_mdm:cmdm:scdb_olac_za:200">

- <Insert_response>

<insert_count>1</insert_count>

</Insert_response>

</ns1:insert_olac_za_response>

[Former Member]

Hi kalyan,

>>the source message (the actual JDBC response from the database) is in one SWCV and the target message is in another SWCV. Is this a problem?

Sure this is not a problem. Check you mapping as per this blog

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

Regards,

Jai Shankar

[Former Member]

Hi,

Did u map ur access element with some source element?

Thanks.

[Former Member]

Hi,

You are getting error because you just copied that message from sxmb_moni.

Go to that message in sxmb_moni and then select view source and then copy this source message in ur mapping test tab.

Thanks.

[Former Member]

Same error even after copying viewsource also....

Same XML File comes right....

even you see source also but it shows with out some spaces...

Can u tell me another alternative

Regards,

Pushparaju...