topic Re: Re: Error 500 in qlik sense in Management & Governance

Error 500 in qlik sense

Fri, 07 Nov 2014 13:50:47 GMT

Hi all,

Whats mean error 500 when trying open the qmc sense?

Re: Error 500 in qlik sense

JonnyPoole — Fri, 07 Nov 2014 16:04:41 GMT

It could be a few things but better clues will be in the logs. The logs are on the server, typically under c:\programdata\qlik\Sense\Log

There are different kinds of logs, its best to zip up the whole folder and share if you can.

Also is this a new install ? Have you ever been able to access the QMC ? Are there certain conditions (machines, users) that result in this ? PLease provide any of this information.

Re: Re: Error 500 in qlik sense

Fri, 07 Nov 2014 18:07:02 GMT

Hi!

This is a new install and I never acessed the QMC.

The logs are shared.

Re: Re: Error 500 in qlik sense

JonnyPoole — Fri, 07 Nov 2014 18:41:15 GMT

Thank you - there should be additional logs besides proxy. can you forward those ? Please also confirm all 5 qlik sense services are running succesfully too and that you are using IE10 or greater.

Re: Re: Re: Error 500 in qlik sense

Fri, 07 Nov 2014 18:58:02 GMT

Sorry Jonathan, all the logs is attached now.

I'm using IE 11 and the all services are started. How can i know if they are running?

Re: Re: Re: Error 500 in qlik sense

JonnyPoole — Fri, 07 Nov 2014 19:07:26 GMT

Strangely everything but the server and proxy logs are empty. Do you know what happened ? If you find them please attach.

I also saw references to QlikVIew in the log , it may have been just a user name but please confirm that QlikView Server is NOT already installed on this machine. Qlik Sense Server and QLikView server cannot coexist and you would have to uninstall qlik sense server, remove directories and manually remove certificates before reinstalling if that is the case.

Also, i saw some strange domain references in the proxy log as it tried to log you in. Do you remember what you entered at this screen (during the install) ?

Re: Re: Re: Error 500 in qlik sense

Fri, 07 Nov 2014 19:54:31 GMT

Qlikview desktop was installed in the same machine. But I will uninstall this.

In the address machine was entered "unimed-vs.localdomain\qlikview". The "Qlikview" is the user administrator.
It is correct? Full computer name is "SRV-HU-BI02.unimed-vs.localdomain"

I will install sense again and send you the logs.

Re: Error 500 in qlik sense

JonnyPoole — Fri, 07 Nov 2014 20:05:45 GMT

ok. i suggest just using the unqualified machine name.

You don't need to uninstall QlikView Desktop

BUT , there is additional cleanup that MUST be done after uninstall qlik sense before attempting a reinstall..

- delete c:\progamdata\qlik directory

- follow these steps to remove certificates (after these reboot and retest the install)

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.

Re: Re: Error 500 in qlik sense

Fri, 07 Nov 2014 20:41:47 GMT

Hi Jonathan,

Thanks a lot for your help until here.

I deleted the directory and the certificates that you listed.

After I install the sense again, but the same error occurred...

I'm send the logs for you.

Thanks again.

Re: Re: Error 500 in qlik sense

JonnyPoole — Fri, 07 Nov 2014 20:52:10 GMT

Michele - still there are no entries being generated for the repository service which is not good. there should be multiple lines / checks within that key log showing that its started.

See below - all 5 services start successfully , and then in the c:\programdata\qlik\log\repository\<machine>_system_reporitory,log there should be a 'startup phase completed'.

It can take up to 5 mins.. can you just 2x check all of this ? Also please share your windows OS version.

Re: Re: Re: Error 500 in qlik sense

Mon, 10 Nov 2014 11:29:26 GMT

Hi Jonathan!

See the logs attached, now they are there.

I looked the services and all was started.

The Windows server version is 2008 R2

Thank you!

Re: Error 500 in qlik sense

JonnyPoole — Mon, 10 Nov 2014 15:38:57 GMT

michele - can you copy/paste the URL you are using to hit the QMC ? The proxy log is saying the following URLS should be valid. Perhaps you can try the last one ?

https://srv-hu-bi02.unimed-vs.localdomain/qmc

https://localhost/qmc

https://SRV-HU-BI02/qmc

Re: Error 500 in qlik sense

Mon, 10 Nov 2014 16:07:04 GMT

Jonathan,

I tried the URL's but don't work. The message is the same.

The URL that i'm using is:

https://srv-hu-bi02.unimed-vs.localdomain/qmc/

Re: Error 500 in qlik sense

JonnyPoole — Tue, 11 Nov 2014 13:50:05 GMT

Couple other questions:

-is the 'QlikView' account a member of the administrators group on the local machine ?

-Also, you may be logged into the server as a different account when you install the software, if so i have a couple other questions: 1) are you logged in as a member of the administrators group 2) when you removed the certificates following the uninstall, did you log in as the QlikView account to remove the certificates ?

Re: Error 500 in qlik sense

Tue, 11 Nov 2014 15:57:12 GMT

Hi Jonathan!

Yes, the "Qlikview" account is a member of the administrators group on the local machine, and I used this account when installed qlik sense.

Re: Error 500 in qlik sense

JonnyPoole — Tue, 11 Nov 2014 16:18:15 GMT

Ok thanks.

The error still seems to be tied to certificates and i wanted to 2x check that after the uninstall you were able to locate and delete ALL 3 of the certificates correct ?

The next thing i'd like to search is the EVENT VIEWER logs on windows. You can see them from the control panel/administative tools. Search the application and security logs for any errors pertaining to the Qlik Sense services. You may want to bounce (restart) the 5 qlik sense services to see if they generate any errors.

Other questions... you'll need all of these ports open on the machine: 443,4244,4243,80,4248

I'd also like to know if you have CHROME browser installed and if not, it you are willing to install it and test the URL to the QMC in chrome... it sometimes yields more meaningful error messages than IE.

Ps: if you can it might be worth opening a ticket with support, ideally we would just webex through an uninstall, cleanup, reinstall for an hour or so but i don't think i can dedicate the time myself.

Re: Error 500 in qlik sense

milton_forte — Fri, 14 Nov 2014 18:27:46 GMT

Jonathan Poole! Thanks.

His tips were perfect for my case.

Thank you so much.

Re: Error 500 in qlik sense

JonnyPoole — Fri, 14 Nov 2014 18:29:55 GMT

well that is heartening .. thanks

Michelle - just wondering if you had an update . Otherwise, perhaps can you explain more about the platform you are using... Amazon, in house server , VM etc... Any other software installed on the machine ? That kind of thing..

Re: Error 500 in qlik sense

milton_forte — Fri, 14 Nov 2014 18:30:57 GMT

Hello Michele Petersen,

you opened the Ports: 443,4244,4243,80,4248 ?