Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

Qlik Sense moved to a new domain or server name changed: Convert Users To New User Directory

Lisa_Sun
Support
Support

Qlik Sense moved to a new domain or server name changed: Convert Users To New User Directory

Scenarios:

  • Qlik Sene has been migrated to a new domain. Bookmarks are no longer visible for user.
  • Qlik Sense server has been migrated to a new domain or been assigned a new hostname. User records in Qlik Management Console (QMC) refer to the previous user directory, which is no longer valid.


1.png

Accessing users will be identified according to new user directory, which can lead to duplicate user records. Depending on license allocation rules, there is also a risk that the same physical user will get a double user access allocation.


2.png

Please note that if direct assistance is required to implement these changes, Consulting Services will need to be engaged. See How and When to contact the Consulting Team


Related articles:


Qlik Sense: Change hostname (and certificates) after an installation
Qlik Sense and changing the Active Directory Domain name

 

Resolution:


This guide shows how to alter the user directory value by directly accessing the Qlik Sense Repository Database.  In this example the previous user directory OLDDOMAIN has been replaced with NEWDOMAIN.

Please note that if direct assistance is required to implement these changes, Consulting Services will need to be engaged. See How and When to contact the Consulting Team

CAUTION: Direct change in the database are not supported and may cause irreversible corruption. Manual changes to the database must be executed with caution, and the system must be restored from backup at any symptom of system corruption.

  1. Stop all Qlik Sense services, except the Qlik Sense Repository Database
  2. Create a complete backup of Qlik Sense, to allow restoring the site in case of disaster
    Qlik Sense Help - Backup and restore
  3. Connect to Qlik Sense Repository Database as described in article Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense 
  4. Validate that connection is accurate by querying all users
    SELECT * FROM public."Users"
  5. Change user directory name from old domain to new domain
    UPDATE public."Users"
    SET "UserDirectory" = 'NEWDOMAIN'
    WHERE "UserDirectory" = 'OLDDOMAIN';
  6. Validate that intended change has been successfully applied to all affected users
    SELECT * FROM public."Users"
  7. Start all Qlik Sense services
  8. Confirm in QMC that users list shows the new domain as expected

    3.png
  9. Confirm in QMC that license allocation and allocation rules are accurate and match the directory change and allocation expectation

    4.png

  10. Login to Qlik Sense Hub with an authorized user from the “new domain”
  11. Validate in QMC that the user access does not generate any duplicate entries, in the same view as in above steps 8 and 9.
Comments
Lauri
Specialist
Specialist

Do these instructions also apply when I change my user directory from connecting to Active Directory to connecting to an Excel file?

Lauri
Specialist
Specialist

As another option, could I delete my Active Directory UDC (name: 'VRHA') without deleting users and then name my new Excel UDC as 'VRHA'? The AD users are in the Excel file.

Sonja_Bauernfeind
Digital Support
Digital Support

Hello,

 

The same instructions would apply, but we recommend carrying this action out in a test environment prior to touching the production environment as these changes are done on database level, which should only be done with the proper testing done prior as well as with a fallback strategy (backup taken and ready to be restored) in place. 

 

Kind Regards,

Sonja 

Lauri
Specialist
Specialist

Thank you for the assistance, Sonja. I am testing this with a test account. After I go through the steps, I log into Qlik with my test account, and I end up with duplicates:

Lauri_0-1629038910094.png

VRHA is the old directory name. In step 5, I set "UserDirectory" = 'VRHA2'

I use Okta for authentication (and have been for a few years).

Damien_Villaret
Support
Support

@Lauri 

You would need to modify the configuration of the virtual proxy you use for OKTA authentication.

In there, you have a field "SAML attribute for user directory", this needs to be updated to your new User Directory, either as a static string [VRHA2] or as a dynamic SAML attribute (in that case that needs to be set up also in OKTA and included in the SAML assertion)

Version history
Last update:
‎2021-06-21 04:13 PM
Updated by: