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.
Good house keeping activity 🙂 . Thanks for making..
Really helpful and useful.
Thanks for sharing.
Thanks Anshu for your valuable comments.
Interesting and useful.
Hi Ivan ,
Thanks for your comments.
Thanks kamal for providing valuable information
Thanks Purushotham for your comments .
Really good job and useful info.Thanks for sharing.
Thanks for your valuable comments.
Hi Satendra ,
Thanks for your comments.
Nice document Thanks for sharing.
Can you rate it .
Really a helpful document.
Thanks for sharing. 🙂
Thanks for your comments Pratik.
informative kamal thanks for sharing... 🙂
I have one query regarding the TRFC's as part of housekeeping activity daily i'll do reorganize which are stuck for long time, because as per knowladge if TRFC's are in the state like this Function module executed for long time it will create inconsistency in the data load from ECC---> BW so please tell me am i doing right....!!!
I have gone through many docs and blogs but no answer to my question.... 😉
please suggest me.
Thanks & Regards,
It depends ideally if you have TRFC's for quite some time may be 2 years back i don't think deleting the same would create any kind of inconsistencies. Hence, you should delete all old TRFC's(1-2 years back) and check and monitor all TRFC's with cancelled status and see whether they need to restarted or deleted.
Also do a test in Quality environment to check and verify the same.