We couldn't create your project due to an unknown error.

[Deleted user]

I get the following error message when it try to create a new it service desk:

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

Any ideas?

[aruizcon]

I'm getting this error. Trial period, database PostgreSQL 9.3, in my own installation.

Web server log:

2016-04-14 11:59:59,677 http-bio-8081-exec-21 ERROR aruizcon 719x241x1 1tvx4sq 192.168.0.22 /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 PSQLException for insert into "AO_B9A0F0_APPLIED_TEMPLATE" ("PROJECT_ID", "PROJECT_TEMPLATE_MODULE_KEY", "PROJECT_TEMPLATE_WEB_ITEM_KEY") values (?, ?, ?)

        at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50)

        at com.querydsl.sql.Configuration.translate(Configuration.java:451)

        at com.querydsl.sql.dml.SQLInsertClause.executeWithKeys(SQLInsertClause.java:364)

        at com.querydsl.sql.dml.SQLInsertClause.executeWithKey(SQLInsertClause.java:172)

        at com.querydsl.sql.dml.SQLInsertClause.executeWithKey(SQLInsertClause.java:153)

        at com.atlassian.jira.projecttemplates.service.AppliedTemplateStorageImpl.lambda$add$4(AppliedTemplateStorageImpl.java:26)

        at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.lambda$execute$18(DatabaseAccessorImpl.java:55)

        at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.executeInternal(DefaultTransactionalExecutor.java:103)

        at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor$1.execute(DefaultTransactionalExecutor.java:50)

        at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.lambda$borrowConnectionAndExecute$0(JiraHostConnectionAccessor.java:62)

        at com.atlassian.jira.database.DatabaseAccessorImpl.executeQuery(DatabaseAccessorImpl.java:67)

        ... 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.$Proxy308.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.$Proxy308.executeQuery(Unknown Source)

        at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.borrowConnectionAndExecute(JiraHostConnectionAccessor.java:50)

        at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.execute(JiraHostConnectionAccessor.java:40)

        at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.execute(DefaultTransactionalExecutor.java:45)

        at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.execute(DatabaseAccessorImpl.java:53)

        at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.runInTransaction(DatabaseAccessorImpl.java:37)

        at com.atlassian.jira.projecttemplates.service.AppliedTemplateStorageImpl.add(AppliedTemplateStorageImpl.java:20)

        at com.atlassian.jira.projecttemplates.service.ApplyProjectTemplateHandler.applyProjectTemplate(ApplyProjectTemplateHandler.java:61)

        at com.atlassian.jira.projecttemplates.service.ApplyProjectTemplateHandler.onProjectCreated(ApplyProjectTemplateHandler.java:53)

        at com.atlassian.jira.project.ProjectCreateRegistrarImpl.notifyAllHandlers(ProjectCreateRegistrarImpl.java:36)

        at com.atlassian.jira.bc.project.DefaultProjectService.notifyHandlersOfProjectCreated(DefaultProjectService.java:393)

        at com.atlassian.jira.bc.project.DefaultProjectService.createProjectInternal(DefaultProjectService.java:378)

        at com.atlassian.jira.bc.project.DefaultProjectService.createProject(DefaultProjectService.java:348)

        ... 3 filtered

        at java.lang.reflect.Method.invoke(Method.java:498)

        at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)

        at com.sun.proxy.$Proxy91.createProject(Unknown Source)

        ... 3 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.$Proxy91.createProject(Unknown Source)

        at com.atlassian.jira.projecttemplates.service.ProjectTemplateServiceImpl.applyProjectTemplate(ProjectTemplateServiceImpl.java:173)

        at com.atlassian.jira.projecttemplates.rest.ProjectTemplatesResource.createProjectFromFormRequest(ProjectTemplatesResource.java:170)

        ... 3 filtered

        at java.lang.reflect.Method.invoke(Method.java:498)

        at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)

        ... 12 filtered

        at com.atlassian.plugins.rest.module.RestDelegatingServletFilter$JerseyOsgiServletContainer.doFilter(RestDelegatingServletFilter.java:154)

        ... 1 filtered

        at com.atlassian.plugins.rest.module.RestDelegatingServletFilter.doFilter(RestDelegatingServletFilter.java:68)

        ... 86 filtered

        at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:70)

        ... 16 filtered

        at com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter(RestSeraphFilter.java:37)

        ... 73 filtered

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

        at java.lang.Thread.run(Thread.java:745)

Caused by: org.postgresql.util.PSQLException: ERROR: relation "AO_B9A0F0_APPLIED_TEMPLATE" does not exist

  Position: 13

        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)

        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)

        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)

        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:332)

        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)

        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)

        at com.querydsl.sql.dml.SQLInsertClause.executeWithKeys(SQLInsertClause.java:335)

        ... 245 more

2

[mtassara]

Hello,

Could you resolve this problem? I'm getting the same error?

Thanks!

[Christophe_Bol]

Workaround was in here:

https://jira.atlassian.com/browse/JRASERVER-64886

[Mauro Badii]

On Service Desk projects it could be caused by https://jira.atlassian.com/browse/JSD-3385

On Software Projects it may be https://jira.atlassian.com/browse/JSW-13456

Cheers

[Grzegorz Ciesielski]

I have this problem too on servicedesk. Use with mysql - now trial version for testing

[Shawn Ho]

I also encountered the same thing when using CentOS 6.6 + JIRA 7.1.0 (core only). It is quite frustrating. I checked my administrator privilege when logging in. Please advice.

[Ben Mathews]

I am getting the same error on the Atlassian cloud. I have the Service Desk permission and am logged in. 

Help!

[Nils Bluemer]

Disk full

I had the same problem today in my installation (in JIRA Software/Core). The reason was that no space was left on the Atlassian home directory (including /var/atlassian/application-data/jira). Freeing up disk space removed the problem, i.e. I could create the project.

[Phill Fox]

My first check would be to make sure my authentication has not expired as this would have logged you out.

[Deleted user]

thank you phil. Im still logged in. So that can't be the problem..

[Phill Fox]

I assume a refresh of the page did not solve the problem either. Can you check you application logfile to see if there are any other error details recorded in there.