Wrong Issue Count displayed on a version

Hi All,

           I see that there is a wrong count of issues displayed on a project version in version panel view though clicking the version displays issues.

  • Performed Re-Indexing - It did not help

Nothing in logs. Please share your thoughts

 

Regards

Chander Inguva

 

2 answers

1 accepted

1 vote
Accepted answer

I have seen similar problems when there were invalid associations in the nodeassociation table, pointing issues to (in that case components) that didn't exist, but I imagine the same could happen for versions.

I'd suggest reaching out to our support on support.atlassian.com though. smile

Reference: https://confluence.atlassian.com/x/8YCVCQ

Hi Matheus,

                    Just found the database has some missed links.

select count(*) from nodeassociation where sink_node_id not in (select id from projectversion) and association_type = 'IssueFixVersion';

and 

select count(*) from nodeassociation where sink_node_id not in (select id from projectversion) and association_type = 'IssueVersion';

Expected: They should return 0 rows

 

But, its displaying records when executed.

 

Workaround:

delete from nodeassociation where sink_node_id not in (select id from projectversion) and association_type = 'IssueFixVersion';

and

delete from nodeassociation where sink_node_id not in (select id from projectversion) and association_type = 'IssueVersion';

Also i ran these queries to identify which projects have been affected

select COUNT(*) as distinct_issues_in_project, PROJECT from jiraissue 
 where ID IN (select distinct(SOURCE_NODE_ID) from nodeassociation 
where sink_node_id not in (select id from projectversion) and association_type = 'IssueFixVersion') group by PROJECT;

 

and

select ID, pname from project where ID in (<Project ID's from above query>);

 

 

You will need to re-index JIRA after deleting the missing links if that's the case. Let us know if that fixes the issue. :)

Hey Matheus.I will execute that during weekend and let you know.

I'll be awaiting! :)

Hey Matheus. I applied this on Dev and it worked.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,721 views 17 21
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