The Issue
Attempting to delete a domain on the Administration Console;
However, the following error appears:
This usually means the domain is still tied to something else, for example, a realm, a policy, a role, etc
Search the Admin Console for Domain Bindings
The first thing to do is check the obvious places on the Admin Console
Authentication > Realms
Check under the domains column...
If you see it in there (as per the example above), edit the realm and remove it.
Administration>Policies
Check all domain/group/user policies that you may have created or edited recently
Administration>Roles
Check if any roles are tied to a domain
Also, check the permissions of all roles in case the domain is specified as the scope
Configuration>Gateways
Check to see if you can see the domain bound to any message gateway
If you see the domain you wish to delete listed in any of the above place then you will need to edit and remove those associations, then try deleting the domain again.
If however, you cannot find it in any of those locations, then it will need to be manually removed using a series of SQL queries.
Remove using SQL Queries
Go to Platform>Database Servers then click on the blue SQL Console button on the top right.
Obtain the ID of the domain you wish to delete:
select id from domain where name = 'spt.deepnetid.com'
In the example above the domain is called spt.deepnetid.com. Please replace this with the name of your own domain.
Execute the query
In the result we see the id = 5. For future reference this will be refered to as the domain_id
Try and delete the domain by executing the following query:
delete from domain where name = 'spt.deepnetid.com'
You will now see an error which should give details as to why the domain cannot be deleted... for example...
This error tells us that a foreign key constraint fails where the domain_id is referenced in the table role_domain
So we can use the following delete query. (Remember domain_id = 5)
delete from role_domain where domain_id = 5