My Oracle Support Banner

BAM 12.2.1: Error drilling down to hour level in a time hierarchy, 'ORA-00978: nested group function without GROUP BY' (Doc ID 2171463.1)

Last updated on AUGUST 14, 2016

Applies to:

Oracle BAM (Business Activity Monitoring) - Version and later
Information in this document applies to any platform.


The following error occurs when drilling down to the HOUR level in a time hierarchy for a combo chart:

[2016-07-18T16:22:34.092+02:00] [ANDDwebbam01] [WARNING] [] [oracle.beam.server.service.reportcache] [tid: [ACTIVE].ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: UT06137] [ecid: 381bda8b-880c-4520-bb5a-a4204b22940c-00027735,0] [APP: BamServer] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: 0000LNyNOkm7q2xLSAl3ic1NY8TK000015] [125]Exception opening ViewSet..dummyMinMax_V1_0_SN0,[[
Exception: oracle.beam.common.exceptions.BeamException: BAM-00139: The BAM storage engine has encountered an exception. See exception cause for further details.
  at oracle.beam.common.dse.StorageEngine.convertSQLToBEAMException(

Caused by: java.sql.SQLSyntaxErrorException: ORA-00978: nested group function without GROUP BY

  at oracle.jdbc.driver.T4CTTIoer.processError(
  at oracle.jdbc.driver.T4CTTIoer.processError(
  at oracle.jdbc.driver.T4C8Oall.processError(
  at oracle.jdbc.driver.T4CTTIfun.receive(
  at oracle.jdbc.driver.T4CTTIfun.doRPC(



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.