[Mondrian] "ORA-00979: not a GROUP BY expression" in nightly test run

Thiyagu Palanisamy tpalanis at thoughtworks.com
Thu Jul 12 05:35:04 EDT 2007


Julian,
 I'm looking into this issue. 

Thanks,
Thiyagu




"Julian Hyde" <julianhyde at gmail.com> 
Sent by: mondrian-bounces at pentaho.org
12/07/2007 03:39
Please respond to
Mondrian developer mailing list <mondrian at pentaho.org>


To
"Thiyagu Palanisamy" <thiyagu at gmail.com>
cc
mondrian at pentaho.org
Subject
[Mondrian] "ORA-00979: not a GROUP BY expression" in nightly test run






Thiyagu,

An error occurred in last night's run related to GROUPING SETS. Can you 
take
a look please?

Full output is attached. Note that the error only occurs with a particular
combination of properties.

Julian


     [java] mondrian.olap.MondrianException: Mondrian Error:Internal 
error:
Error while loading segment; sql=[select
"agg_c_10_sales_fact_1997"."the_year" as "c0",
"agg_c_10_sales_fact_1997"."quarter" as "c1",
"agg_c_10_sales_fact_1997"."month_of_year" as "c2",
"agg_c_10_sales_fact_1997"."unit_sales" as "m0",
grouping("agg_c_10_sales_fact_1997"."month_of_year") as "g0",
grouping("agg_c_10_sales_fact_1997"."quarter") as "g1" from
"agg_c_10_sales_fact_1997" "agg_c_10_sales_fact_1997" where
"agg_c_10_sales_fact_1997"."the_year" = 1997 group by grouping sets
(("agg_c_10_sales_fact_1997"."the_year","agg_c_10_sales_fact_1997"."quarter"
,"agg_c_10_sales_fact_1997"."month_of_year"),("agg_c_10_sales_fact_1997"."th
e_year"))]
     [java]              at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)
     [java]              at mondrian.olap.Util.newInternal(Util.java:1103)
     [java]              at mondrian.olap.Util.newError(Util.java:1119)
     [java]              at 
mondrian.rolap.SqlStatement.handle(SqlStatement.java:204)
     [java]              at
mondrian.rolap.SqlStatement.execute(SqlStatement.java:138)
     [java]              at 
mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:285)
     [java]              at 
mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:246)
     [java]              at
mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:317)
     [java]              at
mondrian.rolap.agg.SegmentLoader.load(SegmentLoader.java:73)
     [java]              at
mondrian.rolap.FastBatchingCellReader$CompositeBatch.loadAggregation(FastBat
chingCellReader.java:326)
     [java]              at
mondrian.rolap.FastBatchingCellReader.loadAggregation(FastBatchingCellReader
.java:201)
     [java]              at
mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReade
r.java:177)
     [java]              at
mondrian.rolap.RolapResult.executeBody(RolapResult.java:776)
     [java]              at 
mondrian.rolap.RolapResult.<init>(RolapResult.java:390)
     [java]              at
mondrian.rolap.RolapConnection.execute(RolapConnection.java:414)
     [java]              at
mondrian.test.TestContext.executeQuery(TestContext.java:390)
     [java]              at
mondrian.test.TestContext.executeAxis(TestContext.java:565)
     [java]              at
mondrian.test.TestContext.assertAxisReturns(TestContext.java:485)
     [java]              at
mondrian.test.FoodMartTestCase.assertAxisReturns(FoodMartTestCase.java:148)
     [java]              at
mondrian.olap.fun.FunctionTest.testDescendantsMLBeforeAfter(FunctionTest.jav
a:2853)
     [java]              at 
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
     [java]              at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
     [java]              at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
     [java]              at 
java.lang.reflect.Method.invoke(Method.java:324)
     [java]              at 
junit.framework.TestCase.runTest(TestCase.java:154)
     [java]              at 
junit.framework.TestCase.runBare(TestCase.java:127)
     [java]              at 
junit.framework.TestResult$1.protect(TestResult.java:106)
     [java]              at
junit.framework.TestResult.runProtected(TestResult.java:124)
     [java]              at 
junit.framework.TestResult.run(TestResult.java:109)
     [java]              at 
junit.framework.TestCase.run(TestCase.java:118)
     [java]              at 
junit.framework.TestSuite.runTest(TestSuite.java:208)
     [java]              at 
junit.framework.TestSuite.run(TestSuite.java:203)
     [java]              at 
junit.framework.TestSuite.runTest(TestSuite.java:208)
     [java]              at 
junit.framework.TestSuite.run(TestSuite.java:203)
     [java]              at
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:130)
     [java]              at java.lang.Thread.run(Thread.java:534)
     [java] Caused by: java.sql.SQLException: ORA-00979: not a GROUP BY
expression

     [java]              at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
     [java]              at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
     [java]              at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
     [java]              at 
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
     [java]              at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
     [java]              at
oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
     [java]              at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java
:1038)
     [java]              at
oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
     [java]              at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1133)
     [java]              at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273)
     [java]              at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement
.java:188)
     [java]              at
mondrian.rolap.SqlStatement.execute(SqlStatement.java:124)
     [java]              ... 31 more
_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070712/987f0465/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: testAll.log.gz
Type: application/octet-stream
Size: 32921 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20070712/987f0465/attachment.obj 


More information about the Mondrian mailing list