Error in Scenario

[Former Member]

hi all,

I have created a scenario ,in which sender side an flat file is used and in the receiver side RFC is used .

A data is read from a flat file and has to be stored in a Databasee table , the pb is data is read by file dapter and is not stored in the table .

Receiver side a BAPI is used , which will store the data to the table .

when we ececute the transaction sxmb_moni a message get generated .....but no updation in the table.

Can u explain the pb.

[Former Member · Accepted solution]

what is the status of the msg in SXMB_MONI? Error or Success?

Make sure you have the <b>commit work</b> in the RFC code.

Regards,

Jai Shankar

[Former Member]

hi

Can you send any useful link regarding this scenario.....

[Former Member]

ok

i will check the scenario.

so if we give COMMIT there and execute what will happen .....

will the control goes to the bapi.

[bhavesh_kantilal]

Hi,

Please read through the help link i have given,

<i>If you want to use this communication channel to call BAPIs as remote-enabled function modules that change data in the database, set the indicator.

If executed successfully, the transaction is written to the database by calling the function module BAPI_TRANSACTION_COMMIT explicitly. If an error occurs, the transaction is rolled back by BAPI_TRANSACTION_ROLLBACK.</i>

RFC adapter will COMMIT the data internally by calling the BAPI "BAPI_TRANSACTION_COMMIT "

Regards

Bhavesh

[Former Member]

Hi,

BAPI is working fine when executed seperately.....

how to check COMMIT WORK in the RFC Adapter side

[bhavesh_kantilal]

Jude,

In your receiver RFC adapter --> Select Adavenced Mode and then the check Box --> Commit Control for Individual BAPI Calls.

This will commit the BAPI call from XI.

More on this link,

http://help.sap.com/saphelp_nw04/helpdata/en/c8/e80440a832e369e10000000a155106/content.htm

Regards

Bhavesh

[Former Member]

i

have set a breakpoint in the BAPI , but no response .

the sxmb_moni transaction show the same message...

[Former Member]

As pointed bu Bhavesh, look into Adapter monitoring in RWB. You may have some error there. Is COMMIT WORK done?

Regards,

Jai Shankar

[Former Member]

Hi,

Try executing the BAPI independently, and check if the database is being updated.

This way, you could eliminate the possibility of a malfunctioning BAPI.

Regards,

Smitha.

[Former Member]

Hi ,

Success message in the Sxmb_moni

[bhavesh_kantilal]

Hi,

Please look into the RFC adapter in Adapter Monitoring for errors if any.

Next , like mentioned check foir the COMMIT

Regards

Bhavesh

[bhavesh_kantilal]

Hi,

Take a look at the receiver RFC adapter for errors if any on RWB.

Also, like pointed by Jai Shankar, check if COMMIT is handled in your BAPI and if no, make sure that the COMMIT has been turned on in the receiver RFC adapter.

Regards

Bhavesh