on 09-19-2006 5:42 AM
hi all,
i m working on one scenario where i m sending data using HTTP and receiver is jdbc adapter which is retrieving me data from sql server.
i have checked the structure both for req and res.
i m getting this error
<SAP:Error>
<SAP:Category>Application</SAP:Category>
<SAP:Code>MAPPING.EXCEPTION_DURING_EXECUTE</SAP:Code>
<SAP:P1>com/sap/xi/tf/_INF57285_DB_HR_RES_</SAP:P1>
<SAP:P2>com.sap.aii.utilxi.misc.api.BaseRuntimeException</SAP:P2>
<SAP:P3>RuntimeException in Message-Mapping transformatio~</SAP:P3>
<SAP:Stack>During the application mapping com/sap/xi/tf/_INF57285_DB_HR_RES_ a com.sap.aii.utilxi.misc.api.BaseRuntimeException was thrown: RuntimeException in Message-Mapping transformatio~</SAP:Stack>
</SAP:Error>
can somebody help me with this.
Thanks & Regards
Aruna
Aruna,
There is some exception in the mapping.
I think the data recived from the JDBC adapter does not match with the data type you have created and so a mapping exception
For info on how the JDBC response will look like , take a look at these blogs,
/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step
/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response
Regards,
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thnks bhavesh i made extacly the way it is given in
/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step
my request stucture to jdbc is
<REQUEST>
<EmpNo>57285</EmpNo>
</REQUEST>
my response from jdbc is
<Employee_response>
<row>
<Name>aruna</Name>
<EmpId>57285</EmpId>
<Band>A</Band>
<Salary>4675776</Salary>
</row>
</Employee_response>
and request i m sendind to jdbc is
<ns:INF57285_DB_Request xmlns:ns="http://www.infosys.com/xi/training/hyd/57285">
<Employee>
<EmpDetails action="SELECT">
<table>EmpDetails</table>
<access>
<Name />
<EmpId />
<Band />
<Salary />
</access>
<Key>
<EmpId>57285</EmpId>
</Key>
</EmpDetails>
</Employee>
</ns:INF57285_DB_Request>
and response i m getting from jdbc is
<response>
<row>
<Name>aruna</Name>
<Empld>57285</Empld>
<Salary>4675776</Salary>
</row>
</response>
</ns:INF57285_HR_Res>
i have mapped my req to jdbc request
and response of jdbc to response which i m getting
my scenario is
HR syn-- XI -syn- DB
Hi,
The response datatype should be as follows,
<ns:INF57285_DB_Request_<b>response</b> xmlns:ns="http://www.infosys.com/xi/training/hyd/57285">
<Employee_<b>response</b>>
<b><row></b>
<Name>aruna</Name>
<Empld>57285</Empld>
<Salary>4675776</Salary>
</row>
</Employee_<b>response</b>>
</ns:INF57285_DB_Request_<b>response</b> xmlns:ns="http://www.infosys.com/xi/training/hyd/57285">
Please note : it should <b>_response</b> ( case senssitive )
Change the response datatype as shown above, redo the response mapping and it should work.
From my blog,
<i>This is the trickiest part of the configuration and where most of us go wrong. <b>The JDBC adapter when sending its response back will create a Message Type of the same name as the request message with a _response appended to it.</b>
So, if your Request message type is going to have the name, MT_JDBC_SELECT_JDBC_REQUEST then, the message type for the response that is to be created will have to be MT_JDBC_SELECT_JDBC_REQUEST_response .</i>
Regards,
Bhavesh
thnks bhavesh i think i made it that way
JDBC REQ
<ns:INF57285_DB_Request xmlns:ns="http://www.infosys.com/xi/training/hyd/57285">
<Employee>
<EmpDetails action="SELECT">
<table>EmpDetails</table>
<access>
<Name />
<EmpId />
<Band />
<Salary />
</access>
<Key>
<EmpId>57285</EmpId>
</Key>
</EmpDetails>
</Employee>
</ns:INF57285_DB_Request>
JDBC RES
<ns:INF57285_DB_Request_response xmlns:ns="http://www.infosys.com/xi/training/hyd/57285">
<Employee_response>
<row>
<Name>aruna</Name>
<EmpId>57285</EmpId>
<Band>A</Band>
<Salary>4675776</Salary>
</row>
</Employee_response>
</ns:INF57285_DB_Request_response>
my hr req is which i mapped with DB req
<ns:INF57285_HR_Req xmlns:ns="http://www.infosys.com/xi/training/hyd/57285">
<REQUEST>
<EmpNo>57285</EmpNo>
</REQUEST>
</ns:INF57285_HR_Req>
my hr res is which i mapped with DB res
<ns:INF57285_HR_Res xmlns:ns="http://www.infosys.com/xi/training/hyd/57285">
<response>
<row>
<Name>aruna</Name>
<Empld>57285</Empld>
<Salary>4675776</Salary>
</row>
</response>
</ns:INF57285_HR_Res>
and interestingly i am not getting any error in sxmb_moni
it's not showing any error
plz suggest me something wht to do ....
thnks & regards
Aruna
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.