Kbase P135797: 4GL client cannot connect to a database due to error 700 and 748
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/07/2010 |
|
Status: Verified
SYMPTOM(s):
4GL client cannot connect to a database due to error 700 and 748
The server or the system has no more resources. Please contact Progress Technical Support. (748)
** Server rejected login. (700)
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)
FACT(s) (Environment):
Database is configured for -n 20
-Mn is set to 16 for 16 server processes
-Ma is set to 16 for 16 users per server.
4GL client is local to the physical machine where the database is running.
4GL client is making use of -H hostname and -S port number to access the database.
promon dbname -> 5. Activity Screen indicates 20 remote clients are connected to the database.
Database only servicing 4GL clients.
All Supported Operating Systems
Progress 9.1E
CAUSE:
The database startup parameters are not configured sufficiently for the total # of users that need to connect to the database.
FIX:
Shutdown the database.
FIX:
1. Shutdown the database.
2. Modify database startup parameters for -n to reflect actual number of processes that need to connect to the database.
3. Review and modify the -Mn and -Ma parameters to reflect actual number of clients and servers needed to accommodate all remote users connecting to the database.