on 06-25-2009 10:55 PM
Hi friends,
I have created a RFC to JDBC scenario. I m trying to insert to 2 different tables in the reciever system. I have a RFC with 2 internal tables. I first tried it as a async scenario,but that did not work, and then as a sync scenario and even that is not working. Can anyone please help me with the design of this.
Thanks in advance.
Anjana.
You dont need to change the flow from Async to Sync.....just make sure that you have created the JDBC receiver structure as is mentioned in the link given by Michal.....in your case you will have two different StatementName nodes (since you are inserting into two different tables)...with action as Insert....the name of the nodes and action are case-sensitive.
Regards,
Abhishek.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
My scenario is working as a perfect sync scenario now. I m able to insert into 2 tables, and get the number of entries inserted as the response. But, now the issue is if i run the program from R/3 with just 1 internal table, it is giving me an error,like it is expecting both tables to be inserted at the same time. Is there a way in mapping I can fix this?
In the java stack i m getting error like this.
FATAL ERROR document format in structure 'INSERT_PERSON': expected 'access' tag(s) not found
But I have given maping to access tag for both tables. This error comes only when 1 internal table is empty.
Please help.
Thanks for the suggestions.
Anjana.
access tabs contain the column names for a particular table....
when you are passing the structure to the DB one of your StatementName's access remains blank/ does not occur.......henc you get the error.....StatementName is occuring but access is not occuring
To avoid the error what you should do is that in your mapping take care to avoid the StatementName for which the data is not send from the RFC table.....no blank instance should be created for the StatemnetName......so when there is call from 1 RFC only one StatementName is present....when call form 2 RFCs then two....and so on....
Regards,
Abhishek.
Hi,
in your JDBC data type structure, change the occurance of header node of both tables to 0..1
then in msg mapping, map the header nodes of these tables with the source internal tables of RFC taking those source fields whose data decides whether target table has to be created.........then using exists and creatif functions map it to target header node of target table.
Regards,
Rajeev Gupta
hi,
>>> have a RFC with 2 internal tables. I first tried it as a async scenario,but that did not work, and then as a sync scenario and even that is not working. Can
which step is not working?
did you do the mapping correctly and the jdbc format is like here?
http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
?
do you see any errors in jdbc channel monitoring?
Regards,
Michal Krawczyk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
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.