Kbase P184454: Error 748 occurs connecting client when database should have sufficient resources
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/03/2011 |
|
Status: Unverified
SYMPTOM(s):
Error 748 occurs connecting ABL client when database should have sufficient resources
The server or the system has no more resources. Please contact Progress Technical Support. (748)
Database is configured to use primary and secondary brokers for ABL and SQL connections respectively
Database is started with the following commands/parameters:
proserve sports -Mn 5 -Mp 2 -ServerType 4GL -S 9991
proserve sports -m3 -ServerType SQL -S 9992
If SQL server is spawned first, then only 1 ABL server can be started
If ABL servers are started first, then a maximum of 2 ABL servers can be spawned
Database log file reports error 1154
No servers are available. Try again later. (1154)
FACT(s) (Environment):
Parameters should allow 4 servers to be spawned for the database
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
Bug# OE00205899
CAUSE:
The -Mp parameter (Servers Per Protocol) is used incorrectly and can be avoided by using the correct parameter (-Mpb - Maximum Servers Per Broker). -Mp is a legacy parameter left over from the time when Progress supported multiple network protocols (e.g. TCP and Novell) . -Mp is intended to to limit the number of servers that a broker can start to serve remote users for a specific network protocol. In addition, per the documentation, -Mp should only be used with a secondary broker. The behaviour that sees only 1 ABL server spawn does appear to be erroneous though.
FIX:
Replace -Mp with -Mpb.
Set -Mpb on each broker to divide -Mn appropriately between brokers. For more information on setting up primary and secondary brokers, please refer to solution P7843.