3528819 - Error message 'Lookup of function RSAO_BICS_OPEN metadata failed for destination xxx' is displayed when opening AO workbook

• When opening an AO workbook, following error message is displayed when AO tries to connect to the BW system:
  
  [290e-2329-17] Lookup of function RSAO_BICS_OPEN metadata failed for destination XXX
  [290e-2329-17] The only destination xxx available failed when retrieving
  metadata from XXX -- see log for details
  
  
• Issue may occurs only for specific users.
  
  
• In AO_Trace, following exception can be found:
  
  General .NET Exception [290e-2329-17]:
  Lookup of function RSBOLAP_BICS_STATISTIC_INFO metadata failed for destination XXX
       SAP.Middleware.Connector.RfcRepository.LookupFunctionMetadataClassic(String name)
       SAP.Middleware.Connector.RfcRepository.LookupFunctionMetadata(String name)
       SAP.Middleware.Connector.RfcRepository.GetFunctionMetadata(String name, Boolean reload)
       SAP.Middleware.Connector.RfcRepository.CreateFunction(String name)
       com.sap.ip.bi.base.application.service.rfcproxy.impl.nco3.Nco3Proxy.createFunctionWithoutGracefulFailure(String name)
       com.sap.ip.bi.base.application.service.impl.statistic.StatisticService.writeEvents(Boolean stepClose)
       com.sap.ip.bi.base.application.statistic.impl.StatisticApplicationStep.endApplicationStep()
       com.sap.ip.bi.base.application.statistic.impl.StatisticManager.stepClose()
       com.sap.ip.bi.base.application.impl.Application.endApplicationStep(Int32 commitMemoryTag, Int32 exceptionReason)
       com.sap.ip.bi.base.application.impl.Application.endApplicationStep()
       com.sap.ip.bi.base.application.impl.Application.destroy()
  >>
  General .NET Exception [290e-2329-17]:
  The only destination XXX available failed when retrieving metadata from XXX -- see log for details
      SAP.Middleware.Connector.RfcRepository.FindAlternateDestination(Int32& destIndex, Int32& alternativeDestinationsCount, Exception ex)
      SAP.Middleware.Connector.RfcRepository.Execute(RfcFunction function)
      SAP.Middleware.Connector.RfcRepository.LookupFunctionMetadataClassic(String name)

• In 'dev_nco_rfc.log' trace, following exception can be found:
  
  SAP.Middleware.Connector.RfcAbapRuntimeException: No RFC authorization for function module RFC_FUNCTION_SEARCH.
     at SAP.Middleware.Connector.RfcFunction.RfcCallReceive(RfcConnection conn, RFCID rid)
     at SAP.Middleware.Connector.RfcRepository.Execute(RfcFunction function)
     at SAP.Middleware.Connector.RfcRepository.UseRfcMetadataGet()
     at SAP.Middleware.Connector.RfcRepository.LookupFunctionMetadata(String name)
     at SAP.Middleware.Connector.RfcRepository.GetFunctionMetadata(String name, Boolean reload)
     at SAP.Middleware.Connector.RfcRepository.CreateFunction(String name)
     at com.sap.ip.bi.pioneer.core.Connections.Rfc.CrRfcProxy.GetInternalRfcFunction(String destinationName, String functionName)
     at com.sap.ip.bi.pioneer.core.Connections.Rfc.CrRfcProxy.call_RSAO_BICS_SESSION_INITIALIZE(String iDestinationName, String iSessionId, Dictionary`2 iFrontendParameters, Boolean& oNoBwFunctionalityAvailable)

SAP Analysis for Microsoft Office

Analysis Office, Analysis for Office, A4O, Analysis for Excel, A4O, access, authorized , KBA , BI-RA-AO-XLA , Excel Addin , Problem