Kbase P170722: Error 437 and 700 trying to connect a database when database name on connection string is correct
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/07/2010 |
|
Status: Unverified
SYMPTOM(s):
Error 437 and 700 trying to connect a database
Disconnected from server because database name was incorrect. (437)
** Server rejected login. (700)
Server cannot find a free port for a TCP socket. (1159)
Database Server process that rejected the connection appears to have sufficient ports available for connection.
netstat -a shows that the port that the server process that rejected the connection is in a listening state.
The databases are not making use of the -minport and -maxport settings for different port ranges.
FACT(s) (Environment):
Local users are not experiencing an issue.
Many remote clients connecting to the database.
Promon R&D -> Status -> Servers shows that there are servers available for the connection.
Multiple databases being started on this machine.
Database name on the connection string that is receiving the error is correct.
All Supported Operating Systems
Progress/OpenEdge Product Family
OpenEdge Category: Database
CAUSE:
netstat -a shows that the port that was associated with the server process that rejected the connection is actually associated with a different PID (Process ID) that happens to be associated with a different database name altogether.
FIX:
Use -minport and -maxport to define different port ranges for all the databases being started on this machine.