Summary

Advanced Roadmaps for Jira (ARJ) does not show the right values for "Story points". Values can be added in the plan, but are not reflected correctly on the Jira Issue itself.

In addition, other Story Points related functions, like "Progress (story points)" and roll-up of Story Points is not working correctly.

Environment

• Jira Server or Data Center 8.x, 9.x, 10.x
• Advanced Roadmaps for Jira

Diagnosis

• The symptoms match that in the "Summary" section

• When checking the database, the custom field "id" for the "Story Points" field mismatches to the field Id that ARJ uses:

  -- Step 1: Obtain the custom field ID for "Story Points"
  SELECT id FROM customfield WHERE cfname = 'Story Points'
  
  -- Step 2: Obtain the custom field ID that ARJ uses for Story Points:
  SELECT propertyvalue FROM propertynumber WHERE ID IN (SELECT id FROM propertyentry WHERE PROPERTY_KEY = 'GreenHopper.StoryPoints.Default.customfield.id'); 

Cause

• ARJ uses the default Jira Software "Story Points" field for story points calculations, not what the linked board  is configured to use
• ARJ renders the column "Story points" (with a lower case p) rather than the actual field name used for story points JSWSERVER-25071 - Render the "Story points" column name as the Jira field name

Solution

If applicable, you can change the Jira Software default story points field, which will result in ARJ using this field for story points calculation.

1. Obtain the custom field ID of the story points field you wish to use (for example, "Story Points")

   SELECT id FROM customfield WHERE cfname = 'Story Points'

2. Obtain the ID of the propertynumber  row needing update

   SELECT id FROM propertynumber WHERE ID IN (SELECT id FROM propertyentry WHERE PROPERTY_KEY = 'GreenHopper.StoryPoints.Default.customfield.id'); 

3. Update the propertyvalue column of the proprertynumber  table for the ID  obtained in step 2 to the custom field id obtained in step 1

   UPDATE propertynumber SET propertyvalue = '<STORY POINTS CUSTOM FIELD ID FROM STEP 1>' WHERE id = <PROPERTYNUMBER ID FROM STEP 2>