JDBC to RFC Asynchronous Scenario - Not all records are intserted into RFC

[Former Member]

I have a strange issue happening in production all of a sudden. There is an interface which sends data from Oracle system to RFC, the scenario is JDBC to RFC Asynchronous. There are 570 records coming from JDBC to RFC, I can see all 570 records in the incoming and outgoing messages in PI SXMB_MONI but when I checked in SAP RFC there are only 561 records. When I compared the missing records in SAP with the ones that are successfully loaded, I do not see any difference. Any one came accross this issue before?

Thanks for your help.

Naga

[Former Member]

Forgot to mention one more point - If I try to add a record manually in the RFC, the record is inserted in the ZTABLE.

Naga

[Former Member]

Hi Naga,

go to se37 at ECC and execute the RFC, enter 2 identical records and see how it process them. If it process just one of them, problem's found.

Anyway, if you can see incoming records and outgoing records at PI in same number, the issue is at RFC code for sure.

Cheers,

Edu

[Former Member]

Hello everyone

     Thanks for all your replies.The keyfields in the table are pernr and perfplnyear. For example if the JDBC extract has an employee number 123456 and perfplnyear 2012-2013, eventhough this record does not exist in the SAP table it is not inserted. There is no filtering in the RFC code, it is just moving the records from RFC to ZTABLE which is very direct method.

Thanks

Naga

[ambrish_mishra]

Hi,

>>>>>when I checked in SAP RFC there are only 561 records.

Do you mean in the underlying table ?

You can try to replicate the issue in a quality system. If the behavior is the same, the issue is with data which is getting filtered out.

Ambrish

[Pranil1]

Hi Naga,

Please check the RFC code. Input data might be getting filtered based on the specific conditions mentioned in the code.

Regards,

Pranil.

[iaki_vila]

HI Naga,

I think you should follow Osman advice and to control if the records are duplicated. However if you want assure this thing, you can create a log table in R/3 with all fields like a key table and a sequential field, key table too, if the insert fail you add one to this sequential and try again. If there are a sequential with a value greater than zero may be the problem will be the issue that Osman pointed.

Regards.

[Former Member]

Might be the 9 missing records are the duplicate records and it is updating the records instead of creating new enty.