Skip to Content
0

current number of active sessions only increases

Oct 18, 2017 at 11:42 AM

164

avatar image

Hi,

Recently installed BI 4.2 SP04. It's a small configuration for max 30 named users, 16 GB RAM.

Now we're experiencing an issue where we receive the following error: Connection failed. server has reached the maximum number of simultaneous connections (Error: RWI 00239)

Maximum number of connections is set to 200. So when the current number of active sessions from the webi processing server reaches 200, it will throw this error. The max number of users who were simultaneously running reports is 5 over the last 3 months

I've monitored the 'current number of active sessions' metric from the webi [processing server and it just never seems to go down. If I open a report the number goes up, if I close the report the number won't go down. Even after logging out and waiting for 20 minutes, the session remains active.

Any ideas on this?

Regards,

Yvo van de ruit

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Megh Vora Oct 18, 2017 at 01:13 PM
0

Hi,

Please check below two SAP KBAs:


1517019 - "Connection failed. The server has reached the maximum number of simultaneous connections. (Error: RWI 00239)" when opening a Web Intelligence document

2012623 - The maximum connection limit has been reached. (Error: RWI 00239) (Error: INF) or (Error: RWI 00000) when opening a WebI Report

Additionally, are you aware since when did you start facing this issue? Was there any upgrade made?

Did you change any session timeout parameter for your webapps? BI Launchpad?

How is your environment setup? I mean is it clustered/standalone? How many webi processing servers do you have?

Do you only have named user licenses or concurrent users also? Is the issue observed with only name user license key or concurrent as well?

Do you face the same issue when you open a report with Administrator user?

Have you tried restarting the SIA once to release all the sessions and then try fresh. If not then can you try to restart the SIA and then observe for any pattern or workflow to replicate this issue.

Thanks,

Megh

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Megh,

Thanks for your answer!

No update, just a clean standalone installation, 1 webi processing server(as we have 1 CPU) and no parameters changed. We only have named users. When opening reports as Administrator all works fine, sessions are cleared when a report is closed.

SIA has been restarted every time the error appears.

Regards,

Yvo

0
Jawahar Konduru Oct 18, 2017 at 01:27 PM
0

it looks like it may be a bug. I have not reproduced it from my side. Can you check, if your webi processing server , Properties -> Enable Memory Analysis - Uncheck this option. and try again.

Share
10 |10000 characters needed characters left characters exceeded
Dell Stinnett-Christy Oct 19, 2017 at 02:26 PM
0

Also, I would make sure that you've installed the latest patch for 4.2 SP4.

-Dell

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 20, 2017 at 10:21 AM
0

Hi,

Please check below SAP KBA new constraint for bi plateform BI4.2 SP4

https://blogs.sap.com/2017/05/12/limits-to-number-of-sessions-for-named-users/

Regards

Share
10 |10000 characters needed characters left characters exceeded