Duplicated entry - unique constraint violated in Jira Data Center
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Problem
The logs may include stack traces similar to the ones below:
1
2
3
Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:GlobalPermissionEntry][group_id,BED-Jira-Access][permission,USE][id,10015] (SQL Exception while executing the following:INSERT INTO globalpermissionentry (ID, PERMISSION, GROUP_ID) VALUES (?, ?, ?) (Duplicate entry '10015' for key 'PRIMARY'))
at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:214)
at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:179)1
2
3
4
Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:GadgetUserPreference][id,60081][userprefvalue,assignees][userprefkey,ystattype][portletconfiguration,13951] (SQL Exception while executing the following:INSERT INTO gadgetuserpreference (ID, PORTLETCONFIGURATION, USERPREFKEY, USERPREFVALUE) VALUES (?, ?, ?, ?) (ORA-00001: unique constraint (JIRAPROD.PK_GADGETUSERPREFERENCE) violated
))
at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:136)
at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:101)1
Caused by: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:PortletConfiguration][position,0][id,14485][portalpage,12305][color,color1][gadgetXml,rest/gadgets/1.0/g/com.atlassian.jira.gadgets:admin-gadget/gadgets/admin-gadget.xml][columnNumber,0] (SQL Exception while executing the following:INSERT INTO portletconfiguration (ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, positionseq, GADGET_XML, COLOR) VALUES (?, ?, ?, ?, ?, ?, ?) (ORA-00001: unique constraint (JIRAPROD.PK_PORTLETCONFIGURATION) violated
1
2
2013-08-05 10:46:05,050 http-bio-8080-exec-2838 ERROR [500ErrorPage.jsp] Exception caught in 500 page org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ApplicationUser][id,10002][userKey,oarteaga][lowerUserName,oarteaga] (SQL Exception while executing the following:INSERT INTO app_user (ID, user_key, lower_user_name) VALUES (?, ?, ?) (Duplicate entry '10002' for key 1))
com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ApplicationUser][id,10002][userKey,oarteaga][lowerUserName,oarteaga] (SQL Exception while executing the following:INSERT INTO app_user (ID, user_key, lower_user_name) VALUES (?, ?, ?) (Duplicate entry '10002' for key 1))1
Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Membership][id,82263][membershipType,GROUP_USER][lowerParentName,nicr][parentId,80014][childId,42310][childName,lhooipen][lowerChildName,lhooipen][directoryId,10100][parentName,NICR] (SQL Exception while executing the following:INSERT INTO cwd_membership (ID, parent_id, child_id, membership_type, group_type, parent_name, lower_parent_name, child_name, lower_child_name, directory_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-00001: unique constraint (JIRAUSER.PK_CWD_MEMBERSHIP) violatedSolution
Diagnosis 1: for non-AO table
It is possible to see in the error message the entity that is throwing the problem, together with its corresponding table e.g.:
1
2
3
4
org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Membership]
...
SQL Exception while executing the following:INSERT INTO cwd_membershipIn this example, we can see that the problematic entity is 'Membership', and its corresponding table is 'cwd_membership'. With this, we can run the following queries in the database:
1
SELECT * FROM sequence_value_item WHERE seq_name = 'Membership';1
SELECT max(id) FROM cwd_membership;If the value returned in the second query is bigger than the value returned in the first one, please refer to the steps under Resolution to fix this problem. Otherwise, refer to Alternative Resolution for the solution
The names of the tables used are mostly equal to the entity's name. In some occasions though, the name is not exactly the same, so you may need to look for similar names as in the above example. Please take note of the case-sensitivity of the table name in your specific database. Sometimes you may need to use SEQUENCE_VALUE_ITEM instead of sequence_value_item.
May have to use numerical sorting for the SQL query, for example
MySQL query
SELECT max(CAST(id AS SIGNED)) FROM cwd_membership;
PostgreSQL query SELECT max(id::integer) FROM cwd_membership;
Diagnosis 2 - for AO tables
Refer to another kb article - https://confluence.atlassian.com/jirakb/getting-ora-00001-unique-constraint-error-while-performing-some-actions-in-jira-data-center-1318390669.html
Causes
It is not known yet what causes this problem, although the most likely reason is an update attempt was not successfully finished and therefore caused this mismatch in the id counts.
Also, this can occur after the migration from Jira Cloud to Jira Server/Datacenter.
Resolution
Always back up your data before making any database modifications. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Shutdown your JIRA application;
Run the following query in the database:
1UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM <TableName>) WHERE seq_name = '<EntityName>';Don't forget to commit your changes If you're using Oracle database.
Be sure to replace '<EntityName>' and <TableName> with the ones shown in the error message.
Restart your JIRA application.
For example, the update statement below would be used to fix the problem in the example above:
1
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM cwd_membership) WHERE seq_name = 'Membership'; Alternative Resolution
If the sequence value is higher than the maximum ID of the table in question (and the failing ID number already exists), try restarting Jira.
In some cases, JIRA will generate the next ID number internally, rather than referring to the database. If this in-memory value is not in line with what's in the database, database insertions will fail.
Restarting JIRA should allow for JIRA to re-read what's in the database and have the correct IDs to generate.
Mapping of sequence name and sequence_value_item
The following is a mapping of sequence_value_item entries and a SQL script to update maximum ID. The SQL script is useful in fixing possible multiple incorrect sequence ID values after a migration. The script has been tested in versions 8.20.11, 9.4.2, and 9.7.0.
⚠️ We recommend backup the database before applying the script, and always test in non-production first. Some minor adjustments may needed due to each Jira version may use a different set of values.
Mapping Table
seq_name | table |
|---|---|
Action | jiraaction |
ApplicationUser | app_user |
Avatar | avatar |
ChangeGroup | changegroup |
ChangeItem | changeitem |
Component | component |
ClusterLockStatus | clusterlockstatus |
ClusterMessage | clustermessage |
ClusteredJob | clusteredjob |
ColumnLayout | columnlayout |
ColumnLayoutItem | columnlayoutitem |
ConfigurationContext | configurationcontext |
CustomField | customfield |
CustomFieldOption | customfieldoption |
CustomFieldValue | customfieldvalue |
DraftWorkflow | jiradraftworkflows |
DraftWorkflowScheme | draftworkflowscheme |
DraftWorkflowSchemeEntity | draftworkflowschemeentity |
EntityProperty | entity_property |
EntityPropertyIndexDocument | entity_property_index_document |
EventType | jiraeventtype |
FavouriteAssociations | favouriteassociations |
Feature | feature |
FieldConfigScheme | fieldconfigscheme |
FieldConfigSchemeIssueType | fieldconfigschemeissuetype |
FieldConfiguration | fieldconfiguration |
FieldLayout | fieldlayout |
FieldLayoutItem | fieldlayoutitem |
FieldLayoutScheme | fieldlayoutscheme |
FieldLayoutSchemeAssociation | fieldlayoutschemeassociation |
FieldLayoutSchemeEntity | fieldlayoutschemeentity |
FieldScreen | fieldscreen |
FieldScreenLayoutItem | fieldscreenlayoutitem |
FieldScreenScheme | fieldscreenscheme |
FieldScreenSchemeItem | fieldscreenschemeitem |
FieldScreenTab | fieldscreentab |
FileAttachment | fileattachment |
FilterSubscription | filtersubscription |
GadgetUserPreference | gadgetuserpreference |
GenericConfiguration | genericconfiguration |
GlobalPermissionEntry | globalpermissionentry |
Group | cwd_group |
Issue | jiraissue |
IssueFieldOption | issue_field_option |
IssueFieldOptionScope | issue_field_option_scope |
IssueLink | issuelink |
IssueLinkType | issuelinktype |
IssueSecurityScheme | issuesecurityscheme |
IssueType | issuetype |
IssueTypeScreenScheme | issuetypescreenscheme |
IssueTypeScreenSchemeEntity | issuetypescreenschemeentity |
IssueVersion | issue_version |
Label | label |
LicenseRoleDefault | licenserolesdefault |
LicenseRoleGroup | licenserolesgroup |
ListenerConfig | listenerconfig |
ManagedConfigurationItem | managedconfigurationitem |
Membership | cwd_membership |
MovedIssueKey | moved_issue_key |
NodeIndexCounter | nodeindexcounter |
Notification | notification |
NotificationScheme | notificationscheme |
OAuthConsumer | oauthconsumer |
OSCurrentStep | os_currentstep |
OSPropertyEntry | propertyentry |
OSWorkflowEntry | os_wfentry |
OptionConfiguration | optionconfiguration |
PermissionScheme | permissionscheme |
PermissionSchemeAttribute | permissionschemeattribute |
PluginVersion | pluginversion |
PortalPage | portalpage |
PortletConfiguration | portletconfiguration |
Priority | priority |
ProductLicense | productlicense |
Project | project |
ProjectCategory | projectcategory |
ProjectKey | project_key |
ProjectRole | projectrole |
ProjectRoleActor | projectroleactor |
ReindexComponent | reindex_component |
ReindexRequest | reindex_request |
RememberMeToken | remembermetoken |
ReplicatedIndexOperation | replicatedindexoperation |
Resolution | resolution |
RunDetails | rundetails |
SchemePermissions | schemepermissions |
SearchRequest | searchrequest |
ServiceConfig | serviceconfig |
SharePermissions | sharepermissions |
Status | issuestatus |
UpgradeHistory | upgradehistory |
UpgradeTaskHistory | upgradetaskhistory |
UpgradeTaskHistoryAuditLog | upgradetaskhistoryauditlog |
UpgradeVersionHistory | upgradeversionhistory |
User | cwd_user |
UserAttribute | cwd_user_attributes |
UserHistoryItem | userhistoryitem |
Version | projectversion |
Workflow | jiraworkflows |
WorkflowScheme | workflowscheme |
WorkflowSchemeEntity | workflowschemeentity |
Worklog | worklog |
WorklogVersion | worklog_version |
update-sequence.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
-- Action | jiraaction
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM jiraaction) WHERE seq_name = 'Action' and 0 < (select count(*) from jiraaction);
-- ApplicationUser | app_user
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM app_user) WHERE seq_name = 'ApplicationUser' and 0 < (select count(*) from app_user);
-- Avatar | avatar
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM avatar) WHERE seq_name = 'Avatar' and 0 < (select count(*) from avatar);
-- ChangeGroup | changegroup
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM changegroup) WHERE seq_name = 'ChangeGroup' and 0 < (select count(*) from changegroup);
-- ChangeItem | changeitem
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM changeitem) WHERE seq_name = 'ChangeItem' and 0 < (select count(*) from changeitem);
-- Component | component
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM component) WHERE seq_name = 'Component' and 0 < (select count(*) from component);
-- ClusterLockStatus | clusterlockstatus
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM clusterlockstatus) WHERE seq_name = 'ClusterLockStatus' and 0 < (select count(*) from clusterlockstatus);
-- ClusterMessage | clustermessage
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM clustermessage) WHERE seq_name = 'ClusterMessage' and 0 < (select count(*) from clustermessage);
-- ClusteredJob | clusteredjob
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM clusteredjob) WHERE seq_name = 'ClusteredJob' and 0 < (select count(*) from clusteredjob);
-- ColumnLayout | columnlayout
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM columnlayout) WHERE seq_name = 'ColumnLayout' and 0 < (select count(*) from columnlayout);
-- ColumnLayoutItem | columnlayoutitem
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM columnlayoutitem) WHERE seq_name = 'ColumnLayoutItem' and 0 < (select count(*) from columnlayoutitem);
-- ConfigurationContext | configurationcontext
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM configurationcontext) WHERE seq_name = 'ConfigurationContext' and 0 < (select count(*) from configurationcontext);
-- CustomField | customfield
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM customfield) WHERE seq_name = 'CustomField' and 0 < (select count(*) from customfield);
-- CustomFieldOption | customfieldoption
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM customfieldoption) WHERE seq_name = 'CustomFieldOption' and 0 < (select count(*) from customfieldoption);
-- CustomFieldValue | customfieldvalue
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM customfieldvalue) WHERE seq_name = 'CustomFieldValue' and 0 < (select count(*) from customfieldvalue);
-- DraftWorkflow | jiradraftworkflows
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM jiradraftworkflows) WHERE seq_name = 'DraftWorkflow' and 0 < (select count(*) from jiradraftworkflows);
-- DraftWorkflowScheme | draftworkflowscheme
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM draftworkflowscheme) WHERE seq_name = 'DraftWorkflowScheme' and 0 < (select count(*) from draftworkflowscheme);
-- DraftWorkflowSchemeEntity | draftworkflowschemeentity
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM draftworkflowschemeentity) WHERE seq_name = 'DraftWorkflowSchemeEntity' and 0 < (select count(*) from draftworkflowschemeentity);
-- EntityProperty | entity_property
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM entity_property) WHERE seq_name = 'EntityProperty' and 0 < (select count(*) from entity_property);
-- EntityPropertyIndexDocument | entity_property_index_document
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM entity_property_index_document) WHERE seq_name = 'EntityPropertyIndexDocument' and 0 < (select count(*) from entity_property_index_document);
-- EventType | jiraeventtype
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM jiraeventtype) WHERE seq_name = 'EventType' and 0 < (select count(*) from jiraeventtype);
-- FavouriteAssociations | favouriteassociations
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM favouriteassociations) WHERE seq_name = 'FavouriteAssociations' and 0 < (select count(*) from favouriteassociations);
-- Feature | feature
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM feature) WHERE seq_name = 'Feature' and 0 < (select count(*) from feature);
-- FieldConfigScheme | fieldconfigscheme
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM fieldconfigscheme) WHERE seq_name = 'FieldConfigScheme' and 0 < (select count(*) from fieldconfigscheme);
-- FieldConfigSchemeIssueType | fieldconfigschemeissuetype
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM fieldconfigschemeissuetype) WHERE seq_name = 'FieldConfigSchemeIssueType' and 0 < (select count(*) from fieldconfigschemeissuetype);
-- FieldConfiguration | fieldconfiguration
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM fieldconfiguration) WHERE seq_name = 'FieldConfiguration' and 0 < (select count(*) from fieldconfiguration);
-- FieldLayout | fieldlayout
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM fieldlayout) WHERE seq_name = 'FieldLayout' and 0 < (select count(*) from fieldlayout);
-- FieldLayoutItem | fieldlayoutitem
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM fieldlayoutitem) WHERE seq_name = 'FieldLayoutItem' and 0 < (select count(*) from fieldlayoutitem);
-- FieldLayoutScheme | fieldlayoutscheme
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM fieldlayoutscheme) WHERE seq_name = 'FieldLayoutScheme' and 0 < (select count(*) from fieldlayoutscheme);
-- FieldLayoutSchemeAssociation| fieldlayoutschemeassociation
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM fieldlayoutschemeassociation) WHERE seq_name = 'FieldLayoutSchemeAssociation' and 0 < (select count(*) from fieldlayoutschemeassociation);
-- FieldLayoutSchemeEntity | fieldlayoutschemeentity
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM fieldlayoutschemeentity) WHERE seq_name = 'FieldLayoutSchemeEntity' and 0 < (select count(*) from fieldlayoutschemeentity);
-- FieldScreen | fieldscreen
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM fieldscreen) WHERE seq_name = 'FieldScreen' and 0 < (select count(*) from fieldscreen);
-- FieldScreenLayoutItem | fieldscreenlayoutitem
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM fieldscreenlayoutitem) WHERE seq_name = 'FieldScreenLayoutItem' and 0 < (select count(*) from fieldscreenlayoutitem);
-- FieldScreenScheme | fieldscreenscheme
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM fieldscreenscheme) WHERE seq_name = 'FieldScreenScheme' and 0 < (select count(*) from fieldscreenscheme);
-- FieldScreenSchemeItem | fieldscreenschemeitem
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM fieldscreenschemeitem) WHERE seq_name = 'FieldScreenSchemeItem' and 0 < (select count(*) from fieldscreenschemeitem);
-- FieldScreenTab | fieldscreentab
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM fieldscreentab) WHERE seq_name = 'FieldScreenTab' and 0 < (select count(*) from fieldscreentab);
-- FileAttachment | fileattachment
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM fileattachment) WHERE seq_name = 'FileAttachment' and 0 < (select count(*) from fileattachment);
-- FilterSubscription | filtersubscription
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM filtersubscription) WHERE seq_name = 'FilterSubscription' and 0 < (select count(*) from filtersubscription);
-- GadgetUserPreference | gadgetuserpreference
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM gadgetuserpreference) WHERE seq_name = 'GadgetUserPreference' and 0 < (select count(*) from gadgetuserpreference);
-- GenericConfiguration | genericconfiguration
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM genericconfiguration) WHERE seq_name = 'GenericConfiguration' and 0 < (select count(*) from genericconfiguration);
-- GlobalPermissionEntry | globalpermissionentry
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM globalpermissionentry) WHERE seq_name = 'GlobalPermissionEntry' and 0 < (select count(*) from globalpermissionentry);
-- Group | cwd_group
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM cwd_group) WHERE seq_name = 'Group' and 0 < (select count(*) from cwd_group);
-- Issue | jiraissue
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM jiraissue) WHERE seq_name = 'Issue' and 0 < (select count(*) from jiraissue);
-- IssueFieldOption | issue_field_option
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM issue_field_option) WHERE seq_name = 'IssueFieldOption' and 0 < (select count(*) from issue_field_option);
-- IssueFieldOptionScope | issue_field_option_scope
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM issue_field_option_scope) WHERE seq_name = 'IssueFieldOptionScope' and 0 < (select count(*) from issue_field_option_scope);
-- IssueLink | issuelink
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM issuelink) WHERE seq_name = 'IssueLink' and 0 < (select count(*) from issuelink);
-- IssueLinkType | issuelinktype
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM issuelinktype) WHERE seq_name = 'IssueLinkType' and 0 < (select count(*) from issuelinktype);
-- IssueSecurityScheme | issuesecurityscheme
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM issuesecurityscheme) WHERE seq_name = 'IssueSecurityScheme' and 0 < (select count(*) from issuesecurityscheme);
-- IssueType | issuetype (id is TEXT not numeric) - write your own UPDATE - write your own UPDATE
--UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM issuetype) WHERE seq_name = 'IssueType' and 0 < (select count(*) from issuetype);
-- IssueTypeScreenScheme | issuetypescreenscheme
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM issuetypescreenscheme) WHERE seq_name = 'IssueTypeScreenScheme' and 0 < (select count(*) from issuetypescreenscheme);
-- IssueTypeScreenSchemeEntity | issuetypescreenschemeentity
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM issuetypescreenschemeentity) WHERE seq_name = 'IssueTypeScreenSchemeEntity' and 0 < (select count(*) from issuetypescreenschemeentity);
-- IssueVersion | issue_version
UPDATE sequence_value_item SET seq_id = (SELECT max(issue_id)+100 FROM issue_version) WHERE seq_name = 'IssueVersion' and 0 < (select count(*) from issue_version);
-- Label | label
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM label) WHERE seq_name = 'Label' and 0 < (select count(*) from label);
-- LicenseRoleDefault | licenserolesdefault
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM licenserolesdefault) WHERE seq_name = 'LicenseRoleDefault' and 0 < (select count(*) from licenserolesdefault);
-- LicenseRoleGroup | licenserolesgroup
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM licenserolesgroup) WHERE seq_name = 'LicenseRoleGroup' and 0 < (select count(*) from licenserolesgroup);
-- ListenerConfig | listenerconfig
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM listenerconfig) WHERE seq_name = 'ListenerConfig' and 0 < (select count(*) from listenerconfig);
-- ManagedConfigurationItem | managedconfigurationitem
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM managedconfigurationitem) WHERE seq_name = 'ManagedConfigurationItem' and 0 < (select count(*) from managedconfigurationitem);
-- Membership | cwd_membership
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM cwd_membership) WHERE seq_name = 'Membership' and 0 < (select count(*) from cwd_membership);
-- MovedIssueKey | moved_issue_key
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM moved_issue_key) WHERE seq_name = 'MovedIssueKey' and 0 < (select count(*) from moved_issue_key);
-- NodeIndexCounter | nodeindexcounter
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM nodeindexcounter) WHERE seq_name = 'NodeIndexCounter' and 0 < (select count(*) from nodeindexcounter);
-- Notification | notification
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM notification) WHERE seq_name = 'Notification' and 0 < (select count(*) from notification);
-- NotificationScheme | notificationscheme
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM notificationscheme) WHERE seq_name = 'NotificationScheme' and 0 < (select count(*) from notificationscheme);
-- OAuthConsumer | oauthconsumer
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM oauthconsumer) WHERE seq_name = 'OAuthConsumer' and 0 < (select count(*) from oauthconsumer);
-- OSCurrentStep | os_currentstep
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM os_currentstep) WHERE seq_name = 'OSCurrentStep' and 0 < (select count(*) from os_currentstep);
-- OSPropertyEntry | propertyentry
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM propertyentry) WHERE seq_name = 'OSPropertyEntry' and 0 < (select count(*) from propertyentry);
-- OSWorkflowEntry | os_wfentry
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM os_wfentry) WHERE seq_name = 'OSWorkflowEntry' and 0 < (select count(*) from os_wfentry);
-- OptionConfiguration | optionconfiguration
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM optionconfiguration) WHERE seq_name = 'OptionConfiguration' and 0 < (select count(*) from optionconfiguration);
-- PermissionScheme | permissionscheme
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM permissionscheme) WHERE seq_name = 'PermissionScheme' and 0 < (select count(*) from permissionscheme);
-- PermissionSchemeAttribute | permissionschemeattribute
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM permissionschemeattribute) WHERE seq_name = 'PermissionSchemeAttribute' and 0 < (select count(*) from permissionschemeattribute);
-- PluginVersion | propertyentry
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM propertyentry) WHERE seq_name = 'PluginVersion' and 0 < (select count(*) from pluginversion);
-- PortalPage | portalpage
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM portalpage) WHERE seq_name = 'PortalPage' and 0 < (select count(*) from portalpage);
-- PortletConfiguration | portletconfiguration
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM portletconfiguration) WHERE seq_name = 'PortletConfiguration' and 0 < (select count(*) from portletconfiguration);
-- Priority | priority (id is of character type) - write your own UPDATE
-- UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM priority) WHERE seq_name = 'Priority' and 0 < (select count(*) from priority);
-- ProductLicense | productlicense
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM productlicense) WHERE seq_name = 'ProductLicense' and 0 < (select count(*) from productlicense);
-- Project | project
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM project) WHERE seq_name = 'Project' and 0 < (select count(*) from project);
-- ProjectCategory | projectcategory
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM projectcategory) WHERE seq_name = 'ProjectCategory' and 0 < (select count(*) from projectcategory);
-- ProjectKey | project_key
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM project_key) WHERE seq_name = 'ProjectKey' and 0 < (select count(*) from project_key);
-- ProjectRole | projectrole
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM projectrole) WHERE seq_name = 'ProjectRole' and 0 < (select count(*) from projectrole);
-- ProjectRoleActor | projectroleactor
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM projectroleactor) WHERE seq_name = 'ProjectRoleActor' and 0 < (select count(*) from projectroleactor);
-- ReindexComponent | reindex_component
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM reindex_component) WHERE seq_name = 'ReindexComponent' and 0 < (select count(*) from reindex_component);
-- ReindexRequest | reindex_request
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM reindex_request) WHERE seq_name = 'ReindexRequest' and 0 < (select count(*) from reindex_request);
-- RememberMeToken | remembermetoken
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM remembermetoken) WHERE seq_name = 'RememberMeToken' and 0 < (select count(*) from remembermetoken);
-- ReplicatedIndexOperation | replicatedindexoperation
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM replicatedindexoperation) WHERE seq_name = 'ReplicatedIndexOperation' and 0 < (select count(*) from replicatedindexoperation);
-- Resolution | resolution (id is TEXT type) - write your own UPDATE
-- UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM resolution) WHERE seq_name = 'Resolution' and 0 < (select count(*) from resolution);
-- RunDetails | rundetails
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM rundetails) WHERE seq_name = 'RunDetails' and 0 < (select count(*) from rundetails);
-- SchemePermissions | schemepermissions
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM schemepermissions) WHERE seq_name = 'SchemePermissions' and 0 < (select count(*) from schemepermissions);
-- SearchRequest | searchrequest
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM searchrequest) WHERE seq_name = 'SearchRequest' and 0 < (select count(*) from searchrequest);
-- ServiceConfig | serviceconfig
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM serviceconfig) WHERE seq_name = 'ServiceConfig' and 0 < (select count(*) from serviceconfig);
-- SharePermissions | sharepermissions
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM sharepermissions) WHERE seq_name = 'SharePermissions' and 0 < (select count(*) from sharepermissions);
-- Status | issuestatus (id is TEXT type) - write your own UPDATE
-- UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM issuestatus) WHERE seq_name = 'Status' and 0 < (select count(*) from issuestatus);
-- UpgradeHistory | upgradehistory
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM upgradehistory) WHERE seq_name = 'UpgradeHistory' and 0 < (select count(*) from upgradehistory);
-- UpgradeTaskHistory | upgradetaskhistory
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM upgradetaskhistory) WHERE seq_name = 'UpgradeTaskHistory' and 0 < (select count(*) from upgradetaskhistory);
-- UpgradeTaskHistoryAuditLog | upgradetaskhistoryauditlog
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM upgradetaskhistoryauditlog) WHERE seq_name = 'UpgradeTaskHistoryAuditLog' and 0 < (select count(*) from upgradetaskhistoryauditlog);
-- UpgradeVersionHistory | upgradeversionhistory
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM upgradeversionhistory) WHERE seq_name = 'UpgradeVersionHistory' and 0 < (select count(*) from upgradeversionhistory);
-- User | cwd_user
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM cwd_user) WHERE seq_name = 'User' and 0 < (select count(*) from cwd_user);
-- UserAttribute | cwd_user_attributes
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM cwd_user_attributes) WHERE seq_name = 'UserAttribute' and 0 < (select count(*) from cwd_user_attributes);
-- UserHistoryItem | userhistoryitem
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM userhistoryitem) WHERE seq_name = 'UserHistoryItem' and 0 < (select count(*) from userhistoryitem);
-- Version | projectversion
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM projectversion) WHERE seq_name = 'Version' and 0 < (select count(*) from projectversion);
-- Workflow | jiraworkflows
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM jiraworkflows) WHERE seq_name = 'Workflow' and 0 < (select count(*) from jiraworkflows);
-- WorkflowScheme | workflowscheme
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM workflowscheme) WHERE seq_name = 'WorkflowScheme' and 0 < (select count(*) from workflowscheme);
-- WorkflowSchemeEntity | workflowschemeentity
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM workflowschemeentity) WHERE seq_name = 'WorkflowSchemeEntity' and 0 < (select count(*) from workflowschemeentity);
-- Worklog | worklog
UPDATE sequence_value_item SET seq_id = (SELECT max(id)+100 FROM worklog) WHERE seq_name = 'Worklog' and 0 < (select count(*) from worklog);
-- WorklogVersion | worklog_version
UPDATE sequence_value_item SET seq_id = (SELECT max(worklog_id)+100 FROM worklog_version) WHERE seq_name = 'WorklogVersion' and 0 < (select count(*) from worklog_version);Was this helpful?