Error when creating a new/first ServiceDesk project

Hi,

 

When trying to create a new ServiceDesk project (type: Customer Service) I get an error message reading "Hmm... we couldn't create your project due to an unknown error. Try refreshing the page to start again.".

It tried it multiple times - always with the same result.

When looking into the catalina.out file, I find this exception:

2017-08-25 09:22:25,193 http-nio-8080-exec-1 ERROR s.listing 562x3247x1 pm89rv 92.50.82.58,127.0.0.1 /rest/project-templates/1.0/templates [c.a.jira.project.ProjectCreateRegistrarImpl] The handler with id com.atlassian.jira.project-templates-plugin:apply-project-template-handler threw an exception while handling a notification about a project being created
com.querydsl.core.QueryException: Caught MySQLIntegrityConstraintViolationException for delete from `AO_54307E_GROUP` where `AO_54307E_GROUP`.`VIEWPORT_ID` = ?
at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50)
at com.querydsl.sql.Configuration.translate(Configuration.java:453)
at com.querydsl.sql.dml.SQLDeleteClause.execute(SQLDeleteClause.java:209)
at com.atlassian.servicedesk.internal.requesttype.group.RequestTypeGroupQStoreImpl.lambda$hardDeleteGroups$6(RequestTypeGroupQStoreImpl.java:119)

Background infos:

- we use a self hosted Jira 7.4.3
- we used ServiceDesk before hadn't renewed our license in some time. So this is a "reboot" but it might be, that some old data is still lingering around the datatbase

Any ideas?

Thanks a lot,

Sven

3 answers

Hi Sven,

 

Can you check what it's displayed in the Versions & Licenses page for JIRA SD?

You will be able to see there if a license is active at the moment (even if it's a trial one).

Hi Daniel,

 

We currently have JIRA for 25 and service desk for 3 users. Both licenses are active.

Once I changed the name of the project, I get a different error message (see screenshot).

Hi Sven,

did you find a solution for this problem yet?

Nope - not really. I ended up installing the entire setup from scratch :(

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Asked Feb 02, 2018 in Jira Service Desk

What are the must-have addons?

Hi all, We are trialing Jira Service Desk for a large-ish, flat, team-based organization where members can serve on multiple teams. A few needs that are not out of the box... Assigning i...

927 views 12 5
View question

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you