Repitition of Records using JDBC Receiver

[Former Member]

Hello Experts,

I am using a scenario RFC -PI - JDBC. When the RFC is executed for the first time on the R3 side it send the data perfectly in the table in the Oracle database.The action field is set to UPDATE_INSERT. Thereafter when it is executed for the second time, the first record is repeated 5000 time and other records are intact as it is. When the RFC is excuted for the third time the entire record gets appended to the entire record in the Database and the first record count also increases by one. The occurence in the receiving structure for access is set to 1 to unbounded and for elements below it is set to 1. On the sender side the occurence is set to 0 to 1. may know the problem might be and what needs to be done for the JDBC adapter to work perfectly fine. The Oracle database is Oracle 8i.

Regards

[zameerf]

>>The occurence in the receiving structure for access is set to 1 to unbounded

Can you try to set the StatementName occurrence to 1 to unbounded and Access node to be 1 to 1?

You can map the sender Record node to StatementName node, so that for each record at sender side an UPDATE_INSERT would be performed at target side Database.

[Shabarish_Nair]

can you check the JDBC XML created for each of these scenarios? How many nodes are being created for the update insert statement?

also enable  logSQLStatement - described in OSS note 801367 for further troubleshooting

[iaki_vila]

Hi,

Have you checked the monitoring?. Are the target XML's similar in the three times?

Regards.

[former_member184681]

Hi,

Have a look at SAP Help for UPDATE_INSERT:

http://help.sap.com/saphelp_nwpi71/helpdata/en/44/7b6d32fde93673e10000000a114a6b/content.htm

Regards,

Greg