Kbase P11716: Exceeding permissible number of connection - No Secondary Login Broker
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/05/2009 |
|
Status: Verified
SYMPTOM(s):
Error on ODBC connection
Error on JDBC connection
[DataDirect Technology][ODCB Progress drive][Progress] Invalid attribute in connect in connect string
Description [DataDirect Technology][ODCB Progress drive][Progress] Exceeding permissible number of connection
Not using Secondary Login Broker
No SQL-92 Servers available
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
Not enough Servers available to be spawned by the broker
FIX:
Increase the number of Servers by increasing the value of the "-Mn" parameter.
Ensure that the minimum number clients per server "-Mi" will allow the number of servers that you increased to be available. This is achieved by increasing the value of "-Mi" parameter to be the same as the "-Ma" value.
Example
Lets say you have a maximum of 50 4GL remote users and you need a maximum of 10 SQL-92 connections, for this you can start your DB like this:
proserve sports -S 4444 -Ma 10 -Mi 10 -Mn 15 -n 62
The 50 4GL users will use 5 servers, -Mi 10 will cause that each server will reach 10 connections before starting a new one.
This will leave 10 servers free for SQL-92 connections.