Kbase P102360: Not able to login 50 users with 50 Client Networking and 50 Enterprise DB licenses
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
SYMPTOM(s):
Only 25 users can login into a 50-users Enterprise DB licenses
Error 1154 in the database log
No servers are available. Try again later. (1154)
Error 5291 in the database log
You have attempted to connect to a database with too many users connected to it. Retry the connection later, or increase -n on the server. (5291)
Only 25 users can login
Making AppServer as well as client connections to database
50 Client Networking, 50 AppServer, and 50 Enterprise Database licenses
Each login uses two database connections
The -Mpb parameter is set to 10
The -Mn parameter is set to 51
The -Ma parameter is set to 5
CAUSE:
Since every users login uses two connection to the database (one client server and one AppServer) and the -Mpb maximum server per broker was limiting the number of broker to be spawned and the -Ma maximum clients per server was set to 5, only 50 connection could be established to the database. As a result only 25 users can login to the Application.
FIX:
Remove -Mpb or set it to a value that allows the number of needed connections