Skip to Content

Process Chain got stuck showing yellow traffic light...

Dear All,

I have a process chain which has been executing perfectly daily early in the morning. But for last couple of days after successful executing "Start" and InfoPackage" processes it is not executing or triggering drop index process or next process. I have checked that the InfoPackage has finished the successfully and fetched the delta records. But next process which is drop index process is not being triggered or executed by Process Chain. Please find below a screen shoot of Log View of Process Chain:

1. Yesterday, I manually executed the remaining processes and thought next day it will fix the problem by its own when it will be re-executed from the start process? But it did not finish successfully and got stuck again on InfoPackage which finished successfully in the Log View and in the background but did not trigger or executed next process in the Chain. why?

2. How to fix the process at hand?

3. Do I need to design it again or have I missed something while fixing the problem?

I will appreciate your reply.

Many thanks!

Tariq Ashraf

ProcessChain.gif (87.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Dec 29, 2014 at 09:40 AM

    Hi Tariq

    Please use RSPC_PROCESS_FINISH to make the infopackge green manually and finish the remaining steps.

    Thanks

    Bhaskar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Tariq Ashraf

      Hello Tariq,

      Use FM[se37] RSPC_PROCESS_FINISH to make any step in a process chain or meta chain green.

      You ll have to fill the following fields

      I_LOGID: Log id of chain

      I_CHAIN: Process Chain Name

      I_TYPE: Type of step you want to manually put the status for eg LOADING for infopackage

      I_VARIANT: Variant name of the step

      I_INSTANCE: Instance name of the chain

      you will find the information for TYPE, INSTANCE & VARIANT in table RSPCPROCESSLOG. Just give the log id and find the details.


      I_STATE: Give the status you want to put for this step.

      R Ended with errors G Successfully completed F Completed A Active X Canceled P Planned S Skipped at restart Q Released Y Ready Undefined J Ended with Error (for example, subsequent job missing)

      Once you put the status G. Your chain will start executing from the next step onwards,

      Regards,

      Amit

  • Dec 28, 2014 at 11:58 AM

    Hi Tariq,

    Did you analyze the Process Chain log,(background) job log and (SLG1) application log to see if any particular message is issued re. the index deletion process? It might be that you can find more information and an explanation here. If so, please share as many details as possible.

    Another thing to check is manual index deletion (and subsequent creation) using the Manage function of the InfoCube. Maybe you can observe here also a different behavior.

    Last but not least, you might have to correct the status of the previous failed Process Chain(s). Please have a look at blog Restarting Processchains. I expect that you only have to do that for the latest failed Process Chain (i.e. of the previous night).

    Best regards,

    Sander

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 28, 2014 at 07:43 PM

    Hello Tariq,

    This kind of irregularities occur after system upgrade or migration or any other downtime. Was some activity planned in your system?

    The design is correct. You do not have to redesign

    You have manually executed the remaining steps... Did you check the status of the steps in table RSPCPROCESSLOG. If it shows R or A. Use FM to make it green again. This will not retrigget the delta. It will only make the step green in the background so that the next step is triggered.

    Try the above and let us know the results. Otherwise search for NOTES

    Regards

    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 29, 2014 at 08:37 AM

    Hi Tariq,

    Please refer below thread link, which may help you get solution:

    http://scn.sap.com/thread/3428395

    Thanks,

    Avadhoot Nayakal

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 29, 2014 at 10:30 AM

    Hi Tariq,

    Does it happens with all of your process chain?

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Tariq Ashraf

      Hi,

      Please compare the info package settings of the working process chain and non working process chain such as traffic light, time out time setting etc.

      In case if it is not similar make it similar as of working ones.

      Regards,

  • avatar image
    Former Member
    Dec 30, 2014 at 04:17 AM

    Hi Tariq,

    I have a similar issue before where one sub-chain keep in status F (yellow color) and not go to the next sub-chain although all process in the sub-chain already green.

    I fixed it by remove the chain from schedule and re-schedule it, give it a try if you still have the issue.

    Regards

    Bill

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 30, 2014 at 04:56 AM

    Hi,

    Just right click on Infopackage and go to Process monitor and click refresh all.

    This will trigger the further process.

    Hope this helps.

    Regards,

    Rajesh

    Add comment
    10|10000 characters needed characters exceeded