轉： A Replacement for RSPCM

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/17846

Blogs

A Replacement for RSPCM - Process Chain monitoring from ST13 (/SSA/BWT program) Balaji Venugopal  Business Card Company: Cognizant Posted on Feb. 11, 2010 08:10 AM in Enterprise Data Warehousing/Business Warehouse

Subscribe Print Permalink <!-- Share

 

Before Starting this blog, let us first look at the benefits of monitoring the process chains from ST13 (or /SSA/BWT program) compared to RSPCM transaction. 

Process Chain Monitoring from RSPCM	Process Chain Monitoring from /SSA/BWT
Need to add every Process chain MANUALLY to be monitored in RSPCM	Whenever a Process chain is created it is automatically included on the chain's first run.
Only the LATEST INSTANCE of the process chain will be displayed even if it had run multiple times in a day.	All the instances will be displayed in the given time interval.
Details like whether the Process chain is a Main chain or a Sub chain, End Date/Time, Number of sub-chains, Number of steps in each chain, Number of Failed/In-Progress steps, Total number of errors in the chain will NOT be displayed.	All these details can be viewed here.
The Refresh time will be VERY SLOW if the number of process chains included in RSPCM increases.	The time taken for Refresh is very much faster compared to RSPCM.
Added/Transferred number records will NOT be displayed in the detail view	The number of Added/Transferred records will be displayed against each LOADING/DTP_LOAD step in the first detail view.
The Runtime CANNOT be compared for each step in the process chain.	The Runtime for each step in the process chain can be compared.

In many systems, ST13 authorization will not be given. But don’t worry, follow the below steps.

1) In SE38 (or SA38) transaction, enter the Program “/SSA/BWT” and execute (F8)

2) Select “Process Chain Analysis” Radio button and execute (F8)

 

3) Select “Process Chains” button

 

4) Enter “*” in Chain ID field (or leave it blank). Enter Start Date and End Date.

 

 

5) The “Process chain Run time Analysis” screen will be displayed. The Log REFRESH is much faster compared to RSPCM. A one stop shop for all the monitoring activities.

 

 

The “STATUS” shows the overall status of the process chain.

The “STEPS” shows the status of the process steps (Sub-chains, data load step, activation step, Rollup, etc.).

For example, a Process chain has failed in a data load step and then it was repeated and the issue got fixed. The process chain got completed successfully. Then the “STEPS” would be in RED as the data load had failed and the “STATUS” will be in GREEN showing that the overall chain got completed successfully.

By this we can easily track all the chains that got failed and we can know if a chain needs to be corrected or not.
If both “STATUS” and “STEPS” are in RED then the Process chain needs to be corrected.
If “STATUS” is in “YELLOW” and “STEPS” is in RED then still there are chances that there might be some failure in the Process chain and that needs to be looked into.

 

6) Click the individual process chain under “CHAIN” column. It will take you to the below screen.

 

7) Now it will show at which step the chain had failed. Click the chain again. It will take you to the Process chain Log, from where the failure can be corrected.

 

Also, we can get additional information like,
• Start Date / Time
• End Date / Time
• Run time (in Seconds & Minutes)
• Whether the Process chain is a Main Chain or Sub chain
• Number of Sub-chains within the Main chain
• Number of Process steps within each chain
• Number of “Failed” steps (Red)
• Number of “In-progress” steps (Yellow)
• Total Number of errors in each chain

 

Additional Parameters:

We can even compare the Runtime of each process types in a process chain. To do this, select a process chain and click on "Compare Runtimes" button.

The Runtime for each step in the process chain will be displayed as shown below.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Hope this helps BW Consultants to monitor the chains in an efficient manner.

 

Balaji Venugopal   is a BI Consultant working in Cognizant Technology Solutions. He has more than 3.5 years of experience in SAP BI and has handled both Development and Support projects

---

Comment on this weblog

Showing messages 1 through 15 of 15.
Titles Only	Main Topics	Oldest First

• Excelent
  2010-10-07 22:44:37 reka p Business Card [Reply]
  
  Oh Create Analysis.very Help full.

• ST13 and SAP CPS
  2010-02-26 01:38:15 Martin Lauer  Business Card [Reply]
  
  Hi,

  
  transaction SR13 has more to offer, see fopr example http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/17414.

  
  Consider using SAP CPS for an improved BW process chain management:
  http://www.sdn.sap.com/irj/sdn/nw-scheduling?rid=/library/uuid/50c60d60-4a8d-2b10-a2be-f9e8ebac6e7f

  
  Kind regards,
  Martin

• good one...
  2010-02-19 23:24:12 Rajesh Salecha Business Card [Reply]
  
  I'll spread this so that it can be use effectively. Thanks for the details.

• Great work
  2010-02-12 01:52:33 B R Business Card [Reply]
  
  Excellent explanation Balaji...Keep them coming..

  
  Regards,
  Balaji.R

• Good Work Again...!
  2010-02-11 21:05:11 vimal murugan Business Card [Reply]
  
  It's really nice to get this method on Blog, Balaji.

• Thanks for the info
  2010-02-11 20:48:47 Vasanth VF Business Card [Reply]
  
  Great blog Balaji, will try this one for sure

• Thanks for pointing this out
  2010-02-11 13:14:35 Jim Ward Business Card [Reply]
  
  I am using it already.
  • Thanks for pointing this out
    2010-03-01 03:42:01 sulman shaikh Business Card [Reply]
    
    Hi there,

    
    I cannot find the program in Se38, and when I enter t-code ST13 I get the message that it doesnt exist?

    
    Ay suggestions?

    
    Thanks

    • Thanks for pointing this out
      2010-04-07 11:22:28 Tobias Haas Business Card [Reply]
      
      Hi,
      i have a bw 7 sandbox system and i also have the message that ST13 does not exist.
      I use the transaction since years also in bw 7.
      I will try tomorrow the programm.

      
      Maybe the program is in an addon?
      Kind regards,
      Tobias

    • Thanks for pointing this out
      2010-03-01 21:40:18 Balaji Venugopal Business Card [Reply]
      
      Very Strange. I am currently in BI 7.0. I am not sure if it exists in BW 3.5 (hopefully it must be there).
      In which version is your BW system ?
      • Thanks for pointing this out
        2010-03-16 23:03:11 Dinakar A Business Card [Reply]
        
        Dear Balaji,
        Really tis method is very helpful.But I am unable to find the program /SSA/BT in SE38.We are in BI 7.0 only.Please suggest.

        
        Thanks & Regards,
        Dinakar.

        • Thanks for pointing this out
          2010-04-20 01:21:08 berna bagdemir Business Card [Reply]
          
          Dear Dinakar and Balaji,

          
          Could you find a solution for the problem.
          I also can not find the transaction ST13 or the program /SSA/BWT.

          
          Regards,
          Berna

          • Thanks for pointing this out
            2010-05-13 07:51:58 Michael Gibbs Business Card [Reply]
            
            Had the same exact issue after applying

            
            ST-A/PI 01M_BCO700

            
            Go to SE38, run RTCCTOOL, and perform. the "Addons &Upgr." step after applying this tool.

            
            

          • Thanks for pointing this out
            2010-04-20 01:25:54 Tobias Haas Business Card [Reply]
            
            Hi,

            
            watch note https://service.sap.com/sap/support/notes/69455
            you have to install the needed plugin.

            
            Regards,
            Tobias

        • Thanks for pointing this out
          2010-04-07 12:20:56 Tobias Haas Business Card [Reply]
          
          Hi,
          i browsed through the oss notes and found the following
          https://service.sap.com/sap/support/notes/69455
          so maybe we need to install these servistools?

          
          Kind regards,
          Tobias

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22792542/viewspace-696322/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22792542/viewspace-696322/