Error when creating a new/first ServiceDesk project



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, /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(
at com.querydsl.sql.Configuration.translate(
at com.querydsl.sql.dml.SQLDeleteClause.execute(

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,


4 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 :(

Hallo every one,

Please try to clear the Jira cache.

This is possible from : System -> Add-ons -> Built-in Scripts -> Clear classloader or jira internal caches -> Jira internal caches

best regards


Suggest an answer

Log in or Sign up to answer
Community showcase
Published Feb 15, 2019 in Jira Service Desk

Are you a Jira Service Desk agent? We want to talk to you!

Are you a whiz at handling tickets and looking at how you can further optimize your workflow with automation? Do you tackle detailed customer support questions while simultaneously getting flooded wi...

346 views 0 11
Read article

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