Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks,
After upgrading to QV11 SR2 last week we have been forced to performed restarts every day. Qlikview server is just not responding, today it showed "No server".
The installation has a separate machine for the QVS which also holds an IIS.
Today the memory usage was very low (4-9 GB) when the server had hanged before it have reached 25 GB.
175 users/ 50 applications
Nothing special is written in the logs. The only thing I see is when it happens is this: qvpx: Exception while handling request
and the 2nd time (when the "No server" message appeared) it hang today it said first
14:11 qvpx: Exception while handling request
and then
14:42 Restart: Server aborted trying to recover by restart. Reason for restart: Internal inconsistency, type D, detected.
Any hints?
Just don't want the customer to force me to reinstall QV9 again but they are discussing it.
/Andy
I see... I have done something similar. I added an additional step to what you describe, and set up a Windows Task to trigger running the batch script. The task is triggered by a "Custom event filter" and the XML for the filter looks something like this:
<QueryList>
<Query Id="0" Path="Application">
<Select Path="Application">
*[System[(Level=2) and (EventID=300)]]
and
*[EventData[Data and (Data='qvpx: Exception while handling request')]]
</Select>
</Query>
</QueryList>
The QVS is automatically restarted when the ERROR event occurs.
Andy, which server did you guys buy? I am considering a dual socket E5-2690 with 256 GB RAM
Hi,
I think that will be fine, same processor as we got two of and things have
been very stable since then.
Got this recommendation:
Intel Xeon E5-2650, Intel Xeon E5-2690 or the older Intel X5690.
Bios settings:
Variable. Setting. How to configure
Hyper threading. Disable. System BIOS setting
Node Interleaving. Enable. Advanced BIOS setting Hardware
pre-fetch. Disable. Advanced BIOS setting
HP Power Profile. Maximum Performance. Power Management Options
Intel Turbo Boost Technology. Enabled. System BIOS setting
Turbo Boost Optimization. Optimized for Performance. Power BIOS
setting
Energy settings:
Change Power Options/Power Plan to High performance
/Andy
Den 26 jun 2013 15:56 skrev "Aji Paul" <qcwebmaster@qlik.com>:
Thank you Andy!
BTW did you guys look into any other processors ?
ex. E5-2687W seems higher performance
Also Intel's naming conventions are super confusing
No problem. No we didn't look into any other.
/Andy
Den 27 jun 2013 18:15 skrev "Aji Paul" <qcwebmaster@qlik.com>:
**
QlikCommunity <http://community.qlik.com/index.jspa> Re: After
upgrading to QV11 SR2 system is unstable created by Aji Paul<http://community.qlik.com/people/ajipaul01>in
Deployment and Management (Server/Publisher/AJAX/IE/Web Parts) - View
the full discussion <http://community.qlik.com/message/361748#361748>