Workflow transition or Switch workflowscheme

[krishnan]

Whenever I transition a issue from one status to another status, I get this error:

Could not move to history step for #21255: root cause: while inserting: [GenericEntity:OSHistoryStep][owner,null][caller,jira-admin-contractor][dueDate,null][stepId,11][actionId,11][finishDate,2015-01-06 17:42:13.371][id,28822][startDate,2013-07-16 19:51:20.0][entryId,21255][status,Not Done] (SQL Exception while executing the following:INSERT INTO OS_HISTORYSTEP (ID, ENTRY_ID, STEP_ID, ACTION_ID, OWNER, START_DATE, DUE_DATE, FINISH_DATE, STATUS, CALLER) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry '28822' for key 'PRIMARY'))

The same exception also occurs when I switch one workflowscheme to another workflowscheme for a project.

Unable to trace out this error at database level.  What went wrong  in database?

[Satyendra Narwane]

Hi 

The cause of above issue is due to JIRA tracks workflow transition history via the OS_CURRENTSTEP and OS_HISTORYSTEP tables.  Due to the sequence_value_item being reset, old ID values were re-assigned, resulting in duplicate errors.

Please refer below link for solution

Workflow+due+to+Duplicate+entry+error

or 

https://confluence.atlassian.com/display/JIRAKB/Unable+to+Transition+Workflow+due+to+Duplicate+entry+error

Regards

Satyendra

[krishnan]

Thanks Satyendra. I have seen these links. My query is when there are other objects listed in Sequence_value_item table there is no entry for OSHistoryStep in the sequence_value_item table. How Jira picks the next number from the sequence_value_item table when inserting records into OS_historystep table?

[Satyendra Narwane]

Hi Krishnan, Have you tried with the given solution on the link? Please follow the step it will solve you problem.

[krishnan]

Thanks Satyendra. I have been working at the DB end. The xml in the jiraworkflows descriptor column has mismatched status id. when I changed those status id to the correct ones, the issue got resolved. To my surprise, there is no entry for OS_Historystep, os_historystep_prev in the sequence_value_item. Moreover this link https://docs.oracle.com/cd/E27119_01/doc.11113/e23128/databaseadministratorsguideprintable43.html helped me in understanding the OpenSymphony table relationship in jira workflows.

[Joe Pitt]

I suggest you open an issue with Atlassian support.