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
Next: Root
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
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can't have an issue with the same id in the database, not unless you are using an unsupported database that you shouldn't be.
Again, the best thing you can do is stop looking at the database. It will not work the way you are expecting.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @mahsa ah ,
welcome to the Atlassian community!
I agree with @Tom Lister .Please, could you share what operation you performed on the UI in order to delete issue?
Fabio
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.