topic Re: Getting Error when accessing Qlik sense HUB in Management & Governance

Getting Error when accessing Qlik sense HUB

Saif1 — Wed, 19 Jul 2023 09:53:16 GMT

I never had this happen to me before, everything was going fine until i last checked my Qlik sense HUB,

I have Qlik sense enterprise on my device and getting this error when accessing the HUB :

Error requesting "/license/' - Error : Connect ECONNREFUSED ******:****:***::*::**4242

Any solution for this ?

Last thing i have done on my device is i installed Microsoft Powerautomate desktop , is this relatable to the issue ?

Chrome updated
Services working

Thanks

Re: Getting Error when accessing Qlik sense HUB

Chip_Matejowsky — Wed, 19 Jul 2023 10:31:19 GMT

Hi @Saif1,

This error is typically returned due to internet access issues such as a blocked port or disabled cipher suites. Have a look at Qlik KB article Qlik Sense hub fails to connect with: Error requesting "https://SERVERNAME:4242/qrs/license/" Error read ECONNRESET.

Best Regards

Re: Getting Error when accessing Qlik sense HUB

Saif1 — Wed, 19 Jul 2023 11:02:57 GMT

Hello Chip,

I have followed the article instructions , i have checked the ports ( i gave full ports access inbound and outbound) for Qlik sense , and i have applied the "Best practices" for the cipher suites through the 3rd party app that was recommended. and it did not help (Same issue)

Any other help ?

Thanks

Re: Getting Error when accessing Qlik sense HUB

Albert_Candelario — Fri, 21 Jul 2023 08:56:01 GMT

Hello @Saif1,

Is the port 4242 listening and opened as needed.

What about the PostgreSQL, is listening on that IP addressed?

Do you see further errors on the License logs, if yes, please do share those here.

Cheers,

Albert

Re: Getting Error when accessing Qlik sense HUB

Saif1 — Sat, 22 Jul 2023 15:11:46 GMT

Hello Albert,

Here are the licesnse logs :

{"caller":"qrs_client.go:31","error":"Get \"https://localhost:4242/qrs/servernodeconfiguration/local?xrfkey=InHocSignoVinces\": dial tcp [::1]:4242: connectex: No connection could be made because the target machine actively refused it.","level":"error","logTraceId":"4314117e82f1bdc45f81095892419cc1","message":"failed retrieve central node info from QRS (communication error)","timestamp":"2023-07-22T14:54:45.0338903Z"}
{"caller":"qrs_client.go:31","error":"Get \"https://localhost:4242/qrs/servernodeconfiguration/local?xrfkey=InHocSignoVinces\": dial tcp [::1]:4242: connectex: No connection could be made because the target machine actively refused it.","level":"error","logTraceId":"f01d46cccef3d461a56029100522ac8d","message":"failed retrieve central node info from QRS (communication error)","timestamp":"2023-07-22T14:54:57.4095388Z"}
{"caller":"qrs_client.go:31","error":"Get \"https://localhost:4242/qrs/servernodeconfiguration/local?xrfkey=InHocSignoVinces\": dial tcp [::1]:4242: connectex: No connection could be made because the target machine actively refused it.","level":"error","logTraceId":"8972327ed9ce9f193bcf3e4259b82430","message":"failed retrieve central node info from QRS (communication error)","timestamp":"2023-07-22T14:55:09.7613935Z"}
{"audience":"","caller":"middleware.go:101","level":"info","license":"0009550133082615","logTraceId":"fca0260d33fa7a387d3698a3a1679130","message":"http request","name":"V1LicensesOverviewGet","req.method":"GET","req.url":"/v1/licenses/overview?xrfkey=ichbineinberlinR","res.statusCode":"200","subType":"","tenant":"","timestamp":"2023-07-22T14:55:19.7998577Z","userAgent":""}
{"caller":"qrs_client.go:42","level":"error","logTraceId":"eb3667f912f2028ff4c8fae1c75fe685","message":"failed retrieve central node info from QRS. http status code","statusCode":503,"timestamp":"2023-07-22T14:55:21.1090014Z"}

And the Whole file is attached

And here are the CMD screenshots from checking the port :

Can you please check them , it is urgent I need the Qlik sense hub to work before monday.

Thank you so much

Re: Getting Error when accessing Qlik sense HUB

RaviSingh — Fri, 28 Jul 2023 04:05:20 GMT

@Saif1

I am facing the same issue after new installation of QlikSense. Have you got any solution ? If you have resolved the issue kindly share it.

Re: Getting Error when accessing Qlik sense HUB

Saif1 — Fri, 28 Jul 2023 08:57:36 GMT

Hello RaviSingh

I have tried everything, nothing worked on may 2023 version.

The solution was to downgrade so i used the August 2022 version and it worked!!!!!

Try it and report back on this thread if it works for you.

Kind regards

Re: Getting Error when accessing Qlik sense HUB

Albert_Candelario — Fri, 28 Jul 2023 14:03:34 GMT

Hello @Saif1,

Did do check the TLS/SSL set up? do you have a sandbox where the issue could have been reproduced?

Cheers,

Albert

Re: Getting Error when accessing Qlik sense HUB

Saif1 — Fri, 28 Jul 2023 14:07:31 GMT

I have checked everything , i even opened a support ticket with Qlik support and went through all solutions, we landed on that my environment had mashup ports and need to use a new environment , so what i did is that use a new local user and try different solutions, nothing worked even on the new local user, TLS/SSL setup i tried many times and with the conseltation of the Qlik support.

The only method worked is i downloaded the Aug 2022 version of Qlik sense and it worked both on my account and the local user account.

Re: Getting Error when accessing Qlik sense HUB

Saif1 — Mon, 14 Aug 2023 09:33:41 GMT

@Albert_Candelario Hello albert, hope you are doing well,

What i really want to know is that i tried to update to may 2023 again ( i need the background features and the filter new features)
and it did not work , it gave the same error, i thought it is a version issue so i decided to try the beta of the August 2023 , it gave the same issue. but the august 2022 works , did anything changed in the 2023 versions ?

How can i solve this issue without formatting my server or change anything in my environment since 2022 version is working ??

Thanks for your help

Re: Getting Error when accessing Qlik sense HUB

Albert_Candelario — Mon, 14 Aug 2023 12:25:39 GMT

Hello @Saif1,

do you have non default setting on your config files and potentially SSL/TLS settings or similar?

Cheers,

Albert

Re: Getting Error when accessing Qlik sense HUB

Saif1 — Mon, 14 Aug 2023 12:29:22 GMT

Hello Albert,

As you can see from the screenshot , SSL/TLS settings has been put to best practices

And i did not play with the config files , even if i played with the config files, i removed it and reinstalled it 10 times now just to make it work.

Re: Getting Error when accessing Qlik sense HUB

Albert_Candelario — Tue, 15 Aug 2023 13:38:33 GMT

Hello @Saif1,

Seeing this ******:****:***::*::**4242, are you using ipv6 and ipv4? If so, do you have a sandbox where you could try the upgrade again and just allow ipv4 to your machine and see what the outcome is.

Cheers,

Albert

Re: Getting Error when accessing Qlik sense HUB

Saif1 — Wed, 16 Aug 2023 09:18:40 GMT

Both are enabled, I tried disabling ipv6 and no luck there.

unfortunately, i cannot run any sandbox currently, i am stuck on what i am having right now.

Re: Getting Error when accessing Qlik sense HUB

Albert_Candelario — Fri, 18 Aug 2023 06:30:02 GMT

so, you disabled ipv6 and then upgrade and no luck?

what error were you getting when that was done?

Cheers,

Albert

Re: Getting Error when accessing Qlik sense HUB

Proginov — Tue, 03 Oct 2023 07:48:50 GMT

I had the exact same situation.

And I lost 2 days making all possible tests.

In my case, I had my DevServer (W2K16) with QS Enterprise Feb 2023 ( + Update 6). I tried to make the Upgrade to QSE Aug 2023. No error, but stuck on "Upgrading Database Repository". Reboot server, installation resuming, installation success, QMC working, Apps can be open directly through "Apps" menu in QMC.

BUT: no Hub possible, same error as Saif1. I disabled IP v6, same. Check ports, check config (with QlikRepositroyUtil), nothing.

I thought the installer had trouble with the fact I used during a past upgrade the Qlik Postgre Installer to upgrade my 9.6 PSQL to 12.5.

I then tried May 2023 upgrade: same situation. Uninstalling old remaining QSDR services: same situation.

So to get rid of all hypothesis, I took a full backup I tried 2 things:

Restoration an a brand new server (Different hostname): no luck, as the Repository.exe in bootstrap standalone mode could not work (Fatal Error during execution). So I could not finish my restoration, as the new name could not be used... Epic fail.
Complete uninstallation of Qlik Sense AND PostGreSQL on my original server. I had a fresh February 2023 installation done, restoring my 4 databases (QSR/SenseServices/QSMQ/Licences) and my Shared Folder. Everything went fine, QMC and HUB fully functionnal, Apps there, Security Rules too.

So with my original but "brand new" QS February 2023 (IR), I upgraded my PSQL in 14 with QPI. Test afterwards: everything's fine (QMC,Hub,Apps,SecRules).

Last step: upgrade in QS August 2023. Upgrade went fine, no error. But still the same Hub error :

Error requesting "/license/" - Error: connect ECONNREFUSED ::1 :4242

after authentication (Here the message with only IP V4 enabled):

For me too, QMC OK, Apps launching from the QMC, PostGres OK, 4242 listening, and everything is fine in in Feb2023. It appears to me it is really a Hub Application problem during upgrade.

And to be honest, there are WAAAAAY too many logs in QlikSense, with high verbosity in addition, I I don't know where and what to search/find.

What's really ennoying here is that I cannot imagine upgrading my production environement if this happens too.

So it means we are stuck in Feb 2023...

If anyone has an idea of the solution and the cause of this problem, we would be happy to know.

Anyway, we are going to open a case, because we have to know what's going on and how to avoid this in production.

Regards,

Julien

Re: Getting Error when accessing Qlik sense HUB

QHeel — Fri, 03 Nov 2023 13:38:26 GMT

Any news on this topic? I'm failing to upgrade to Aug 2023 with the same ECONNREFUSED error.

Feb 2023 P11 is running fine together with Postgres 14.8, but any upgrade to May or Aug 2023 returns this hub error.

Re: Getting Error when accessing Qlik sense HUB

Proginov — Fri, 03 Nov 2023 13:52:20 GMT

I'v opened a case with Qlik one month ago, and I am still investigating.

The answer is for the moment: "Probably environmental issue", so the error could be caused my server or my domain, but nothing more precise.

I hope you could open a case too, with a link to this post and my Case number (to help Qlik to link both of our cases), in order for them to be able to see any commun point between your problem and mine, and may be find what's going on.

For information, my case number: #00115810

Re: Getting Error when accessing Qlik sense HUB

Proginov — Fri, 24 Nov 2023 10:19:08 GMT

Bonjour,

J'ai des nouvelles!

Il s'agit d'un souci de communication du service Licence qui n'a pas l'air d'apprécier l'IP v6.

En ajoutant une clé de registre, on peut désactiver l'utilisation de l'IP v6, et permettre au QLS de répondre au QRS, et donc d'ouvrir le Hub, ce qui débloque la situation pour MAY/AUG/NOV2023.

Par contre, dans le cas d'une restauration d'un serveur FEV2023 et en dessous avec changement de nom serveur, ne pas créer cette clé, car le process de restauration bloquera sur le Reporistory.exe en mode "-standalone -bootstrap -restorehostname"

Autre point qui était bloquant chez moi: mon serveur 2K16 QSFEV2023 a été traité avec QPI 1.2 a un moment donné, et cela semble poser problême lors de l'upgrade, avec l'installer qui cherche (et réussi) à installer le service QSRD alors que PostgreSQL est DEJA installé en stand-alone. L'upgrade ne se termine du coup jamais.

La bonne solution de mon côté a été d'installer un nouveau serveur 2019 avec un nouveau nom, utiliser IISCrypto, d'installer QS FEV2023, d'utiliser QPI 1.3, de restaurer mon environnement en suivant les documentations Qlik (Certificats, Bases de données, Shared Repository, exécution de Repository.exe en mode bootstrap/restorhostname), de migrer en NOV2023, de désactiver l'IP v6 via la clé de registre, puis de rebooter.

Et là, tout fonctionne 🙂

La clé de registre a créer:

HKLM\SYSTEM\CurrentControlSet\Services\Tcipip\Parameters -> DisabledComponents (REG_DWORD) 0x0000020 (32)

En espérant que tout ceci puisse aider d'autres personnes qui rencontre ce problème lors d'upgrade ou de restauration.

Cordialement,

Julien

Re: Getting Error when accessing Qlik sense HUB

QHeel — Thu, 07 Dec 2023 16:18:39 GMT

Yesss, the registry key did the the trick for me, too!

But it's HKLM\SYSTEM\CurrentControlSet\Services\Tcipip6\Parameters (as depicted)

Now I upgraded from Feb23 P11 to Nov23 P1, added the above mentioned registry key and was able to open the hub 🙂