KB43077: Error "(103) RFC_ERROR_LOGON_FAILURE: No RFC authorization for function module RFCPING" appears when launching the MDX Cube Catalog to connect to SAP BW 7 in MicroStrategy Developer

Salesforce Solutions Architect • Strategy

This article describes an issue that can occur where insufficient database user privileges are given to the database login used against an SAP BW 7 database.

SYMPTOM:
In Developer, when launching the MDX Cube Catalog to connect to SAP BW 7, the following error message shows up:


Login to database failed. Database error: Connect failed. Login failed. 
Error type: JCO layer error. JCOConnection.connect failed. java.lang.Exception: Failed to get SAP logon ticket
com.sap.conn.jco.JCoException: (103) RFC_ERROR_LOGON_FAILURE: No RFC authorization for function module RFCPING. on 10.27.10.10 sysnr 00
 at com.Strategy.Database.JCO.JCOConnection3.createConnection(Unknown Source)
 at com.Strategy.Database.JCO.JCOConnection3.connect(Unknown Source)
 at com.Strategy.Database.JCO.JCOConnection.connect(Unknown Source). Connection String: ...;.

CAUSE:
The error comes from the SAP Database, indicating that the SAP user being used here does not have RFC authorization for function module RFCPING.

ACTION:
Ask an SAP server admin to assign RFC authorization for the required function module to the user.

Comment

0 comments

Details

Knowledge Article

Published:

April 7, 2017

Last Updated:

April 7, 2017