Qlik Community

Ask a Question

Deployment & Management

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

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikplaut
Partner
Partner

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
Partner
Partner

Attach  the system log files in the following locations:

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

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

qlikplaut
Partner
Partner
Author

Hello Alexander,

Thanks for your reply. I attached the logs.

Kind regards,

Bogdan

korsikov
Partner
Partner

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

Giuseppe_Novello

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

Giuseppe Novello
Principal Technical Support Engineer @ Qlik
qlikplaut
Partner
Partner
Author

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

Sonja_Bauernfeind
Digital Support
Digital Support

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

Don't forget to Like posts and use the "Accept as Solution" button on content that answered your question! Thanks 🙂
Giuseppe_Novello

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

Giuseppe Novello
Principal Technical Support Engineer @ Qlik
qlikplaut
Partner
Partner
Author

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
Partner
Partner

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