[JRASERVER-66847] Can't create Service Desk project (template: IT Service Desk) when using Hungary

Type: Bug
Resolution: Duplicate
Priority: Low (View bug fix roadmap)
Fix Version/s: None
Affects Version/s: 7.8.0
Component/s: Project - Actions
Labels:
- triaged

Introduced in Version:
7.08
Support reference count:
1
Symptom Severity:
Severity 3 - Minor
Bug Fix Policy:
View Atlassian Server bug fix policy

Summary

Can't create Service Desk project (template: IT Service Desk) when using Hungary

Steps to Reproduce

Set the system language to Hungary
Create a Service Desk project by selecting the template "IT Service Desk"

Expected Results

The project is created

Actual Results

The project isn't created

Logs

2018-02-26 16:46:59,548 ajp-nio-8009-exec-6 ERROR jira.admin 1006x682x1 1my8rns 10.196.18.16 /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.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][sequence,42][statuscategory,2][name,Más fél által végzett szakmai ellenőrzés / Változásmenedzser jóváhagyása][iconurl,/images/icons/status_generic.gif][description,This was auto-generated by JIRA Service Desk during workflow import][id,10101] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(60)))
        at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:299)
        at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:172)
        at com.atlassian.jira.config.AbstractIssueConstantsManager.createConstant(AbstractIssueConstantsManager.java:43)
        at com.atlassian.jira.config.DefaultStatusManager.createStatus(DefaultStatusManager.java:85)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        ... 2 filtered
        at java.lang.reflect.Method.invoke(Unknown Source)
        at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
        at com.sun.proxy.$Proxy71.createStatus(Unknown Source)
        ... 3 filtered
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
        at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
        at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
        at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)
        at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
        at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
        at com.sun.proxy.$Proxy2809.createStatus(Unknown Source)
        at com.atlassian.servicedesk.internal.manager.WorkflowImporterService$$anonfun$7$$anonfun$apply$13.apply(WorkflowImporterService.scala:154)
        at com.atlassian.servicedesk.internal.manager.WorkflowImporterService$$anonfun$7$$anonfun$apply$13.apply(WorkflowImporterService.scala:153)
        at scala.Option.fold(Option.scala:158)
        at com.atlassian.servicedesk.internal.manager.WorkflowImporterService$$anonfun$7.apply(WorkflowImporterService.scala:153)
        at com.atlassian.servicedesk.internal.manager.WorkflowImporterService$$anonfun$7.apply(WorkflowImporterService.scala:153)
        at scala.collection.MapLike$class.getOrElse(MapLike.scala:128)
        at scala.collection.AbstractMap.getOrElse(Map.scala:59)
        at com.atlassian.servicedesk.internal.manager.WorkflowImporterService.com$atlassian$servicedesk$internal$manager$WorkflowImporterService$$findOrCreateStatus(WorkflowImporterService.scala:150)
        at com.atlassian.servicedesk.internal.manager.WorkflowImporterService$$anonfun$4$$anonfun$apply$9.apply(WorkflowImporterService.scala:136)
        at com.atlassian.servicedesk.internal.manager.WorkflowImporterService$$anonfun$4$$anonfun$apply$9.apply(WorkflowImporterService.scala:131)
        at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
        at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
        at scala.collection.immutable.List.foreach(List.scala:392)
        at scala.collection.TraversableLike$class.map(TraversableLike.scala:234)
        at scala.collection.immutable.List.map(List.scala:296)
        at com.atlassian.servicedesk.internal.manager.WorkflowImporterService$$anonfun$4.apply(WorkflowImporterService.scala:131)
        at com.atlassian.servicedesk.internal.manager.WorkflowImporterService$$anonfun$4.apply(WorkflowImporterService.scala:128)
        at scala.collection.TraversableLike$$anonfun$flatMap$1.apply(TraversableLike.scala:241)
        at scala.collection.TraversableLike$$anonfun$flatMap$1.apply(TraversableLike.scala:241)
        at scala.collection.immutable.List.foreach(List.scala:392)
        at scala.collection.TraversableLike$class.flatMap(TraversableLike.scala:241)
        at scala.collection.immutable.List.flatMap(List.scala:355)
        at com.atlassian.servicedesk.internal.manager.WorkflowImporterService.com$atlassian$servicedesk$internal$manager$WorkflowImporterService$$parseWorkflowForStatusMapping(WorkflowImporterService.scala:128)
        at com.atlassian.servicedesk.internal.manager.WorkflowImporterService$$anonfun$1.apply(WorkflowImporterService.scala:73)
        at com.atlassian.servicedesk.internal.manager.WorkflowImporterService$$anonfun$1.apply(WorkflowImporterService.scala:69)
        at scala.collection.immutable.List.map(List.scala:288)
        at com.atlassian.servicedesk.internal.manager.WorkflowImporterService.createAndAssociateWorkFlowForProject(WorkflowImporterService.scala:69)
        at com.atlassian.servicedesk.internal.feature.gettingstarted.GettingStartedService.com$atlassian$servicedesk$internal$feature$gettingstarted$GettingStartedService$$associateITSupportWorkflow(GettingStartedService.scala:370)
        at com.atlassian.servicedesk.internal.feature.gettingstarted.GettingStartedService$$anonfun$createServiceDeskForEmptyProject$1$$anonfun$apply$4$$anonfun$apply$5$$anonfun$apply$6.apply(GettingStartedService.scala:160)
        at com.atlassian.servicedesk.internal.feature.gettingstarted.GettingStartedService$$anonfun$createServiceDeskForEmptyProject$1$$anonfun$apply$4$$anonfun$apply$5$$anonfun$apply$6.apply(GettingStartedService.scala:157)
        at scalaz.$bslash$div.flatMap(Either.scala:134)
        at com.atlassian.servicedesk.internal.feature.gettingstarted.GettingStartedService$$anonfun$createServiceDeskForEmptyProject$1$$anonfun$apply$4$$anonfun$apply$5.apply(GettingStartedService.scala:157)
        at com.atlassian.servicedesk.internal.feature.gettingstarted.GettingStartedService$$anonfun$createServiceDeskForEmptyProject$1$$anonfun$apply$4$$anonfun$apply$5.apply(GettingStartedService.scala:154)
        at scalaz.$bslash$div.flatMap(Either.scala:134)
        at com.atlassian.servicedesk.internal.feature.gettingstarted.GettingStartedService$$anonfun$createServiceDeskForEmptyProject$1$$anonfun$apply$4.apply(GettingStartedService.scala:154)
        at com.atlassian.servicedesk.internal.feature.gettingstarted.GettingStartedService$$anonfun$createServiceDeskForEmptyProject$1$$anonfun$apply$4.apply(GettingStartedService.scala:149)
        at scalaz.$bslash$div.flatMap(Either.scala:134)
        at com.atlassian.servicedesk.internal.feature.gettingstarted.GettingStartedService$$anonfun$createServiceDeskForEmptyProject$1.apply(GettingStartedService.scala:149)
        at com.atlassian.servicedesk.internal.feature.gettingstarted.GettingStartedService$$anonfun$createServiceDeskForEmptyProject$1.apply(GettingStartedService.scala:146)
        at scalaz.$bslash$div.flatMap(Either.scala:134)
        at com.atlassian.servicedesk.internal.feature.gettingstarted.GettingStartedService.createServiceDeskForEmptyProject(GettingStartedService.scala:146)
        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)
        at com.atlassian.pocketknife.step.EitherStep1.then(EitherStep1.java:18)
        at com.atlassian.servicedesk.internal.project.ServiceDeskProjectConfigurator.configure(ServiceDeskProjectConfigurator.java:54)
        at com.atlassian.servicedesk.internal.project.template.hook.ItilV2ServiceDeskAddProjectHook.configure(ItilV2ServiceDeskAddProjectHook.java:17)
        at com.atlassian.jira.projecttemplates.service.ApplyProjectTemplateHandler.applyProjectTemplate(ApplyProjectTemplateHandler.java:65)
        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 filtered
        at java.lang.reflect.Method.invoke(Unknown Source)
        at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
        at com.sun.proxy.$Proxy114.createProject(Unknown Source)
        ... 3 filtered
        at java.lang.reflect.Method.invoke(Unknown Source)
        at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:136)
        at com.sun.proxy.$Proxy114.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(Unknown Source)
        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)
        ... 32 filtered
        at com.atlassian.servicedesk.internal.web.ExternalCustomerLockoutFilter.doFilter(ExternalCustomerLockoutFilter.java:56)
        ... 13 filtered
        at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
        ... 53 filtered
        at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
        ... 1 filtered
        at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
        ... 16 filtered
        at com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter(RestSeraphFilter.java:37)
        ... 19 filtered
        at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
        ... 5 filtered
        at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.lambda$invokeFilterChain$0(CustomerContextSettingFilter.java:181)
        at com.atlassian.servicedesk.internal.api.util.context.ReentrantThreadLocalBasedCodeContext.rteInvoke(ReentrantThreadLocalBasedCodeContext.java:137)
        at com.atlassian.servicedesk.internal.api.util.context.ReentrantThreadLocalBasedCodeContext.runOutOfContext(ReentrantThreadLocalBasedCodeContext.java:90)
        at com.atlassian.servicedesk.internal.utils.context.CustomerContextServiceImpl.runOutOfCustomerContext(CustomerContextServiceImpl.java:47)
        at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.outOfCustomerContext(CustomerContextSettingFilter.java:174)
        at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.doFilterImpl(CustomerContextSettingFilter.java:130)
        at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.doFilter(CustomerContextSettingFilter.java:121)
        ... 4 filtered
        at com.atlassian.jwt.internal.servlet.JwtAuthFilter.doFilter(JwtAuthFilter.java:32)
        ... 8 filtered
        at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
        ... 4 filtered
        at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)
        ... 26 filtered
        at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
        ... 23 filtered
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Unknown Source)
Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][sequence,42][statuscategory,2][name,Más fél által végzett szakmai ellenőrzés / Változásmenedzser jóváhagyása][iconurl,/images/icons/status_generic.gif][description,This was auto-generated by JIRA Service Desk during workflow import][id,10101] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(60)))
        at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:206)
        at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:171)
        at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:89)
        at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:562)
        at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:548)
        at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:296)
        ... 343 more
Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(60))
        at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:570)
        at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:198)
        ... 349 more
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(60)
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)
        at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:135)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
        at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:562)
        ... 350 more
2018-02-26 16:46:59,608 ajp-nio-8009-exec-6 ERROR jira.admin 1006x682x1 1my8rns 10.196.18.16 /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 created
java.lang.RuntimeException: An error occurred while notifying that a project was created

duplicates

JSDSERVER-5545 Unable to create IT Service Desk project in default Czech, Russian, Slovak, Polish, French

Closed

is related to: SSE-384 You do not have permission to view this issue

Form Name

There are no comments yet on this issue.

Details

Description

Summary

Steps to Reproduce

Expected Results

Actual Results

Logs

Attachments

Issue Links

Forms

Activity

People

Dates