Symptoms

1. Internal Server Error occur whenever user click on Issue link in Rapid board

2. Error below has been observe in log

   Feb 7, 2012 10:11:26 PM com.sun.jersey.server.impl.application.WebApplicationImpl onException
   SEVERE: Internal server error
   java.lang.ClassCastException: com.pyxis.greenhopper.jira.fields.NotSupported cannot be cast to com.pyxis.greenhopper.jira.fields.CustomIssueField
   	at com.pyxis.greenhopper.jira.configurations.ScrumDefaultConfiguration.getStoryPointCustomField(ScrumDefaultConfiguration.java:162)
   	at com.atlassian.greenhopper.web.rapid.issue.DefaultFieldsServiceImpl.getStoryPointsCustomField(DefaultFieldsServiceImpl.java:26)
   ...
   

Cause

Default "story points" custom field created upon JIRA Agile installation was removed.

This is a bug introduced in JIRA Agile 5.8.5/5.8.6 which is fixed the (upcoming) 5.8.7 release. In 5.8.7+ the story points field is automatically recreated if it doesn't exist anymore

Resolution

Update the new "story points" id to propertytext table using steps below:

1. Create a new custom field on your instance called 'Story Points' of type 'Number Field'. You might have to re-index JIRA after that.
   
2. Shut down JIRA
3. Backup JIRA database.

4. Find the new Story Points ID via JIRA UI or customfield table.

   SELECT id FROM customfield where cfname='Story Points';
   

5. Find the setting where existing setting has been stored.

   SELECT t.propertyvalue FROM propertyentry e right join propertytext t on e.id=t.id where e.property_key="SCRUM_DEFAULT_TEMPLATE_CONFIGURATION";
   

6. In the propertyvalue column, look for gh.issue.storypoints.

    <entry>
       <string>gh.issue.storypoints</string>
       <string>customfield_10075</string>
    </entry>

7. Update the customfield with new Story Points ID. e.g. if the custom field id = 10010, then the propertyvalue would look like as follows

   update propertytext set propertyvalue ="<map>
     <entry>
       <string>gh.issue.storypoints</string>
       <string>customfield_10010</string>
     </entry>
     <entry>
       <string>gh.issue.story</string>
       <string>8</string>
     </entry>
     <entry>
       <string>gh.issue.rankingfield</string>
       <string>customfield_10072</string>
     </entry>
     <entry>
       <string>gh.issue.labelfield</string>
       <string>customfield_10071</string>
     </entry>
     <entry>
       <string>FIELDCONFIG_SCHEME_ID</string>
       <long>10090</long>
     </entry>
     <entry>
       <string>gh.issue.task</string>
       <string>15</string>
     </entry>
     <entry>
       <string>gh.issue.epic</string>
       <string>14</string>
     </entry>
     <entry>
       <string>gh.issue.businessvalues</string>
       <string>customfield_10073</string>
     </entry>
     <entry>
       <string>gh.issue.flaggingfield</string>
       <string>customfield_10071</string>
     </entry>
   </map>" where id=10345;
   

8. Start JIRA