Process Chain got stuck showing yellow traffic light...
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.