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 for Me (Login required).

Search for additional results

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