FME Server jobs keeps running (cannot cancel the job)

Hello @stefanh​ ,

The duplicate key value violates unique constraint error usually occurs when two jobs are submitted under the same job ID. When the first job completes, this is recorded in the fme_job_history table in the System Database, then when the second job completes it also tries to add a record to this table, but cannot because the ID already exists, hence a duplicate key value error. 

To resolve this error, you could first try and delete the record from the fme_job_history table. This should allow the second record to be entered and things should continue running as normal. 

If the issue persists then there may be something out of sync with the assignment of job IDs, in which case please follow the instructions on the best answer to this post: https://community.safe.com/s/question/0D54Q000080h97mSAA/error-throwing-a-duplicate-user-key-error-when-trying-to-create-a-new-account-in-fme-server but using the fme_job_history_pkey value instead of the user account.