Kbase 20570: SQL Only or 4GL Only Login Brokers Only Set Through Explorer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/10/2008 |
|
Status: Verified
SYMPTOM(s):
Specifying whether a primary or secondary login broker can accept SQL-only or 4GL-only clients via the Progress Explorer
The command line cannot be used to do this
Error: <command name | SQL Exception message>. (8933)
Exceeding Permissible Number of Connections (8933)
FACT(s) (Environment):
Progress 9.x
All Supported Operating Systems
FIX:
To set this value use the following steps:
1. Connect to the Progress Explorer
2. Expand the database tree
3. Under DefaultServerConfiguration, there is an option to make the login broker accept/service SQL Only, 4GL Only, or SQL and 4GL clients.
By default, the brokers are set to service both types of clients.
If, for example, SQL Only has been selected, a line in the database log states the broker is set to only service SQL Clients. A closer look at the log file reveals no corresponding startup parameter. However, an even closer look (at the conmngr.properties file) shows a new entry under [servergroup.dbname.defaultconfiguration.defaultservergroup] that shows the following:
Type=sql
This is the only place to restrict the type of client access to a particular login broker. Otherwise, modify the client's service port (-S) connection parameter to guarantee that your 4GL clients and SQL clients attach to a pre-designated login broker.
FIX:
References to Written Documentation:
Progress Solution:
20415, Exceeding permissible number of connections (8933)