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

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Wrong Issue Count displayed on a version

Chander Inguva

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

Accepted answers

Matheus Fernandes

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

All comments

Matheus Fernandes

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

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

Chander Inguva

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 (&lt;Project ID's from above query&gt;);

Matheus Fernandes

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.

Chander Inguva

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

Matheus Fernandes

I'll be awaiting!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-software