You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Hello Atlassian Community,
After I remove the issue from Jira UI, it still exists in the oracle database, while when you search it in UI you cannot see that issue.
Why does this happen?
How can I remove it completely from the database?
Hi @mahsa ah
What do you mean by remove from UI?
if you delete and issue it will be permanently removed as many of my users have painfully discovered.
if you archive an issue it will not appear in searches. But it is still in the database and can be accessed directly.
Hi @mahsa ah
what do you mean by ‘removed from the dashboard’? It doesn’t sound like an action likely to delete the issue. Do you mean dashboard or a scrum/kanban board?
re EasyBI, did you get an actual error or do you see the fact that the issue is still reported as an error.
Thanks for your attention
I will describe completely what happened.
After the issue was removed from the dashboard, I faced an error during getting a report from eazybi that the issue is still available.
So I checked from the database, and I realized that there was another issue exactly with the same issue number and same project name in the database and both of them did not appear in the dashboard search.
for example mentioned issue was Test-2020, while there was another Test-2020 with different issue types and descriptions in the database, which means now we have two Jira issues with the same id and project name in jiraissue table.
my question is that how it is possible to have the same issue id and project at the same time?
why by removing it in the dashboard, it still persists in the database?
Why are you looking at the database? It's the worst possible way to report on Jira information, and you've almost certainly run into one of the many reasons why here. You've "deleted" the issue in the UI, so everything will be working there (including the REST API), so why are you even looking in the database?