Issue since applying security updates

[pgrenier]

Good morning,

Has anyone experienced issues with their QlikView 12.0 SR5 server since the installation of the following Windows security updates:

KB4038792

KB4040972

KB4040956

KB4038793

KB4036586

KB4034672

We've been experiencing strange behaviors on Virtual Memory usage on our server, which was very stable before those updates as can be observed using the Governance Dashboard:

Restarting the services fixes the problem for a while, but it is far from a permanent solution

Any insight would be most helpful.

Cheers,

Philippe

[pgrenier · Accepted solution]

Finally, the problem wasn't related to the security updates, that was only a fluke.

The real issue resides when a user toggles a Straight Table to a Pivot Table when there are a lot of dimension columns. The memory balloons up to the maximum available, then the server freezes.

We solved the situation by creating two distinct prepared objects, one pivot table, and one straight table.