Absent Member.
Absent Member.

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.

Solution expected:-

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 script
Sample thread from SAP Portal - connection limit issues
Kindly let me know if you need any additional details


Ravi M - 07448325875

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.