How to skip error process in Process chain – SAP BW 7.0 and 3.5
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
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
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
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.
3. Reference
Reference 2
Good document Prakash.
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:
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
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:
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
when i am executing process chain i got an error in somewhere. Generally for that we will go there use skip process, is there any process wherever error occurs in chain it needs to skip automatically and continue with next step.
or
can we write any thing in decision step for entire chain to skip that particular error and continue?