SAP Knowledge Base Article - Public

3537243 - Importing Data from Hana view the following error appears "Not a Group by Expression" - SAP Analytics Cloud

Symptom

- The customer is experiencing an error when attempting to import data from the HANA Calculation View (CV) to SAP Analytics Cloud (SAC).

- The error message is: "SAP DBTech JDBC: [277]: not a GROUP BY expression: ..."

Environment

  • SAP Analytics Cloud version: 2024.15.16
    • Agent Version:  {"version":"1.0.419"} and lower.

Reproducing the Issue

  1. Open SAP Analytics Cloud Tenant.

  2. Go to Model. 

  3. From "Workspace" change to "Data Management".

  4. Check the Error on Import job:

"A database call failed with the following error: SAP DBTech JDBC: [277]: not a GROUP BY expression: ..."

Cause

Currently Missing functionality on SAP Analytics Cloud Import Job.

Resolution

Added on Patch Version: 2025.05

See Also

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

Keywords

SAP Analytics Cloud, SAC, SAP, Analytics, Cloud, kba, note, help, knowledge, chart, story, canvas, responsive, model, modeling, connection, tenant, version, import, hana, view, not, a, group, by, expression, agent, acquire  , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0