2509301 - Database error occured when using Delegate measure in query filter in webi 4.1 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2509301 - Database error occured when using Delegate measure in query filter in webi 4.1

Symptom

  • Error appears when using Delegate measure object in query filter in webi .
    "The following database error occured: SAP DBTech JDBC: [277](at 1488): not a GROUP BY expression: 'TABLE_XXX' must ne in group by clause.: line 50 col 8(at pos 1488). Fro information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)(Error: INF)".
  • Same query including delegate measure objects runs fine at IDT query panel.
  • Issue is seen only with database delegate measure.

Read more...

Environment

  • SAP BusinessObjects Business Intelligence 4.1 Service pack 7 Patch 13
  • SAP BusinessObjects Business Intelligence 4.1 Service pack 9 Patch 5
  • HANA SPS12
  • Web Intelligence

Product

SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2

Keywords

the following database error occured SapDBTech JDBC 277 not a group by expression BO Bi 4.1 4.2 webi rich client html applet 2054721 IES INF 10901 , KBA , BI-RA-WBI , Web Intelligence , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.