TRFC Monitoring – Maintaining Table ARFCSDATA – BW Check
Introduction : Many a times we faced lot of issues with respect to TRFC’s because of which either we experience performance related issues or sometimes data load failure in BW Process Chains. This is typically a Basis task but from BW point of view it can get better if we know and can take care of the same ourselves as well as finally BW is only going to be used for Reporting and one can save some time if possible.
The table ARFCSDATA basically holds temporary data for tRFCs. It could contain many cancelled tRFCs. Using transaction SM58 we can identify and monitor all such tRFCs. The table and its Index allocated can contribute to a large table space which can be reviewed to be deleted or executed as the need be. However very old entries in this table should be deleted on regular intervals. Normally, this table should only contain tRFCs that are currently being processed. Cancelled tRFCs should be monitored daily / weekly and either restarted or deleted. If these entries are deleted or the above mentioned table is maintained on regular basis then we can experience better performance in BW data loading as well.
Delete all entries in table ARFCSSTATE where Return field is blank and its status having SYSFAIL. All these entries are unprocessed entries that should be deleted as best practice.
Note : Entry in this table can be deleted by only that person who has created these entries. Including the one created by ALEREMOTE!!(Hence recommended to do this by way of Re-organize)
Proceed as follows:
Step 1: Log on to R3 / ECC, go to T Code SM58.
Choose an appropriate time period and execute the report
Step2: The report will show ALL TRFCs.
Step3: From the output, Choose ‘Reorganize” as shown in above picture. Execute this after selecting * on user name and preferably error entries.
Better to take care of this on periodic basis may be include in Housekeeping periodic Tasks.