SAP Knowledge Base Article - Public

2686792 - Data Acquisition fails with internal server error when importing data from BW BEx query with mandatory variables in SAP Analytics Cloud (SAC)

Symptom

  • Failed to acquire data from SAP BW Import connection when using SAP Analytics Cloud Agent version 1.0.115.
  • Problem is specific when using mandatory BW variables without default or SAP/Customer Exits defined.
  • Following error message appears when SAP Analytics Cloud is trying to list the available values to submit:
    • An internal server error occurred in the SAP Analytics Cloud agent: Error: Provider Selection Object: Initialization Issue Specify a value for variable Enter Product Specify a value for variable <Variable_Name>
  • The Catalina logfile in Tomcat folder shows:
    • com.sap.fpa.logging.CoreLogger.log Error while processing BW request:com.sap.ip.bi.base.exception.BIBaseRuntimeException: Error: Provider Selection Object: Initialization Issue...
    • Caused by: com.sap.ip.bi.bics.dataaccess.resource.impl.bi.exceptions.BicsResourceBwRuntimeException: Invalid variable values

Environment

  • SAP Analytics Cloud 2018.15
  • SAP Analytics Cloud Agent 1.0.115

Reproducing the Issue

  1. Create a model using SAP BW Import Data Connection as a datasource.
  2. Select a connection and choose "Create a new query".
  3. Browse a BEx query containing mandatory variables.
  4. Click Next.
  5. List of values are failing to load and error message appears.

Cause

Defect in SAP Analytics Cloud Agent version 1.0.115 and 1.0.117

Resolution

Resolved with the 1.0.118 version of the SAP Analytics Cloud Agent.

Upgrade to the latest version of the SAP Analytics Cloud agent (1.0.118).

  • In case you encounter the above problem please revert your SAC Agent version to 1.0.111 or 1.0.113 or upgrade to 1.0.118.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,  SAP BW Import Data Connection, list of values, lov, mandatory, exit, customer, sap, variable , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0