The error is an SQL insert into a core Jira table, which means there's a bug in Jira, or something is trying to send over garbage when creating an issue.
We need the support to fix and resolve this issue.
Could you show us the relevant part of the log?
Pls find the below logs.
Unable to create a new project in Jira Core
2017-12-14 12:42:11,419 http-nio-8087-exec-1 ERROR Administrator 762x3391x1 nu8uzc 192.168.1.4 /rest/project-templates/1.0/templates [c.a.p.r.c.error.jersey.ThrowableExceptionMapper] Uncaught exception thrown by REST service: An error occurred while notifying that a project was createdjava.lang.RuntimeException: An error occurred while notifying that a project was createdat com.atlassian.jira.bc.project.DefaultProjectService.notifyHandlersOfProjectCreated(DefaultProjectService.java:397)at com.atlassian.jira.bc.project.DefaultProjectService.createProjectInternal(DefaultProjectService.java:379)at com.atlassian.jira.bc.project.DefaultProjectService.createProject(DefaultProjectService.java:349)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)... 1 filteredat java.lang.reflect.Method.invoke(Method.java:498)at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)at com.sun.proxy.$Proxy426.createProject(Unknown Source)... 3 filteredat 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.$Proxy426.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 filteredat java.lang.reflect.Method.invoke(Method.java:498)at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)... 12 filteredat com.atlassian.plugins.rest.module.RestDelegatingServletFilter$JerseyOsgiServletContainer.doFilter(RestDelegatingServletFilter.java:154)... 1 filteredat com.atlassian.plugins.rest.module.RestDelegatingServletFilter.doFilter(RestDelegatingServletFilter.java:68)... 41 filteredat com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)... 53 filteredat com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)... 1 filteredat com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)... 16 filteredat com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter(RestSeraphFilter.java:37)... 19 filteredat com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)... 10 filteredat com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)... 4 filteredat com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)... 26 filteredat com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)... 23 filteredat 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)2017-12-14 13:28:23,846 Caesium-1-3 INFO ServiceRunner [c.a.j.p.h.service.connect.InstallGlancesJobHandler] Running InstallGlancesJobHandler...2017-12-14 13:28:23,846 Caesium-1-3 INFO ServiceRunner [c.a.j.p.h.service.connect.InstallGlancesJobHandler] There is no link to HipChat, no need to install glances.2017-12-14 13:28:29,447 Caesium-1-4 INFO ServiceRunner [c.a.j.p.h.service.ping.RefreshConnectionStatusJobHandler] Running RefreshConnectionStatusJobHandler...2017-12-14 13:34:31,455 http-nio-8087-exec-21 WARN Administrator 814x3641x1 rygeh4 192.168.1.4 /rest/webResources/1.0/resources [c.a.p.webresource.legacy.DefaultResourceDependencyResolver] Cannot find web resource: jira/util/formatter2017-12-14 14:28:08,133 Caesium-1-1 WARN ServiceRunner [c.a.upm.pac.PacClientImpl] Update check request may take longer because of the number of add-ons2017-12-14 14:28:23,851 Caesium-1-4 INFO ServiceRunner [c.a.j.p.h.service.connect.InstallGlancesJobHandler] Running InstallGlancesJobHandler...2017-12-14 14:28:23,851 Caesium-1-4 INFO ServiceRunner [c.a.j.p.h.service.connect.InstallGlancesJobHandler] There is no link to HipChat, no need to install glances.2017-12-14 14:28:29,429 Caesium-1-4 INFO ServiceRunner [c.a.j.p.h.service.ping.RefreshConnectionStatusJobHandler] Running RefreshConnectionStatusJobHandler...2017-12-14 15:28:23,857 Caesium-1-1 INFO ServiceRunner [c.a.j.p.h.service.connect.InstallGlancesJobHandler] Running InstallGlancesJobHandler...2017-12-14 15:28:23,857 Caesium-1-1 INFO ServiceRunner [c.a.j.p.h.service.connect.InstallGlancesJobHandler] There is no link to HipChat, no need to install glances.2017-12-14 15:28:29,445 Caesium-1-1 INFO ServiceRunner [c.a.j.p.h.service.ping.RefreshConnectionStatusJobHandler] Running RefreshConnectionStatusJobHandler...2017-12-14 16:28:23,863 Caesium-1-3 INFO ServiceRunner [c.a.j.p.h.service.connect.InstallGlancesJobHandler] Running InstallGlancesJobHandler...2017-12-14 16:28:23,863 Caesium-1-3 INFO ServiceRunner [c.a.j.p.h.service.connect.InstallGlancesJobHandler] There is no link to HipChat, no need to install glances.2017-12-14 16:28:29,457 Caesium-1-3 INFO ServiceRunner [c.a.j.p.h.service.ping.RefreshConnectionStatusJobHandler] Running RefreshConnectionStatusJobHandler...2017-12-14 16:55:10,315 localhost-startStop-2 INFO [c.a.jira.startup.DefaultJiraLauncher] Stopping launchers2017-12-14 16:55:16,305 localhost-startStop-2 INFO [c.a.plugin.manager.DefaultPluginManager] Preparing to shut down the plugin system2017-12-14 16:55:20,836 localhost-startStop-2 INFO [c.a.plugin.manager.DefaultPluginManager] Shutting down the plugin system2017-12-14 16:55:29,601 Gemini Blueprint context shutdown thread1 DEBUG [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] ungetService bundle [com.atlassian.jira.plugins.webhooks.jira-webhooks-plugin]2017-12-14 16:55:29,617 Gemini Blueprint context shutdown thread1 DEBUG [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] ungetService bundle [com.atlassian.streams.thirdparty-plugin]2017-12-14 16:55:29,633 Gemini Blueprint context shutdown thread1 DEBUG [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] ungetService bundle [com.atlassian.plugins.base-hipchat-integration-plugin-api]2017-12-14 16:55:29,633 Gemini Blueprint context shutdown thread1 DEBUG [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] ungetService bundle [com.atlassian.labs.hipchat.hipchat-for-jira-plugin]2017-12-14 16:55:29,633 Gemini Blueprint context shutdown thread1 DEBUG [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] ungetService bundle [com.atlassian.whisper.atlassian-whisper-plugin]2017-12-14 16:55:29,633 Gemini Blueprint context shutdown thread1 DEBUG [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] ungetService bundle [com.atlassian.troubleshooting.plugin-jira]2017-12-14 16:55:29,633 Gemini Blueprint context shutdown thread1 DEBUG [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] ungetService bundle [com.atlassian.plugins.authentication.atlassian-authentication-plugin]2017-12-14 16:55:29,633 Gemini Blueprint context shutdown thread1 DEBUG [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] ungetService bundle [com.atlassian.plugins.atlassian-whitelist-api-plugin]2017-12-14 16:55:29,633 Gemini Blueprint context shutdown thread1 DEBUG [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] destroy2017-12-14 16:56:13,457 Gemini Blueprint context shutdown thread2 INFO [c.a.j.plugins.monitor.MonitoringScheduler] Unscheduling metrics collector...2017-12-14 16:56:13,520 Gemini Blueprint context shutdown thread2 INFO [c.a.j.plugins.monitor.MonitorLauncher] Stopped JIRA monitoring2017-12-14 16:59:01,538 localhost-startStop-2 INFO [c.a.jira.startup.DefaultJiraLauncher] JIRA launchers stopped in 231082ms
2017-12-14 12:42:11,024 http-nio-8087-exec-1 INFO Administrator 762x3391x1 nu8uzc 192.168.1.4 /rest/project-templates/1.0/templates [c.a.j.i.f.config.manager.FieldConfigSchemeManagerImpl] ConfigScheme SQLDEV: Project Management Issue Type Scheme (10106). Created with no associated contexts2017-12-14 12:42:11,166 http-nio-8087-exec-1 INFO Administrator 762x3391x1 nu8uzc 192.168.1.4 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'Administrator(administrator)' updated workflow 'SQLDEV: Project Management Workflow' at 'Thu Dec 14 12:42:11 IST 2017'2017-12-14 12:42:11,346 http-nio-8087-exec-1 ERROR Administrator 762x3391x1 nu8uzc 192.168.1.4 /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 createdcom.querydsl.core.QueryException: Caught SQLServerException for insert into "JIRASchema"."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$0(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:86)at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.lambda$execute$0(DefaultTransactionalExecutor.java:42)at com.atlassian.jira.database.DatabaseAccessorImpl.runInManagedTransaction(DatabaseAccessorImpl.java:125)... 2 filteredat java.lang.reflect.Method.invoke(Method.java:498)at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)at com.sun.proxy.$Proxy119.runInManagedTransaction(Unknown Source)... 2 filteredat 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.$Proxy119.runInManagedTransaction(Unknown Source)at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.runInStartedOrExistingTransaction(JiraHostConnectionAccessor.java:130)at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.execute(JiraHostConnectionAccessor.java:60)at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.execute(DefaultTransactionalExecutor.java:39)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.AppliedTemplateStorageCache.add(AppliedTemplateStorageCache.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:35)at com.atlassian.jira.bc.project.DefaultProjectService.notifyHandlersOfProjectCreated(DefaultProjectService.java:394)at com.atlassian.jira.bc.project.DefaultProjectService.createProjectInternal(DefaultProjectService.java:379)at com.atlassian.jira.bc.project.DefaultProjectService.createProject(DefaultProjectService.java:349)... 3 filteredat java.lang.reflect.Method.invoke(Method.java:498)at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)at com.sun.proxy.$Proxy426.createProject(Unknown Source)... 3 filteredat 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.$Proxy426.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 filteredat java.lang.reflect.Method.invoke(Method.java:498)at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)... 12 filteredat com.atlassian.plugins.rest.module.RestDelegatingServletFilter$JerseyOsgiServletContainer.doFilter(RestDelegatingServletFilter.java:154)... 1 filteredat com.atlassian.plugins.rest.module.RestDelegatingServletFilter.doFilter(RestDelegatingServletFilter.java:68)... 41 filteredat com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)... 53 filteredat com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)... 1 filteredat com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)... 16 filteredat com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter(RestSeraphFilter.java:37)... 19 filteredat com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)... 10 filteredat com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)... 4 filteredat com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)... 26 filteredat com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)... 23 filteredat 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: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert the value NULL into column 'ID', table 'JIRA_CORE.JIRASchema.AO_B9A0F0_APPLIED_TEMPLATE'; column does not allow nulls. INSERT fails.at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:467)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:409)at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151)at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219)at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:356)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)... 269 more2017-12-14 12:42:11,419 http-nio-8087-exec-1 ERROR Administrator 762x3391x1 nu8uzc 192.168.1.4 /rest/project-templates/1.0/templates [c.a.p.r.c.error.jersey.ThrowableExceptionMapper] Uncaught exception thrown by REST service: An error occurred while notifying that a project was createdjava.lang.RuntimeException: An error occurred while notifying that a project was createdat com.atlassian.jira.bc.project.DefaultProjectService.notifyHandlersOfProjectCreated(DefaultProjectService.java:397)at com.atlassian.jira.bc.project.DefaultProjectService.createProjectInternal(DefaultProjectService.java:379)at com.atlassian.jira.bc.project.DefaultProjectService.createProject(DefaultProjectService.java:349)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)... 1 filteredat java.lang.reflect.Method.invoke(Method.java:498)at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)at com.sun.proxy.$Proxy426.createProject(Unknown Source)... 3 filteredat 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.$Proxy426.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 filteredat java.lang.reflect.Method.invoke(Method.java:498)at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)... 12 filteredat com.atlassian.plugins.rest.module.RestDelegatingServletFilter$JerseyOsgiServletContainer.doFilter(RestDelegatingServletFilter.java:154)... 1 filteredat com.atlassian.plugins.rest.module.RestDelegatingServletFilter.doFilter(RestDelegatingServletFilter.java:68)... 41 filteredat com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)... 53 filteredat com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)... 1 filteredat com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)... 16 filteredat com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter(RestSeraphFilter.java:37)... 19 filteredat com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)... 10 filteredat com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)... 4 filteredat com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)... 26 filteredat com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)... 23 filteredat 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)
It looks like you're new here. Sign in or register to get started.
