SAP Knowledge Base Article - Public

3277868 - Error "We found an issue in the joins while creating the query" in SAP Analytics Cloud (SAC)

Symptom

When using an embedded version of SAC to create a story, if you add the same table three times it throws the error "We found an issue in the joins while creating the query".  In the log files you wil also see the error "ERROR 3989 --- [http-nio-8080-exec-69] .o.r.q.o.c.u.QueryScenarioValidatorUtils : [-,UniRepBeta27,-] [54133048-5426-4606-9822-159301168917] ERROR-5028 Right Datasource YourTableNameHere is used in two joins"

Environment

  • SAP SuccessFactors HXM Suite Core 2205

Reproducing the Issue

  1. Create a new story
  2. Add the same table 3 times
  3. Try to save the query

Cause

This issue has been identified as product bug by development due to same table names used under different groups.

Resolution

This issue is scheduled to be fixed on wave 2023.02

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, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software epm, business intelligence, , KBA , LOD-ANA-OEM , Embedded usage of SAP Analytics Cloud , Problem

Product

SAP Analytics Cloud 1.0 ; SAP SuccessFactors HXM Suite Core 2205