topic Re: Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console in Management & Governance

Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

qlikplaut — Mon, 22 Sep 2014 11:44:20 GMT

Hello everyone,

I'm trying to install Qlik Sense Server on my laptop, but I must be doing something wrong because after installation completes I cannot log in to QMC. All services are running and I have tried accessing QMC from IE and Chrome, both show the same error message. I am running win 8.1. Would it be related to a certificate?

Any ideas?

Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

korsikov — Mon, 22 Sep 2014 11:58:53 GMT

Attach the system log files in the following locations:

l %ProgramData%\Qlik\QlikView\Log\Proxy

l %ProgramData%\Qlik\QlikView\Log\Repository

Re: Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

qlikplaut — Mon, 22 Sep 2014 12:05:10 GMT

Hello Alexander,

Thanks for your reply. I attached the logs.

Kind regards,

Bogdan

Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

korsikov — Mon, 22 Sep 2014 12:23:42 GMT

Are you sure that all services are up and running normally?

Try to restart the service click sense, and even better server and try over again.

information in the log indicates the inaccessibility of services

Error when requesting service alive response from 'https://catalinnastase.10.1.10.in-addr.arpa:5151/qss/'. The remote name could not be resolved: 'catalinnastase.10.1.10.in-addr.arpa'

Error when requesting service alive response from 'https://catalinnastase.10.1.10.in-addr.arpa:4243/qps/'. The remote name could not be resolved: 'catalinnastase.10.1.10.in-addr.arpa'

When contacting https://localhost:4242/ No connection could be made because the target machine actively refused it 127.0.0.1:4242

Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

Giuseppe_Novello — Mon, 22 Sep 2014 12:53:12 GMT

Bogdan,

Yes, it could be related to digital certs. try to restart the services at least 2 times so it can sync up with Qlik Sense management. If that does not work, try the following:

Here is the process to find and possibly recreate the certificates if you need to -

Stop Qlik Sense Repository Service (this will also stop the other services)
Open Microsoft Management Console (MMC). Important: Run this as the account configured to run the services (Run as... )
Add snap-in for Certificates: My user account and Local Computer account
In Certificates - Current User > Trusted Root Certification Authorities > Certificates, delete the certificate created by QlikSense, issued by your computer, computer.domain-CA
In Certificates > Current User > Personal > Certificates, delete the certificate named QlikClient
In Certificates (Local Computer) > Personal > Certificates, delete the certificate issued by computer.domain-CA.
Start Qlik Sense Repository Service and verify it created the new certificates
Start the rest of the services

There's no need to do a full reinstall to propagate new certificates. They are being created by the Repository Service automatically if missing.

Cannot connect to Qlik Sense server

Gio

Re: Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

qlikplaut — Mon, 22 Sep 2014 13:23:40 GMT

Hello Gio,

Thank you for the reply. I tried deleting the certificate and restarting the services a couple of times. After this, a new QlikClient certificate was posted to Personal-Certificates but not replicated in Trusted Root Certification Authorities (is this by design?). I copied the certificate from Personal to Trusted, but this did not fix the error message, I still get error 500.

Kind regards,

Bogdan

Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

Sonja_Bauernfeind — Mon, 22 Sep 2014 13:41:05 GMT

Hello Bogdan,

I would recommend you bring this to our Technical Support, should the information you've received here not help just yet. Keep in mind that licensed Qlik Sense Server installations are fully supported by Qlik, and we are looking forward to hearing from you there.

Kind Regards,

Sonja

Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

Giuseppe_Novello — Mon, 22 Sep 2014 14:16:25 GMT

Bogdan,

I agree with Sonja, go head and open a support ticket ( if you have a Qliksense license, if not let us know here) However, it seems that the issue the trusted root is not generating the "CA" certificate. for any chance, do you have a long list of certificate under trusted root?

Gio

Re: Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

qlikplaut — Mon, 22 Sep 2014 17:04:32 GMT

Hello Sonja,

Thank you for replying. We will get the Sense Partner License this week, but I wanted to have the Server prepared. Never got to the screen where I could enter the license code though

I will submit the case once I have the licenses, but hopefully I'll manage to fix it until then.

@ Gio, I have 37 certificates listed in Trusted Root.

@ Alexander, I also saw the error messages but I cannot figure out why that happens. I have copied the QlikClient certificate from Personal to Trusted Root, restarted the services and they look fine.

I know for sure it's just a little thing somewhere, I just need to figure out what. It is not so urgent or business impacting, but thank you everyone for your help and interest.

Kind regards,

Bogdan

Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

korsikov — Tue, 23 Sep 2014 06:47:21 GMT

I think Cetificate - personal - certificate is not what you need. Certificate in the trusted zone of the other. They do not replace each other.

in trusted zone certificate have description - host,domain.com-CA

All issuance policies

All application policies

and personal certificate - host.domain.com

All application policies

In any case, should help re-create the certificates provided by Gio instructions

Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

p_verkooijen — Tue, 23 Sep 2014 12:24:04 GMT

Same issue here, but I believe it's related to the PostgreSQL because of several errors in my Windows Application Eventlog.

Server was a QV Next machine, uninstalled QV Next and removed all remaining folders (C:\ProgramData\Qlik , C:\Program Files\Qlik)

QV Sense Installer installed succesfully.

Event log :

The description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

ERROR: relation "EdmMetadata" does not exist at character 55

STATEMENT: SELECT

"Extent1"."Id",

"Extent1"."ModelHash"

FROM "EdmMetadata" AS "Extent1"

ORDER BY "Extent1"."Id" DESC

LIMIT 1

Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

p_verkooijen — Wed, 24 Sep 2014 08:48:10 GMT

Just checked the certificates on the QV Sense server,

Since the servername also changed from QVNext to QVSense there were several old QVNext certificates existing. And no QVSense certificates.

Removed all found certificates, after restarting the services qvsense certificates were generated. However the QMC and Hub were not functional (webpage does not exist).

Started the QVSense server installer and did a Repair installation, after this installation the QMC works !

Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

Michael_Tarallo — Tue, 30 Sep 2014 20:20:57 GMT

Hi Bogdan,

Would you happen to have Skype running on the same machine, possibly using ports 443 or 80?

Regards,

Mike

Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

qlikplaut — Wed, 01 Oct 2014 09:36:59 GMT

Hi Mike,

I do have Skype running on the same machine. I unticked the option to use those specific ports and ran the Repair Installation but it did not change anything.

I also tried to install the Server on a different machine, the result was the same. Same error message, same certificate (only in personal but not in trusted).

Kind regards,

Bogdan

Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

Michael_Tarallo — Wed, 01 Oct 2014 11:52:25 GMT

Hi Bogdan - let me know what support finds.

Can you perform this process following these:

Log into whatever ID you originally installed as and uninstall Qlik Sense from the Add / remove programs
Delete everything here: C:\ProgramData\Qlik
Remove any old certificates as previously discussed
Log out
Create an admin equivalent account such as sense_system - as per the Quick Install Guide - (below)
log in and use the sense_system account you just created - not your id.
Perform the Custom install not the Quick Install
Check the box to Enter in your Service credentials
a. Enter the domain\username ex. computer_name\sense_system
b. Leave Central Node checked
c. Click Next

Let me know

Just in case - here is the videos:

Qlik Sense Platform - (Server) Installation (video)

Qlik Sense Platform - Token Licensing and Assigning Access Passes (video)

Qlik Sense Quick Installation Guide

Allocating Access Passes Information Guide

Main: New to Qlik Sense Platform Videos

Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

Anonymous — Wed, 01 Oct 2014 13:39:09 GMT

Hi Bogdan,

- Did you install the Qlik Sense Desktop to the same machine? If yes, just uninstall and then clear the certificates (2 in each category, personal and computer). Then try reinstalling the Qlik Sense server only(after proper restarts of the server).

- Did you install with a local user or a domain user? If with domain user, try using a local admin local user.

- Are you trying to access with a local user or domain user? Try logging in with a local user (the one that starts the services). That way it should work; otherwise we get the same error with a domain user. Plus, if it's your first time to login, the domain should be defined so it would be kinda normal to get that error.

Serhan

Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

Caique_Zaniolo — Tue, 21 Oct 2014 15:36:54 GMT

Hi Bogdan,

I had the same issue installing Qlik Sense on a VM.

I noticed the installed prompted me for a Host Name.

I edited the address and removed the .localdomain, leaving just the machine name as a host name.

Everything worked after that.

Please let us know if that fixes your issue.

Regards

Caique

Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

aparnanair1405 — Fri, 22 Apr 2016 15:01:09 GMT

Hi Caique,

This also helped me resolve "Error 404 - Not found Cannot establish a connection to Qlik Sense: Qlik Sense Management Console" after resolution.

Thanks,

Aparna

Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

gainkarthi — Mon, 25 Apr 2016 19:47:56 GMT

What version are you using. if it's 2.2, there is a known issue, services will run, but portal will not come up.

Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

image242 — Wed, 27 Jul 2016 14:48:27 GMT

Thanks Giuseppe,

This solved my problem. Turns out I was running QlikSense 2 as a different service account when I upgraded to 3.0.1.

Jason