Problem with scenario from RFC to Oracle DB

[Former Member]

Hello,

I have a scenario from R/3 to Oracle DB. With this scenario I received more then 100 RFC's from R/3 system.

Each of this RFC's contain 20 lines insert to DB.

I don't know way but I received to DB only 99 lines.

Any Idea

Elad

[former_member240483 · Accepted solution]

Check in the MONI what showing there for the messages...

check the payloads there u can see how many records came into XI...

Regards

Rao

[Former Member · Accepted solution]

Hello,

In JDBC insert I write - JDBC insert.

Yes I create new message to each insert.

In RWB I have this message - sql command not properly ended.

In MONI I have black-white flag.

Elad

[Former Member · Accepted solution]

Hello,

Can you clearly mention the exact information which you are getting in audit log like you said,

" In RWB I have this message - sql command not properly ended. "

So can you comlete this message.

And try to configure an advanced mode parameter "logSQLStatment" as true and activate the changes and run the scenario again.

And again check the RWB and find the error message if you get any and send that error message.

Thanks,

Soorya

[Former Member · Accepted solution]

Hello Surya,

Now is look like mapping problem because I received to Oracle DB 106 lines and I sent 106 RFC's (with 20 lines each).

My source file is:

<?xml version="1.0" encoding="UTF-8"?>

<ns0:Z_RFC_QRY_HR_ABC_SEND_DATA xmlns:ns0="urn:sap-com:document:sap:rfc:functions">

<ZZ_OUTTAB>

<item>

<PERNR/>

<ZZVORNA/>

<ZZNACHN/>

<ZZRUFNM/>

<TEXT_P0001_WERKS/>

<TEXT_P0001_ORGEH/>

<TEXT_P0001_PLANS/>

<USRID/>

<MY0003/>

<MY0002/>

<MY0004/>

<MYMAIL/>

<MY0005/>

<ZZORGTXT/>

<ZZORGSTXT/>

<ZZPRFTXT/>

<ZZPRFSTXT/>

<DAT01/>

<KOSTL/>

<TEXT_P0001_KOSTL/>

<PERSG/>

<PLANS/>

<RUFNM/>

<NCHMC/>

<VNAMC/>

<ZZFULL_NAME/>

<PERNR01/>

<MTGE/>

</item>

</ZZ_OUTTAB>

</ns0:Z_RFC_QRY_HR_ABC_SEND_DATA>

And my target is:

<?xml version="1.0" encoding="UTF-8"?>

<ns1:Phone_Book_MT xmlns:ns1="com:netafim:phone_pook"><Statement><EMPLOYEES action="UPDATE_INSERT"><TABLE>EMPLOYEES</TABLE><access><PERSONAL_NUM></PERSONAL_NUM><EN_FIRST_NAME></EN_FIRST_NAME><EN_LAST_NAME></EN_LAST_NAME><EN_NICK_NAME></EN_NICK_NAME><WORK_CENTER></WORK_CENTER><ORG_UNIT></ORG_UNIT><TITLE></TITLE><USER_ID></USER_ID><HOME_PHONE></HOME_PHONE><OFFICE_PHONE></OFFICE_PHONE><MOBILE></MOBILE><EMPLOYEE_TYPE></EMPLOYEE_TYPE><PLANS></PLANS><EN_FULL_NAME></EN_FULL_NAME><FIRST_NAME></FIRST_NAME><LAST_NAME></LAST_NAME><NICK_NAME></NICK_NAME><BIRTH_DATE></BIRTH_DATE><MAIL></MAIL><START_DATE></START_DATE><COST_CENTER></COST_CENTER><COST_CENTER_DESC></COST_CENTER_DESC></access><key><PERSONAL_NUM></PERSONAL_NUM></key></EMPLOYEES></Statement></ns1:Phone_Book_MT>

Thank you for all your help

Elad

[VijayKonam]

How is your JDBC insert statement look like? Are you creating a new message for each insert? Check RWB if it has any SQL exceptions received.

VJ