JIRA Agile Documentation

JIRA Agile 6.3
GreenHopper 6.2
GreenHopper 6.1

More...

Agile Knowledge Base Resources

Skip to end of metadata
Go to start of metadata

Symptoms

Custom Agile project template lost after restart or migration.

Cause

Referring to the raised bug: GHS-2276

Resolution

  1. Back up your SQL data
  2. Determine the current GH general settings using a query like:

    SELECT propertyvalue FROM propertytext 
    WHERE id in (SELECT id FROM propertyentry WHERE entity_name='GreenHopper' AND property_key='GH_CONFIGURATION');
    

    Save those results to a file.

  3. Edit the file, add or change to declare 'CUSTOM_TEMPLATES':

    <entry>
      <string>CUSTOM_TEMPLATES</string>
      <string>1274654400681</string>
    </entry>
    

    Please note:If there're multiple custom templates, they should be all declared with separated by a comma, as in:

    <entry>
      <string>CUSTOM_TEMPLATES</string>
      <string>_EXISTING_ID1_,_EXISTING_ID2_,1274654400681</string>
    </entry>
    1. The IDs of existing custom templates can be found with this SQL query:

      select * from propertyentry where entity_name = 'GreenHopper' and property_key like '%CONFIGURATION';
    2. The IDs is listed under the property_keycolumn right before the work 'CONFIGURATION.
      1. Example: 1332882417462_CONFIGURATION has the ID of 1332882417462
  4. Turn the XML output into an update statement by enclosing it an an update statement, for example:

    UPDATE propertytext SET propertyvalue='<map>
      <entry>
        <string>GH_CARD_CREATION</string>
        <boolean>false</boolean>
      </entry>
      <entry>
        <string>GH_NIGHT_SERVICE</string>
        <boolean>true</boolean>
      </entry>
      <entry>
        <string>GH_PROJECT_LIST</string>
        <string>10020,</string>
      </entry>
      <entry>
        <string>GH_FLAG_VALUE</string>
        <string>Impediment</string>
      </entry>
      <entry>
        <string>CUSTOM_TEMPLATES</string>
        <string>1274654400681</string>
      </entry>
      <entry>
        <string>GH_FLAG_FIELD</string>
        <string>customfield_10030</string>
      </entry>
    </map>' WHERE id in (SELECT id FROM propertyentry WHERE entity_name='GreenHopper' AND property_key='GH_CONFIGURATION');
    
  5. Run the SQL statement you've prepared, preferably by "sourcing" the file from within the MySQL command line client.
  6. Restart JIRA to pick up the changes.