Qlik Community

Qlik Scalability

A group dedicated to advancing Qlik scalability and performance. In this group we will share knowledge on how to perform load tests of Qlik products.

CREATE A POST
Post a Question
  • Recommended Server Logging Configuration

    Hi All,Please suggest recommended Logging Services to be enabled for best performance for the QlikSense Dashboard response time. We are capturing Dash... Show More

    Hi All,

    Please suggest recommended Logging Services to be enabled for best performance for the QlikSense Dashboard response time. We are capturing Dashboard and sheet level audit as part of our usage dashboard. Apart from these logs we rarely use other logs, 

    Kindly recommend the what logging service can be enabled at what level for best usage.

    Regards

    Krishna Kumar S

    Show Less
  • Qlikview UI Automation

    Do we have any new tool in market to automate the QV UI and functional testing?I explored selenium and Jmeter. Both do not have complete capability to... Show More

    Do we have any new tool in market to automate the QV UI and functional testing?

    I explored selenium and Jmeter. Both do not have complete capability to automate/simulate all scenarios and controls.

    Any help on this would be appreciated.

    Show Less
  • Test the qlikview dashboard

    How to test the Qlikview dashboard
  • AppEvaluator runs for a long time

    I have been scanning a lot of apps recently to get an everview of what is on the platform. Most run ok, some with errors, but a few run for a very lon... Show More

    I have been scanning a lot of apps recently to get an everview of what is on the platform. Most run ok, some with errors, but a few run for a very long time with a massive number of requests, running into thousands. One app can keep processing for over 24 hours. What type of design elements would lead to such an excessive test and is there anything we can do to stop it if the design is not actually faulty?

    Show Less
  • AppEvaluator logging entries under both AppID and AppName

    When I look at the results the files have the ID in the app name column for the first 10-20 rows and then it has the name after that. When I load the ... Show More

    When I look at the results the files have the ID in the app name column for the first 10-20 rows and then it has the name after that. When I load the results in QSAEanalyzer each file then shows as two different app names.

    Show Less
  • Best practice workload profile für HPE Proliant Gen10 hardware

    Hello.Would anybody be so kind to review the available workload profiles for the new HPE Proliant Gen10 Hardware.As for my understanding the profile "... Show More

    Hello.

    Would anybody be so kind to review the available workload profiles for the new HPE Proliant Gen10 Hardware.

    As for my understanding the profile "high Performance Cumpute" will fit the needs?

     

    Spoiler
    Workload Profiles
    Workload Profiles and performance options
    Workload Profiles is one of the HPE Intelligent System Tuning (IST) features and allows you to tune the
    resources in your HPE ProLiant server by choosing a pre-configured workload profile. The server will
    automatically configure the BIOS settings to match the selected workload.
    System provided Workload Profiles
    The system provides these Workload Profiles:
    General Power Efficient Compute
    This profile is the default profile for most ProLiant servers and HPE Synergy compute modules.
    This profile applies the most common performance settings that benefit most application workloads while
    also enabling power management settings that have minimal impact to overall performance. The settings
    that are applied heavily favor a balanced approach between general application performances versus
    power efficiency.
    This profile is recommended for customers that do not typically tune their BIOS for their workload.
    General Peak Frequency Compute
    This profile is intended for workloads that generally benefit from processors or memory that must achieve
    the maximum frequency possible, for any individual core, at any time. Power management settings are
    applied when they ensure that any component frequency upside can be readily achieved. Processing
    speed is favored over any latencies that might occur. This profile is a general-purpose profile, so
    optimizations are done generically to increase processor core and memory speed.
    This profile benefits workloads that typically benefit from faster compute time.
    General Throughput Compute
    This profile is intended to be used for workloads where the total maximum sustained workload throughput
    is needed. Increased throughput does not always occur when the processor runs at the highest individual
    core speed. Increased throughput can occur when the processor is able to perform sustained work across
    all available cores during maximum utilization. Power management settings are disabled when they are
    known to have impact on maximum achievable bandwidth.
    Best throughput is achieved when the workload is also (Non-uniformed Memory Access) NUMA aware
    and optimized so settings that benefit NUMA awareness are applied.
    Virtualization - Power Efficient
    This profile is intended to be used for virtualization environments. The profile ensures that all available
    virtualization options are enabled. Certain virtualization technologies can have possible performance
    impacts to nonvirtualized environments and can be disabled in other profiles. Power management settings
    can have an impact on performance when running virtualization operating systems and this profile applies
    power management settings that are virtualization friendly.
    Virtualization - Max Performance
    This profile is intended to be used for virtualization environments. The profile ensures that all available
    virtualization options are enabled. Power management settings are disabled in favor of delivering
    maximum performance.
    Low Latency
    This profile is intended to be used by customers who desire the least amount of computational latency for
    their workloads. This profile follows the most common best practices that are documented in the HPE Low
    4 Workload Profiles
    Latency Whitepaper. Maximum speed and throughput are often sacrificed to lower overall computational
    latency. Power management and other management features that might introduce computational latency
    are also disabled.
    The profile benefits customers running Real-Time Operating Systems (RTOS) or other transactional
    latency sensitive workloads.
    Mission Critical
    This profile is intended to be used by customers who trade off performance for server reliability above the
    basic server defaults. The profile enables advanced memory reliability, availability, and serviceability
    (RAS) features that are known to have more than a measurable impact to computational performance.
    Enabling this profile will have an impact to maximum memory bandwidth and will increase memory
    latency.
    Transactional Application Processing
    This profile is intended to be used for business processing environments, such as online transaction
    processing (OLTP) applications that require a database back-end. For example, workloads typically
    comprised of a high number of user-based, transactional applications running on a single server with
    cohosted database component. The profile balances the requirement of managing both peak frequency
    and throughput.
    High Performance Compute (HPC)
    This profile is intended for customers running in a traditional HPC environment. Typically, these
    environments are clustered environments where each node performs at maximum utilization for extended
    periods of time to solve large-scale scientific and engineering workloads. The default for our Apollo series
    servers, power management is typically disabled in favor of sustained available bandwidth and processor
    compute capacity. This profile is similar to the Low Latency profile except that some latency is accepted to
    achieve maximum throughput.
    Decision Support
    This profile is intended for Enterprise Business Database (Business Intelligence) workloads that are
    focused on operating and/or accessing data warehouses, such as data mining or online analytical
    processing (OLAP).
    Graphic Processing
    This profile is intended for workloads that are run on server configurations which utilize Graphics
    Processing Units (GPUs.) GPUs typically depend on maximum bandwidth between I/O and Memory.
    Power management features that have impact on the links between I/O and memory are disabled. Peer to
    Peer traffic is also critical and therefore virtualization is also disabled.
    I/O Throughput
    This profile is intended to be used for configurations that depend on maximum throughput between I/O
    and memory. Processor utilization driven power management features that have performance impact to
    the links between I/O and memory are disabled.

     

    Show Less
  • AppEvaluator results will not load with [] in the filename

    Only if I remove the square brackets from the result file names can I get the QSAEanalyser to load the files from the results folder. Is there some sp... Show More

    Only if I remove the square brackets from the result file names can I get the QSAEanalyser to load the files from the results folder. Is there some special setting I need to use to get it to tolerate these characters in the name. It looks like it removes them and tried to open a file without them in the name and so fails to find the file.

    Show Less
  • Numerous error message - please help clarify what they mean?

    Hello,We are using the scalability tool for testing 400 users. The Rampup delay is setSome of our tests contain the following messages:"Execution did ... Show More

    Hello,

    We are using the scalability tool for testing 400 users. The Rampup delay is set

    Some of our tests contain the following messages:

    "Execution did not dispose. Forcibly killed by timeout"

    Another message is "The operation has timed out"

    Another is "SessionTimedOut [Fatal]: Session timed out due to inactivity."

    Another message is "Connect failed after 2 attempts ---> LicenseAccessDenied [Fatal]: Access to the app is denied: NoAvailableAccessType"

    Any idea what each of these errors/warnings mean and how to fix them?

    Is this error something to be concerned about? How to fix them?

    Here is how my test configuration looks:Config2.PNG

     

     

    Show Less
  • How to properly design concurrent users testing for up to 300 concurrent users?

    Hi,We have a Qlik Sense environment where we are anticipating up to 300 concurrent users. The idea is to test how our Qlik Sense environment copes wit... Show More

    Hi,

    We have a Qlik Sense environment where we are anticipating up to 300 concurrent users. The idea is to test how our Qlik Sense environment copes with up to this many users at any one time.

    How can we appropriately configure a scalability test for handling this many users?

    We are going to test on an app that closely resembles the Production environment

    The typical user arrival pattern will be:

    1. log in
    2. go to the Everyone stream
    3. open app
    4. "think" time of 45 seconds
    5. select something(could be one to 5 values from a field)
    6. think further for 45 seconds
    7. Navigate to different sheet
    8. Clear selections
    9. Select something else (could be one to 5 values form a field)
    10. "think" time of 45 seconds
    11. Navigate to a different sheet
    12. "think" time of 45 seconds
    13. Select something from another field
    14. "think" time of 45 seconds
    15. Clear selections
    16. Close the app

    We want to add 20 users at a time if that's possible with scalability testing? If yes, how to configure it? If no, what is the best way to realistically test loading 300 users for concurrent testing?

     

    Show Less
  • Qlik Scalability Tools compatibility with QV 12.30

    HelloIs the actual package full compatible with QlikView 12.30?If not (I have some test errors after migrating to this QV version), is a new package p... Show More

    Hello

    Is the actual package full compatible with QlikView 12.30?

    If not (I have some test errors after migrating to this QV version), is a new package planned for soon?

    Thanks

    David

    Show Less
  • Duplicate columns in Windows Server Performance Counter csv file

    Hi all, I have a problem with the csv file generated by WIndows Server Perf Counters. A lot of columns are duplicated. (38 duplicate, 556 unique colum... Show More

    Hi all,

    I have a problem with the csv file generated by WIndows Server Perf Counters.

    A lot of columns are duplicated. (38 duplicate, 556 unique columns name)

    Example (sorry the server is in french):

    \\xxx\Processus(IDLE)\Taille virtuelle (octets)

    \\xxx\Processus(IDLE)\Taille virtuelle (octets)

     

    I use the generic "Qlik-1minute-NoWildcards.xml" to setup the counters

    Server : Windows 2016

     

    Any idea ?

     

    Best regards

    Show Less
  • Qlik Sense header based authentication for health check API

    Hello All, Is it possible to implement header based authentication for Qlik Sense health check APIs?Currently in our environment, only kerberos authen... Show More

    Hello All, Is it possible to implement header based authentication for Qlik Sense health check APIs?

    Currently in our environment, only kerberos authentication is enabled and its complicates the development of an automated tool which can periodically gets data from this API and dumps to a time series database for analysis. 

    The enterprise QS URL looks like : 

    https://<servername>/engine/healthcheck/

    Thanks

    Ganesh

    Show Less
  • Intermittent Errors while executing the test scenario

    Getting below two errors intermittently while executing the scenario. Pls share your thoughts.Error 1:Connect failed after 2 attempts. ---> LicenseAcc... Show More

    Getting below two errors intermittently while executing the scenario. Pls share your thoughts.

    Error 1:

    Connect failed after 2 attempts. ---> LicenseAccessDenied [Fatal]: Access to the app is denied: NoAvailableAccessType
    Connect failed after 2 attempts. ---> NoEngineAvailable [Fatal]:

    Error 2:
    Invalid parameters [8]:Invalid parameters(Invalid Match index)

    Environment:

    Single box environment

    Version: Sep 2018

    Only 25% of the tokens are used even after running this load test

    Show Less
  • Scalabillity Tool - NTLM - User Has No Access Error

    Hi,We are trying to get Scalability tools to pre-cache  Qlikview Document.Our test document has no section access and consists of 2 sheets with 1 List... Show More

    Hi,

    We are trying to get Scalability tools to pre-cache  Qlikview Document.

    Our test document has no section access and consists of 2 sheets with 1 Listbox to loop through.

    On checking the events log after running the script we see this error numerous times :

    Information Document Open: Open document: User has no access to document xxxxxxxxx.qvw

    One question I have is, I am able to access the document when logging into the AccessPoint - so how do I force the scalability tool to use my details to login to the AccessPoint.

    Any help appreciated.

     

    Phil

    Show Less
  • Qlik Sense Scalability Tool running at 50% Capacity in 2 socket 96 Core server

    We are running the 5.2 version of the scalability tool in a server that has 2 sockets and 96 cores. We are scaling up 250-500 concurrent users in the ... Show More

    We are running the 5.2 version of the scalability tool in a server that has 2 sockets and 96 cores. We are scaling up 250-500 concurrent users in the server and seeing the tool only use HALF of the CPU.  In a 1 socket 48 core environment, the tool is performing BETTER and reaching higher capacity.  

    There is nothing online to indicate why the tool cannot use the full capacity of the server and was wondering if anyone else has run into this issue or has any insights on why the tool is behaving this way. 

    This is inhibiting us from scaling an appropriate amount of concurrent users.  

     

    Show Less
  • How to run performance test using multiple NTLM users from a single host machine

    Hello Team,In our environment there is a need to test Qlik Sense application against multiple streams & multiple apps.Even within a single app the dat... Show More

    Hello Team,

    In our environment there is a need to test Qlik Sense application against multiple streams & multiple apps.

    Even within a single app the data view depends on who is logged in using NTLM/Kerberos authentication mechanism.

    We want to make script run with multiple NTLM usernames/passwords at the same time. Just like in loadrunner we parameterise user name and password and use web_set_user to use their NTLM credentials.

    Could anyone please let me know if thats possible in QSST?

    Regards

    Ganesh

    Show Less
  • ScalabilityTool result analysis with Qlik Sense

    Hi,after I've managed to run first scenarios against my Qlik application with the ScalabilityTool, I wanted to analyse the result of the executions.Ac... Show More

    Hi,

    after I've managed to run first scenarios against my Qlik application with the ScalabilityTool, I wanted to analyse the result of the executions.

    According to the "User Guide for SC Result Analyzer.pdf" this is done using the QlikView applications in "ScalabilityTools\Analyzer". Unfortunately I have no QlikView. I already tried to drag & drop the QVW-Files into Qlik Sense Desktop. This seems to work in the first place but the scripts don't seem to be 100% compatible and the applications don't contain any sheets.

    Is there a way to perform analysis of the ScalabilityTool results in Qlik Sense or will I need to install QlikView?

    Best regards

    Show Less
  • Qlikview through nginx

    Hello.We use nginx for load balancing our application(java)Part of our application it's report based on qlikviewNow I seeking solution integrate qlikv... Show More

    Hello.

    We use nginx for load balancing our application(java)

    Part of our application it's report based on qlikview

    Now I seeking solution integrate qlikview with nginx, I need route http://oursite/qlikview direct to http://qlikview_server/qlikview

    In apache work perfect, see below config:

    <VirtualHost *:80>

    <Location "/qlikview">

            ProxyPass http://10.7.136.107/qlikview

    </Location>

    <Location /QvAJAXZfc/>

            ProxyPass http://10.7.136.107/QvAJAXZfc/

    </Location>

    <Location /QvAjaxZfc/>

            ProxyPass http://10.7.136.107/QvAjaxZfc/

    </Location>

    </VirtualHost>

    In nginx doesn't work see config below

    server {

            listen 801;

            location        /qlikview {

                    proxy_pass     http://10.7.136.107/qlikview;

            }

            location        /QvAJAXZfc/ {

                    proxy_pass     http://10.7.136.107/QvAJAXZfc/;

            }

            location        /QvAjaxZfc/ {

                    proxy_pass     http://10.7.136.107/QvAjaxZfc/;

            }

    }

    Are anybody have solution on nginx ?

    Thanks

    Show Less
  • NTLM user - Not able to connect to Qlik Sense Scalability

    Hi,I've been trying to connect to my app on QlikSense through Scalability Tool with ConnectionType - NTLM and have been getting below error message."C... Show More

    Hi,

    I've been trying to connect to my app on QlikSense through Scalability Tool with ConnectionType - NTLM and have been getting below error message.

    "Connection failed Server reachable: Please verify NTLM user and app! (See Appendix A in the help)"

    Attached is the screenshot of the error.

    I'm quite new to this so may have missed some configuration, but can't figure out what.

    Any help is much appreciated.

    Thanks,

    Anusha

    Show Less
  • App Evaluator - Lib Directory Connection not found.

    Hi,I've run App Evaluator test and trying to load the log file to App (from load script). But when I update the Scalability_Results  (library connecto... Show More

    Hi,

    I've run App Evaluator test and trying to load the log file to App (from load script). But when I update the Scalability_Results  (library connector) to point to the log file location, it is throwing Connection Not found error. See screenshot below. And also there is a second error indicating where the error occurred.

    Does anyone know why the data connection has a problem?

    I followed the same instructions that are in the documentation folder (Qlik_Sense_App_Evaluator PDF).

    Capture.JPG

    Show Less
Group details
Qlik Scalability
Qlik Scalability
1,035 members Open Group Since ‎2010-11-08 10:26 AM
A group dedicated to advancing Qlik scalability and performance. In this group we will share knowledge on how to perform load tests of Qlik products.
A group dedicated to advancing Qlik scalability and performance. In this group we will share knowledge on how to perform load tests of Qlik products.
Group Admin
ccv Employee
lse Employee
dlo Employee
jae Employee
sfg Employee
Members (1,035)