Kbase P180877: Error "No servers available" when attempting to connect to DataServer for MS SQL Server via Unified
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/02/2011 |
|
Status: Unverified
SYMPTOM(s):
Error "No servers available" when attempting to connect to DataServer for MS SQL Server via Unified Broker
Error "No servers available" followed by 7255, 1451 when attempting to connect to DataServer for MS SQL Server started with Progress Explorer
Error "No servers available" followed by 7255, 1451 when attempting to connect to DataServer for MS SQL Server started with OpenEdge Explorer
On screen error reports the following:
No servers available
DataServer connection failure. (7255)
Failed to connect to MSS database . (1451)
Only 36 ABL client can be spawned. Spawning more than 36 causes the above error.
The ABL client is connecting to 7 different schema holders which causes 7 _msssrv.exe processes to be spawned by the mssbroker1
FACT(s) (Environment):
Starting DataServer brokers via Unified Broker / AdminServer
MS SQL DataServer
OpenEdge 10.2x
Windows
CAUSE:
The maxSrvrInstance is set to 256 which is causing the error when more than 36 ABL client being spawned.
FIX:
Modify the "maxSrvrInstance" to the value that matches the number of ABL client times the number of schema holders or schema images inside a schema holder being connected per ABL client on the settings found in Server properties for the DataServer Unified Broker.
For instance the value of the maxSrvrInstance should follow the math below:
maxSrvrInstance = # of ABL client * # of schema holders (or schema images inside a schema holder)
In order to change this property you need to manually modify the $DLC/properties/ubroker.properties file by setting the "maxSrvrInstance" parameter. For example:
#
# Default properties for broker instances serving Oracle DataServers
#
[UBroker.MS]
appserviceNameList=
brkrLoggingLevel=3
classMain=com.progress.ubroker.broker.ubroker
defaultService=0
description=MSS DataServer Broker
initialSrvrInstance=0
maxSrvrInstance=256
minSrvrInstance=0
operatingMode=State-aware
portNumber=4446
srvrDSLogFile=
srvrExecFile="@{Startup\DLC}\bin\_msssrv.exe"
srvrMaxPort=5000
srvrMinPort=3000
srvrStartupParam=-svub -S X -N TCP -U X -P X -hs 0 -s 40