After an upgrade to Jira 6.2.3 (Jira Agile 6.3.12) agile gadgets are no longer available on the dashboard

Ivar

(atlassian-jira_after_restart.log)

We recently upgraded Jira and Jira Agile. After the upgrade, Jira agile gadgets on the dashboard are no longer available. The following warning can be found in the logs:

/secure/Dashboard.jspa [gadgets.renderer.internal.GadgetSpecFactoryImpl] Error occurred while retrieving gadget spec for rest/gadgets/1.0/g/com.pyxis.greenhopper.jira:greenhopper-gadget-sprint-burndown/gadgets/greenhopper-sprint-burndown.xml

The following is seen in the UI:

Error loading gadget from rest/gadgets/1.0/g/com.pyxis.greenhopper.jira:greenhopper-gadget-project-dashboard/gadgets/greenhopper-project-dashboard.xml: org.apache.shindig.gadgets.GadgetException: Unable to retrieve gadget xml. HTTP error 404

System as been re-indexed and restarted.

I have raised an issue with Atlassian support - but I'm trying out here as well.

Pedro Souza

Hello Ivar,

I believe you are facing the problem described on this bug:

• JIRA Agile hangs on installation

Below you can see the same SQL query from one of our test instances affected by the same issue. Note that we have one extra line, which is exactly the one mentioned in the Bug above:

After test the suggested workaround in the bug, everything seems to be working here, but I strongly suggest you to create a test instance for that, since we will modify the database directly. Also, database modifications need to be done with JIRA down, so a test instance will be easier for that, right?

Basically, you need to run the following queries in your JIRA database:

INSERT INTO propertyentry 
VALUES      ((SELECT seq_id 
              FROM   sequence_value_item 
              WHERE  seq_name = 'OSPropertyEntry'), 
             'GreenHopper.properties', 
             1, 
             'GreenHopper.JIRA60.Version.Migration', 
             1); 
			 
INSERT INTO propertynumber 
VALUES      ((SELECT seq_id 
               FROM   sequence_value_item 
               WHERE  seq_name = 'OSPropertyEntry'), 
			              1); 

UPDATE sequence_value_item 
SET    seq_id = (SELECT seq_id 
               FROM   sequence_value_item 
               WHERE  seq_name = 'OSPropertyEntry') 
			                 + 10 
WHERE  seq_name = 'OSPropertyEntry';

I hope it helps.

Cheers,

Pedro Souza.