SAP Knowledge Base Article - Preview

2485402 - "Search query failed" after searching for BEx queries when importing data from BW in SAP Analytics Cloud

Symptom

  • The following error messages appear when searching for BW Queries at model creation:
    • "Search query failed"
    • "Failed to load resource: the server responded with a status of 500 (Internal Server Error) error - 500 - Internal Server Error -  sap.fpa.ui.infra.service.AjaxHelper @ sap-ui-core.js:160"
  • Function module BICS_CONS_SET_GET_SESSION_PROP does not have output table E_T_CAPABILITIES (execute using transaction SE37 on the BW system)
  • In Tomcat logs there is an error, where the NullPointerException coming from BWMasterSystemSettingsService.isBW4Hana:
    • "java.lang.NullPointerException
      at com.sap.ip.bi.base.application.service.impl.application.BWMasterSystemSettingsService.isBW4Hana(BWMasterSystemSettingsService.java:773)"


Read more...

Environment

  • SAP Analytics Cloud 2017.11.1
  • SAP Business Warehouse
  • SAP Analytics Cloud Agent 1.0.59 or newer

Product

SAP Analytics Cloud 1.0

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.