KB439888: Configurable Port Number for the Data Wrangling Service in MicroStrategy 2021

INTRODUCTION
The port number for the Data Wrangling Service i.e., the  MJRefSvr_64 Refine Server process is user-configurable. In older Strategy versions (before version 10.11 and 10.4 Hotfix7), the process used the default value of 3333 and was not configurable. 
This feature will be useful in Strategy deployments which are not able to use the port 3333 for administrative or security reasons, increasing the usability of the MJRefSvr_64 process. 
The port can be configured through a registry setting in Windows environments or by editing the MSIReg.reg file in Linux/Unix environments. 
The following factors need to be considered before setting a port for the Refine Server process: 

• The value should be set to a positive integer no greater than 65535
• The value should be different than the port used by the Intelligence Server (default value 34952)
• Any other invalid value will cause the MJRefSvr_64 process to use the default value of 3333
• If the specified port is occupied, the process will try increasing port values until an open port is found

​If the registry/MSIReg settings are not changed at all from the out-of-the-box values, the process will use the default port value of 3333.
Steps for Windows Operating Systems

1. Type 'regedit' on the Windows run menu to access the Windows  registry,
2. Navigate to the key HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Strategy, and create a new Key called "Refine Server"
3. Add a new string value under this key called "port" and modify it to give it the desired value. A screenshot of the completed configuration is below:

Steps for Linux Operating Systems

• Stop the Strategy Intelligence Server and make a backup of the MSIReg.reg file found in the home folder of the Strategy installation.
• Edit the MSIReg.regi file to add the following lines (with the desired port number instead of 12345):
  

  
  [HKEY_LOCAL_MACHINE\SOFTWARE\MicroStrategy\Refine Server]
  "port"="12345"

  
  
  Below is a screenshot of the edited MSIReg.reg file:
  

Registry Modification:
WARNING: 
Modifying registry values incorrectly may cause serious, system-wide problems that may require the re-installation of Microsoft Windows or Strategy Product Suite. Any edit of the registry is done at the user's own risk. Since these are user-initiated changes, they are not covered by any Strategy warranty. If using Microsoft Windows, the user should backup the registry and/or update an Emergency Repair Disk (ERD) prior to alterations.