MergeResults plugin throws Error parsing field 'timeStamp' at line 1. java.text.ParseException: Unparseable date:

[Chinni P]

Hi,

When I tried to do merge using MergeResults plugin it throws "Error parsing field 'timeStamp' at line 1. java.text.ParseException: Unparseable date:"

2017-09-08 10:33:46,457 WARN o.a.j.s.CSVSaveService: Unknown column name sampler_label,aggregate_report_count,average,aggregate_report_median,aggregate_report_90%_line,aggregate_report_95%_line,aggregate_report_99%_line,aggregate_report_min,aggregate_report_max,aggregate_report_error%,aggregate_report_rate,aggregate_report_bandwidth,aggregate_report_stddev

2017-09-08 10:33:46,458 INFO o.a.j.s.CSVSaveService: E:\JMETER\PROJECT_NGP\Results\SL_Rel\ScriptsValidation\Build_165-20749\Reports__09-08-2017-08-45-49\AgReport.csv  does not appear to have a valid header. Using default configuration.

2017-09-08 10:33:46,458 WARN o.a.j.s.CSVSaveService: Error parsing field 'timeStamp' at line 1. java.text.ParseException: Unparseable date: "sampler_label,aggregate_report_count,average,aggregate_report_median,aggregate_report_90%_line,aggregate_report_95%_line,aggregate_report_99%_line,aggregate_report_min,aggregate_report_max,aggregate_report_error%,aggregate_report_rate,aggregate_report_bandwidth,aggregate_report_stddev"

2017-09-08 10:33:46,458 WARN o.a.j.r.ResultCollector: Problem reading JTL file: E:\JMETER\PROJECT_NGP\Results\SL_Rel\ScriptsValidation\Build_165-20749\Reports__09-08-2017-08-45-49\AgReport.csv 

2017-09-08 10:33:46,460 WARN o.a.j.s.CSVSaveService: Unknown column name sampler_label,aggregate_report_count,average,aggregate_report_median,aggregate_report_90%_line,aggregate_report_95%_line,aggregate_report_99%_line,aggregate_report_min,aggregate_report_max,aggregate_report_error%,aggregate_report_rate,aggregate_report_bandwidth,aggregate_report_stddev

2017-09-08 10:33:46,461 INFO o.a.j.s.CSVSaveService: E:\JMETER\PROJECT_NGP\Results\SL_Rel\ScriptsValidation\Build_165-20749\Reports__09-08-2017-08-46-08\AgReport.csv  does not appear to have a valid header. Using default configuration.

2017-09-08 10:33:46,477 WARN o.a.j.s.CSVSaveService: Error parsing field 'timeStamp' at line 1. java.text.ParseException: Unparseable date: "sampler_label,aggregate_report_count,average,aggregate_report_median,aggregate_report_90%_line,aggregate_report_95%_line,aggregate_report_99%_line,aggregate_report_min,aggregate_report_max,aggregate_report_error%,aggregate_report_rate,aggregate_report_bandwidth,aggregate_report_stddev"

2017-09-08 10:33:46,492 WARN o.a.j.r.ResultCollector: Problem reading JTL file: E:\JMETER\PROJECT_NGP\Results\SL_Rel\ScriptsValidation\Build_165-20749\Reports__09-08-2017-08-46-08\AgReport.csv 

In user.properties file and jmeter.properties file timestamp settings are same.

TWO AggregateReport JTL files are successfully converted into csv using the below CMD runner command.Though i have configured defalut-delimenater =\t still converted csv AggregarReport file is in comma formatted. Interestingly View Results in Tree.csv and View Results in Table.csv files are generated in tab format.

JMeterPluginsCMD.bat --generate-csv  E:\JMETER\PROJECT_NGP\Results\SL_Rel\ScriptsValidation\Build_165-20749\Reports__09-08-2017-08-45-49\AgReport.csv   --input-jtl E:\JMETER\PROJECT_NGP\Results\SL_Rel\ScriptsValidation\Build_165-20749\Reports__09-08-2017-08-45-49\AgReport.jtl --plugin-type AggregateReport

Please advise.

Thanks,

Raj

[Vincent Daburon]

You can't merge aggregate report
Only jmeter "raw" results jtl or csv results

Regards
Vincent D.

[Chinni P]

Thanks Vin!It worked!