Kbase P17008: Errors 1154, 748 and 8839 with both 4GL and SQL92 clients.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
No servers are available. Try again later. (1154)
The server or the system has no more resources. Try a larger -n. (748)
No SQL servers are available. Try again later. (8839)
Progress 4GL and SQL92 clients simultaneously connected.
Only one login broker for the database is defined (that's the default).
CAUSE:
The error messages are generated when you only have one login broker to serve both 4GL and SQL92 clients.
Your 4GL remote connections could use up the maximum number of remote servers (-Mn startup parameter) solely for the 4GL remote servers. In this scenario, a new SQL92 client would not be able to connect to the database because the broker cannot spawn a new SQL92 remote server for the SQL92 client.
The other way round may also be true: your SQL92 connections have used up the maximum number of servers only for SQL92 remote servers, and a new 4GL remote server cannot be spawned for a 4GL remote client.
FIX:
Please configure a secondary login broker as detailed in Progress Solution 19968