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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You should also reverse out the SQL changes you made to restore functionality before you do anything else.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
And Srikanth, to stress on the database part, please do not directly manipulate JIRA database. It can result in a broken JIRA installation and restore will be your only option.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.