Consultor Eletrônico

Status: Verified

SYMPTOM(s):

Error Reading socket, ret=10054, errno=2 (778)

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

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

Problem appears to be sporadic. Sometimes a client will get the error, but after repeated attempts will connect.

The errors did not occur until they added the 5th database on the new server and clients started trying to connect to that.

Trying to connect to a sports database from a client that reported this error also fails with the same error.

FACT(s) (Environment):

The broker is started using a service defined in the services file with a port number of 15000 to 16000 number range.
The minimum and maximum port range being used are the defaults of 3000 and 5000 respectively.
Clients connect to 4 databases on one server and one database on a newly configured server.
Clients getting this error are connecting to a 5th database running on a new server.
Progress 9.1E04 Service Pack
Windows Server 2000 SP4

CAUSE:

The web filtering software, SurfControl, is blocking some, but not all, of the ports in the 3000 - 5000 range. And it is only filtering connections to the newer server with the 5th database, not the older server with the 4 databases. The problem is intermittent because sometimes the broker will assign a remote client to a server on a blocked port instead of one on a non-blocked port. It depends on how many remote clients are connected to each server and the -Mn, -Ma and -Mi startup parameters used. The broker will attempt to load balance across the servers based on those startup parameters.

FIX:

Configure the web filtering software to not block the ports used by the Progress broker and server processes.
Or us the -minport and -maxport startup parameters to specify a new range that the web filtering software is not currently blocking.