Kbase P15764: No SQL servers available after 4 connections/disconnections
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/11/2008 |
|
Status: Verified
SYMPTOM(s):
Connecting SQL clients to a database
SQL and 4GL brokers are started
No SQL servers are available. Try again later. (8839)
No SQL servers available after 4 connects/disconnects
Error 8839 received even though no clients are currently connected
FACT(s) (Environment):
Progress 9.1B
Progress 9.1C
CAUSE:
Bug# OE00063261
CAUSE:
The bug is due to a _sqlsrv2 reuse error. This does not occur with the primary broker because the primary broker reuses the servers.
FIX:
Upgrade to Progress 9.1D.
A workaround is to use the primary broker for the SQL92 clients, and use the secondary broker for the 4GL clients, although this has not worked in all cases.