How to delete/remove SM58 TRFC failed entries using transaction ID
Purpose of the blog
To get rid of the failed entries and shrink the overall memory footprint size of ARFCS* and TRFCQ* tables if there are huge amount of failed entries in SM58. If the Log file / Reorganize method of cleaning the SM58 is still not helping to remove unwanted / failed entries then the report RSTRFCQD does help to delete those unwanted / failed entries.
Also if one is trying to delete the SM58 entry directly by delete option, it will throw the below dependency which will not delete even after using DDIC user.
This blog provides step by step procedure on how to delete unwanted/failed entries in SM58 tRFC and qRFC entries. It provides information on the reports used to delete unwanted tRFC and qRFC entries.
Note: Please ensure with the relevant application that entries are not needed before they are deleted because they are permanently deleted. Also make sure you have the full database backup before doing so.
Steps to delete the TRFC are as per below
- TRFC records can be deleted directly from SM58 (Log file / Reorganize)
- tcode SM58, make the selection as per your requirement and then execute.
- It will display the number of entries in SM58 TRFC with their status
- Click on Log file and then reorganize
- Again make the selection as per the requirement in which you want to delete unwanted TRFC and then execute
2. Now if you want to delete the TRFC via running report report RSARFCER, then we will get the exact same screen as in Fig 4. above.
3. And if both the steps 1 and 2 above are not helping to remove/delete unwanted/failed TRFC entries, then via report RSTRFCQD it can be achieved (selection by TID – one by one). TID – Transaction ID of TRFC.
- The unique Transaction ID is obtained from tcode SM58 against the TRFC. For eg. below it is ABCD1234
- Then execute the report RSTRFCQD, enter the unique TID Transaction ID obtained from SM58 and then execute for deletion
This is it, you are done!
Dear BASIS fellows and colleagues, please share your thoughts and feedbacks on this blog in a comment.
Please follow my profile for future posts.
This will help us a lot.
Thanks Abhishek, indeed!
Good one . Very helpful.