3137171 - [BW Central KBA] Housekeeping for Request Administration tables (RSPM* tables)

You want to know how to proceed in order to perform Housekeeping in RSPM Request Administration tables. These tables are either occupying huge disk size in your database or you are noticing increasing performance issues during data loads or data activation in InfoProviders. This document will try to detail all relevant information you must know in order to properly perform Housekeeping in your system and how to proceed for each table, as some of them cannot have their data deleted while others can. This KBA refers to such below tables and their respective RSPMHK* counterparts, if they exist:

• RSPMADMIN
• RSPMDATAPID
• RSPMDATATARGET
• RSPMDTASELECTION
• RSPMFILTERCMD
• RSPMLOG
• RSPMPROCESS
• RSPMPROCESSDTAV
• RSPMPROCESSTYPE
• RSPMPROCESSTYPET
• RSPMREQSTATHIST
• RSPMREQUEST
• RSPMREQUESTPROP
• RSPMSTATICEVENT
• RSPMSTORAGESTAT
• RSPMTRACE
• RSPMVARIANT
• RSPMXREF

Notice that the programs and processes delivered by SAP will account for all relevant tables where Housekeeping must be performed, regardless if they are listed here or not. The above list is just a reference, not necessarily including all relevant tables for Housekeeping.

• SAP NetWeaver Business Warehouse 7.4
• SAP NetWeaver Business Warehouse 7.5
• SAP BW/4HANA - All versions

RSPM, Housekeeping, doubts, questions, how to proceed, RSPM_Housekeeping, DTP, TSN, request, RSPM, ADSO, table growth, RSPMREQUEST, RSPMPROCESS, RSPMXREF, general, main, information, clean, up, cleanup, RSPMADMIN, RSPMDATAPID, RSPMDATATARGET, RSPMDTASELECTION, RSPMFILTERCMD, RSPMLOG, RSPMPROCESS, RSPMPROCESSDTAV, RSPMPROCESSTYPE, RSPMPROCESSTYPET, RSPMREQSTATHIST, RSPMREQUEST, RSPMREQUESTPRO, RSPMSTATICEVENT, RSPMSTORAGESTAT, RSPMTRACE, RSPMVARIANT, RSPMXREF, process chain variant, BW Request Status Management: Housekeeping, IF_RSPM_QUERY_RETRIEVE~QUERY_XREF,  TSV_TNEW_PAGE_ALLOC_FAILED, IF_RSPM_PERSISTENCY~UPDATE_REQUEST, TIME_OUT, CL_RSPM_PERSISTENCY_STANDARD, SAPLOLEA , RFC OLE_FLUSH_CALL, Error table could, No more memory available to add rows to an internal table,  Process chain got failed due to "cannot allocate enough memory", Long running job rspm_housekeeping, Issue with housekeeping, Memory consuming housekeeping issue, Housekeeping Process Variant, SAP system housekeeping , housekeeping request , housekeeping process variant , KBA , BW-WHM-DST-RSPM , BW Request Status and Process Management , BW4-DM-RSPM , Request Status and Process Management , How To