topic Re: Setup Qlik server on new Domain. in Management & Governance

Setup Qlik server on new Domain.

jrathgebercs — Thu, 16 Jan 2025 10:22:22 GMT

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

Re: Setup Qlik server on new Domain.

Bhushan_Mahajan — Thu, 16 Jan 2025 10:59:44 GMT

@jrathgebercs Check if below blog helps your issue.

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Enterprise-on-Windows-and-changing-the-Active/ta-p/1805405

Re: Setup Qlik server on new Domain.

jrathgebercs — Thu, 16 Jan 2025 14:07:05 GMT

Hi Bhushan,

Thank you . I will go through it.

Regards,

Irshad Ahmad.

Re: Setup Qlik server on new Domain.

Dana_Baldwin — Thu, 16 Jan 2025 18:10:28 GMT

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

Re: Setup Qlik server on new Domain.

jrathgebercs — Fri, 17 Jan 2025 14:55:01 GMT

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,

Re: Setup Qlik server on new Domain.

Levi_Turner — Fri, 17 Jan 2025 20:30:30 GMT

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).

Re: Setup Qlik server on new Domain.

jrathgebercs — Sat, 18 Jan 2025 02:55:05 GMT

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

Re: Setup Qlik server on new Domain.

jrathgebercs — Sat, 18 Jan 2025 03:01:19 GMT

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

Thank you.

Re: Setup Qlik server on new Domain.

jrathgebercs — Sat, 18 Jan 2025 14:41:21 GMT

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.