Error when Deleting space

Shafaqut Mohamedali

I was having troubles deleting spaces.  You sent me a long script earlier and it seemed to work for the 20 spaces that i wasn't able to delete.  However, there are two spaces that i can't delete.

https://confluence.atlassian.com/confkb/after-a-failed-space-import-it-s-not-possible-to-re-import-because-of-leftover-space-data-217743668.html 

The Deletion from spaces and deletion from Bandana were the last steps in the scripts

Same Error for both spaces:

Delete From SPACES
Where SPACEID = '27787273'

DELETE From SPACES
Where SPACEID = '26738692'

The DELETE statement conflicted with the REFERENCE constraint "FKlmweu06nft59g7mw1i1myorys". The conflict occurred in database "ConfStaging", table "dbo.CONTENT", column 'SPACEID'.
The statement has been terminated.

 

Shannon S

Can you tell me what database version you're using and what's your Confluence version?

I've found a user that had the same error when trying to purge a space, but they discovered it was due to the following bug, and was resolved when they upgraded:

• CONFSERVER-51806 Cannot purge page

Can you also tell me if the space you're trying to delete was imported from anywhere else, such as a Cloud instance, or another version of Confluence?

Shannon