Kbase P14904: Unable to connect to a database - No servers are available. Try again later. (1154)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/6/2010 |
|
Status: Verified
SYMPTOM(s):
Cannot get any more remote clients connected to a database due to 1154 error.
Remote clients can't connect to a database
No servers are available. Try again later. (1154)
FACT(s) (Environment):
-n parameter is set high enough to warrant additional user processes connecting to a database.
Maximum allowed remote clients are currently logged in.
promon dbname -> R&D -> 1. Status Displays -> 3. Servers shows that based on -Ma and -Mn the maximum number of servers and remote clients have been exhausted.
All Supported Operating Systems
Progress/OpenEdge Product Family
CAUSE:
The 1154 error is expected behavior in this situation because you have reached the limit for the number of remote clients and server processes that can be started for the database, based on the way your database is currently configured.
FIX:
Number of remote clients that can connect to a database is managed by -Mn (maximum number of remote servers) and -Ma (maximum clients per remote server).
Increase the -Mn (or -Ma) in order to allow more remote clients to log in.