We have a DTP(cube to cube load) which runs daily in a process chain. Last week it got stuck twice without extracting any data and the status as yellow.
We made the status RED and deleted the request and repeated the step in the process Chain and it got completed successfully in 20-25 mins.
It got Stuck for over 7 hrs and as it didn't timeout or abort, we have to forcefully kill the job by going to SM51.
Can anybody please explain in detail why this might have happened.