Consultor Eletrônico



Kbase P5808: Client disconnected from database after some idle time
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   25/11/2009
Status: Verified

SYMPTOM(s):

Client disconnected from database after some idle time

Error 735 and 778 appear in the database log file

** Incomplete write when writing to the server. (735)

Error <read/writing> socket, ret=<n>, errno=<n>. (778)

Error reading socket, ret=10054, errno=2. (778)

FACT(s) (Environment):

Clients connect to database via -H -S and -N
Firewall between database server and clients
All Supported Operating Systems
Progress/OpenEdge Product Family

CAUSE:

Some firewalls have a timeout on inactive connections feature,
For example Checkpoint Firewall-1 has by default a 1 hour timeout for inactivity this timeout value is set thru the TCP_TIMEOUT parameter, and its value is given in seconds

FIX:

Increase the timeout of inactive connections on the Firewall to supply your inactive connections