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.
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
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: 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
Context menu for BI 3.5 and 7.0
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.
Step 2. Go to Chain tab and note down the following parameter.
Step 3. Go to table (SE16) RSPCPROCESSLOG and fill the above parameters as shown below.
Step 4. You will see that state is R in this table.
Following are possible values for Status of Process.
Step 5. Go to Functional Module(SE37) RSPC_PROCESS_FINISH and run it in test mode.
Step 6. Fill the Import parameters from above table and for I_STATE put G.
Step 7. Execute the above functional module, you should get following similar message.
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.
Step 9. Now, go to table once again, you will see that Status of Process is now G (Green or successful).
I hope, this article will be useful for beginers who work on Data Load monitoring ondaily basis.