Kbase 19354: Error 8839 & 8933 when Connecting a SQL Client to the databa
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/08/2004 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.0B
FACT(s) (Environment):
Windows 32 Intel
FACT(s) (Environment):
Progress 9.1A
FACT(s) (Environment):
Progress 9.1B
FACT(s) (Environment):
Progress 9.1C
SYMPTOM(s):
Cannot connect a SQL client to the database.
No SQL servers are available. Try again later. (8839)
Exceeding permissible number of connections (8933)
Increasing the -n (number of users) does not help.
Increasing the -Ma (number of clients per server) does not help.
CAUSE:
Each SQL client has a one to one correspondence to the SQL servers. This means that every SQL client requires it own dedicated server to connect to the database.
If a Secondary login broker is not setup, the SQL clients will encounter contention for the servers by the 4GL clients connecting to the database.
FIX:
Create a secondary login broker, specifically for the SQL clients.