nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

I am getting an sql Exception Unique constraint violation SYS_IDX_57 in Jira 4.4.5

srikanth Asoori

Inside my program I have written the following statement

stmt.executeUpdate("INSERT INTO CUSTOMFIELDVALUE VALUES(10001,12800,12000,NULL,'0.46 Days',NULL,NULL,NULL,NULL)");

I think the error has came because I manually created the Id(10001).

My question is how in jira the id for CUSTOMFIELDVALUE TABLE IS CREATED

And also what is SYS_IDX_57?

Accepted answers

Naren3

Hi Srikanth,

What is the error generated in the log? Please go through this link, you'll get a clear picture about JIRA Database Schema. Also check out the Example SQL Queries in JIRA.

All comments

Nic Brough -Adaptavist-

Could you please stop tagging things with "on demand" when you are NOT using OnDemand?

Anyway, yes, you should never update a Jira database with SQL unless you know exactly what you are doing. You probably have neglected to update the counter table sequence_value_item

Also, if you are going to use SQL on a Jira database, you MUST NOT have Jira running. I can't emphasise this enough - Jira MUST be offline, shutdown, inactive. When you restart it after executing the SQL, you will then need to re-index it

Stop your Jira now if it was running, update sequence_value_item, restart and reindex.

Naren3

Hi Srikanth,

What is the error generated in the log? Please go through this link, you'll get a clear picture about JIRA Database Schema. Also check out the Example SQL Queries in JIRA.

srikanth Asoori

Thanks Naren for your help.

Nic Brough -Adaptavist-

You should also reverse out the SQL changes you made to restore functionality before you do anything else.

srikanth Asoori

Ok nic thanks a lot

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-cloud