KB442590:Error message "JCO_ERROR_COMMUNICATION: Initialization of repository destination xxxx failed: Connect to message server on host XXX failed” appears on Microstrategy web and Developer by connecting to SAP BW Message Server

SYMPTOM:
When connect to SAP BW Message Server, no matter in Developer or Web(Data Import), users get an error message as showed below.

Connect failed. Login failed. Error type: JCO layer error. JCOConnection.connect failed. java.lang.Exception: [JCO] Failed to get SAP logon ticket com.sap.conn.jco.JCoException: (102) JCO_ERROR_COMMUNICATION: Initialization of repository destination xxxxx failed: Connect to message server on host xx,xx,xx,xx failed

CAUSE:
It is caused by a configuration problem in SAP BW. Strategy is unable to connect to the SAP BW Message Server because the Message Server entry has not been added to the "services" file, or the Message Server port number is incorrect in the "services" file.
ACTION:
Add below entry in 'services' file

Entry:  sapms<SID>    <Port Number>/tcp   #SAP System Message Server Port
For example, if the SAP Message Server <SID> is R79, and the port number is 3601, the entry to add to the services file will be like:
sapmsR79   3601/tcp   #SAP System Message Server Port

• For Intelligence server in Windows machine. the 'service' file is located in the path C:\Windows\system32\drivers\etc\services
• For Intelligence Server in Linux machine, the 'services' file is located in the patch /etc/services

 
 
  KB442590