on 09-30-2005 7:00 AM
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
looks 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
t' was namespace.
It solved issue.
Besides
the sql statement
select EmployeeID , FirstName ,LastName from Employees where EmployeeID > 7
and the output is
<?xml version="1.0" encoding="UTF-8" ?>
- <p3:ZZTESTXIJDBC xmlns:p3="urn:sap-com:document:sap:rfc:functions">
- <OUTAB>
- <item>
<EMPNO>8</EMPNO>
<EMPNAME>Laura Callahan</EMPNAME>
</item>
- <item>
<EMPNO>9</EMPNO>
<EMPNAME>Anne Dodsworth</EMPNAME>
</item>
</OUTAB>
</p3:ZZTESTXIJDBC>
but I see only one record is getting updated
<EMPNO>9</EMPNO>
<EMPNAME>Anne Dodsworth</EMPNAME>
what could be the reason for that
You have to check your ABAP code for that. May be you are not using the INSERT dbtab FROM TABLE <INTERNAL TABLE>.
what you can do is in the RFC function module, dump the whole internal table into a file by using OPEN DATASET,
TRANSFER, and CLOSE DATASET between the LOOP of ITAB and ENDLOOP. That way you will know what you are getting in the internal table.
It would be nice if you assign some points
regards
Shravan
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.