Automic Workload Automation

SAP SET_CONSTRAINT does not restart a failed BW process

  • 1.  SAP SET_CONSTRAINT does not restart a failed BW process

    Posted Dec 11, 2018 04:52 AM

    I want to use SAP BW SET_CONSTRAINT to restart a failed BW chain. I define my job process as below:

     

    BW_SET_CONSTRAINT TYPE="ABAP",NAME="*",FIELD="STATUS",OPERATOR="EQ",VALUE="R",ACTION="RESTART",COUNT="3",DELAY="1"

    BW_ACTIVATE_CHAIN ID="ZTEST_PC_RESTART_01",NOFOUND="ABEND",ERROR="SUSPEND",LONGTEXT="YES",REPLICATE="YES",STATUSRETRY="1"

     

    The chain fails with the agent below:

    2018-12-11 08:06:15 - U02000005 Job 'JOBS.SAP_ABAP.LAB13.08' with RunID '3209702' started. 2018-12-11 08:06:15 - U02004018 The job was successfully interpreted. 2018-12-11 08:06:15             BW_SET_CONSTRAINT TYPE="ABAP",NAME="*",FIELD="STATUS",OPERATOR="EQ",VALUE="R",ACTION="RESTART",COUNT="3",DELAY="1" 2018-12-11 08:06:15             BW_ACTIVATE_CHAIN ID="ZTEST_PC_RESTART_01",NOFOUND="ABEND",ERROR="SUSPEND",LONGTEXT="YES",REPLICATE="YES",STATUSRETRY="1" 2018-12-11 08:06:17 - U02004134 Process instance AAXOXR0MDR8ANGQAAN3NYE2HF jobcount 07061500 is now active 2018-12-11 08:06:17 - U02004134 Process instance  jobcount 07061600 is now active 2018-12-11 08:06:17 - U02004109 SAP chain 'ZTEST_PC_RESTART_01' with LogID 'BUJGY7JG6SC3STLMGZSMS6U4Z' is now active 2018-12-11 08:06:19 - U02004135 Process instance AAXOXR0MDR8ANGQAAN3NYE2HF jobcount 07061500 ended normally 2018-12-11 08:06:27 - U02004135 Process instance DTPR__20181211070618000005000 jobcount 07061600 ended normally 2018-12-11 08:06:27 - U02004134 Process instance  jobcount 07061600 is now active 2018-12-11 08:06:37 - U02004136 Process instance ADA_AAGTUKSUIAPNRP5CNCY7NV4ECQ jobcount 07061600 ended abnormally 2018-12-11 08:06:55 - U02004159 SAP chain 'ZTEST_PC_RESTART_01' with LogID 'BUJGY7JG6SC3STLMGZSMS6U4Z' ended with SAP status 'R' 2018-12-11 08:06:55 - U02004111 SAP chain 'ZTEST_PC_RESTART_01' with LogID 'BUJGY7JG6SC3STLMGZSMS6U4Z' ended abnormally

     

    However, I do not see any restart attempt. Please advise.

    Thanks