Skip to Content

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.

1.PNG

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

To report this post you need to login first.

4 Comments

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

  1. SG Sg

    Hi Mukesh,

    This is very much helpful, for Support projects rarely we face this kind of issue 😉 😉 😉 , we think that sometimes we nedd to apply oss note for this issue. But your Blog helps before thinking oss note . 😉 😉 😉 😉

    Regards,
    Giri

    (0) 

Leave a Reply