In the new JIRA version, how to change EPIC color?

[Rhita Chatila]

On my backlog, I used to see different EPICs in different colors (easy way to group user stories). I don't have anymore this possibility.

Thanks.

[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