Issue with SMS agent service (ccmexec.exe) and Alteryx Connect using port 8005 after Windows patch update, causing Alteryx Connect to crash after startup.
Connect version 2021.2
Connect Metadata Loaders version: 2021.2
This can likely happen with any version of Connect.
Windows patch update on machine if Connect had worked correctly beforehand. Otherwise, this could occur any time the needed port is otherwise bound.
Catalinaout.log will show the error below:
"SEVERE: Failed to create servershutdown socket on address [localhost] and port [8005] (base port [8005] and offset [0])"
After Windows patch update, SMS agent host service (ccmexec.exe) had bound to port 8005, so it was unavailable when attempting to start Alteryx Connect service (and also when attempting to stop Alteryx Connect service). This is due to code in theserver.xml file which designates port 8005 as the shutdown port for Alteryx Connect service.
To check what service is using port 8005 you can open Command Prompt in Admin mode and run the following command:
- netstat -ano | findstr 8005
From there you can take the PID and run this command to see what service is running on 8005.
- tasklist | findstr 8005
1. Update the shutdown server port in Server.xml file usually located in <install directory>:/Alteryx Connect/conf/server.xml.
Note: We recommend that you set the port to be any free port, but optimally one that is not typically assigned to other software. For reference here is a list of commonly used ports: https://en.wikipedia.org/wiki/List_of_TCP_and_UDP_port_numbers
2. Save the server.xml file.
3. Startup the AlteryxConnect service.