org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ChangeGroup][issue,41393][author,sidharath.roy@copart.com][created,2015-03-12 13:26:17.316][id,313157] (SQL Exception while executing the following:INSERT INTO changegroup

Srinivas Surabhi

While logging work on Tempo timesheet, we are getting this error.

 

org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ChangeGroup][issue,41393][author,sidharath.roy@copart.com][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'))

João Palharini

Hi Srinivas!

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 2^nd query is a bigger number than the one output on the 1^st 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. 

 

Cheers!

Joao