how to change a bubble chart to a bar chart

[Danielle Sturgis]

I am setting up a dashboard with a chart gadget that shows the created vs completed issues and it is only displaying as a bubble chart. Is there a way to change the chart to a bar chart or pie chart?

[Janet Albion]

Eva,

Moving issue normally not causing this problem. The attachment normally moved together with the issue to another ticket.

[Janet Albion]

Hi Eva,

If the files does exist in the JIRA_HOME/data/attachments/PROJECT_KEY/ISSUE_KEY , it is expected for JIRA to throw error since it can't find it. To confirm if the database is indeed correct, you can run SQL query to double confirm if the issue has attachment associated to it :

SELECT * FROM fileattachment where issueid in (SELECT ID FROM jiraissue where pkey='ISSUE_KEY');

If the association does exist, I do suspect that the files are removed manually.

Good Luck.

-Janet

[Eva]

I already use that SQL before posting the question and saw that there is connection to that ticket with that attachment. The only thing I can think of is that this ticket had been moved by someone before, from one project to another. Would moving ticket cause this problem to occur?