How to allocate a RootAdmin Role after a Qlik Sense migration - Qlik Sense Management Console is greyed out

Daniel_Seo · Mar 2, 2021 11:00:18 AM

During a Qlik Sense migration process, PostgreSQL has been migrated from an old machine to a new machine with a different Domain name and a different Service Account. The migration was successful.

But when accessing the Qlik Sense Management Console (QMC), all functions are disabled and are greyed out. You can make any changes to the setup and no sections are accessible.

The user has lost their RootAdmin role. See Fig 1.

Fig 1 Fig 1

Environment:

Qlik Sense Enterprise on Windows any version

Resolution:

This is a User Directory issue with the RootAdmin role.

For example:

OLD Machine1 (old domain name)
https://machin1.qlik.com/qmc Logged in as QLIK\qvserviceadmin --RootAdmin

New Machine2 (New domain name)
https://machine2.qliksense.com/qmc Logged in as QLIKSENSE\qvserviceadmin

Here, QLIKSENSE\qvserviceadmin was given RootAdmin on a fresh install of Qlik Sense.

But when Importing the database from the old machine to the new database, the new database does not have a record for a user named QLIKSENSE\qvserviceadmin.

You need to manually apply the role for this user. (QLIKSENSE\qvserviceadmin).

Log in QMC using an userID (e.g qvserviceadmin or Administrator or domain Administrator or any user ID)
When logging QMC or Hub, the userID(e.g qvserviceadmin or Administrator or domain Administrator or any user ID) will be inserted on PostgreSQL database
Update RootAdmin role on the userID (e.g qvserviceadmin ) in PostgreSQL database
1. Option #1, Using CMD.exe
  1. Create elevate.sql on C:\"Program Files"\Qlik\Sense\Repository\PostgreSQL\9.6\bin and then put the below commend in elevate.sql file:
```
UPDATE "Users" SET "RolesString"='RootAdmin' WHERE "UserId"='qvserviceadmin';
```
  2. Stop Repository service
  3. Open CMD.exe as administrator and execute the below command:
```
command:   cd C:\"Program Files"\Qlik\Sense\Repository\PostgreSQL\9.6\bin
command:   psql.exe -h localhost -p 4432 -U postgres -d QSR -e -f elevate.sql
```
  4. Start repository service
2. Option #2. Using pgAdmin 4
  1. Download/use pgAdmin 4.
    See Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinti...
  2. Connect PostgreSQL using pgAdmin 4
  3. Go to "Users" table and search userID of the service account
    Server >> QRS >> Database >> QSR >> Schemas >> public >> Table >> Users
  4. Update RootAdmin role on "RolesString" column on "Users" table directly
    or using the below Update commend on SQL command:
```
UPDATE "Users" SET "RolesString"='RootAdmin' WHERE "UserId"='qvserviceadmin';
```
  5. Save the update