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

/wp-content/uploads/2013/09/1_288918.jpg

Step2: The report will show ALL TRFCs.

/wp-content/uploads/2013/09/2_288919.jpg

Step3: From the output, Choose ‘Reorganize” as shown in above picture. Execute this after selecting * on user name and preferably error entries.

/wp-content/uploads/2013/09/3_288941.jpg

Better to take care of this on periodic basis may be include in Housekeeping periodic Tasks.

Thanks .

To report this post you need to login first.

20 Comments

You must be Logged on to comment or reply to a post.

  1. Harish Allachervu

    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,

    Harish

    (0) 
    1. Kamal Mehta Post author

      Hi Harish,

      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.

      Thanks

      Kamal

      (0) 

Leave a Reply