current number of active sessions only increases

[former_member372327]

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

[S0005304332]

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