Issue with "Working Days" Tab in Jira When Timezone is Set to "Europe/Kiev"
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
In Jira, when the timezone for Working Days in the board configuration is set to Europe/Kiev, the board misbehaves. The "Working Days" tab fails to load, and adding new admins results in an error. This issue is reproducible on Data Center. This problem is being tracked under JSWSERVER-25984.
Environment
Problem only occurs if you upgrade from version 8.x/9.x to 9.13 or later. The problem does not occur on fresh installations of 9.13 or later.
Diagnosis
- Navigate to <instance-url>/RapidView.jspa?rapidView=<rapid-view-id>&tab=time.
- Observe that the "Working Days" tab does not load.
- Attempt to add new board administrators, which results in an error.
The following exception is visible at the bottom of the page:
An error occurred
Hide…
Please try refreshing the page, or contact your administrator / Atlassian Support if the problem continues.
Details
Exception: Uncaught TypeError: Cannot read properties of undefined (reading 'regionKey')
Resource: <instance-url>/secure/RapidView.jspa?rapidView=<rapidboard-id>&tab=time
Line: 428
Column: 26573
Environment
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36
Stack trace
TypeError: Cannot read properties of undefined (reading 'regionKey')
at Object.getRegionKeyForTimeZoneId (<instance-url>/s/ce6a7a6a1fe7eca51ac54a3da4bd4b05-T/-ls8imj/9170000/xt0jra/872da0c1a6dad5128755392421efda34/_/download/contextbatch/js/gh-rapid-exception,greenhopper-rapid-non-gadget,gh-rapid-config,atl.general,jira.global,jira.general,-_super/batch.js?_v=cb5d015&agile_global_admin_condition=true&baseurl-check-resources=true&csp_AddGhDependencyCondition=true&csp_IsSysAdminCondition=true&flexboards=true&healthcheck-resources=true&jag=true&jaguser=true&locale=en-UK&slack-enabled=true&user-logged-in=true:52885:65375)
at Object.renderTimeZoneConfig (<instance-url>/s/ce6a7a6a1fe7eca51ac54a3da4bd4b05-T/-ls8imj/9170000/xt0jra/872da0c1a6dad5128755392421efda34/_/download/contextbatch/js/gh-rapid-exception,greenhopper-rapid-non-gadget,gh-rapid-config,atl.general,jira.global,jira.general,-_super/batch.js?_v=cb5d015&agile_global_admin_condition=true&baseurl-check-resources=true&csp_AddGhDependencyCondition=true&csp_IsSysAdminCondition=true&flexboards=true&healthcheck-resources=true&jag=true&jaguser=true&locale=en-UK&slack-enabled=true&user-logged-in=true:52885:64638)
at Object.renderTab (<instance-url>/s/ce6a7a6a1fe7eca51ac54a3da4bd4b05-T/-ls8imj/9170000/xt0jra/872da0c1a6dad5128755392421efda34/_/download/contextbatch/js/gh-rapid-exception,greenhopper-rapid-non-gadget,gh-rapid-config,atl.general,jira.global,jira.general,-_super/batch.js?_v=cb5d015&agile_global_admin_condition=true&baseurl-check-resources=true&csp_AddGhDependencyCondition=true&csp_IsSysAdminCondition=true&flexboards=true&healthcheck-resources=true&jag=true&jaguser=true&locale=en-UK&slack-enabled=true&user-logged-in=true:52885:64447)
at Object.init (<instance-url>/s/ce6a7a6a1fe7eca51ac54a3da4bd4b05-T/-ls8imj/9170000/xt0jra/872da0c1a6dad5128755392421efda34/_/download/contextbatch/js/gh-rapid-exception,greenhopper-rapid-non-gadget,gh-rapid-config,atl.general,jira.global,jira.general,-_super/batch.js?_v=cb5d015&agile_global_admin_condition=true&baseurl-check-resources=true&csp_AddGhDependencyCondition=true&csp_IsSysAdminCondition=true&flexboards=true&healthcheck-resources=true&jag=true&jaguser=true&locale=en-UK&slack-enabled=true&user-logged-in=true:52885:64361)
at q.renderEditScreen (<instance-url>/s/ce6a7a6a1fe7eca51ac54a3da4bd4b05-T/-ls8imj/9170000/xt0jra/872da0c1a6dad5128755392421efda34/_/download/contextbatch/js/gh-rapid-exception,greenhopper-rapid-non-gadget,gh-rapid-config,atl.general,jira.global,jira.general,-_super/batch.js?_v=cb5d015&agile_global_admin_condition=true&baseurl-check-resources=true&csp_AddGhDependencyCondition=true&csp_IsSysAdminCondition=true&flexboards=true&healthcheck-resources=true&jag=true&jaguser=true&locale=en-UK&slack-enabled=true&user-logged-in=true:52885:2651)
at Array. (<instance-url>/s/ce6a7a6a1fe7eca51ac54a3da4bd4b05-T/-ls8imj/9170000/xt0jra/872da0c1a6dad5128755392421efda34/_/download/contextbatch/js/gh-rapid-exception,greenhopper-rapid-non-gadget,gh-rapid-config,atl.general,jira.global,jira.general,-_super/batch.js?_v=cb5d015&agile_global_admin_condition=true&baseurl-check-resources=true&csp_AddGhDependencyCondition=true&csp_IsSysAdminCondition=true&flexboards=true&healthcheck-resources=true&jag=true&jaguser=true&locale=en-UK&slack-enabled=true&user-logged-in=true:52885:1580)
at i (https://dc6gx05b7igp3.cloudfront.net/s/14ce372441b8d103061bdabad7ba4c21-CDN/-ls8imj/9170000/xt0jra/0597a98aff0fed702e673d78e6917ba6/_/download/contextbatch/js/_super,-com.atlassian.plugins.atlassian-plugins-webresource-rest:data-collector-perf-observer,-jira.webresources:resource-phase-checkpoint-init/batch.js?locale=en-UK:123:22860)
at Object.fireWith [as resolveWith] (https://dc6gx05b7igp3.cloudfront.net/s/14ce372441b8d103061bdabad7ba4c21-CDN/-ls8imj/9170000/xt0jra/0597a98aff0fed702e673d78e6917ba6/_/download/contextbatch/js/_super,-com.atlassian.plugins.atlassian-plugins-webresource-rest:data-collector-perf-observer,-jira.webresources:resource-phase-checkpoint-init/batch.js?locale=en-UK:123:23641)
at Object. (https://dc6gx05b7igp3.cloudfront.net/s/14ce372441b8d103061bdabad7ba4c21-CDN/-ls8imj/9170000/xt0jra/0597a98aff0fed702e673d78e6917ba6/_/download/contextbatch/js/_super,-com.atlassian.plugins.atlassian-plugins-webresource-rest:data-collector-perf-observer,-jira.webresources:resource-phase-checkpoint-init/batch.js?locale=en-UK:123:24852)
at i (https://dc6gx05b7igp3.cloudfront.net/s/14ce372441b8d103061bdabad7ba4c21-CDN/-ls8imj/9170000/xt0jra/0597a98aff0fed702e673d78e6917ba6/_/download/contextbatch/js/_super,-com.atlassian.plugins.atlassian-plugins-webresource-rest:data-collector-perf-observer,-jira.webresources:resource-phase-checkpoint-init/batch.js?locale=en-UK:123:22860)Cause
The issue is caused by the outdated timezone identifier Europe/Kiev. The system fails to recognize this identifier, resulting in the error and malfunction of the "Working Days" tab and admin addition functionality.
Solution
Workaround:
Before proceeding, perform a backup of the database.
- Update the value for the timezone directly in the database.
- For PostgreSQL, use the following SQL command:
update "AO_60DB71_WORKINGDAYS" set "TIMEZONE"='Europe/Kyiv' where "TIMEZONE" like '%Europe/Kiev%';
- For PostgreSQL, use the following SQL command:
- To check which boards have been changed, run the following SQL commands:
select * from "AO_60DB71_WORKINGDAYS" where "TIMEZONE" like '%Europe/Kiev%'; select * from "AO_60DB71_WORKINGDAYS" where "TIMEZONE" like '%Europe/Kyiv%'; - Clear cookies in the browser and relogin to see the changes.
Last modified on Jun 24, 2024
Powered by Confluence and Scroll Viewport.