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
