JDBC to RFC synch RFC call not executing.

[Former Member]

Hi,

I am working on the synchronous JDBC to RFC without BPM. After completing design and config when I test the complete scenario the data from databse is not getting updated in R/3. And I do not see any errors in MONI. But when compared the moni logs I observed the following between the working scenario and not working scenario.

<u>Working scenario log in MONI:</u>

<SAP:Receiver>

<SAP:Party agency="" scheme="" />

<SAP:Service>ECS300</SAP:Service>

<SAP:Interface namespace="<b>http://sap.com/xi/XI/System</b>">InterfaceCollection</SAP:Interface>

- <SAP:Mapping notRequired="S">

<SAP:ObjectId>YYgNVKC9PTCW4JlMapfxZQ==</SAP:ObjectId>

<SAP:SWCV>IrmTYNPLEdqKItGjlusuXw==</SAP:SWCV>

<u>Not working log from the MONI:</u>

++++++++++++++++++++++++

<SAP:Receiver>

<SAP:Party agency="" scheme="" />

<SAP:Service>ECS300</SAP:Service>

<SAP:Interface namespace="<b>http://my_Own_namespace</b>">JDBC_Rfc_Synch_MI</SAP:Interface>

- <SAP:Mapping notRequired="M">

<SAP:ObjectId>28ZZbGggOw6UcnigDXMD7A==</SAP:ObjectId>

<SAP:SWCV>IrmTYNPLEdqKItGjlusuXw==</SAP:SWCV>

<SAP:SP>-1</SAP:SP>

</SAP:Mapping>

Could some body point me where I am doing wrong ?

Thaks

Steve.

[former_member187339 · Accepted solution]

Hi,

Check this

1) Does the sender JDBC adapter shows some processing in Adapter Monitor?

2) Does the receiver RFC adapter shows some processing in Adapter Monitor?

3) When you have created MT for sender JDBC,are you using some value in the <b>XML Namespace </b> textbox? If yes then

you have to give the same value in the <b>Document Namespace</b> of the sender JDBC Adapter. (or other alternative is to use blank in both places).

4) Check Message Monitoring in the Runtime Workbench.

Regards

Suraj

[Former Member · Accepted solution]

Thank you Abhy and Suraj. Your suggestions helped me to resolve the issue.

The scenario is working like charm..

Keep up good work !!

Steve.

[Former Member]

Hi Steve,

I think the error is because your database table is expecting some kind of input and the input you are passing has some error in it.Just cross check the table using DESCRIBE <tablename> with the data you are trying to enter.

Also Just look at Query SQL Statement part ubnder this link,

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

Regards,

abhy

[Former Member]

Hi,

you can check rfc call trace at r3 side in using ST01

Regards

Venjamin