How to Manually Remove Pending Deployment Sites in Bold BI?

Published:

If you encounter an issue where a site is stuck in Pending Deployment and cannot be deleted, you can manually remove the site from the database by following these steps:

Go to the sites listing page and click on the site name to access the site information.
Copy the Client ID for all deployment pending sites.
Update the copied ID in the Client_id field in the following SQL query and run it in your SQL query tool:

MS SQL Server

UPDATE BOLDTC_Tenant
SET IsDeleted = 1,
    IsActive = 0
WHERE BOLDTC_Tenant.Id in
   (SELECT BOLDTC_TenantInfo.TenantId from BOLDTC_TenantInfo
WHERE BOLDTC_TenantInfo.Id in ('Client_id'));

UPDATE BOLDTC_TenantInfo
SET IsDeleted = 1,
    IsActive = 0,
    TenantStatus = 22
WHERE BOLDTC_TenantInfo.Id in ('Client_id');

PostgreSQL

UPDATE BOLDTC_Tenant
SET IsDeleted = 1,
    IsActive = 0
WHERE BOLDTC_Tenant.Id in
   (SELECT BOLDTC_TenantInfo.TenantId from BOLDTC_TenantInfo
WHERE BOLDTC_TenantInfo.Id in ('Client_id'));

UPDATE BOLDTC_TenantInfo
SET IsDeleted = 1,
    IsActive = 0,
    TenantStatus = 22
WHERE BOLDTC_TenantInfo.Id in ('Client_id');

MySQL

UPDATE BOLDTC_Tenant
SET IsDeleted = 1,
    IsActive = 0
WHERE BOLDTC_Tenant.Id in
   (SELECT BOLDTC_TenantInfo.TenantId from BOLDTC_TenantInfo
WHERE BOLDTC_TenantInfo.Id in ('Client_id'));

UPDATE BOLDTC_TenantInfo
SET IsDeleted = 1,
    IsActive = 0,
    TenantStatus = 22
WHERE BOLDTC_TenantInfo.Id in ('Client_id');

Note: You can add multiple client IDs by separating them with a comma (,) as shown below:

UPDATE BOLDTC_Tenant
SET IsDeleted = 1,
    IsActive = 0
WHERE BOLDTC_Tenant.Id in
   (SELECT BOLDTC_TenantInfo.TenantId from BOLDTC_TenantInfo
WHERE BOLDTC_TenantInfo.Id in ('Client_id', 'Client_id', 'Client_id'));

UPDATE BOLDTC_TenantInfo
SET IsDeleted = 1,
    IsActive = 0,
    TenantStatus = 22
WHERE BOLDTC_TenantInfo.Id in ('Client_id', 'Client_id', 'Client_id');