Skip to Content

SAP BW 7.0 and will also work on BW 3.5

Disclaimer: This article will be useful for freshers who work on data load monitoring on daily basis. This article is completely based on my project experience and your suggestions are most welcome.

Summary

This article explains step by step process about skipping an error process in process chain.

Author: Prakash Kumar Sahu    

Company: Cognizant Technology Solutions(Pune/India)

Created on: 27 June 2013

Author Bio

MyPic.png

Prakash Kumar Sahu is a SAP BI/BPC/BOBJ consultant with around 4 years of SAP BI/BPC experience and currently working with Tata Technologies Limited (Pune/India). He has got rich experience and worked on various BW/BI, BPC and BOBJ implementation/Support projects

Table of Contents

1. Introduction

2. Step by step process

3. Reference

1. Introduction: Very often we come across the error in any intermediate step of a process chain. Many times we just want to skip that error process so that process chain can proceed further. In BI 7.3 SAP has given the option of SKIP for any error process. By selecting this process chain proceeds further ignoring the error process. However in BI 7.0 and its lower version SKIP option is not available.

Context menu for BI 7.3

1.JPG

Context menu for BI 3.5 and 7.0

2.JPG

2. Step by step process

For skipping any error process in Process chain in BI 7.0 and its lower version, we need to run the functional module RSPC_PROCESS_FINISH providing the import parameter from table rspcprocesslog.

Following are step wise step process for performing this activity.

Step 1.  Right click on failed process and select Displaying Messages.

/wp-content/uploads/2012/09/pic1_237742.png

Step 2. Go to Chain tab and note down the following parameter.

/wp-content/uploads/2012/09/pic2_237797.png

Step 3.  Go to table (SE16)  RSPCPROCESSLOG and fill the above parameters as shown below.

/wp-content/uploads/2012/09/pic3_237799.png

Step 4. You will see that state is R in this table.

/wp-content/uploads/2012/09/pic4_237803.png

Following are possible values for Status of Process.

7.JPG

Step 5. Go to Functional Module(SE37) RSPC_PROCESS_FINISH and run it in test mode.

8.JPG

Step 6. Fill the Import parameters from above table and for I_STATE put G.

/wp-content/uploads/2012/09/pic5_237804.png

Step 7. Execute the above functional module, you should get following similar message.

/wp-content/uploads/2012/09/pic6_237805.png

Step 8. Now, go to your process chain, you will see the error process has been skipped and process chain has proceeded to the next step.

/wp-content/uploads/2012/09/pic7_237812.png

Step 9.  Now, go to table once again, you will see that Status of Process is now G (Green or successful).

/wp-content/uploads/2012/09/pic8_237813.png

I hope, this article will be useful for beginers who work on Data Load monitoring ondaily basis.

3. Reference

Reference 1

http://help.sap.com/

Reference 2

http://www.sdn.sap.com/irj/sdn

Reference 3

service.sap.com

To report this post you need to login first.

2 Comments

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

  1. Udayaditya Boruah

    Thanks for the document Prakash. I would however like to add a point here.

    As you said regarding the RSPC_PROCESS_FINISH function module, instead of going to the table RSPCPROCESSLOG and filling the details, we can directly provide the details in the screen that comes after executing the Function Module itself.

    1. After going to tcode se38, we enter the program name as RSPC_PROCESS_FINISH

       and execute it.

    2.It then brings us to the below screen:

    Screenshot 3.JPG

    3. We can enter the details by going to the event that has completed successfully but has not turned green. In my example, I have taken a DTP Load as an event.

    4. Go to the event and right click to get the Displaying messages option. Below is the screen that comes up

    Screenshot 2.JPG

    By going to the Chain tab, we get the details of the Instance and the Variant.

    5. For the remaining details, go to the Backg tab and click on the job details list as shown below:

    Screenshot 1.JPG

    From there, you’ll get the LOGID, CHAIN and TYPE details.

    The final step is in executing it and the job’s done.

    Cheers!

    Uday

    (0) 

Leave a Reply