Facing issue in retrieving aggregate report details into csv

210 views
Skip to first unread message

Aditya U

unread,
Dec 15, 2020, 12:04:28 AM12/15/20
to jmeter-plugins
Hi Team,

I need your help in resolving my issue, i see the  attached error while running the command 
D:\Jmeter\apache-jmeter-5.1\bin>JMeterPluginsCMD.bat --generate-csv "D:\Jmeter\apache-jmeter-5.1\Results\AggregrateGraphResults.csv" --input-jtl "D:\Jmeter\apache-jmeter-5.1\Results\TestResults.jtl" --plugin-type AggregateReport

Please suggest me proper jars for jmeterpluginsCMD if this the issues .Please review and suggest the solution.

error: is attachederror.PNG
error.PNG

Singh Pawan Kumar

unread,
Dec 15, 2020, 7:22:51 AM12/15/20
to jmeter-plugins
Hi Team,

Even I am getting below error while generating AggregateReport in CSV format.


Singh Pawan Kumar

unread,
Dec 15, 2020, 7:24:12 AM12/15/20
to jmeter-plugins

Singh Pawan Kumar

unread,
Dec 15, 2020, 7:25:31 AM12/15/20
to jmeter-plugins
Hi Team,

My error is different than what is mentioned in the screenshot.
I am getting below error while running:
C:\Temp\performance_jmeter_framework\apache-jmeter-5.2.1\bin>JMeterPluginsCMD.bat --generate-png test.png --input-jtl demo.jmx.jtl_1607673889.jtl --plugin-type ResponseTimesOverTime --width 800 --height 600
2020-12-15 17:49:28,310 WARN o.a.j.u.JMeterUtils: Exception 'null' occurred when fetching String property:'sampleresult.default.encoding', defaulting to: ISO-8859-1
2020-12-15 17:49:28,317 WARN o.a.j.u.JMeterUtils: Exception 'null' occurred when fetching String property:'jmeterPlugin.prefixPlugins'
2020-12-15 17:49:28,318 INFO k.a.j.PluginsCMDWorker: Using JMeterPluginsCMD v. N/A
2020-12-15 17:49:28,322 INFO o.a.j.u.JMeterUtils: Setting Locale to en_US
2020-12-15 17:49:28,327 INFO k.a.j.JMeterPluginsUtils: Loading user properties from: C:\Temp\performance_jmeter_framework\apache-jmeter-5.2.1\bin\user.properties
2020-12-15 17:49:28,328 INFO k.a.j.JMeterPluginsUtils: Loading system properties from: C:\Temp\performance_jmeter_framework\apache-jmeter-5.2.1\bin\system.properties
ERROR: java.lang.RuntimeException: java.lang.ClassNotFoundException: kg.apc.jmeter.vizualizers.ResponseTimesOverTimeGui
*** Problem's technical details go below ***
Home directory was detected as: C:\Temp\performance_jmeter_framework\apache-jmeter-5.2.1\lib
Exception in thread "main" java.lang.RuntimeException: java.lang.ClassNotFoundException: kg.apc.jmeter.vizualizers.ResponseTimesOverTimeGui
        at kg.apc.jmeter.PluginsCMDWorker.getGUIObject(PluginsCMDWorker.java:237)
        at kg.apc.jmeter.PluginsCMDWorker.getGUIObject(PluginsCMDWorker.java:234)
        at kg.apc.jmeter.PluginsCMDWorker.getGUIObject(PluginsCMDWorker.java:230)
        at kg.apc.jmeter.PluginsCMDWorker.setPluginType(PluginsCMDWorker.java:73)
        at kg.apc.cmdtools.ReporterTool.processParams(ReporterTool.java:102)
        at kg.apc.cmdtools.PluginsCMD.processParams(PluginsCMD.java:62)
        at kg.apc.cmdtools.PluginsCMD.processParams(PluginsCMD.java:21)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at kg.apc.cmd.UniversalRunner.main(UniversalRunner.java:115)
Caused by: java.lang.ClassNotFoundException: kg.apc.jmeter.vizualizers.ResponseTimesOverTimeGui
        at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:264)
        at kg.apc.jmeter.PluginsCMDWorker.getGUIObject(PluginsCMDWorker.java:227)
        ... 11 more


On Tuesday, 15 December 2020 at 17:52:51 UTC+5:30 Singh Pawan Kumar wrote:

Aditya U

unread,
Dec 15, 2020, 9:00:44 AM12/15/20
to jmeter-...@googlegroups.com
Hi Pawan Kumar,

It got resolved for me when I tried to execute the below command from the ext folder.

java -jar cmdrunner-2.0.jar --tool Reporter --generate-csv "D:\Jmeter\apache-jmeter-5.1\Results\aggregate_summary.csv" --input-jtl "D:\Jmeter\apache-jmeter-5.1\Results\TestResults.jtl" --plugin-type AggregateReport



--
You received this message because you are subscribed to a topic in the Google Groups "jmeter-plugins" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/jmeter-plugins/plMLglyFUMs/unsubscribe.
To unsubscribe from this group and all its topics, send an email to jmeter-plugin...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jmeter-plugins/d5588ca7-a6b7-485b-8e81-2a024bdaa1d5n%40googlegroups.com.

Dmitri Tikhanski

unread,
Dec 15, 2020, 10:38:38 AM12/15/20
to jmeter-plugins
  1. In one case it's a Jar Hell 
  2. In another case there is 3 Basic Graphs plugin missing
  3. In both cases the solution is to install clean latest stable JMeter version, then install JMeter Plugins Manager
  4. Once there is clean JMeter with the Plugins Manager installed look for Command-Line Graph Plotting Tool and it will pick up all the necessary .jar files

Singh Pawan Kumar

unread,
Dec 16, 2020, 11:57:39 PM12/16/20
to jmeter-plugins
Hi Aditya,

I download the jars from  JMeter Plugins :: JMeter-Plugins.org (jmeter-plugins.org)  and copied the respective files to jmeter location as mentioned. When I tried to execute the reporting command, I got below error. It is not working for me. 
Could you please let me know how are you doing it? Also, I am automating this via Taurus and this report generation need to work.
java -jar C:\Users\310246846\Downloads\apache-jmeter-5.2.1\apache-jmeter-5.2.1\lib\cmdrunner-2.2.jar --tool Reporter --generate-csv aggregateResults.csv --input-jtl C:\Temp\performance_jmeter_framework\testResults.jtl --plugin-type AggregateReport

Errors:

2020-12-17 10:23:02,255 WARN o.a.j.u.JMeterUtils: Exception 'null' occurred when fetching String property:'sampleresult.default.encoding', defaulting to: ISO-8859-1
2020-12-17 10:23:02,262 WARN o.a.j.u.JMeterUtils: Exception 'null' occurred when fetching String property:'jmeterPlugin.prefixPlugins'
2020-12-17 10:23:02,263 INFO k.a.j.PluginsCMDWorker: Using JMeterPluginsCMD v. N/A
2020-12-17 10:23:02,268 INFO o.a.j.u.JMeterUtils: Setting Locale to en_US
2020-12-17 10:23:02,275 INFO k.a.j.JMeterPluginsUtils: Loading user properties from: C:\Users\310246846\Downloads\apache-jmeter-5.2.1\apache-jmeter-5.2.1\bin\user.properties
2020-12-17 10:23:02,277 INFO k.a.j.JMeterPluginsUtils: Loading system properties from: C:\Users\310246846\Downloads\apache-jmeter-5.2.1\apache-jmeter-5.2.1\bin\system.properties
ERROR: java.lang.RuntimeException: java.lang.ClassNotFoundException: kg.apc.jmeter.vizualizers.AggregateReportGui
*** Problem's technical details go below ***
Home directory was detected as: C:\Users\310246846\Downloads\apache-jmeter-5.2.1\apache-jmeter-5.2.1\lib
Exception in thread "main" java.lang.RuntimeException: java.lang.ClassNotFoundException: kg.apc.jmeter.vizualizers.AggregateReportGui
        at kg.apc.jmeter.PluginsCMDWorker.getGUIObject(PluginsCMDWorker.java:237)
        at kg.apc.jmeter.PluginsCMDWorker.getGUIObject(PluginsCMDWorker.java:234)
        at kg.apc.jmeter.PluginsCMDWorker.getGUIObject(PluginsCMDWorker.java:230)
        at kg.apc.jmeter.PluginsCMDWorker.setPluginType(PluginsCMDWorker.java:73)
        at kg.apc.cmdtools.ReporterTool.processParams(ReporterTool.java:102)
        at kg.apc.cmdtools.PluginsCMD.processParams(PluginsCMD.java:62)
        at kg.apc.cmdtools.PluginsCMD.processParams(PluginsCMD.java:21)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at kg.apc.cmd.UniversalRunner.main(UniversalRunner.java:115)
Caused by: java.lang.ClassNotFoundException: kg.apc.jmeter.vizualizers.AggregateReportGui
        at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:264)
        at kg.apc.jmeter.PluginsCMDWorker.getGUIObject(PluginsCMDWorker.java:227)
        ... 11 more

Thanks & Regards,
Pawan Singh 

Singh Pawan Kumar

unread,
Dec 17, 2020, 12:36:41 AM12/17/20
to jmeter-plugins
Hi Tikhanski,

I followed step 3 and 4 but no luck. I am still getting below error.
C:\Users\310246846\Downloads\apache-jmeter-5.4\apache-jmeter-5.4\bin\examples>java -jar C:\Users\310246846\Downloads\apache-jmeter-5.4\apache-jmeter-5.4\lib\cmdrunner-2.2.jar --tool Reporter --generate-csv aggregateResults.csv --input-jtl C:\Users\310246846\Downloads\apache-jmeter-5.4\apache-jmeter-5.4\bin\examples\ThreadGroup.jtl --plugin-type AggregateReport
2020-12-17 11:05:25,017 WARN o.a.j.u.JMeterUtils: Exception 'null' occurred when fetching String property:'sampleresult.default.encoding', defaulting to: ISO-8859-1
2020-12-17 11:05:25,028 WARN o.a.j.u.JMeterUtils: Exception 'null' occurred when fetching String property:'jmeterPlugin.prefixPlugins'
2020-12-17 11:05:25,029 INFO k.a.j.PluginsCMDWorker: Using JMeterPluginsCMD v. N/A
2020-12-17 11:05:25,035 INFO o.a.j.u.JMeterUtils: Setting Locale to en_US
2020-12-17 11:05:25,044 INFO k.a.j.JMeterPluginsUtils: Loading user properties from: C:\Users\310246846\Downloads\apache-jmeter-5.4\apache-jmeter-5.4\bin\user.properties
2020-12-17 11:05:25,046 INFO k.a.j.JMeterPluginsUtils: Loading system properties from: C:\Users\310246846\Downloads\apache-jmeter-5.4\apache-jmeter-5.4\bin\system.properties
ERROR: java.lang.RuntimeException: java.lang.ClassNotFoundException: kg.apc.jmeter.vizualizers.AggregateReportGui
*** Problem's technical details go below ***
Home directory was detected as: C:\Users\310246846\Downloads\apache-jmeter-5.4\apache-jmeter-5.4\lib
Exception in thread "main" java.lang.RuntimeException: java.lang.ClassNotFoundException: kg.apc.jmeter.vizualizers.AggregateReportGui
        at kg.apc.jmeter.PluginsCMDWorker.getGUIObject(PluginsCMDWorker.java:237)
        at kg.apc.jmeter.PluginsCMDWorker.getGUIObject(PluginsCMDWorker.java:234)
        at kg.apc.jmeter.PluginsCMDWorker.getGUIObject(PluginsCMDWorker.java:230)
        at kg.apc.jmeter.PluginsCMDWorker.setPluginType(PluginsCMDWorker.java:73)
        at kg.apc.cmdtools.ReporterTool.processParams(ReporterTool.java:102)
        at kg.apc.cmdtools.PluginsCMD.processParams(PluginsCMD.java:62)
        at kg.apc.cmdtools.PluginsCMD.processParams(PluginsCMD.java:21)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at kg.apc.cmd.UniversalRunner.main(UniversalRunner.java:115)
Caused by: java.lang.ClassNotFoundException: kg.apc.jmeter.vizualizers.AggregateReportGui
        at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:264)
        at kg.apc.jmeter.PluginsCMDWorker.getGUIObject(PluginsCMDWorker.java:227)
        ... 11 more


Please help..!!!

Thanks & Regards,
Pawan Singh

Aditya U

unread,
Dec 17, 2020, 12:59:10 AM12/17/20
to jmeter-...@googlegroups.com
Hi Pawan,

To Avoid further Confusion , i have attached the document with list of jars , which needs to be added under lin and ext folder.
Post adding the jars run the below command . If you are seeing any issues run the below command from cmd navigating till lib folder, still facing issues try from ext folder aswell

java -jar {Path}/lib/ext/cmdrunner-2.2.jar --tool Reporter --generate-csv "Aggregate_Report.csv" --input-jtl "output.jtl" --plugin-type AggregateReport

jars List.ods

Singh Pawan Kumar

unread,
Dec 17, 2020, 2:09:39 AM12/17/20
to jmeter-plugins
I have identified the issue. Apart from all the jars which are available in  JMeter Plugins :: JMeter-Plugins.org (jmeter-plugins.org) , we need to download  
JMeterPlugins-Standard-1.4.0.zip (jmeter-plugins.org)  as well and put it in /lib/ext/ folder. 

The next problem is how should I download above JMeterPlugins-Standard-1.4.0.zip (jmeter-plugins.org) files from internet using Taurus.
Can someone help with this?

Regards,
Pawan 

Singh Pawan Kumar

unread,
Dec 17, 2020, 3:00:12 AM12/17/20
to jmeter-plugins
Hi All,

The problem with command-line reporting is FIXED now. Below are the steps which needs to be followed to make it work.
Step 1) Download latest Apache JMeter version
Step 2) Download  JMeter Plugins :: JMeter-Plugins.org (jmeter-plugins.org)  and copy the respective files mentioned in the download folders/zip to the jmeter path (in bin, lib, ext folders)
Step 3) Download "Synthesis Report" plugin (jpgc-synthesis 2.2)

With all these downloaded jars, the command line JMeter reporting works smooth.

Thanks & Regards,
Pawan Singh

Tong Sun

unread,
Feb 4, 2021, 3:04:36 PM2/4/21
to jmeter-plugins
Thanks Pawan, 

I can confirm that for the error of, 

ERROR: java.lang.RuntimeException: java.lang.ClassNotFoundException: kg.apc.jmeter.vizualizers.AggregateReportGui
*** Problem's technical details go below ***
Home directory was detected as: /Applications/apache-jmeter-5.3/lib
Exception in thread "main" java.lang.RuntimeException: java.lang.ClassNotFoundException: kg.apc.jmeter.vizualizers.AggregateReportGui

Installing "Synthesis Report" plugin alone, without the 3 Basic Graphs plugins, solved the problem.

thx!
Reply all
Reply to author
Forward
0 new messages