For Enterprise Edition (SQL Server)
Open SQL Server Management Studio (SSMS) or any SQL query editor.

Connect to the Asset DB.

Run the following SQL script:



DECLARE @EmptyTenantControllerId UNIQUEIDENTIFIER = '00000000-0000-0000-0000-000000000000';
;WITH SourceEntityIds AS
(
    SELECT aur.Id AS EntityId
    FROM dbo.ActiveDirectoryUserRole aur
    UNION
    SELECT agr.Id AS EntityId
    FROM dbo.ActiveDirectoryGroupRole agr
    UNION
    SELECT aus.Id AS EntityId
    FROM dbo.ADUserShortInfo aus
)
INSERT INTO dbo.TenantMapping (Id, TenantControllerId, EntityId)
SELECT NEWID(), @EmptyTenantControllerId, s.EntityId
FROM SourceEntityIds s
WHERE NOT EXISTS
(
    SELECT 1
    FROM dbo.TenantMapping tm
    WHERE tm.TenantControllerId = @EmptyTenantControllerId
      AND tm.EntityId = s.EntityId
);
 Once the script completes successfully, the update is done.

For Platform Edition (SQLite)
Before you start
Please make sure you have the database encryption key, as you will need it during the process.

Steps
Copy and save the encryption key somewhere safe.

Stop the Controller service.

Close Leapwork Studio if it is running.

Take a backup of the Assets folder from this location:



C:\Program Files\Leapwork\Assets
 Copy the Assets folder from:



C:\Program Files\Leapwork\Assets
to another location, for example Desktop.
 We will run the database queries on the copied files from that Desktop location.

 Download the attached ZIP file and extract it.

 Run WpfApp2.exe.

 Click Open Database File, then select LEAPWORK.DB.sqlite from the copied Desktop Assets folder, and click Open.

 Enter the saved encryption key and click OK.

 Right-click the TenantMapping table and select Script as SELECT.

 In the SQL editor, replace the generated query with the script below.

Important:
 Before running the script, replace Users_Sqlite_File_Path with the full path of the copied Users SQLite database file (i.e. C:\Users\SachinDevTomar\Desktop\Assets\ LEAPWORK.DB.Users.sqlite) from the Desktop location.



ATTACH DATABASE 'Users_Sqlite_File_Path' AS usersDB;
WITH SourceEntities AS (
    SELECT ADUR.Id
    FROM usersDB.ActiveDirectoryUserRole ADUR
    UNION
    SELECT ADGR.Id
    FROM usersDB.ActiveDirectoryGroupRole ADGR
    UNION
    SELECT ADUS.Id
    FROM usersDB.ADUserShortInfo ADUS
)
INSERT INTO TenantMapping (Id, TenantControllerId, EntityId)
SELECT
    lower(hex(randomblob(4))) || '-' ||
    lower(hex(randomblob(2))) || '-4' ||
    substr(lower(hex(randomblob(2))), 2) || '-' ||
    substr('89ab', abs(random()) % 4 + 1, 1) ||
    substr(lower(hex(randomblob(2))), 2) || '-' ||
    lower(hex(randomblob(6))),
    '00000000-0000-0000-0000-000000000000',
    Id
FROM SourceEntities se
WHERE NOT EXISTS (
    SELECT 1
    FROM TenantMapping tm
    WHERE tm.TenantControllerId = '00000000-0000-0000-0000-000000000000'
      AND tm.EntityId = se.Id
);
 Run the script.

 After the script finishes, copy all updated .sqlite files from the Desktop Assets folder back to:



C:\Program Files\Leapwork\Assets
 Start the Controller service again.