Exception getting property 'jira.lf.date.relativize' from database. Using default
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs 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
Problem
Multiple WARN messages on this exception is showing on the logs
The following appears in the catalina.out log
1
2016-03-30 19:22:03,003 http-bio-8037-exec-10 WARN INTERNAL-Admin 1162x1042x1 is9j4t 127.0.0.1 /rest/activity-stream/1.0/preferences [jira.config.properties.ApplicationPropertiesImpl] Exception getting property 'jira.lf.date.relativize' from database. Using defaultDiagnosis
Diagnostic Steps
Run this SQL query on the database to determine whether there is any value set for that
1select * from propertyentry where property_key = 'jira.lf.date.relativize';If there is a value , please proceed to the resolution below :
Cause
It is unclear how this entry is populated in the database as if the user would like to disable relative dates, the only step is to add a line to the jira-config.properties file as per Display standard dates in Jira server
Solution
Resolution
Run the query below to remove the entry from the database and then restart JIRA.
Always back up your data before making any database modifications. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
1
delete FROM propertyentry where property_key = 'jira.lf.date.relativize';Was this helpful?