on 03-20-2012 3:10 PM
hi all,
i have a synchronous jdbc to rfc scenario
i can see data getting successfully fetched from jdbc and sent to rfc and rfc response data getting inserted to database successfully in sxmb_moni,but when i see in database ,no data is inserted to it......
can anyone help me with this issue
i have created
2 data type,2 message type,1 service interface,2 message mapping,1 interface mapping
2 communication channel(sender-jdbc,receiver-rfc),1 receiver determination,1 interface determination,1 sender agreement and 1 receiver agreement
thanks,
sahana
thanks all ,its working now
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If your RFC response is not so big then without BPM yu can achive this like below
JDBC-sender--->RFCLookup---->JDBC receiver.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I would suggest you to set up two async interface . If you can use proxies instead of RFC , it will be much better. But that its your option
1. JDBC - > RFC
2. RFC - > JDBC ( some background program that triggers the RFC)
Regards,
Krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
http://wiki.sdn.sap.com/wiki/display/XI/File-RFC-File(Without+BPM)
I dont want to use BPM.can i use the above method and change my design accordingly.
will this work?
I have PI 7.1 and sp 06 ...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sahana,
What is your problem precisely? Do I understand it correctly that you cannot see the data inserted in the target system? If so, only mark "Commit Handling for Single BAPI Calls" in receiver CC. And don't think of BPM or RequestResponseBean.
If you require some response being sent from RFC receiver to JDBC sender, you can try with the approach described in your wiki, it should work for you, configured properly.
Greg
Hi,
JDBC sender wont support sync communication ,that is the reason .so you have to change your interface design to support the same.(use BPM).
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you are seeing successful messages that are flowing between sender and recevier via pi means there is no problem with your design.
SAP document regarding BAPI commit operation
BAPIs that post data in the target system,that is, make a change in the database, do so by using an update technique whichrequires an explicit COMMIT WORK statement to actually write the data into the database; This requires an external COMMIT WORK Statement and for that reason we use enhanced mode in the reciever communication channel to set commit operation.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sahana,
You are simply missing a commit after your RFC-enabled function module is executed. Changes are not written to the database without that. In your receiver Communicatoin Channel settings, mark the "Commit Handling for Single BAPI Calls" checkbox to fix the problem. Refer here for further details about this parameter if required: http://help.sap.com/saphelp_nwpi71/helpdata/en/c8/e80440a832e369e10000000a155106/content.htm
Hope this helps,
Greg
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
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.