Exception getting property 'jira.lf.date.relativize' from database. Using default

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

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

Problem

Multiple WARN messages on this exception is showing on the logs  

The following appears in the catalina.out log

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 default

Diagnosis

Diagnostic Steps

  • Run this SQL query on the database to determine whether there is any value set for that

    select * 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 Disable relative dates in JIRA applications

Resolution

Run the query below to remove the entry from the database and then restart JIRA. 

Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.

 

delete FROM propertyentry where property_key = 'jira.lf.date.relativize';

 

 

Last modified on Nov 2, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.