Summary

Unable to create customer service project when system language is set to French

Environment

Jira's system language is set to French, Polish, Hungarian

Steps to Reproduce

1. Installed Jira Software 7.6.0 (or you could just use the Core installer too)
2. In System menu (Gear icon -> System -> Edit settings), change system language to French
3. Install JSD to this instance (Gear Icon -> Applications -> Try Service Desk button)
4. Reindex
5. Attempt to create a 'Customer Service' type project
   

Expected Results

New project is created

Actual Results

1. Jira is unable to create this project
2. User sees an error in the browser explaining that something went wrong
   
3. Jira logs show this error:
   Postgres:

   2018-02-06 10:20:33,331 http-nio-5760-exec-9 INFO admin 620x874x1 gwvtsl 0:0:0:0:0:0:0:1 /rest/project-templates/1.0/templates [c.a.jira.workflow.OSWorkflowManager] User 'admin(admin)' updated workflow 'IN: Service Request Fulfilment with Approvals workflow for JIRA Service Desk' at 'Tue Feb 06 10:20:33 CST 2018'
   2018-02-06 10:20:33,379 http-nio-5760-exec-9 ERROR admin 620x874x1 gwvtsl 0:0:0:0:0:0:0:1 /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,27][statuscategory,2][name,Approbation par gestionnaire de modification/évaluation par les pairs][iconurl,/images/icons/status_generic.gif][description,This was auto-generated by JIRA Service Desk during workflow import][id,10118] (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.GeneratedMethodAccessor527.invoke(Unknown Source)
   

   MySQL:

   2018-01-30 23:02:42,284 http-nio-8080-exec-18 ERROR docmind 1382x904x1 1mj3gh7 41.242.88.32 /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,23][statuscategory,2][name,Approbation par gestionnaire de modification/évaluation par les pairs][iconurl,/images/icons/status_generic.gif][description,This was auto-generated by JIRA Service Desk during workflow import][id,10016] (SQL Exception while executing the following:INSERT INTO issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'pname' at row 1)) 
   

For Polish, it shows this:
The Stack trace is a bit different for Polski (Polish):

2018-02-07 17:39:37,597 http-nio-8770-exec-6 ERROR admin 1059x1583x2 sosn62 10.60.2.177 /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,112][statuscategory,2][name,Recenzja współpracownika/zatwierdzanie przez kierownika zmian][iconurl,/images/icons/status_generic.gif][description,This was auto-generated by JIRA Service Desk during workflow import][id,10119] (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)))

Notes

Basically what I think is happening is that the string 'Approbation par gestionnaire de modification/évaluation par les pairs' is too long for the field here (69 characters in length). I think this is a status name in Jira. These appear to be limited to a max of 60 characters for both mysql and postgres instances of Jira. In English I believe this translates to 'Change Manager / Peer Review Approval' (only 37 characters). It appears that Service Desk is trying to do a literal translation in regards to status values and in this case, that string is too long for French and the constraints of the database itself.

Workaround

1. Uninstall the Service Desk from Jira (Gear Icon -> Applications -> select the uninstall option for Service Desk)
2. Change the system language back to English
3. Reindexed
4. Reinstall JSD - Cog Icon -> Applications -> Try Service Desk link
5. In my case I had to restart in order to get JSD to load up properly.

At this point I was then able to create this project in Service Desk, however the status will be in English. While you could convert the system back to French, I do not expect this to change the status names back into a French equivalent. So this work-around is limited in its scope.