Signals Data Factory - How to cancel a job that is stuck in submitting or received status

When checking the list of jobs, if any job is stuck is submitting or received request and cannot be cancel using the cancel button, please follow the next steps to set the status to "Failed on Cluster", so other jobs can be processed:

1- Confirm the job ID, by viewing the details of the job and checking the URL in the browser.

2- Copy of the ID of the job at the end of the browser e.g. https://inventa.yourdomain.com/job/677ff75967f0f000109f7ad1

3- Connect to the mongo database

kubectl exec -it $(kubectl get pod -l io.kompose.service=sdf-cs-signals-mongo -o jsonpath="{.items[0].metadata.name}") -- mongo -u root -p MONGO_DB_PASSWORD

4-  Run this command to use Signals SDF database

use signals--sdf

5- Finally run this command to cancel job

db.getCollection('jobs').findOneAndUpdate({_id: new ObjectId("677ff75967f0f000109f7ad1")}, {$set: {status: "Failed on Cluster"}})

Note: Replace the ObjectID of the example to the ID from the URL

Job should be cancelled at this moment.