Hi,
I am tryiing JDBC TO RFC SCEANRIO.
XI is picking data from MS SEQUEL SERVER but
the same data is not getting mapped into RFC
I am not getting any error as such.
Following are the details.
made a datatype
resultset
row
EmployeeID
LastName
FirstName
message mappping
RFCFORJDBC
resultset outab
row item
EmployeeID----
Empno
FirstName
concatenate--- Empname
Lastname
But for some odd reason
the OUTTAB FOR RFC
is coming like this in message
<?xml version="1.0" encoding="UTF-8" ?>
- <p3:ZZTESTXIJDBC xmlns:p3="urn:sap-com:document:sap:rfc:functions">
<OUTAB />
</p3:ZZTESTXIJDBC>
while payload is getting picked correctly
<?xml version="1.0" encoding="utf-8" ?>
- <resultset>
- <row>
<EmployeeID>9</EmployeeID>
<FirstName>Anne</FirstName>
<LastName>Dodsworth</LastName>
</row>
</resultset>
Kindl help with the same
1 Answer
-
Former MemberSep 30, 2005 at 06:08 AMlooks like you are missing namespace in the JDBC data, you should mention the docNamespace in the JDBC sender adapter.
Copy your payload and paste this in your mapping test tab. How ? After copying the payload go to Message mapping, there is Tab for Test right next to the Design. click on that and then click on the SRC button in the source message and paste your XML and do a test. Then you will know whats going wrong.
One other precaution is, you can fill the fields in the test tab then click on SRC button to look at what the source XML should look like.
hope you understand, if not post the question again.
regards
Shravan
Add comment
Add comment