Greenhopper Sprint report wrong status of issues. How to fix?

Hi!

I've recently discovered a glitch in our jira - greenhopper installation.
It was probably a operating error or a kind of misconfiguration.


We are currently in sprint 12 and everything is fine so far. Greenhopper interacts with Jira in the expected way, but from sprint 1 till 4 there's a mismatch between the status of the stories in Jira and Greenhopper.

Greenhopper matched all stories to "Review" not "Done". "Review" is a custom workflow-step between in "Progress" and "Done".

If you take a look at Greenhopper/Reports/Sprint-report you won't find any completed stories. They're all marked as "Review". There's no further error since sprint 4, remember we're in 12 now, so I assume that our configuration is working fine, at least since sprint 5.

I like to change this state in greenhopper. Is there a way to achieve this?

Thanks for any hints!!

Regards

Michael

1 answer

1 accepted

This widget could not be displayed.
Paul Greig Atlassian Team Jun 18, 2013

Hi Michael,

If I've understood your situation, you could try and the bulk-update functionality.

Simply write an advanced query in the 'Issue Navigator' similar to:

sprint = x and status = review

From the query results, select 'Tools' in the top-right and select the 'Bulk Change' option. From the 'Choose operation' page use 'Transition Issues' and attempt to move the issues to the 'Done' status.

Cheers,

Paul

Hi Paul,

Thanks!

That's exactly what i've tried first. Unfortuantely a bulk change doesn't work, because the corresponding field (Greenhopper/EpicStatus) is locked and not available.

I've raised a support request to update the database. We're using a onDemand installation and aren't allow to access the database itself. Let's hope they'l help.

I assue we need something like ....

update greenhopperTableXYZ set grenhopper.Statusfield = jira.statusfield where jira.status = closed

Cheers

Michael

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Published yesterday in Marketplace Apps

The 7 hacks of highly successful automation

...there's anything I've learnt from working, it's that people are lazy! No offense to anyone reading this, but it's true and we can all admit it. The easier you make something for someone, the more...

95 views 0 8
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you