Transition Summary Displays Invalid Period for 'Time In Source Status'

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

JIRA Suite Utilities activated in the 'Transition Summary' shows an invalid time-period for certain events.

 

Cause

The cause will be related to an earlier import with a 'yy' created date.

Workaround

If the issue is recognised immediately, you can edit the data being imported to ensure the year format is 'yyyy'

Resolution

  • Request support.atlassian.com to update the database directly on your behalf
  • You will need to identify the affected issues within your support ticket
  • Support will run a query similar to the below

    UPDATE jiraissue SET created = created + '2000 years'::interval where id = <selection of issues provided> ;
    
Last modified on Feb 26, 2016

Was this helpful?

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