T-Code RSPCM is not working

Problem:

This is a very Common problem from BW team that they are unable to run transaction Code RSPCM in BW system.

Reason:

This problem start when system start SAP_CCMS_MONI_BATCH_DB job to gather the information from Process Chain and request for CCMS Monitoring. The purpose of this job is to check and evaluate the all request and Process chain where the status has been changed since last run of the job.

Immediate Work Around:

Cancel the job SAP_CCMS_MONI_BATCH_DB.

Permanent solution:

1. The first and most important step to improve performance is to create an index on table EDIDC including the fields MANDT, CREDAT and MESTYP.
2. The ALE tables (EDIDC, EDI40 etc) should be reorganized in your BW and also in the connected source systems to improve the performance of the job.
3. Perform a request archiving to reorganize all the maintenance tables for the Infopackage & DTP requests such as RSMONMESS and RSBMONMESS. This can be done with the help of the archiving object BWREQARCH, documentation on this is available in the link below:

Recommended link:

http://wiki.sdn.sap.com/wiki/display/BI/A+Performance+Issue+With+Transaction+RSPCM