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.

Employee
Employee

Re: QV Scalability Tools (QV10,QV11,QV12)

Hi,

First, this question belong more to the Result analyzer page than here.

If you perform a test using the exerciser (i.e Qlik Sense) the result file should be put in the exerciser folder.

If you perform a test using JMeter (i.e. QlikView) the result file should be put in the JmeterLogs folder.

The same file should never be put in two folders.

I will assume you're testing qlikview since you're posting on this page. To "fix" the problem the copy of the file needs to be removed and the corresponding qvd needs to be deleted. The result analyzer has functionality to help you delete the correct qvd by helping you compose a console delete command.

The only "mandatory" file is the result file, an exerciser result file for Qlik Sense and a jmeter one for QlikView. All other files are there to provide more information, i.e. without the performance counters you will not see any cpu/memory used by the servers etc. Any file missing will have corresponding missing information in the analyzer app.

tunoi
Contributor

Re: QV Scalability Tools (QV10,QV11,QV12)

Hi, i'm trying to use this tools for cache warming purpose but i having a strange issue.

here is my test scenario:

Scenario.PNG

But in audit log of the server i found the following lines after the execution of the scenario:

20161014T072538.000+010020161014T090657.000+0100D:/Test_Environment/Server_Documents/executive dashboard v005.qvwDocumentBFL\bostiOpenDocument\SH1412
20161014T072538.000+010020161014T090657.000+0100D:/Test_Environment/Server_Documents/executive dashboard v005.qvwActionBFL\bostiaction(32)[%AcquisitionCostBasis, Gross Of Acquisition Cost, ]Doc12
20161014T072538.000+010020161014T090657.000+0100D:/Test_Environment/Server_Documents/executive dashboard v005.qvwActionBFL\bostiaction(32)[%CurrencyCode, USD, ]Doc12
20161014T072538.000+010020161014T090657.000+0100D:/Test_Environment/Server_Documents/executive dashboard v005.qvwActionBFL\bostiaction(32)[%EntityPerspective, Combined View, ]Doc12
20161014T072538.000+010020161014T090657.000+0100D:/Test_Environment/Server_Documents/executive dashboard v005.qvwActionBFL\bostiaction(32)[%RateType, PIM, ]Doc12
20161014T072538.000+010020161014T090657.000+0100D:/Test_Environment/Server_Documents/executive dashboard v005.qvwActionBFL\bostiaction(32)[%ShareType, Beazley Share, ]Doc12
20161014T072538.000+010020161014T090806.000+0100D:/Test_Environment/Server_Documents/executive dashboard v005.qvwSelectionBFL\bostiMonth: AprDocument\LB51012
20161014T072538.000+010020161014T090859.000+0100D:/Test_Environment/Server_Documents/executive dashboard v005.qvwSelectionBFL\bostiClear MonthDocument\LB51012
20161014T072538.000+010020161014T090932.000+0100D:/Test_Environment/Server_Documents/executive dashboard v005.qvwSelectionBFL\bostiMonth: SepDocument\LB51012
20161014T072538.000+010020161014T091003.000+0100D:/Test_Environment/Server_Documents/executive dashboard v005.qvwSelectionBFL\bostiClear MonthDocument\LB51012
20161014T072538.000+010020161014T091039.000+0100D:/Test_Environment/Server_Documents/executive dashboard v005.qvwSelectionBFL\bostiMonth: JunDocument\LB51012

Why the second loop doesnt execute? Any ideea?

Employee
Employee

Re: QV Scalability Tools (QV10,QV11,QV12)

Hi,

The reason is that the tool do not handle nested test loops, so your inner loop will be empty of actions. Having them after each other should work fine though, but there are some considerations and caveats when it comes to the using loops so it is a good idea to have "regular" action in between the loops or start with clear all. Note: It will not work properly with clear object actions in the beginning, they need to extract the name of the object to clear which is not possible to do from the action outside of the loop.

Regards

/Sebastian

kahl_dre
New Contributor II

Re: QV Scalability Tools (QV10,QV11,QV12)

Hi,

I started using the Scalability Tools for Regression testing.

So far, so good, except, when the regression results of a Straight Table are stored for comparison, it only does the first 100 rows.

How do I get it to store all the rows of a straight table in the regression results?

Thanks,

Andre

Employee
Employee

Re: QV Scalability Tools (QV10,QV11,QV12)

Andre van der Merwe wrote:

How do I get it to store all the rows of a straight table in the regression results?

The tool will only save the values which are sent in the protocol, so the only way I can think of is to modify the app to have the straight table show all values, e.g. extend the size of the straight table to show all the values, not very feasible of you have millions of rows though.

tunoi
Contributor

Re: QV Scalability Tools (QV10,QV11,QV12)

Hi guys,

i have a Qlikview server set up to use qlikview web server and i'm trying to run this tool with basic authentication for a stress test but i cant setup up right. Somehow i miss some configuration and dont know what.

What i did:

i constructed a small script for testing

Pic1.PNG

In property tab of the tool i've put at concurrent user: 2 and in authentication section i checked anonymous.

Pic4.PNG

On qlikview server side i've set up DMS authorization

Pic2.PNG

On Document Tab i've set up the value as Appendix C - Setting up Basic Authentication from documentation.

Pic3.PNG

After that i start the script but in event log of the server i see only lines with user under which the tests are started.

What i miss?

Not applicable

Re: QV Scalability Tools (QV10,QV11,QV12)

Hi,


Very interested to start using QV Scalability Tools for load testing, but getting the following record in the JMeterLog:

timeStamp,elapsed,label,responseCode,responseMessage,threadName,dataType,success,bytes,grpThreads,allThreads,Latency

0,0,,Non HTTP response code: java.lang.RuntimeException,Non HTTP response message: java.lang.IllegalArgumentException: Illegal base64 character 2c,QlikView 1-1,text,false,2197,1,1,0

Timestamp and elapsed are 0, which causes problems in the analyser.

Any idea what is going on here? This record seems to occur near the authentication on the access point.

I tried running the same test on the demo dashboards (which do not require authentication) at us-b.demo.qlik.com without any issues.


Thanks in advance

Employee
Employee

Re: QV Scalability Tools (QV10,QV11,QV12)

Hi, first of all I strongly recommend using header authentication as this is a much simpler solution.

However in your case, I see you write that you are using qvws which might be the cause for the failures as the documentaion (Appendix C) is for modifying IIS settings to handle BA.

Employee
Employee

Re: QV Scalability Tools (QV10,QV11,QV12)

Hello,

You could check if there are any special characters in the url. If not, I to get more information on what is actually failing I recommend you to run the script (with 1 user) from the jmeter GUI and look at the response and errors there. To do so, in the execution pane, right click on your script and choose "open in jmeter". Then enable the component "View Results Tree". Once running the script all requests and responses will be shown in that component.

cheers

tunoi
Contributor

Re: QV Scalability Tools (QV10,QV11,QV12)

So are you saing that for BA to work IIS is needed? BA doens work when Qlikview Web Server is used?