KB39766: "Error type: JCO layer error. JCOCatalog.fetchCubes failed. java.lang.Exception" message is seen when connecting SAP BW

DESCRIPTION:
When configuring the Intelligence Server 9.x connection to a SAP BW server, the following error message is seen:
 
 

2011-10-31 16:57:28.193-05:00 ExecCubeQuery failed. MDX Catalog read failed.Error type: JCO layer error. JCOCatalog.fetchCubes failed. java.lang.Exception: Error during fetching Cubes.Exception during Bapi Creation: com.sap.conn.jco.JCoException: (102) JCO_ERROR_COMMUNICATION: Connect to message server host failed Connection parameters: TYPE=B DEST=ABAP_AS MSHOST=167.106.116.190 GROUP=RJR_RWQ R3NAME=RWQ PCS=1 LOCATION CPIC (TCP/IP) on local host 42PR0R1 with Unicode ERROR service '?' unknown TIME Mon Oct 31 16:57:28 2011  RELEASE 720 COMPONENT NI (network interface) VERSION 40  RC -3  DETAIL NiErrSet COUNTER 3 at com.Strategy.Database.JCO.JCOCatalog3.fetchCubes(Unknown Source) . Connection String: N/A;. Connection String: N/A;.

 
CAUSE:
A possible cause is that the SAP port number does not exist in the Windows Services file.
 
ACTION:
Copy the SAP Port to the Windows Services file at the location below:
%WINDIR%\system32\drivers\etc\services file