topic Re: Qlik Sense upgrade fail in Management & Governance

Qlik Sense upgrade fail

mnada2012 — Sat, 16 Nov 2024 06:21:09 GMT

Dear Expert,

I am trying to upgrade Qlik sense from 3.1 SR2 to the latest February 2019 version.

I followed all the steps in the manual and seems that everything fine

at first, I had an issue with database superuser but resolved.

Still, I am getting an unknown error during the installation.

Any suggestion what went wrong.

Re: Qlik Sense upgrade fail

crusader_ — Wed, 13 Mar 2019 05:44:34 GMT

Hi,

Log-file says there is no qliksenserepository role created at your PostgreSQL instance, also check if QSMQ db created and ownership is changed to qliksenserepository user (role).

Check upgrade steps carefully

Hope this helps.

//Andrei

Re: Qlik Sense upgrade fail

mnada2012 — Wed, 13 Mar 2019 08:14:02 GMT

Hello Andri,

Thanks for your reply

I checked the role is already there and also I created QSMQ database and assigned the role but I got the same error

I used pgadmin 3 and connect to the local database and created the database as per the upgrade manual.

I attached the new log and screenshot of pgadmin.

Re: Qlik Sense upgrade fail

Bastien_Laugiero — Wed, 13 Mar 2019 08:57:33 GMT

Hello,

Thanks @crusader_ for the log analysis! The error message is misleading and is a known issue.

Upgrading from 3.2 or earlier to Qlik Sense November 2018 or later might not work and will send this error message.

The solution is to take a middle step to upgrade so basically going to Qlik Sense June 2017 or September 2017 first and then upgrade to Qlik Sense February 2019.

More information available here

As mentioned by @crusader_ make sure to follow all the instruction as well as taking a backup prior to upgrading.

Hope this helps!

Re: Qlik Sense upgrade fail

mnada2012 — Wed, 13 Mar 2019 12:14:21 GMT

Hi Bastien Laugiero

I believe you are correct as I checked with one of my friends and he confirms the same that I need to upgrade to June 2017 first then to Feb 2019

the sad part is that I got another error

please note that I already took backup and follow the steps in the manual carefully still getting these unknown errors

can you help?

Re: Qlik Sense upgrade fail

mnada2012 — Wed, 13 Mar 2019 12:22:48 GMT

another attachment also

Re: Qlik Sense upgrade fail

crusader_ — Thu, 14 Mar 2019 01:27:18 GMT

Hi,

Have you restored backup before upgrading to interim version (June201*)?

Something went wrong with PostgreSQL again.

I can't advise anything else rather than contact Qlik Support, because it looks like something went wrong and to find the root cause, someone need to connect to your server.

//Andrei

Re: Qlik Sense upgrade fail

mnada2012 — Thu, 14 Mar 2019 06:27:13 GMT

Thanks for your reply

I restored the VM and everything works fine.

I will try one more time and if it is not working I will raise a ticket to the support

since this is the first time to do that can you please guide me how to raise a ticket to the support. is there a link?

Thanks

Re: Qlik Sense upgrade fail

crusader_ — Thu, 14 Mar 2019 06:39:16 GMT

Hi,
Go to https://support.qlik.com log on with your qlikid and log a ticket, the process is pretty straightforward.
//Andrei

Re: Qlik Sense upgrade fail

spacehaul — Thu, 04 Apr 2019 12:42:30 GMT

Could I get a step by step solution to the above problem? (Since im an amateur and dont really understand a lot of what was said). Would be really appreciated.

Re: Qlik Sense upgrade fail

mnada2012 — Sun, 07 Apr 2019 13:22:53 GMT

the link in the first reply to show you step by step upgrade but you need to upgrade to 3.2 first not to jun 2017

Re: Qlik Sense upgrade fail

Kingjagi — Thu, 05 Sep 2019 13:43:01 GMT

Am running Qliksense Sep 2017, planned to upgrade to Apr 2019.I heard its good to upgrade batch by batch until Apr 2019.

First try. I upgraded to Nov 2018 first. Successful upgrade without issue. But the version of the files installed are still old files. And the QMC and Hub still show Sep 2017.

Second try I upgraded from Sep 2017 to Apr 2018. Again same issue. Successful upgrade but The files in the installation folders are still old. Hub and QMC still shows Sep 2017.

Any idea what could be the problem?

Thanks in Advance.