Automic Workload Automation

  • Private Community

  • 1.  How dow you restart at a specific point within an SAP BW process chain - Automic job?

    Posted Sep 24, 2015 11:08 AM
    How dow you restart at a specific point within an SAP BW process chain - Automic job? I was just asked a question about how to restart at a specific point within a process chain. In Automic(were release 9.00) you can only restart from the beginning. Right now when we have an abend the developers have to manually restart process chain within SAP and then monitor the chain and report back to computer operations the chain is done and start the next Automic job. 


  • 2.  How dow you restart at a specific point within an SAP BW process chain - Automic job?
    Best Answer

    Posted Sep 24, 2015 02:50 PM
    Hi Daryl,

    In BW, when I needed to restart a chain in a certain point, I've created a job with the command BW_RESTART_CHAIN and inputed the necessary parameters as variables collected from the report of the BW_ACTIVATE_CHAIN job. It involved a little bit of scripting but works like a charm.


  • 3.  How dow you restart at a specific point within an SAP BW process chain - Automic job?

    Posted Oct 01, 2015 05:48 AM
    Hi Simone,

    Could you please send it to my inbox?


  • 4.  How dow you restart at a specific point within an SAP BW process chain - Automic job?

    Posted Oct 05, 2015 01:49 PM
    Hi Iliopoulos_Ioannis_6110 ,

    As I'm using the same example from the documentation (BW_RESTART_CHAIN documentation), I think I can post it here:

    I used this example as a start for my own script. I'll use it also here. Check it out:

     - On the BW_ACTIVATE_CHAIN job post process:
     !Check if the job ended_not_ok and extract the chain id
    :if get_statistic_detail(, RETURN_CODE)<> 0
    :  SET &HND# = PREP_PROCESS_REPORT(, , PLOG, '*U2004111*', 'COL=DELIMITER', "DELIMITER=@'@)
    :  SET &LOGID# = ''
    :  PROCESS &HND#
    :    SET &LOGID# = GET_PROCESS_LINE(&HND#, 4)
    :  ENDPROCESS

    :  IF &LOGID# <> ''
    :    PUT_READ_BUFFER LOGID# = &LOGID#
    :    PUT_READ_BUFFER CHAIN# = 'insert chain name'
    :    set &go=activate_uc_object(RESTART_CHAIN_JOB, wait)
    :  ENDIF
    :endif

    - On the  BW_RESTART_CHAIN job:
    :read &LOGID#,,,
    :read &chain#,,,
    BW_RESTART_CHAIN ID='&CHAIN#',LOGID='&LOGID#',ERROR='ABEND',NOFOUND='NORMAL'


    Something like this....the amount of information depends on where your jobs is located (workflow, direct on schedule, event, etc). So, other rules can be set in order to ease the way that the restart job is displayed for monitoring purposes. Hope this helps!            




  • 5.  How dow you restart at a specific point within an SAP BW process chain - Automic job?

    Posted Dec 14, 2015 02:41 PM
    How do you get the 1st job (BW_ACTIVATE_CHAIN job )to get changed to "ended_ok"? That's after the restart job run to "ended_ok".


  • 6.  How dow you restart at a specific point within an SAP BW process chain - Automic job?

    Posted Dec 15, 2015 01:03 PM
    Hi Daryl,

    I particularly do not change it but you can use the MODIFY_STATE retcode=0 on the 1st job Post Process, I guess...After all the restart jobs have ended succesfully.
    You can check the restart job status since you have the runid of them (&go in my example) and you can set a if clause to change the state of the 1st job.