Administrator

Deleting Workspaces

Before you delete a workspace, remove all applications running in the workspace and unassign all users from the workspace.

Prerequisites

Back up the database.

Context

Procedure

  1. In the Web UI, log in as a user who has the ADMIN role, and who is assigned to the workspace you want to delete.
  2. Navigate to the Set Up Default Menu page.
    1. Remove all applications assigned to the default menu.
    2. Approve the default menu.
  3. Go to the Assets page, and remove all applications from the workspace.
  4. Navigate to the Manage User page, and unassign all users from this workspace, including the user who logged in.
    If the logged-in user is assigned only to this workspace:
    1. Assign the logged-in user to a different workspace.
    2. Unassign the logged-in user from the current workspace.
  5. Using the database management tool, log in to the database, and delete the workspace data.
    1. In the M_CLIENTS table, find the workspace ID (for example, 200). The workspace name is in the NAME column.
    2. In the M_CLIENT_MSISDNS table, find the ID where CLIENTS_ID = 200. In this example, M_CLIENT_MSISDNS.ID = 222.
    3. In the M_MESSAGE_LOG table, delete all rows where CLIENTS_MSISDNS_ID = 222.
    4. In the M_CLIENT_MSISDNS table, delete the row where ID = 222.
    5. In the M_SESSIONS_ACTIVE table, delete all rows where CLIENTS_ID = 200.
    6. In the M_SESSIONS table, delete all rows where CLIENTS_ID = 200.
    7. In the M_MESSAGE_RECEIVERS table, delete all rows where CLIENTS_ID = 200.
    8. In the M_MENU_PAGES table, get the value of ID where CLIENTS_ID = 200. In this example, M_MENU_PAGES.ID = 444.
    9. In the M_MENU_PAGES_LANGS table, delete all rows, where ID = 444.
    10. In the M_MENU_PAGES table, delete all rows where CLIENTS_ID = 200.
    11. In the M_CLIENTS table, delete the row, where ID = 200.