ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 轉: A Replacement for RSPCM

轉: A Replacement for RSPCM

原创 Linux操作系统 作者:solisnail 时间:2011-05-26 10:55:19 0 删除 编辑

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. Subscribe
Print. Print
Permalink 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)

image

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

image
 

3) Select “Process Chains” button

image
 

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

image 

 

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.

image 

 

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.

image

 

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.

image

 

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.

image

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 article
Comment on this weblog

Showing messages 1 through 15 of 15.

Titles Only Main Topics Oldest First
  • ST13 and SAP CPS
    2010-02-26 01:38:15 Martin Lauer SAP Employee 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

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

下一篇: EP USER MANAGEMENT
请登录后发表评论 登录
全部评论

注册时间:2011-04-07

  • 博文量
    18
  • 访问量
    22099