Skip to Content
0
Jun 17, 2009 at 06:37 PM

Restarting BW process chain from the failed step

449 Views

Hi,

We are trying to use SAP CJS to schedule BW Process Chains. As per the advices from SDN, we are creating individual scripts like this to run the BW Prcoess Chains

declare

l_bw_chain constant varchar2(65) := '"RSI".RSI_RUN_BW_CHAIN';

begin

jcs.parameter(l_bw_chain,'P_INSTANCE','DBW');

jcs.parameter(l_bw_chain,'P_CLIENT','10');

jcs.parameter(l_bw_chain,'I_CHAIN','PC_REDWOOD_TEST');

jcs.parameter(l_bw_chain,'I_RESTARTABLE','Y');

jcs.parameter(l_bw_chain,'SHOWSPOOL','N');

jcs.parameter(l_bw_chain,'SHOWLOG','N');

jcs.submit(l_bw_chain);

end ;

For example 'PC_REDWOOD_TEST' BW process chain has 2 steps. The first step will run successfully. The second step will abend. After the SAP CJS job abends at the second step,

I am able to the see message in the console. But if I restart, it restrats the entire BW process chain. Please advise how to restart from the 2nd step where the problem ocuurs. And also please advise whether we are doing the correct way/method to schedule the BW process chains. Thanks.

Thanks.

Raj.