topic Re: Restore apps in another server in Management & Governance

Restore apps in another server

ennioaoki — Thu, 01 Aug 2019 19:54:09 GMT

Hi, guys.

Here is my scenario: I would like to backup apps (and only apps and objects related to them - like extensions and keep custom sheets to their owners) from a server and restore in another one.

Reason: test of new QS versions before apply in production server and to check if custom extensions broke.

Restrictions: we have tons of apps, there are another users and sensitive info. And we'd like to test the exact app in the new version.

Any tip would be really helpful.

Thanks!

Re: Restore apps in another server

Levi_Turner — Fri, 02 Aug 2019 00:47:06 GMT

So something like this: https://support.qlik.com/articles/000041283 ?

Re: Restore apps in another server

ennioaoki — Thu, 08 Aug 2019 17:58:22 GMT

Unfortunately no.

That KB show how to migrate all data to another server (including topology - nodes -, tasks, security rules, etc). I just need the apps and objects related to them.

Just to make myself clearer: I tried this before but, somehow, the self signed certificate (QlikClient) conflicted with existing server (ServerA is my production server and ServerB is my new one where I restored that backup data from ServerA. Note: both of them are central nodes).

So I thought: if I restore all data in a new server (following the KB), the old one must be shutdown to new one works, is that correct?

If not, I'd like to understand what could caused this.

If so, the KB isn't exactly what I need. I'd like to restore only the apps to, for example, test a new QS version or else, refactor all my security rules.

Thanks in advanced!

Re: Restore apps in another server

Chotana_pou — Fri, 02 Aug 2019 12:26:03 GMT

All your apps are stored in your \\shared\Apps folder

The binary files here are the apps ; you can find the ID in the QMC>Apps>Columns selector and add the ID column

Copy the binaries

Rename all of them as example MyBinary => MyBinary.qvd

Import them in the new environment.

But you won't be able to export and import private users sheets and bookmarks. This is a more complex and unsupported method.

And if you have a lot of apps, then the easiest way is to export one by one the Apps and extensions (even if it's painful).

You can do the same with the API, but as before, the sheets and bookmarks will be lost.

Re: Restore apps in another server

ennioaoki — Fri, 02 Aug 2019 13:38:39 GMT

Yeap, already tried it too, @Chotana_pou .

But, as you said, QMC will generate a new ID to them and all relationship are lost.

I'm just trying to confirm if there is a way to solve this kind of scenario or not.

But thanks anyway!

Re: Restore apps in another server

Giuseppe_Novello — Fri, 02 Aug 2019 19:33:53 GMT

Then unfortunately you did it wrong the process. No, you do no have to shut down the original environment or just keep one, you may have both environment, and the QlikClient cer will be recreate it once you execute the bootstrap step , but yes! you will required to change license to keep both environments live, or else, you will be violating the license agreement. As you said to Chotana solution, "them and all relationship are lost." then Levi suggesting is the best, you will need the database, if you required the apps to be exact what they are in your current environment, since the DB carries the metadata that keeps the apps exactly how they are on your current environment.

Gio

Re: Restore apps in another server

ennioaoki — Fri, 02 Aug 2019 19:47:12 GMT

Thanks for the reply, @Giuseppe_Novello !

Please, could you help me to understand which step in the KB process (or which kind of config) could cause this self-signed certificate conflict?

I think that if I could understand (and, of course, fix it), I'd move one with the KB solution.

Thanks again!

Re: Restore apps in another server

Giuseppe_Novello — Fri, 02 Aug 2019 19:53:02 GMT

Well, to begin with this statement:

" I tried this before but, somehow, the self signed certificate (QlikClient) conflicted with existing server (see attachment - BRSPQLIKSENSE is my production server and BRDCQLIKSENPRX is my new one where I restored that backup data from BRSPQLIKSENSE. "

Why would it conflict? Since the only certificate you need to transfer is the Trusted root with the new hosting name, on step#5. Then the QlikClient will regenerated with the new hosting name once you execute bootstrap ( step#20 under "new server").

Re: Restore apps in another server

ennioaoki — Fri, 02 Aug 2019 20:28:08 GMT

Yeah, that was my starting point to figure out another way to restore apps in another server...

I don't know but that's what's happening when the server is up. It conflicts with the another one.

Since I couldn't understand, I'm trying to import only the apps.

But I'll really appreciate if you could help with one or with the other issue!

Re: Restore apps in another server

Giuseppe_Novello — Fri, 02 Aug 2019 20:32:11 GMT

No, I guess I wasn't clear, you statement is incorrect, since there should not be a conflict of QlikClient certificates, so I am not sure where are you getting the fact that was a cert conflict by following the article steps. The steps are straight and forward, follow the article steps and let us know where you getting stuck.

gio

Re: Restore apps in another server

ennioaoki — Fri, 02 Aug 2019 20:40:32 GMT

Oh, I'm sorry if I misunderstood you...

I'm supposing it due the fact the QlikClient certificate being generated in a server with a host name from the other one (see this attachment from a later post - I'm via TS in brspqliksense and the QlikClient is pointing to brdcqliksenprx).

But I'll uninstall, install it again and let you know!

Re: Restore apps in another server

ennioaoki — Tue, 13 Aug 2019 12:00:03 GMT

Turns out it's related to Windows services user.

In the Qlik's help it's mentioned "We recommend that you use a dedicated Windows user account to run the Qlik Sense services" but, actually, I had to use a dedicated Windows user account.

As QlikClient certificate is personal, user carries them out to AD and conflicts when the same account runs the services on different servers.

Once I use a different service account, the issue is gone.

Re: Restore apps in another server

jp_golay — Tue, 25 Feb 2025 01:55:00 GMT

Have a look at our product ebiexperts WIP and Active Backup, if offer continuous backup for Qlik cloud and on premise with selective restore