0

When I am giving a CSV filename path in Summary Report, I get an error to see log file. I see log file and it shows:

2019-01-30 14:23:38,146 WARN o.a.j.s.CSVSaveService: Unknown column name 
2019-01-30 14:23:38,146 INFO o.a.j.s.CSVSaveService: C:\Users\abdullah.bin\Downloads\apache-jmeter-5.0\apache-jmeter-5.0\bin\CSV\Results.csv does not appear to have a valid header. Using default configuration.
2019-01-30 14:23:38,147 WARN o.a.j.s.CSVSaveService: Cannot parse timestamp: '', will try following formats [yyyy/MM/dd HH:mm:ss.SSS, yyyy/MM/dd HH:mm:ss, yyyy-MM-dd HH:mm:ss.SSS, yyyy-MM-dd HH:mm:ss, MM/dd/yy HH:mm:ss]
2019-01-30 14:23:38,147 INFO o.a.j.s.CSVSaveService:  did not match yyyy/MM/dd HH:mm:ss.SSS, trying next date format
2019-01-30 14:23:38,148 INFO o.a.j.s.CSVSaveService:  did not match yyyy/MM/dd HH:mm:ss, trying next date format
2019-01-30 14:23:38,148 INFO o.a.j.s.CSVSaveService:  did not match yyyy-MM-dd HH:mm:ss.SSS, trying next date format
2019-01-30 14:23:38,149 INFO o.a.j.s.CSVSaveService:  did not match yyyy-MM-dd HH:mm:ss, trying next date format
2019-01-30 14:23:38,149 INFO o.a.j.s.CSVSaveService:  did not match MM/dd/yy HH:mm:ss, trying next date format
2019-01-30 14:23:38,149 WARN o.a.j.s.CSVSaveService: Error parsing field 'timeStamp' at line 1. java.text.ParseException: No date-time format found matching 
2019-01-30 14:23:38,149 WARN o.a.j.r.ResultCollector: Problem reading JTL file: C:\Users\abdullah.bin\Downloads\apache-jmeter-5.0\apache-jmeter-5.0\bin\CSV\Results.csv
org.apache.jorphan.util.JMeterError: java.text.ParseException: No date-time format found matching 

I can see it is a timestamp error but I am clueless where do I need to change? When JMeter exports CSV it does work but when I create and save CSV to export to it shows this error.

2

Normally .jtl results file should look like:

timeStamp,elapsed,label,responseCode,responseMessage,threadName,dataType,success,failureMessage,bytes,sentBytes,grpThreads,allThreads,URL,Latency,IdleTime,Connect
1548814963190,68,Some Sampler,200,OK,127.0.0.1-Thread Group 1-2,text,true,,114,0,2,2,null,21,0,3
1548814963100,236,Some Other Sampler,200,OK,127.0.0.1-Thread Group 1-1,text,true,,114,0,3,3,null,32,0,5
etc. 

If your CSV file differs from above - probably something is wrong with it or with JMeter results file configuration

Try re-running JMeter in command-line non-GUI mode like:

jmeter -n -t your_test.jmx -l result.csv

And JMeter should produce the CSV file similar to what I provided above suitable for opening with Listeners or generating the HTML Reporting Dashboard.

  • Hey thanks for replying. I tried running in Non-GUI mode just like you said and this is the output I got: timeStamp,elapsed,label,responseCode,responseMessage,threadName,dataType,success,failureMessage,bytes,sentBytes,grpThreads,allThreads,URL,Latency,IdleTime,Connect 1548846677886,2379,HTTP Request,200,,Thread Group 1-1,text,true,,48498,148,3,3,://yes.xyz.com/login.html,2140,0,1617 So it seems I got the right format. Seems some issue with my Excel maybe? – Abdullah Jan 30 at 11:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.