Can't create a Service Desk Project

[Mark David]

I have a newly install Jira Software and enable jira service desk on a single machine.

But when I tried to create a new project for Service Desk (Basic, IT Service Desk and Customer service) it say's the error below.

"Hmm... we couldn't create your project due to an unknown error. Try refreshing the page to start again"

[Rene C. [Atlassian Support]]

Hello Mark! This question was posted a while ago, and I'm not sure if you were able to solve this issue, but the error in the logs seem to be that the tables for Viewport do not exist, I suggest you try restarting your instance, and verifying again, as Service Desk is usually able to recreate all tables or objects missing during a restart.

Aside from that, I also see some entries related to translation, and there are indeed a couple of known issues related to Service Desk and creating projects in languages like Unable to create IT Service Desk project in default Czech, Russian, Slovak, Polish, French. You the fix for these issues is awaiting release and should be available soon. If you continue experiencing these issues, you can raise a request at Support for us to give it a look!

Hope this helps!

[Ivan Tovbin]

What do the logs say?

[Mark David]

2018-02-13 05:31:55,439 Caesium-1-4 ERROR ServiceRunner [c.a.m.incoming.jepp.processor] MailJobRunner Failed
com.querydsl.core.QueryException: Caught MySQLSyntaxErrorException for select `AO_2C4E5C_MAILCHANNEL`.`ID`, `AO_2C4E5C_MAILCHANNEL`.`MAIL_CHANNEL_KEY`, `AO_2C4E5C_MAILCHANNEL`.`PROJECT_ID`, `AO_2C4E5C_MAILCHANNEL`.`MAX_RETRY_ON_FAILURE`, `AO_2C4E5C_MAILCHANNEL`.`MAIL_CONNECTION_ID`, `AO_2C4E5C_MAILCHANNEL`.`ENABLED`, `AO_2C4E5C_MAILCHANNEL`.`CREATED_TIMESTAMP`, `AO_2C4E5C_MAILCHANNEL`.`UPDATED_TIMESTAMP`, `AO_2C4E5C_MAILCHANNEL`.`CREATED_BY`, `AO_2C4E5C_MAILCHANNEL`.`MODIFIED_BY` from `AO_2C4E5C_MAILCHANNEL` `AO_2C4E5C_MAILCHANNEL` where `AO_2C4E5C_MAILCHANNEL`.`ENABLED` = ?
at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50)
at com.querydsl.sql.Configuration.translate(Configuration.java:459)
at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:502)
at com.atlassian.jira.internal.mail.processor.querydsl.QueryDslHelper.lambda$list$3(QueryDslHelper.java:276)
at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.lambda$execute$0(DatabaseAccessorImpl.java:69)
at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.executeInternal(DefaultTransactionalExecutor.java:86)
at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.lambda$execute$0(DefaultTransactionalExecutor.java:42)
at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.lambda$borrowConnectionAndExecute$0(JiraHostConnectionAccessor.java:95)
at com.atlassian.jira.database.DatabaseAccessorImpl.executeQuery(DatabaseAccessorImpl.java:68)
... 2 filtered
at java.lang.reflect.Method.invoke(Method.java:498)
at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
at com.sun.proxy.$Proxy273.executeQuery(Unknown Source)
... 2 filtered
at java.lang.reflect.Method.invoke(Method.java:498)
at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:136)
at com.sun.proxy.$Proxy273.executeQuery(Unknown Source)
at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.borrowConnectionAndExecute(JiraHostConnectionAccessor.java:84)
at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.execute(JiraHostConnectionAccessor.java:48)
at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.execute(DefaultTransactionalExecutor.java:39)
at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.execute(DatabaseAccessorImpl.java:67)
at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.runInNewTransaction(DatabaseAccessorImpl.java:38)
at com.atlassian.pocketknife.api.querydsl.DatabaseAccessor.runInNewTransaction(DatabaseAccessor.java:54)
at com.atlassian.jira.internal.mail.processor.querydsl.QueryDslHelper.list(QueryDslHelper.java:273)
at com.atlassian.jira.internal.mail.processor.feature.channel.MailChannelStore.getEnabledMailChannels(MailChannelStore.java:41)
at com.atlassian.jira.internal.mail.processor.feature.channel.MailChannelManager.getEnabledMailChannelsFiltered(MailChannelManager.java:92)
at com.atlassian.jira.internal.mail.processor.feature.channel.MailChannelManager.getValidMailChannels(MailChannelManager.java:79)
at com.atlassian.jira.internal.mail.processor.feature.processor.MailProcessorWorker.processAllValidMailChannels(MailProcessorWorker.java:119)
at com.atlassian.jira.internal.mail.processor.feature.processor.MailProcessorService.run(MailProcessorService.java:25)
at com.atlassian.jira.internal.mail.processor.services.MailProcessorExecutor.run(MailProcessorExecutor.java:29)
at com.atlassian.jira.internal.mail.processor.services.AbstractMailExecutor.execute(AbstractMailExecutor.java:45)
at com.atlassian.jira.internal.mail.processor.services.MailJobRunner.runJob(MailJobRunner.java:35)
at com.atlassian.scheduler.core.JobLauncher.runJob(JobLauncher.java:153)
at com.atlassian.scheduler.core.JobLauncher.launchAndBuildResponse(JobLauncher.java:118)
at com.atlassian.scheduler.core.JobLauncher.launch(JobLauncher.java:97)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.launchJob(CaesiumSchedulerService.java:443)

[Mark David]

com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeClusteredJob(CaesiumSchedulerService.java:438)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeClusteredJobWithRecoveryGuard(CaesiumSchedulerService.java:462)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeQueuedJob(CaesiumSchedulerService.java:390)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService$1.consume(CaesiumSchedulerService.java:285)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService$1.consume(CaesiumSchedulerService.java:282)
at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeJob(SchedulerQueueWorker.java:65)
at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeNextJob(SchedulerQueueWorker.java:59)
at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.run(SchedulerQueueWorker.java:34)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jiradb.AO_2C4E5C_MAILCHANNEL' doesn't exist
at sun.reflect.GeneratedConstructorAccessor201.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:446)
... 44 more
2018-02-13 05:31:55,503 Caesium-1-2 ERROR ServiceRunner [c.a.m.incoming.jepp.processor] MailJobRunner Failed
com.querydsl.core.QueryException: Caught MySQLSyntaxErrorException for select `AO_2C4E5C_MAILCHANNEL`.`ID`, `AO_2C4E5C_MAILCHANNEL`.`MAIL_CHANNEL_KEY`, `AO_2C4E5C_MAILCHANNEL`.`PROJECT_ID`, `AO_2C4E5C_MAILCHANNEL`.`MAX_RETRY_ON_FAILURE`, `AO_2C4E5C_MAILCHANNEL`.`MAIL_CONNECTION_ID`, `AO_2C4E5C_MAILCHANNEL`.`ENABLED`, `AO_2C4E5C_MAILCHANNEL`.`CREATED_TIMESTAMP`, `AO_2C4E5C_MAILCHANNEL`.`UPDATED_TIMESTAMP`, `AO_2C4E5C_MAILCHANNEL`.`CREATED_BY`, `AO_2C4E5C_MAILCHANNEL`.`MODIFIED_BY` from `AO_2C4E5C_MAILCHANNEL` `AO_2C4E5C_MAILCHANNEL` where `AO_2C4E5C_MAILCHANNEL`.`ENABLED` = ?
at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50)
at com.querydsl.sql.Configuration.translate(Configuration.java:459)
at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:502)
at com.atlassian.jira.internal.mail.processor.querydsl.QueryDslHelper.lambda$list$3(QueryDslHelper.java:276)
at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.lambda$execute$0(DatabaseAccessorImpl.java:69)
at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.executeInternal(DefaultTransactionalExecutor.java:86)
at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.lambda$execute$0(DefaultTransactionalExecutor.java:42)
at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.lambda$borrowConnectionAndExecute$0(JiraHostConnectionAccessor.java:95)
at com.atlassian.jira.database.DatabaseAccessorImpl.executeQuery(DatabaseAccessorImpl.java:68)
... 2 filtered
at java.lang.reflect.Method.invoke(Method.java:498)
at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
at com.sun.proxy.$Proxy273.executeQuery(Unknown Source)
... 2 filtered
at java.lang.reflect.Method.invoke(Method.java:498)
at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:136)
at com.sun.proxy.$Proxy273.executeQuery(Unknown Source)
at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.borrowConnectionAndExecute(JiraHostConnectionAccessor.java:84)
at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.execute(JiraHostConnectionAccessor.java:48)
at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.execute(DefaultTransactionalExecutor.java:39)
at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.execute(DatabaseAccessorImpl.java:67)
at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.runInNewTransaction(DatabaseAccessorImpl.java:38)
at com.atlassian.pocketknife.api.querydsl.DatabaseAccessor.runInNewTransaction(DatabaseAccessor.java:54)
at com.atlassian.jira.internal.mail.processor.querydsl.QueryDslHelper.list(QueryDslHelper.java:273)
at com.atlassian.jira.internal.mail.processor.feature.channel.MailChannelStore.getEnabledMailChannels(MailChannelStore.java:41)
at com.atlassian.jira.internal.mail.processor.feature.channel.MailChannelManager.getEnabledMailChannelsFiltered(MailChannelManager.java:92)
at com.atlassian.jira.internal.mail.processor.feature.channel.MailChannelManager.getValidMailChannels(MailChannelManager.java:79)
at com.atlassian.jira.internal.mail.processor.feature.puller.MailPullerWorker.pullMailFromAllValidChannels(MailPullerWorker.java:66)
at com.atlassian.jira.internal.mail.processor.feature.puller.MailPullerService.run(MailPullerService.java:33)
at com.atlassian.jira.internal.mail.processor.services.MailPullerExecutor.run(MailPullerExecutor.java:29)
at com.atlassian.jira.internal.mail.processor.services.AbstractMailExecutor.execute(AbstractMailExecutor.java:45)
at com.atlassian.jira.internal.mail.processor.services.MailJobRunner.runJob(MailJobRunner.java:35)
at com.atlassian.scheduler.core.JobLauncher.runJob(JobLauncher.java:153)
at com.atlassian.scheduler.core.JobLauncher.launchAndBuildResponse(JobLauncher.java:118)
at com.atlassian.scheduler.core.JobLauncher.launch(JobLauncher.java:97)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.launchJob(CaesiumSchedulerService.java:443)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeClusteredJob(CaesiumSchedulerService.java:438)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeClusteredJobWithRecoveryGuard(CaesiumSchedulerService.java:462)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeQueuedJob(CaesiumSchedulerService.java:390)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService$1.consume(CaesiumSchedulerService.java:285)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService$1.consume(CaesiumSchedulerService.java:282)
at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeJob(SchedulerQueueWorker.java:65)
at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeNextJob(SchedulerQueueWorker.java:59)
at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.run(SchedulerQueueWorker.java:34)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jiradb.AO_2C4E5C_MAILCHANNEL' doesn't exist
at sun.reflect.GeneratedConstructorAccessor201.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:446)
... 44 more
13-Feb-2018 05:32:07.634 WARNING [http-nio-8080-exec-24] com.sun.jersey.spi.container.servlet.WebComponent.filterFormParameters A servlet request, to the URI http://10.1.51.118:8080/rest/project-templates/1.0/templates, contains form parameters in the request body but the request body has been consumed by the servlet or a servlet filter accessing the request parameters. Only resource methods using @FormParam will work as expected. Resource methods consuming the request body by other means will not work as expected.
2018-02-13 05:32:07,673 http-nio-8080-exec-24 INFO ryanm 332x832x1 1g70tz1 10.1.51.33 /rest/project-templates/1.0/templates [c.a.j.i.f.config.manager.FieldConfigSchemeManagerImpl] ConfigScheme SERT: JIRA Service Desk Issue Type Scheme (11209). Created with no associated contexts
2018-02-13 05:32:08,401 http-nio-8080-exec-24 ERROR ryanm 332x832x1 1g70tz1 10.1.51.33 /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.atlassian.cache.CacheException: com.querydsl.core.QueryException: Caught MySQLSyntaxErrorException for select `AO_54307E_VIEWPORT`.`DESCRIPTION`, `AO_54307E_VIEWPORT`.`ID`, `AO_54307E_VIEWPORT`.`KEY`, `AO_54307E_VIEWPORT`.`LOGO_ID`, `AO_54307E_VIEWPORT`.`NAME`, `AO_54307E_VIEWPORT`.`PROJECT_ID`, `AO_54307E_VIEWPORT`.`SEND_EMAIL_NOTIFICATIONS`, `AO_54307E_VIEWPORT`.`THEME_ID` from `AO_54307E_VIEWPORT` `AO_54307E_VIEWPORT`
at com.atlassian.cache.memory.DelegatingCachedReference.get(DelegatingCachedReference.java:91)
at com.atlassian.servicedesk.internal.feature.customer.portal.PortalInternalManagerImpl.getCache(PortalInternalManagerImpl.java:253)
at com.atlassian.servicedesk.internal.feature.customer.portal.PortalInternalManagerImpl.getPortalByProjectId(PortalInternalManagerImpl.java:136)
at com.atlassian.servicedesk.internal.project.ServiceDeskDeletionManagerImpl.deleteServiceDeskByProject(ServiceDeskDeletionManagerImpl.java:101)
at com.atlassian.servicedesk.internal.feature.servicedesk.InternalServiceDeskServiceImpl.deleteServiceDesk(InternalServiceDeskServiceImpl.java:210)
at com.atlassian.servicedesk.internal.feature.gettingstarted.GettingStartedService.createServiceDeskForEmptyProject(GettingStartedService.scala:143)
at com.atlassian.servicedesk.internal.project.ServiceDeskProjectConfigurator.callGettingStartedServiceToCreateServiceDesk(ServiceDeskProjectConfigurator.java:70)
at com.atlassian.servicedesk.internal.project.ServiceDeskProjectConfigurator.lambda$configure$0(ServiceDeskProjectConfigurator.java:55)
at io.atlassian.fugue.Either$RightProjection.flatMap(Either.java:886)
at io.atlassian.fugue.Either.flatMap(Either.java:231)

[Mark David]

too much error logs, sorry i can't understand the logs.

[Ivan Tovbin]

I suppose the safest way is to create a support zip and hit Atlassian Support with it.

[Mark David]

I tried using re-indexing but still can't create a service desk project.