Cannot delete Objects due to Inbound references
Platform Notice: Cloud - This article applies to Atlassian products on the cloud platform.
Summary
Due to a known bug, deleting an Object may fail in case it contains more than 714 Inbound references.
JSDCLOUD-12330 - Getting issue details... STATUS
Troubleshooting
Some of the errors are not specific, so in order to identify if the cause may be the number of Inbound references, you can open the Developer tools on your browser and access the Network tab while performing the deletion of the Object.
On our Generating HAR files and analyzing web requests documentation, under Solution, you can find the details of how to access the Developer tools.
As mentioned in the bug, it causes three different errors:
Error 1:
Opening the Dev tools, it shows error 504 and Assets will be inaccessible for a couple of minutes since it can also cause a rate limit (error 429). On the UI itself, it doesn't show any error message.
Error 2:
It will show:
Error
Something went wrong. Contact administratorOn the dev tools, it shows error 500.
Error 3:
It may show the following error:
ERROR: update or delete on table "obj" violates foreign key constraint "fkn9w9mympvwm7xvlg8aegqldvf" on table "obj_attr_val" Detail: Key (id)=(100) is still referenced from table "obj_attr_val".
On this third issue, almost all the references will disappear from the object, and also accessing the objects, won't show the attribute as well.
Only one reference will remain and even removing this reference, will show the above error. After some time, refreshing the page (object) will make all the inbound references appear again.
Workaround/Solution
The Object can be deleted by removing the majority of the inbound references and leaving no more than 714 references, or by removing all of the inbound references from the object.
Since the object will be deleted, we recommend removing all the inbound references.
Bulk removing the references
It's possible to bulk edit the Objects that reference the one you need to delete.
After filtering the Objects, you can click on Bulk actions > Edit objects.
Then, on the Bulk edit screen, select Remove for the attribute. On the dropdown next to it, select the name of the Object that you need to remove the reference.
After clicking on Confirm, you can then access the Object that needs to be deleted and confirm under Inbound references if the references were removed.
Once it’s done, you can delete the Object.
Related Documentation