I worked out what the problem was. Sadly it wasn't a real bug, just an oversight on my part.
I'm maintaining tests created by someone else, and I missed that there was an assertion created at the level directly under the Thread Group. This assertion was checking the Response Code for every item in the test, but was failing to JDBC Requests since the Response Code = null. Thanks for all your help sebb. sebb-2-2 wrote: > > Can you send me the JMX file privately? (please don't post to the list). > > Plus any log files and the JTL file? > > You may wish to replace any sensitive data first, but please leave the > JMX otherwise intact. > > On 06/04/2008, heidiaspell <[EMAIL PROTECTED]> wrote: >> >> I tried with an Update Statement too, with the same result. >> >> >> >> >> sebb-2-2 wrote: >> > >> > I've had a look at the JDBC code, and I cannot see any reason why the >> > status should be set to failed if the sample succeeds. >> > >> > Do you get the same result for other types of SQL requests? >> > >> > On 06/04/2008, heidiaspell <[EMAIL PROTECTED]> wrote: >> >> >> >> JDBC Request shows the following on the Sampler Result tab: >> >> >> >> Thread Name: Thread Group 1-1 >> >> Sample Start: 2008-04-07 08:45:30 NZST >> >> Load time: 0 >> >> Latency: 0 >> >> Size in bytes: 4 >> >> Sample Count: 1 >> >> Error Count: 1 >> >> Response code: >> >> Response message: >> >> >> >> Response headers: >> >> [EMAIL PROTECTED] >> >> >> >> Note: I am being correctly returned Response Data from the query. >> >> >> >> >> >> >> >> sebb-2-2 wrote: >> >> > >> >> > What does the Sampler Result tab show for the Response Code and >> >> > Response Message? >> >> > >> >> > >> >> > On 06/04/2008, heidiaspell <[EMAIL PROTECTED]> wrote: >> >> >> >> >> >> As previously mentioned, there are no errors detailed in >> jmeter.log. >> >> >> >> >> >> 2008/04/07 08:44:56 INFO - jmeter.engine.StandardJMeterEngine: >> >> Running >> >> >> the >> >> >> test! >> >> >> 2008/04/07 08:44:56 INFO - jmeter.gui.util.JMeterMenuBar: >> >> >> setRunning(true,*local*) >> >> >> 2008/04/07 08:44:56 INFO - jmeter.engine.StandardJMeterEngine: >> >> Starting >> >> >> 1 >> >> >> threads for group Thread Group. Ramp up = 1. >> >> >> 2008/04/07 08:44:56 INFO - jmeter.engine.StandardJMeterEngine: >> Test >> >> >> will >> >> >> stop on error >> >> >> 2008/04/07 08:44:56 INFO - jmeter.threads.JMeterThread: Thread >> >> Thread >> >> >> Group >> >> >> 1-1 started >> >> >> 2008/04/07 08:45:30 INFO - jmeter.threads.JMeterThread: Stop >> Test >> >> >> detected >> >> >> by thread Thread Group 1-1 >> >> >> 2008/04/07 08:45:30 INFO - jmeter.threads.JMeterThread: >> Stopping >> >> Thread >> >> >> Group 1-1 >> >> >> 2008/04/07 08:45:30 INFO - jmeter.threads.JMeterThread: Thread >> >> Thread >> >> >> Group >> >> >> 1-1 is done >> >> >> 2008/04/07 08:45:30 INFO - jmeter.engine.StandardJMeterEngine: >> >> Ending >> >> >> thread Thread Group 1-1 >> >> >> 2008/04/07 08:45:30 INFO - jmeter.engine.StandardJMeterEngine: >> >> Stopping >> >> >> test >> >> >> 2008/04/07 08:45:30 INFO - jmeter.engine.StandardJMeterEngine: >> >> >> Notifying >> >> >> test listeners of end of test >> >> >> 2008/04/07 08:45:30 INFO - jmeter.gui.util.JMeterMenuBar: >> >> >> setRunning(false,*local*) >> >> >> 2008/04/07 08:45:30 INFO - jmeter.engine.StandardJMeterEngine: >> Test >> >> has >> >> >> ended >> >> >> >> >> >> >> >> >> >> >> >> sebb-2-2 wrote: >> >> >> > >> >> >> > Check jmeter.log for any errors. >> >> >> > >> >> >> > On 06/04/2008, heidiaspell <[EMAIL PROTECTED]> wrote: >> >> >> >> >> >> >> >> I'm using JMeter 2.3.1 >> >> >> >> >> >> >> >> I am not using an Assertion. Here is the structure of my >> test: >> >> >> >> >> >> >> >> - Loop Controller >> >> >> >> -- Simple Controller >> >> >> >> --- JDBC Request >> >> >> >> ---- Regular Expression Extractor >> >> >> >> >> >> >> >> My JDBC Request has a Query Type of "Select Statement". >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> sebb-2-2 wrote: >> >> >> >> > >> >> >> >> > Are you using an Assertion? That can set the status to >> >> failure. >> >> >> >> > >> >> >> >> > Which version of JMeter? >> >> >> >> > >> >> >> >> > On 03/04/2008, heidiaspell <[EMAIL PROTECTED]> wrote: >> >> >> >> >> >> >> >> >> >> I'm using a JDBC Request to perform a simple Select >> >> statement on >> >> >> a >> >> >> >> SQL >> >> >> >> >> Server >> >> >> >> >> db. >> >> >> >> >> >> >> >> >> >> The Results Tree Response Data tab shows that the >> results >> >> were >> >> >> >> returned >> >> >> >> >> correctly, but the Sampler Result tab still shows Error >> >> Count: >> >> >> 1. >> >> >> >> >> >> >> >> >> >> The Summary Report shows 100% failure for my JDBC >> Request. >> >> >> >> >> >> >> >> >> >> There are no errors in the jmeter.log. >> >> >> >> >> >> >> >> >> >> Anyone have any ideas? I'm keen to get my tests running >> >> with 0% >> >> >> >> errors. >> >> >> >> >> >> >> >> >> >> -- >> >> >> >> >> View this message in context: >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> http://www.nabble.com/JDBC-Request-returns-results-but-still-shows-Error-Count%3A-1-tp16473795p16473795.html >> >> >> >> >> Sent from the JMeter - User mailing list archive at >> >> Nabble.com. >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> --------------------------------------------------------------------- >> >> >> >> >> To unsubscribe, e-mail: >> >> >> [EMAIL PROTECTED] >> >> >> >> >> For additional commands, e-mail: >> >> >> [EMAIL PROTECTED] >> >> >> >> >> >> >> >> >> >> >> >> >> >> > >> >> >> >> > >> >> >> >> --------------------------------------------------------------------- >> >> >> >> > To unsubscribe, e-mail: >> >> [EMAIL PROTECTED] >> >> >> >> > For additional commands, e-mail: >> >> >> [EMAIL PROTECTED] >> >> >> >> > >> >> >> >> > >> >> >> >> > >> >> >> >> >> >> >> >> >> >> >> >> -- >> >> >> >> View this message in context: >> >> >> >> >> >> >> >> >> >> http://www.nabble.com/JDBC-Request-returns-results-but-still-shows-Error-Count%3A-1-tp16473795p16528663.html >> >> >> >> >> >> >> >> Sent from the JMeter - User mailing list archive at >> Nabble.com. >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> --------------------------------------------------------------------- >> >> >> >> To unsubscribe, e-mail: >> >> [EMAIL PROTECTED] >> >> >> >> For additional commands, e-mail: >> >> [EMAIL PROTECTED] >> >> >> >> >> >> >> >> >> >> >> > >> >> >> > >> >> --------------------------------------------------------------------- >> >> >> > To unsubscribe, e-mail: >> [EMAIL PROTECTED] >> >> >> > For additional commands, e-mail: >> >> [EMAIL PROTECTED] >> >> >> > >> >> >> > >> >> >> > >> >> >> >> >> >> -- >> >> >> >> >> >> View this message in context: >> >> >> >> >> >> http://www.nabble.com/JDBC-Request-returns-results-but-still-shows-Error-Count%3A-1-tp16473795p16529594.html >> >> >> >> >> >> Sent from the JMeter - User mailing list archive at Nabble.com. >> >> >> >> >> >> >> >> >> >> >> --------------------------------------------------------------------- >> >> >> To unsubscribe, e-mail: >> [EMAIL PROTECTED] >> >> >> For additional commands, e-mail: >> [EMAIL PROTECTED] >> >> >> >> >> >> >> >> > >> >> > >> --------------------------------------------------------------------- >> >> > To unsubscribe, e-mail: [EMAIL PROTECTED] >> >> > For additional commands, e-mail: >> [EMAIL PROTECTED] >> >> > >> >> > >> >> > >> >> >> >> -- >> >> >> >> View this message in context: >> >> >> http://www.nabble.com/JDBC-Request-returns-results-but-still-shows-Error-Count%3A-1-tp16473795p16529796.html >> >> >> >> Sent from the JMeter - User mailing list archive at Nabble.com. >> >> >> >> >> >> >> --------------------------------------------------------------------- >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> >> >> > >> > --------------------------------------------------------------------- >> > To unsubscribe, e-mail: [EMAIL PROTECTED] >> > For additional commands, e-mail: [EMAIL PROTECTED] >> > >> > >> > >> >> -- >> >> View this message in context: >> http://www.nabble.com/JDBC-Request-returns-results-but-still-shows-Error-Count%3A-1-tp16473795p16530368.html >> >> Sent from the JMeter - User mailing list archive at Nabble.com. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/JDBC-Request-returns-results-but-still-shows-Error-Count%3A-1-tp16473795p16531888.html Sent from the JMeter - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
