the user has administrative rights and is in the jira service desk group. If I want to create a service desk project with this user I get the following error message: Hmm... we couldn't create your project due to an unknown error. Try refreshing the page to start again.
@Christian Zoepfchen
Caused by: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
Looks like you might be having the same issue as seen herehttps://community.atlassian.com/t5/Jira-questions/Unable-to-create-Project-in-Jira-Service-Desk/qaq-p/910378
You also might want to open a support ticket with Atlassian to get more immediate help with your problem
https://support.atlassian.com/contact/#/
Hello,
Have a look at the atlassian-jira.log file for the detailed error.
Thanks the error log below:
2018-11-05 11:53:33,452 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.j.i.f.config.manager.FieldConfigSchemeManagerImpl] ConfigScheme ISB: Jira Service Desk Issue Type Scheme (2) (10440). Created with no associated contexts2018-11-05 11:53:34,750 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'zoepfchen(zoepfchen)' updated workflow 'ISB: Service Request Fulfilment workflow for Jira Service Desk' at 'Mon Nov 05 11:53:34 UTC 2018'2018-11-05 11:53:34,790 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'zoepfchen(zoepfchen)' updated workflow 'ISB: Service Request Fulfilment workflow for Jira Service Desk' at 'Mon Nov 05 11:53:34 UTC 2018'2018-11-05 11:53:34,809 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'zoepfchen(zoepfchen)' updated workflow 'ISB: Service Request Fulfilment workflow for Jira Service Desk' at 'Mon Nov 05 11:53:34 UTC 2018'2018-11-05 11:53:36,141 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'zoepfchen(zoepfchen)' updated workflow 'ISB: Service Request Fulfilment with Approvals workflow for Jira Service Desk' at 'Mon Nov 05 11:53:36 UTC 2018'2018-11-05 11:53:36,194 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'zoepfchen(zoepfchen)' updated workflow 'ISB: Service Request Fulfilment with Approvals workflow for Jira Service Desk' at 'Mon Nov 05 11:53:36 UTC 2018'2018-11-05 11:53:36,214 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'zoepfchen(zoepfchen)' updated workflow 'ISB: Service Request Fulfilment with Approvals workflow for Jira Service Desk' at 'Mon Nov 05 11:53:36 UTC 2018'2018-11-05 11:53:36,401 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'zoepfchen(zoepfchen)' updated workflow 'ISB: Change Management workflow for Jira Service Desk' at 'Mon Nov 05 11:53:36 UTC 2018'2018-11-05 11:53:36,449 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'zoepfchen(zoepfchen)' updated workflow 'ISB: Change Management workflow for Jira Service Desk' at 'Mon Nov 05 11:53:36 UTC 2018'2018-11-05 11:53:36,471 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'zoepfchen(zoepfchen)' updated workflow 'ISB: Change Management workflow for Jira Service Desk' at 'Mon Nov 05 11:53:36 UTC 2018'2018-11-05 11:53:36,649 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'zoepfchen(zoepfchen)' updated workflow 'ISB: Incident Management workflow for Jira Service Desk' at 'Mon Nov 05 11:53:36 UTC 2018'2018-11-05 11:53:36,689 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'zoepfchen(zoepfchen)' updated workflow 'ISB: Incident Management workflow for Jira Service Desk' at 'Mon Nov 05 11:53:36 UTC 2018'2018-11-05 11:53:36,703 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'zoepfchen(zoepfchen)' updated workflow 'ISB: Incident Management workflow for Jira Service Desk' at 'Mon Nov 05 11:53:36 UTC 2018'2018-11-05 11:53:36,882 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'zoepfchen(zoepfchen)' updated workflow 'ISB: Problem Management workflow for Jira Service Desk' at 'Mon Nov 05 11:53:36 UTC 2018'2018-11-05 11:53:36,924 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'zoepfchen(zoepfchen)' updated workflow 'ISB: Problem Management workflow for Jira Service Desk' at 'Mon Nov 05 11:53:36 UTC 2018'2018-11-05 11:53:36,939 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'zoepfchen(zoepfchen)' updated workflow 'ISB: Problem Management workflow for Jira Service Desk' at 'Mon Nov 05 11:53:36 UTC 2018'2018-11-05 11:53:37,137 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'zoepfchen(zoepfchen)' updated workflow 'ISB: Jira Service Desk default workflow' at 'Mon Nov 05 11:53:37 UTC 2018'2018-11-05 11:53:37,176 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'zoepfchen(zoepfchen)' updated workflow 'ISB: Jira Service Desk default workflow' at 'Mon Nov 05 11:53:37 UTC 2018'2018-11-05 11:53:37,190 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'zoepfchen(zoepfchen)' updated workflow 'ISB: Jira Service Desk default workflow' at 'Mon Nov 05 11:53:37 UTC 2018'2018-11-05 11:53:37,210 https-jsse-nio-8443-exec-8 INFO zoepfchen 713x7624x1 ccprxl 80.147.221.242 /rest/project-templates/1.0/templates [c.a.j.i.f.config.manager.FieldConfigSchemeManagerImpl] ConfigScheme ISB - Jira Service Desk Priority Scheme (10441). Created with no associated contexts2018-11-05 11:53:38,478 https-jsse-nio-8443-exec-8 ERROR zoepfchen 713x7624x1 ccprxl 80.147.221.242 /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 SQLException for select `AO_54307E_QUEUE`.`ID` from `AO_54307E_QUEUE` `AO_54307E_QUEUE` where `AO_54307E_QUEUE`.`PROJECT_ID` = ? and `AO_54307E_QUEUE`.`NAME` = ? limit ?at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50)at com.querydsl.sql.Configuration.translate(Configuration.java:459)at com.querydsl.sql.AbstractSQLQuery.iterateSingle(AbstractSQLQuery.java:410)at com.querydsl.sql.AbstractSQLQuery.iterate(AbstractSQLQuery.java:342)at com.querydsl.sql.ProjectableSQLQuery.fetchOne(ProjectableSQLQuery.java:397)at com.querydsl.core.support.FetchableQueryBase.fetchFirst(FetchableQueryBase.java:51)at com.atlassian.servicedesk.internal.feature.queue.QueueStore.queueNameExists(QueueStore.java:95)at com.atlassian.servicedesk.internal.feature.queue.QueueManagerImpl.lambda$addQueueUnchecked$9(QueueManagerImpl.java:108)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.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.$Proxy320.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.$Proxy320.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:67)at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.runInTransaction(DatabaseAccessorImpl.java:43)at com.atlassian.servicedesk.internal.feature.queue.QueueManagerImpl.addQueueUnchecked(QueueManagerImpl.java:105)at com.atlassian.servicedesk.internal.feature.gettingstarted.GettingStartedQueueCreationService.lambda$createDefaultQueues$1(GettingStartedQueueCreationService.java:82)at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382)at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499)at com.atlassian.servicedesk.internal.feature.gettingstarted.GettingStartedQueueCreationService.createDefaultQueues(GettingStartedQueueCreationService.java:86)at com.atlassian.servicedesk.internal.feature.gettingstarted.GettingStartedService.createServiceDeskForEmptyProject(GettingStartedService.java:275)at com.atlassian.servicedesk.internal.project.ServiceDeskProjectConfigurator.callGettingStartedServiceToCreateServiceDesk(ServiceDeskProjectConfigurator.java:61)at com.atlassian.servicedesk.internal.project.ServiceDeskProjectConfigurator.lambda$configure$0(ServiceDeskProjectConfigurator.java:46)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:45)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:392)at com.atlassian.jira.bc.project.DefaultProjectService.createProjectInternal(DefaultProjectService.java:377)at com.atlassian.jira.bc.project.DefaultProjectService.createProject(DefaultProjectService.java:347)... 3 filteredat java.lang.reflect.Method.invoke(Method.java:498)at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)at com.sun.proxy.$Proxy523.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.$Proxy523.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 filtered
at com.atlassian.plugins.rest.module.RestDelegatingServletFilter.doFilter(RestDelegatingServletFilter.java:68)... 32 filteredat com.atlassian.servicedesk.internal.web.ExternalCustomerLockoutFilter.doFilter(ExternalCustomerLockoutFilter.java:56)... 13 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)... 5 filteredat 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 filteredat com.atlassian.jwt.internal.servlet.JwtAuthFilter.doFilter(JwtAuthFilter.java:32)... 8 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)... 24 filteredat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)at java.lang.Thread.run(Thread.java:748)Caused by: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2011)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.iterateSingle(AbstractSQLQuery.java:370)... 309 more2018-11-05 11:53:38,722 https-jsse-nio-8443-exec-8 ERROR zoepfchen 713x7624x1 ccprxl 80.147.221.242 /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:395)at com.atlassian.jira.bc.project.DefaultProjectService.createProjectInternal(DefaultProjectService.java:377)at com.atlassian.jira.bc.project.DefaultProjectService.createProject(DefaultProjectService.java:347)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.$Proxy523.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.$Proxy523.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)... 32 filteredat com.atlassian.servicedesk.internal.web.ExternalCustomerLockoutFilter.doFilter(ExternalCustomerLockoutFilter.java:56)... 13 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)... 5 filteredat 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 filteredat com.atlassian.jwt.internal.servlet.JwtAuthFilter.doFilter(JwtAuthFilter.java:32)... 8 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)... 24 filteredat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)at java.lang.Thread.run(Thread.java:748)
Thanks a lot. You're right, it was a problem of database collation. In such a case, it is necessary to create a new database, backup jira, connect the new database and restore the backup.
It looks like you're new here. Sign in or register to get started.
