Steps to check when Executions are stuck in Scheduled status for a long time , even though the scheduled time has passed.

Agenda.

This KBA helps with the effective steps to check when Executions are stuck in Scheduled status for a long time , even though the scheduled time has passed.

Usage

Steps to check when Executions are stuck in Scheduled status for a long time , even though the scheduled time has passed.

• Check if all the pods are up and running

• Check if there's any restarts in the pods during the schedule time and before 3-4 hours.

• Check If there was any activity like db upgrade, was XCRO scaled down and scaled up ?
  the application should be scaled down during any activity on the mongodb servers. 

• Check if any poller is stuck in Inprogress state.

-> Steps to update the poller from Inprogress state to Completed

1.Go to DB.

2.Find if any poller is in InProgress status, by running the below query.

      db.execution.poller.find({“status”:”INPRG”})

3. If the query shows any result. 

4.Run the below Query to mark the poller from inprogress status to Completed.

    db.execution.poller.updateMany({“status”:”INPRG”}.{$set:{status:”COMPLETED”}})

4. Now check if the executions got picked up in the execution report.