Setup Qlik server on new Domain.

[jrathgebercs]

Hi All,

We have Qlik Sense server running in old domain. We have taken the repository data base backup and installed Qlik Sense server on new domain. After installation i applied the backup which we have taken from old server and restarted the Qlik server.

I executed all command which i have listed below.

cd "G:\Program Files\Qlik\Sense\Repository\PostgreSQL\14\bin"

Run the following commands in order to drop and then create the database:

Drop database (if one exists):

dropdb.exe -h localhost -p 4432 -U postgres QSR​

Create temp database:

.\createdb.exe -h localhost -p 4432 -U postgres -T template0 QSR​

Restore the database by running the following command:

pg_restore.exe -h localhost -p 4432 -U postgres -d QSR "<Path>\QSR_backup.tar"

Start the Qlik Sense Service Dispatcher.

cd "G:\Program Files\Qlik\Sense\Repository\

Repository.exe -bootstrap -standalone -restorehostname

After That when i am trying to open QMC its open but everything disabled

Could you please suggest me what need to do to enable everything.

Note: In the new domain server. user directory table name will be different.

Regarding,

Irshad Ahmad

[Bhushan_Mahajan]

@jrathgebercs Check if below blog helps your issue.

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Enterprise-on-Windows-and-changin...

[jrathgebercs]

Hi Bhushan,

Thank you . I will go through it.

Regards,

Irshad Ahmad.

[Dana_Baldwin]

Hi @jrathgebercs 

Please note the forum you have posted to is for the Data Integration product Enterprise Manager, used for managing multiple Replicate/Compose/Catalog servers. To reach your target audience, please consider posting your question here: https://community.qlik.com/t5/Qlik-Sense/ct-p/qlik-sense

Thanks,

Dana

[jrathgebercs]

Hi @Bhushan_Mahajan ,

The issue happened when i applied the backup from old domain server to new domain server. The user are on old domain is not a access for new domain. Is there any possibility to update the user directory table or add admin account user temporary to open QMC enable mode. Later we can change the user directory table.?

Thanks,

[Levi_Turner · Accepted solution]

There are two separate questions here, really. Solving either is something that Qlik Support will not resolve for you as the only way to accomplish your secondary goal will be to alter the underlying PostgreSQL database used by Qlik Sense.

Your primary question is how can the QMC not be greyed out. It's greyed out because your user does not have any access to the QMC (since the user did not exist previously). On the old site you have DOMAINA\MyUserId which has an elevated role to perform QMC operations (e.g. RootAdmin). When you log in on the new site you log in as DOMAINB\MyUserID. You can either:

• Supported: Create the user on the old site, assign the needed access rights, restore to the new site again
• Not covered by your support policy: Adjust the underlying PostgreSQL database. Example:

> cd "G:\Program Files\Qlik\Sense\Repository\PostgreSQL\14\bin"
> psql.exe -h localhost -p 4432 -U postgres -d QSR -e
> UPDATE "Users" SET "RolesString"='RootAdmin' WHERE "UserId"='MyUserId';

Your next question will be, do I really need to change ownership of everything? No one can see any bookmarks / etc. The cause is the same. Ownership of content is assigned to a user based on their UserDirectory value (e.g. DOMAINA) and their UserId (e.g. MyUserId). To solve this (and assuming that all user's user id will remain the same on the new domain), you have to adjust PostgreSQL. Example:

> cd "G:\Program Files\Qlik\Sense\Repository\PostgreSQL\14\bin"
> psql.exe -h localhost -p 4432 -U postgres -d QSR -e
> UPDATE "Users" SET "UserDirectory"='DOMAINB' WHERE "UserDirectory"='DOMAINA';

Make sure you have a good backup of the DB 🙂

Also ensure that you restart services after changing the DB (or ideally only have the DB service running).

[jrathgebercs]

Hi @Levi_Turner ,

Thank you very much for sharing the solution. I am getting warning when i am trying to execute below command. could you please suggest on this.

Thanks

[jrathgebercs]

I have stopped all the services except repository still getting error.

Thank you.

[jrathgebercs]

Hi @Levi_Turner ,

Thank you Very Much for your support. I have updated the admin user and now i am able to see my QMC have enabled in new domain. once again thank you for your support.