SAP Knowledge Base Article - Public

3024674 - "Failed to create the query. Please contact your administrator" error message in SAP Analytics Cloud (SAC) embedded in SuccessFactors

Symptom

  • When running existing Story reports and creating a new Story query from "Employee Central" domains like "Personal Information", "Compensation and Job Information", the following error occurs: "Failed to create the query. Please contact your administrator".
  • Browser console log error:

query
{"error":{"status":400,"errorCode":"0","message":"Query is not activated and will be deleted, Query Name:[name of the query used]","target":null,"details":[{"message":"BadRequestException: error occurred"}]}}

Environment

  • SAP Analytics Cloud (Enterprise) 2021.02.03
  • SF SuccessFactors

Reproducing the Issue

  1. Login to SuccessFactors area and go to Reporting.
  2. Go to the All Reports tab > search for the report.
  3. Run this report => Error or no result.
  4. Edit the report then go to More > Add or Edit Data Sources > Edit Data Source.
  5. Preview the Query => "Failed to create the query. Please contact your administrator".
  6. Try removing the tables/objects one by one and preview again => "Failed to create the query. Please contact your administrator".

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-OEM , Embedded usage of SAP Analytics Cloud , LOD-SF-ANA-SAC , People Analytics (Analytics Cloud for SF) , Problem

Product

SAP Analytics Cloud 1.0 ; SAP SuccessFactors HXM Core 2011