Unable to delete tenants

Products

• CA Performance Management
• Network Observability

Issue/Introduction

When i tried to delete tenant from Manage Tenants, I got "Unable to delete one or more tenants. Try again or contact your system administrator."

 

Cause

These were created to be non-removable.

Resolution

You can do the following in MySql, to set all tenants, except for the default tenant, as removable

1. Login to MySql  /opt/CA/MySql/bin/mysql -uroot -p   and then run the following

        update t_tenant set TenantFlags = 2, ChangedOn = UNIX_TIMESTAMP() where itemid != 8;

        This will make all tenants except Default Tenant removable.  DT should never be removable.

2. To see current flags on each tenant:

        select itemid, itemname, tenantflags from t_tenant;

3. Run the following, after running the above update command

        update items set UpdatedOn = UNIX_TIMESTAMP() where itemtype = 2 and itemid != 8 and itemid != 3;