cancel
Showing results for 
Search instead for 
Did you mean: 

CPS:Process chain restart skipping step in error

Former Member
0 Kudos

Hi all,

This is to ask for input on how to handle BW process chain restart, skipping failed steps. Business case would be for instance as follows :

A process chain has 4 steps.

When submitted step 1 ends OK, step 2 fails. The process chain ends up in status Console and steps 3 & 4 are in status Skipped.

Objective is then to restart the chain from step 3 (i.e. step 2 in error would be skipped)

A first attempt was done by restarting the chain in BW directly but then the processing is not reflected in CPS. I’d assume this is expected behavior but I’m not sure. Is that correct ?

Then I tried to submit the process chain with parameter “Make Process Restartable If Errors Occur” = All.

When the process chains ends in “Console” status, replying to the “Restart process chain?” message allows me to select the jobid of any step. When selecting the one of the step 3, then the process chain ends in status “error”, the step 3 is not restarted (still skipped) and following error is produced at step 3 level:

Operator Message An error has occurred in the SAP connector: Exception while calling RSPC_API_PROCESS_RESTART: 126: ONLY_UNCHECKED


RSPC_API_PROCESS_RESTART is actually a SAP function module and ONLY_UNCHECKED is an "Exception" related to it. But error msg is not telling a lot.

Any idea what the issue could be and how to sort it out ?

Thanks in advance

Regis

Accepted Solutions (1)

Accepted Solutions (1)

h_carpenter
Active Contributor
0 Kudos

Hi Regis,

What was the value of the parameter "Make processes restartable on error?" (CHAIN_RESTARTABLE) ?

Also, in CPS, for the definition of the process chain, what was the value of BW_RESTART_UNCHECKED, this should be set to Y if you think you know what you are doing.

Basically, in BW, a process chain is restartable or not, CPS by default honors this, if you set BW_RESTART_UNCHECKED to y, you "allow" CPS to "force-restart" the process chain without checking restartability. Note that if the process chain is set to not-restartable in SAP (which appears to the case) there "might" be a reason, please check.

Regards,

HP

Former Member
0 Kudos

Hi Giri, HP,

Thanks for looking into this.

I'm attaching here a few screen shots. Hopefully this will make the issue clearer.

Hi HP,

I submitted the process chain with CHAIN_RESTARTABLE = All

You are also mentioning the parameter BW_RESTART_UNCHECKED but I don't see it in the CPS Process Chain job definition. Is it something I should add manually ?

I have also asked my colleague to check the process chain setup in BW itself (I don't have access there).

Regis

h_carpenter
Active Contributor
0 Kudos

Hi Regis,

  1. Navigate to Environment >  SAP Systems
  2. Right-click the SAP system and choose Maintain Objects
  3. In the new dialog, locate your process chain under process chains, expand it
  4. Select the step you want to restart 'without checking SAP restartability'
  5. On the right-hand side check Restart Unchecked

You can also add the parameter I mentioned to the job definition, but this seems simpler and less error-prone. On the job definition, it affects all SAP systems you run the definition against, here, this affects only the SAP system in question.

Please see the following for more info:

http://<server>:<port>/scheduler/help/modules/sap/defsapjobdefs.html#SAP_BW_MaintainProcessChainDefinition

and

http://<server>:<port>/scheduler/help/modules/sap/interfaces/bw/bw_pc_handling.html

Regards,

HP

Former Member
0 Kudos

Hi HP,

I tested your proposed approach and it is working ! i.e. I can restart the chain from step 3 (after failing step 2). Many thx 🙂

I wanted to check the 2 help files you mentioned but although I could access the first one, second one (...bw_pc_handling.html) does not seem to exist on our server.

Would you have an external web reference for it ?

Best regards,

Regis

h_carpenter
Active Contributor
0 Kudos

Hi Regis,

No I have not found one, do not know if anybody else knows how to do that.

Note that I got that off my M33.95 system, maybe it is version-related ... as in, your version does not have that help file.

Regards,

HP

Former Member
0 Kudos

Hi HP,

My version is 33.85 so it might be the reason why this help file is not available on my system. In the meantime, I saw that you posted its content in a blog.

Many thanks for your help on this topic, it answered my question and allowed me to learn a lot on process chains handling.

Best regards,

Regis 

Answers (1)

Answers (1)

Former Member
0 Kudos