While logging work on Tempo timesheet, we are getting this error.
org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ChangeGroup][issue,41393][author,firstname.lastname@example.org][created,2015-03-12 13:26:17.316][id,313157] (SQL Exception while executing the following:INSERT INTO changegroup (ID, issueid, AUTHOR, CREATED) VALUES (?, ?, ?, ?) (Duplicate entry '313157' for key 'PRIMARY'))
I did some research on this and suddenly remembered that I've already handled a case reported by a customer with the same set of errors output on the logs.
Could you please try running the queries below, as described on this knowledge document?
SELECT * FROM sequence_value_item WHERE seq_name = 'ChangeGroup';
--> If you are using PostgreSQL SELECT max(id::integer) FROM changegroup; --> If you are using MySQL SELECT max(CAST(id AS SIGNED)) FROM changegroup;
If the output of the 2nd query is a bigger number than the one output on the 1st query, then you'll need to run an
UPDATE on your database. See the query below:
Always backup your data and shutdown JIRA before performing any changes on the database.
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM changegroup) WHERE seq_name = 'ChangeGroup';
After running the query above, restart JIRA and try logging work on Tempo again. Let me know how this goes.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG