Problem

-- CN log

2024-06-03 17:05:44,067 - FATAL [qtp1597461435-289] (ConnectionManagerImpl) - Error while getting a database connection
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host sqlp-b2b-qua.lazard.com, port 53001 has failed. Error: "Address already in use: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

-- Integrator trace :

WARNING:20240604:14.32.45.71:r4edi(starter):failed to connect to ProcEngine server "procengine_1072_14_1": failed to connect to processing engine on host 'PARQWB2BXFR01', port 'Integratorpool4': SOCKET_CONNECT: connect() system call failed: Address already in use

ERROR :20240604:14.33.04.15:r4edi(b2bi_clusternode):Thread:85:REGISTER_CHILDEXITENABLE: socket error 'Address already in use' when connecting client sock

ERROR :20240604:14.33.04.15:r4edi(b2bi_clusternode):B2Bi Cluster Node:155:REGISTER: REGISTER_CHILDEXITENABLE: socket error 'Address already in use' when connecting client sock

Resolution

* it could be that the windows dynamic range is too short

* netsh int ipv4 show dynamicport tcp

if the command show a range <= 1000, upgrade it to a 10000 number of ports (i.e. from 55000 to 65000) using this command :

Ex :

netsh int ipv4 set dynamicport tcp start=55000 num=10000