-
Bug
-
Resolution: Fixed
-
Highest
-
4.2.0, 4.3.0, 4.2.1, 4.2.3
-
22
-
Severity 2 - Major
-
1,619
-
This bug is caused by JIRA Core platform. Please follow:
Issue Summary
JIRA Service Desk 8.2 people module is showing below code for request participant and organization.
- sd.request.participants.field.name
- sd.customer.organisations.field.name
Environment
JIRA 8.2 (Service Desk 4.2)
Steps to Reproduce
- Install JIRA 8.2 with JIRA Service Desk 4.2
- Create a new service desk project and open a ticket
Expected Results
It should show organization and participants under people module
Actual Results
Notes
This behavior also affects JQL search, as they need to be indicated in JQL with the key instead of their usual human-readable name: 
Workaround
-
- is related to
-
-
- Closed
-
-
DELTA-860 You do not have permission to view this issue
- relates to
-
-
- Closed
-
-
DELTA-859 You do not have permission to view this issue
- is mentioned by
-
- was cloned as
-
JSDS-4097 Loading...
| Form Name | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
[JSDSERVER-6396] JIRA Service Desk 4.2 Organization and Request Participant Field Showing Script Instead Of Text
I see the following KEY-FIXER entries in the logs.
2019-08-05 09:29:45,106 JIRA-Bootstrap INFO [c.a.jira.upgrade.UntranslatedKeyFixer] [KEY-FIXER] Setting application property: com.atlassian.jira.upgrade.untranslatedkeyfixer.disabled to true 2019-08-05 09:29:45,501 JIRA-Bootstrap INFO [c.a.jira.upgrade.UntranslatedKeyFixer] [KEY-FIXER] Application property: com.atlassian.jira.upgrade.untranslatedkeyfixer.disabled=true 2019-08-05 09:29:45,518 JIRA-Bootstrap INFO [c.a.jira.upgrade.UntranslatedKeyFixer] [KEY-FIXER] Running untranslated key fixer... 2019-08-05 09:29:45,518 JIRA-Bootstrap INFO [c.a.jira.upgrade.UntranslatedKeyFixer] [KEY-FIXER] Triggering customfield fixer. 2019-08-05 09:29:45,745 JIRA-Bootstrap WARN [c.a.jira.upgrade.UntranslatedKeyFixer] [KEY-FIXER] Fixing customfield [name, description] id: 10002 from [sd.customer.organisations.field.name, sd.customer.organisations.desc] to [Organizations, Stores the organizations that are associated with a Service Desk customer portal requests. This custom field is created programmatically and required by Service Desk.]...
@Maciej Swinarski, I actually only have a demo license (working on a purchase) so not sure I can open a case. I'll try and review the logs to see what I can find.
Hi matt.thompson2, could you please open a support case so we can investigate it. I would like to see your logs, a specially the result of the upgrade task: any log containing "KEY-FIXER" should describe what untranslated keys were found and how they were retranslated. Please have a look at this document to see what should be translated by the upgrade task and what can only be re-translated (like active objects tables) with a special endpoint we have provided: https://confluence.atlassian.com/jirakb/custom-field-names-shows-message-keys-instead-of-values-jraserver-69388-975028931.html
This bug was preventing a marketplace app from working, so I used these commands to update my database (postgresql) directly:
UPDATE customfield SET cfname = 'Request participants' WHERE description = 'sd.request.participants.desc'; UPDATE customfield SET cfname = 'Customer Request Type' WHERE description = 'sd.origin.customfield.desc'; UPDATE customfield SET cfname = 'Organizations' WHERE description = 'sd.customer.organisations.desc';
I too am experiencing what @Chris Gay is seeing. I have a fresh installation on Linux. Please see the following screenshot for an example:
This screenshot is from the two affected fields when looking at a customer ticket.
No problem...
the bug exists since 2015 (https://jira.atlassian.com/browse/JSDSERVER-2326) and Atlassian ist "GATHERING IMPACT" 
After reviewing further, I also see several entries like this which indicate an error.
2019-08-05 11:58:08,516 JIRA-Bootstrap ERROR [c.a.jira.upgrade.UntranslatedKeyFixer] [KEY-FIXER] Error occurred when fixing customfield id: 10002 : java.sql.SQLRecoverableException: Closed Connection. com.querydsl.core.QueryException: java.sql.SQLRecoverableException: Closed Connection at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:39) at com.querydsl.sql.Configuration.translate(Configuration.java:447) at com.querydsl.sql.dml.AbstractSQLClause.close(AbstractSQLClause.java:211) at com.querydsl.sql.dml.SQLUpdateClause.execute(SQLUpdateClause.java:220) at com.atlassian.jira.upgrade.UntranslatedKeyFixer.lambda$tryFixCustomFields$2(UntranslatedKeyFixer.java:210) at com.atlassian.jira.database.DefaultQueryDslAccessor$1.lambda$execute$1(DefaultQueryDslAccessor.java:91) at com.atlassian.jira.database.DatabaseAccessorImpl.executeQuery(DatabaseAccessorImpl.java:74) at com.atlassian.jira.database.DefaultQueryDslAccessor$1.execute(DefaultQueryDslAccessor.java:90) at com.atlassian.jira.upgrade.UntranslatedKeyFixer.tryFixCustomFields(UntranslatedKeyFixer.java:205) at com.atlassian.jira.upgrade.UntranslatedKeyFixer.runOnce(UntranslatedKeyFixer.java:147) at com.atlassian.jira.upgrade.ConsistencyCheckerImpl.checkUntranslatedKeyFixer(ConsistencyCheckerImpl.java:279) at com.atlassian.jira.upgrade.ConsistencyCheckerImpl.initialise(ConsistencyCheckerImpl.java:183) at com.atlassian.jira.startup.DefaultJiraLauncher.postDBActivated(DefaultJiraLauncher.java:166) at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDbLaunch$2(DefaultJiraLauncher.java:146) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:301) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:196) at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:137) at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$start$0(DefaultJiraLauncher.java:104) at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:31) at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:102) at com.atlassian.jira.startup.LauncherContextListener.initSlowStuff(LauncherContextListener.java:154) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLRecoverableException: Closed Connection at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:3247) at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1392) at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1375) at oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:119) at oracle.jdbc.driver.OraclePreparedStatementWrapper.close(OraclePreparedStatementWrapper.java:96) at org.apache.commons.dbcp2.DelegatingStatement.close(DelegatingStatement.java:156) at com.querydsl.sql.dml.AbstractSQLClause.close(AbstractSQLClause.java:209) ... 19 more