Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,461,785
Community Members
 
Community Events
176
Community Groups

After removing the issue it still exists in database

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?

5 answers

2 votes
Tom Lister Community Leader Dec 03, 2022

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.


0 votes
Tom Lister Community Leader Dec 11, 2022

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?

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.

0 votes

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?

0 votes

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

Suggest an answer

Log in or Sign up to answer