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; } } }

JIRA Service Desk is not licensed!

mishurovskiy_a

This is RIDICULOUS!!! I spent already 2 days trying to solve issues

{"version":"5.1.0-REL-0005","platformVersion":"9.1.0","buildDate":{"iso8601":"2022-07-19T10:22:18+0300","jira":"2022-07-19T07:22:18.921+0000","friendly":"2 days ago 10:22","epochMillis":1658215338921},"buildChangeSet":"0c936eba","isLicensedForUse":true,"_links":{"self":"https://***/rest/servicedeskapi/info"}}

/rest/servicedeskapi/info shows isLicensedForUse: true!!

How to reproduce:
1) Install jira from docker image
2) boot jira
3) install service management OBR
4) ENTER LICENSE KEYS
5) Jira shows LICENSE IS OK
6) Go to /servicedesk to check - everything is OK
7) Restore CLOUD Backup
8) Re-enter License Keys
9) Go to /servicedesk to check - 403 Error: JIRA Service Desk is not licensed

I tried every solution possible with no success

UPD: I Started debugger and realized, thd license is OK, isStartedOK is false

Errors caused to fail: Why you a inserting with absolute PKs


Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.customfieldvalue (ID, ISSUE, CUSTOMFIELD, UPDATED, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_customfieldvalue"
Detail: Key (id)=(2087801) already exists.)

UPD:
https://confluence.atlassian.com/jirakb/duplicated-entry-unique-constraint-violated-397808094.html

Accepted answers

mishurovskiy_a

So solution is to move custom fields Ids upwards



removed by author

More info here: https://confluence.atlassian.com/jirakb/duplicated-entry-unique-constraint-violated-397808094.html

All comments

Joseph Chung Yin

@mishurovskiy_a -

It is recommended that you contact Atlassian Support directly to determine the root cause of your issue (https://support.atlassian.com). They will be able to provide you with more insight against your support zip files.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

mishurovskiy_a

after IDEA debugging I realized that SD started state is false.

mishurovskiy_a

Added new info

mishurovskiy_a

So solution is to move custom fields Ids upwards



removed by author

More info here: https://confluence.atlassian.com/jirakb/duplicated-entry-unique-constraint-violated-397808094.html

Joseph Chung Yin

@mishurovskiy_a -

Glad you found the issue and shared your backend DB update statement with the community.

However, I am sure that you obtained the SQL statement after you contacted Atlassian Support. If not, please note that Atlassian doesn't support direct backend DB update if the the script was not provided by the Atlassian Support Team.

Therefore, if you did obtained the script from Atlassian Support, then please click on Accept answer on my recommendation when you have a chance. It is not advisable to post backend SQL script if it is not provided by Atlassian Support + Everyone's environment may be different and one script may not fit all shoes.

Best, Joseph

mishurovskiy_a

I don't obtained it from atlassian support. I made it by myself by reverse engeneering.

Joseph Chung Yin

To community members (On-prems/Server envs), using and executing direct SQL for backend DB activities (especially UPDATE or DELETE action) which are not provided by Atlassian Support Team is extremely risky.

As by default, one should only execute direct DB script only if it is provided by Atlassian Support Team or it is documented in Atlassian's on-line KBs. Even when they are provided by Atlassian, one should always take a back-up of the DB prior the DB script execution. If you have any question/concern, it is always recommended to contact Atlassian Support (https://support.atlassian.com) for assistance and confirmation.

Best, Joseph

mishurovskiy_a

Pasted new solution

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-service-management

jira-service-management-server