check if qlikview server services are alive and able to response

[marcus_sommer]

Hi all,

are there any ways to check if qlikview server services are alive and able to response. I don't mean to look into the qmc or to check the services per windows services-check then the checks should be work automatically and a windows services-check queried only if the process is running and no error is communicated to windows - but this doesn't mean that the services worked properly.

I have seen the suggestion to tools like Servers Alive - https://community.qlik.com/message/196427#196427 - but I'm not sure if this isn't too comprehensive for me then I want not monitor anything I want only to be able to notice if the services aren't response anymore - to restart the services or the machine.

Maybe there are settings within the qmc or directly within the settings.ini which could do or at least support it.

In my old environment I have had a routine which checked each 6 hours if users are active on the access point (per reading the session logs) and if not restart all services - but I don't want to use such routines anymore. I have thought to something like to ping the services - is this possible? Are there other (easy) ways? How do you handle this topic?

- Marcus

[markodonovan]

Hi Marcus,

Here are 2 other tools that might be useful :

PsPing

You can ping your ports, for example

psping -t orbis-clik:4799

Also, the sc command you can check that services are running.

https://technet.microsoft.com/en-us/library/bb490995.aspx

Thanks

Mark

http://techstuffy.tv

[marcus_sommer]

Hi DataNibbler,

like above mentioned I want to avoid or at least to minimize own created macro-stuff or similar routines/tasks which is even for me hard to maintain over a longer period. I need to use more standardized logics which could other (intern and extern) people support and maintain. Our environment is grown a lot over the last years and I couldn't and I don't want to do everything by myself. Therefore I must simplify everything - and an kind of automatic control if the services are alive is one step of them.

Regarding to official statements from qlik there should no need to restart the server services on a regulary basis - in my old environment this didn't worked because there was a RAM leak but I want to give the new release (SR12) a chance to show that it now worked. And I must say that since them the server service was very stable, no problems with RAM or others and for a few crashes was me and my colleague responsible because we worked parallel on the server. Further I had have thought by these checkings in an interval from a few minutes and not many hours.

Now I'm beginning to test the qlikview server super agent from the power tools and it looked very good after the first trial. For each services will be a log-file generated and I think I will this log-file use by reading it with qlikview fat-client to the max. timestamp and if now() - timestamp > X i will start per execute-statement a batch-file.

If this worked I will report it here.

- Marcus

[Anonymous]

I just knocked up this qv load script out of academic interest :

html:

LOAD

    [head/title] as title

FROM [http://YourAccesspointurl] (XmlSimple, Table is [html]);

replace YourAccesspointurl as per your set up.

If your Accesspoint is alive it should return a single row, with single column [title], with value QlikView - AccessPoint

You said you need to check if services "are able to respond" and this could be used to check a correct response is indeed being returned.

[marcus_sommer]

It's a very interesting approach and it worked (if the service is down an error occured which could be handled with the error-mode) for the access point and for the qmc:

QMC:

LOAD [body/id] as BodyID

From http://QVserver:4780/qmc/About.htm (XmlSimple, Table is [html]);

but not (directly) for the server/distribution/directory services or have I missed something?

- Marcus

[Anonymous]

I expect it just identifies the AccessPoint status as per what you found and you seem to have also ot it working for the qmc as well.

Time permitting I may have a poke around the other bits later out of academic interest.

[#7]

There is a simple status check option built into the server.  Try http://localhost/QvAjaxZfc/QvsStatus.aspx

Here is section from Server Reference Manual, page 104.  It mentions clusters but works fine with single node.

Availability Checking

A special web page on the AccessPoint provides automated checking of the system status:

http://myAccessPoint/QvAjaxZfc/QvsStatus.aspx

This page returns an http status code of 200, if the AccessPoint and at least one QlikView Server in the cluster respond. Any other status code returned by this page should be considered an error. Common errors from this page include:

404: The AccessPoint is unable to respond. Check the web server.

503: No QlikView Servers responded to the AccessPoint and therefore it cannot service user requests.

The status of the QlikView Server cluster is also displayed on the web page:

[marcus_sommer]

Yes, this worked for for the QVS services and the same approach should work for the other services, too. On the top of the qmc you get the (red) message-line "n of 4 services are down" if any of services don't work - maybe this could be also read but which url will be needed?

- Marcus

[#9]

Hi Bill,

How to check the status using the above code in Qlikview File? If we reload the Qlikview code, it will be failed when the services are down?

could you please explain.

[Anonymous]

Hi Bill,

I have used the following script to check if access point is alive.

LOAD

   [head/title] as title

FROM http://access point URL(XmlSimple, Table is [html]);

It gave me "QlikView - AccessPoint".

When access point is alive , after running above script it gave "QlikView - AccessPoint" and when QVS is stopped the above script is giving the same result.

How will i know if access point is down.

Regards,

Saugat

[Anonymous]

Since this thread from 2015 I have fully migrated to Qlik Sense, so no longer have a QlikView environment to work on.