SAP Knowledge Base Article - Public

2628984 - Error "Data import from model cyclic object value failed" when creating a model using User Predefined Model based on Salesforce in SAP Analytics Cloud (SAC)

Symptom

  • Error "Data import from model cyclic object value failed" when creating a model using User Predefined Model based on Salesforce in SAP Analytics Cloud (SAC).
  • The model will show after the creation but data refresh will fail.
  • No data show when creating a story based on this model.
  • The issue happens on both Basic Authentication Salesforce connection and OAuth2 Authentication Salesforce connection.
  • No column with label: XYZ at com.simba.salesforce.dataengine.reports.SFReportMetadataHelper.createTabularMetadata

Environment

  • SAP Analytics Cloud 2018.5.1

Reproducing the Issue

  1. Log into SAC and go to Create -> Model.
  2. Click Get data from an app and choose Salesforce.
  3. Input Model name and choose a connection for Salesforce.
  4. Choose User Predefined Model and select any source.
  5. Click Import and the error shows.

Cause

Report fields had invalid properties. An error "No column with label" was observed.

Resolution

Field with error "No column with label" needs to be removed from report query.

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

EPM, 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, SFDC Data refresh Filter unavailable , KBA , sfdc data refresh filter unavailable , 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