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
  • How should I create a scenario where there is a mixture of poor performing sheet...

    Hello all,How should I create a scenario where there is a mixture of poor performing sheets and good sheets?To give you an example we have a dashboard... Show More

    Hello all,

    How should I create a scenario where there is a mixture of poor performing sheets and good sheets?

    To give you an example we have a dashboard with about 9 sheets.

    Majority of these sheets have good response times to clicks even before using this testing tool.

    However we have a few sheets where there are big table objects with complex expressions for measures and dimensions (e.g. IF statements etc). These sheets can take over a minute to display the data.

    How do you write a scenario where both of these types of sheets are included? Is there anything special you would do for poor sheets where you know the load time of objects is slow? My concern is these sheets impact the overall result especially when you are doing concurrent users testing of 50 to 500 users.

    Show Less
  • How long should you set your TimerDelay after each click action on a sheet?

    Hello all,I am learning about this tool and how to write tests.How long should you set your TimerDelay after an action on a sheet?For example, if ther... Show More

    Hello all,

    I am learning about this tool and how to write tests.

    How long should you set your TimerDelay after an action on a sheet?

    For example, if there is  select action on a sheet that responds fast e.g. it takes less than 2 seconds to load everything on a sheet, what should the timer delay be?

    Similarly, if you have a sheet that can take over 45 seconds to display something, or sometimes even over a minute, how long should you set the timerdelay for an action on that sheet?

    I'm not sure how this works, currently I set it to between 15 and 30 seconds for the best and worst performing sheets but I am wondering whether this approach is correct.

    Show Less
  • Read Failed [9001]:Read Failed(REST client response error)

    Hi,In the tests that I run I get the following error sometimes showing up:Read Failed [9001]:Read Failed(REST client response error)Any idea what this... Show More

    Hi,

    In the tests that I run I get the following error sometimes showing up:

    Read Failed [9001]:Read Failed(REST client response error)

    Any idea what this means please?

    Show Less
  • We are trying to test a new QlikView application with Jmeter tool --> no file ac...

    We want to do some stress tests on a server, RCqlikv2, newly installed.client server where we launch the JMeter is DVqlikv2License used session CALAut... Show More

    We want to do some stress tests on a server, RCqlikv2, newly installed.

    • client server where we launch the JMeter is DVqlikv2
    • License used session CAL
    • Autentification NTLM
    • No section access on the targeted app

    While trying to run JMeter on our new application, we have the following message (see in attachement for detail)

    The document xxxxx.qvw failed to load because of no file access [3000]

    We tried the following

    • we do have access to the app from accesspoint of both 2 servers dvqlikv2 and rcqlikv2 (with same account used from JMeter to access the app)
    • We tried (unsuccessfully) with both JMeter and app on same server dvqlikv2

    We are thinking that issue might be related to Qlik server, maybe next test will be install all on IIS wbserver better than Qlik ones.

    What do you think?

    Do someone have any clues on how the handle this or maybe someone faced the same issue using JMeter with Qv?

    Thank you by advance for your help,

    Camille SECRETIN

    Show Less
  • AppEvaluator RunEvaluator.ps1 not running multiple apps

    I found this powershell script which does everything we want to do for an initial test of a system.  No documentation, but that's fine, I can read pow... Show More

    I found this powershell script which does everything we want to do for an initial test of a system.  No documentation, but that's fine, I can read powershell.  One of the parameters is -apps.  The script supports passing in multiple app IDs, which should then loop through each one, but it doesn't.  Using VS Code in debugging mode I found that multiple apps are getting parsed, loaded into array $apps, and then looped through and JSON created with multiple restart and run sections.  Then it gets passed in TestScheduler.exe, but then disappears into a black hole, only the first app in the list is run.

    We can call this utility once for each app ID, but it would be nice if this worked.  I suspect the issue is in TestScheduler.exe.

    Show Less
  • "The operation has timed out" message showing sometimes in the Executor logs?

    Hi all,Sometimes I can see the message "The operation has timed out" when a scenario is running.Can anyone please explain what this relates to?My scen... Show More

    Hi all,

    Sometimes I can see the message "The operation has timed out" when a scenario is running.

    Can anyone please explain what this relates to?

    My scenario is fairly standard, open app, open sheet, make selections, clear actions. The app has DAR design type layout with some dashboard sheets, more detailed data sheets, and big data tables at the end for deep analysis. My scenario has opening many of these types of sheets.

    Show Less
  • 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
Group details
Qlik Scalability
Qlik Scalability
1,040 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,040)