Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

qlikplaut
New Contributor II

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

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?

25 Replies
korsikov
Valued Contributor II

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

Attach  the system log files in the following locations:

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

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

qlikplaut
New Contributor II

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

Hello Alexander,

Thanks for your reply. I attached the logs.

Kind regards,

Bogdan

korsikov
Valued Contributor II

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

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

Employee
Employee

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

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 -

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

Untitled.png

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

Gio

qlikplaut
New Contributor II

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

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

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

Sonja Bauernfeind
Senior Technical Support Engineer and Knowledge Centered Support Gremlin


To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
Employee
Employee

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

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

qlikplaut
New Contributor II

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

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

korsikov
Valued Contributor II

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

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

Community Browser