Process Chain got stuck showing yellow traffic light...

[former_member189979]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Tariq,

Does it happens with all of your process chain?

Regards,

[former_member189979]

Hello Ashish,

Thank you so much for your reply. It is not happening to all the "Process Chain" it happened to only couple of process chains.

Thanks!

Tariq Ashraf

[Former Member]

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,

[Former Member]

Hi Tariq

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

Thanks

Bhaskar

[former_member189979]

Hello Bhaskar,

Thank you so much for your reply. How I can use "RSPC_PROCESS_FINISH" to make "InfoPackage" green manually? I have not done or used it before.

Thanks!

Tariq Ashraf

[Former Member]

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

[Former Member]

Hi Tariq,

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

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

Thanks,

Avadhoot Nayakal

[Former Member]

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

[sander_vanwilligen]

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 . I expect that you only have to do that for the latest failed Process Chain (i.e. of the previous night).

Best regards,

Sander