Kbase P6118: No servers are available. (1154) when client attempts connection with the -Mpb set to 1
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/12/2004 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.X
OpenEdge 10.x
SYMPTOM(s):
Client connection fails with errors (748)
The server or the system has no more resources. Try a larger -n. (748)
Only server 1 process was spawned in the database log file.
No servers are available. Try again later. (1154)
The -Mpb parameter is set to 1.
CAUSE:
The -Mpb parameter limits the number of servers to be spawned via the database broker. Setting the -Mpb to 1 allows only 1 server process to be spawned per the database broker. The one server spawned is currently handling its allowed client connections. If the "-Mpb" parameter is set to 1 then only the number of clients specified with the "-Ma" parameter are allowed to connect regardless of what the "-Mn" parameter is set to.
FIX:
Increase the -Mpb parameter. To reset this parameter to a higher setting the database must be restarted with the new parameter value.
Follow these steps to use the database startup parameter:
In addition to the regular parameters of the proserve command, specify the ?Mpb (maximum remote servers per protocol). Set the -Mpb parameter to the number of remote servers per broker to match the number of 4GL remote servers. After starting the first broker, start a second broker using -m3 parameter (for second login broker). Use -N, -S and -Mpb for the number of remote SQL92 users.