[Resolved] Issue saving Load Test info to database

Hello,

In the datasource step, click on the option button (icon is a screwdriver crossed with a wrench). In here there is an option that you need to check the "shared" option. Please try this and let me know if you have issues or questions.

Regards,
Temil

Hi,

That option is already selected, below is the screen shot....



Thanks,
Prashanth

Hi,

The log entries indicate that you have a problem in a Groovy script. I think you have a line of code something like

myObject.add(something)

... and when the script is executed, the variable myObject is null, for whatever reason. Support for custom Groovy code is not included in our support offering, but I hope this will help you find what's failing.

Kind regards,
Manne

Hi,

I created data connection in the LoadTestRunListner.beforeloadtest which was used in other event ("afterteststep") to log. So i moved the data connection to the event where I am logging the info to database and the error disappeared.

Except the below debug message the issue is resolved. Can you tell me why the below message is showing.

Thu Oct 24 05:45:25 EDT 2013:DEBUG:Failed to find shared datasource [datasource#1.MySQLDataSource] for [1.MySQLDataSource]


Thanks,
Prashanth

Hard to say but seems like there was some error while creating the instance of the data source and hence it was not set to the load test context.
It will be easier for us to figure out if you can share the project.

Best Regards,
Prakash

Hi,

Attached is the project, one more thing I would like to highlight is when I run the load test on the screen it shows count for each step. But the LoadTestRunListener.afterTestStep is inserting more records than the count on the screen. Its getting hard to reconcile against the report o

You may need to create table in MYSQL and update the connection properties in the Project.

CREATE TABLE webservices.tb_loadtestlog (
runindex INTEGER UNSIGNED NOT NULL,
teststep VARCHAR(50) NOT NULL,
type VARCHAR(20) NOT NULL,
starttime INTEGER UNSIGNED NOT NULL,
timetaken number UNSIGNED NOT NULL,
status VARCHAR(10) NOT NULL,
threadindex INTEGER UNSIGNED NOT NULL
)




CREATE TABLE `ws_response_data` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Message_ID` varchar(100) DEFAULT NULL,
`RequestTimeStamp` varchar(45) DEFAULT NULL,
`ResponseTimeStamp` varchar(45) DEFAULT NULL,
`RequestStatus` varchar(100) DEFAULT NULL,
`TimeTaken` varchar(20) DEFAULT NULL,
`Response_Size` varchar(50) DEFAULT NULL,
`ReplyStatus` varchar(100) DEFAULT NULL,
`Request_msg` varchar(4000) DEFAULT NULL,
`Response_msg` longtext,
`UUID` varchar(100) DEFAULT NULL,
PRIMARY KEY (`ID`)
)


Thanks,
Prashanth

Hi Prashanth,
I was able to reproduce it, will get back to you as soon as I know the root cause.

Best Regards,
Prakash

Hi,

This issue is different, if you think this should be a new ticket let me know I can create one...

I have two different events in the project which saves the raw request and response info to the database and found this discrepancy. I have run the test multiple times and every time I had observed the same thing, below are the number:

Test Scenario: Fixed Rate 2 per second and run for 305 seconds, so expectations are there should be 610 request generated in the test.
On the screen report shows Request Step Count: 595
Records saved using ("LoadTestRunListener.afterTestStep"): 606 (always more than the request step count )
Records saved using ("RequestFilter.afterRequest"): 526 (always less than the request step count in the report)

When I execute the test, on screen count for the request test step in Load Test report is not same as the number of records saved to the database using event handler(LoadTestRunListener.afterTestStep).The observation is always more than the request shown on the screen.

Also the number of records saved using event "RequestFilter.afterRequest" doesn't match either with Report or "LoadTestRunListener.afterTestStep". The other way I am saving the info to the database is using test step(groovy script) which again has different count than both the events shown above this matches with the count shown on the report.


If the difference was small number I could have thought issue with the in flight threads but I think that's not the case. Can you give some insight on the counts shown on the screen. Its getting difficult to reconcile the number of request sent in the load test.

Thanks,
Prashanth

Hi Prashant,

There are known issues with the Shared Data Source with property 'Restart Shared' enabled. You can find more details here in section 'Synchronization Issues': http://www.soapui.org/Load-Testing/data ... sting.html
Missing Shared data source problem will be solved if you use the Limit as Total Runs and the value of the limit should be same as (or in multiple of) the number of Thread.
The second problem of discrepancy between saved records and number of steps should also be fixed by this - otherwise please report it as a separate issue.

Best Regards,
Prakash
SmartBear Sweden

Hi,

My scenario for load test is to send fixed unique request (2) per second for a total of 600 request, can that be achieved with Total Runs. I actually managed to get rid of "Missing Shared data source problem" message by checking "cancel running" under load test options but the records saved are still more than the number of records shown in the LoadUI report.

Thanks,
Prashanth