Transitioning an Issue Results in a Workflow Error

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

  1. You attempt to transition an issue to a new status and then...

The following appears:

Could not move to history step for #175444: root cause: while inserting: [GenericEntity:OSHistoryStepPrev][id,373216][previousId,373215] (SQL Exception while executing the following:INSERT INTO public.OS_HISTORYSTEP_PREV (ID, PREVIOUS_ID) VALUES (?, ?) (ERROR: duplicate key value violates unique constraint "pk_os_historystep_prev"))    

Possible Causes

  1. There is a value in both the os_historystep and os_historystep_prev tables which are the same.

Possible Resolutions

Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.

  1. In your os_historystep_prev table, delete the entire row with the max(id), restart JIRA, and attempt the transition again.
  2. If you have scripts running in any conditions, validators or post functions, make sure they haven't any errors. Delete them to see if this fixes the issue.

    If your case is #1, use this command to delete the row
    delete from os_historystep_prev where id = <id pertaining to the error>;

    (info) Please remember to restart JIRA if making changes to the database.

 

 

 

 

 

   

 

 

Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.