maximum connections limit reached error during SAP BO report 200 user load test
Issue in details:-
We have performed the 200 user load test for 1 hour 30 mints peak duration. After certain point of time observed transaction failure and few mints later test resumed as normal (No failure).
We are suspecting there might be a connection issue between Perfomance center and SAP BO application.
When the transaction started failure, Immediately we have accessed the application manually and observed error as "Maximum connection limit has been reached".
While analyzing the results file (lrr), we could see spikes in the Connection and conection/sec as well as similar representative in HTTP repsone graph as well when the trasactions started failure. (PFA)
Also done the few analaysis in Runtime setting, we kept the preference section setting as like below which might leads to connection limit issues (assumption).
HTTP Request connect timeout:- 3600 sec
HTTP Request receive timeout:- 3600 sec
HTTP keep alive timeout:- 3600 sec
step download timeout:- 3600 sec
We are suspecteing, Conncetion limit has been reached due to above runtime settings. Our script designed such way that, whenever user failed to perfom any one of the trasaction then immediately current user will perfom logoff transaction and new user will do login transaction( To maintain the user concurrency).
If the trasaction is failed then the respective connection need to be closed immediately which is not happening (Assumption)it might be due to above runtime settings. assuming Respective connection of failed transaction is waiting until 3600 sec's to close and the mean time new connection is creating for new user which leads to hit the maximum connection limit
Also we kept the web_set_max_html_param_len to 999999 for few scripts ( Not knowing exact purpose). Based on the other form discussion they are conveying like, It will also impact the LG's memory related issue and leads to transaction failure.
If we decrease the runtime setting to 60/120 sec, Whether connection will be closed for failed trasaction?
How we need to asses, what value need to set for web_set_max_html_param_len?
What could be the rootcause of fist trasaction failure ?
Where we can get, each connection How long i opened?.
if there is any change is required in LR script o overcome this issue?.
Note:- I can able to provide folowing deatail if you need
single user load test rawresults
200 users load test rawresults
Sample thread from SAP Portal - connection limit issues
Kindly let me know if you need any additional details
Ravi M - 07448325875