<br><font size=2 face="sans-serif">Julian,</font>
<br><font size=2 face="sans-serif"> I'm looking into this issue. </font>
<br>
<br><font size=2 face="sans-serif">Thanks,</font>
<br><font size=2 face="sans-serif">Thiyagu</font>
<br>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>"Julian Hyde"
<julianhyde@gmail.com></b> </font>
<br><font size=1 face="sans-serif">Sent by: mondrian-bounces@pentaho.org</font>
<p><font size=1 face="sans-serif">12/07/2007 03:39</font>
<table border>
<tr valign=top>
<td bgcolor=white>
<div align=center><font size=1 face="sans-serif">Please respond to<br>
Mondrian developer mailing list <mondrian@pentaho.org></font></div></table>
<br>
<td width=59%>
<table width=100%>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td><font size=1 face="sans-serif">"Thiyagu Palanisamy" <thiyagu@gmail.com></font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td><font size=1 face="sans-serif">mondrian@pentaho.org</font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td><font size=1 face="sans-serif">[Mondrian] "ORA-00979: not a GROUP
BY expression" in nightly test run</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><tt><font size=2>Thiyagu,<br>
<br>
An error occurred in last night's run related to GROUPING SETS. Can you
take<br>
a look please?<br>
<br>
Full output is attached. Note that the error only occurs with a particular<br>
combination of properties.<br>
<br>
Julian<br>
<br>
<br>
[java] mondrian.olap.MondrianException: Mondrian Error:Internal
error:<br>
Error while loading segment; sql=[select<br>
"agg_c_10_sales_fact_1997"."the_year" as "c0",<br>
"agg_c_10_sales_fact_1997"."quarter" as "c1",<br>
"agg_c_10_sales_fact_1997"."month_of_year" as "c2",<br>
"agg_c_10_sales_fact_1997"."unit_sales" as "m0",<br>
grouping("agg_c_10_sales_fact_1997"."month_of_year")
as "g0",<br>
grouping("agg_c_10_sales_fact_1997"."quarter") as "g1"
from<br>
"agg_c_10_sales_fact_1997" "agg_c_10_sales_fact_1997"
where<br>
"agg_c_10_sales_fact_1997"."the_year" = 1997 group
by grouping sets<br>
(("agg_c_10_sales_fact_1997"."the_year","agg_c_10_sales_fact_1997"."quarter"<br>
,"agg_c_10_sales_fact_1997"."month_of_year"),("agg_c_10_sales_fact_1997"."th<br>
e_year"))]<br>
[java]
at<br>
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)<br>
[java]
at mondrian.olap.Util.newInternal(Util.java:1103)<br>
[java]
at mondrian.olap.Util.newError(Util.java:1119)<br>
[java]
at mondrian.rolap.SqlStatement.handle(SqlStatement.java:204)<br>
[java]
at<br>
mondrian.rolap.SqlStatement.execute(SqlStatement.java:138)<br>
[java]
at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:285)<br>
[java]
at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:246)<br>
[java]
at<br>
mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:317)<br>
[java]
at<br>
mondrian.rolap.agg.SegmentLoader.load(SegmentLoader.java:73)<br>
[java]
at<br>
mondrian.rolap.FastBatchingCellReader$CompositeBatch.loadAggregation(FastBat<br>
chingCellReader.java:326)<br>
[java]
at<br>
mondrian.rolap.FastBatchingCellReader.loadAggregation(FastBatchingCellReader<br>
.java:201)<br>
[java]
at<br>
mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReade<br>
r.java:177)<br>
[java]
at<br>
mondrian.rolap.RolapResult.executeBody(RolapResult.java:776)<br>
[java]
at mondrian.rolap.RolapResult.<init>(RolapResult.java:390)<br>
[java]
at<br>
mondrian.rolap.RolapConnection.execute(RolapConnection.java:414)<br>
[java]
at<br>
mondrian.test.TestContext.executeQuery(TestContext.java:390)<br>
[java]
at<br>
mondrian.test.TestContext.executeAxis(TestContext.java:565)<br>
[java]
at<br>
mondrian.test.TestContext.assertAxisReturns(TestContext.java:485)<br>
[java]
at<br>
mondrian.test.FoodMartTestCase.assertAxisReturns(FoodMartTestCase.java:148)<br>
[java]
at<br>
mondrian.olap.fun.FunctionTest.testDescendantsMLBeforeAfter(FunctionTest.jav<br>
a:2853)<br>
[java]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native<br>
Method)<br>
[java]
at<br>
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39<br>
)<br>
[java]
at<br>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl<br>
.java:25)<br>
[java]
at java.lang.reflect.Method.invoke(Method.java:324)<br>
[java]
at junit.framework.TestCase.runTest(TestCase.java:154)<br>
[java]
at junit.framework.TestCase.runBare(TestCase.java:127)<br>
[java]
at junit.framework.TestResult$1.protect(TestResult.java:106)<br>
[java]
at<br>
junit.framework.TestResult.runProtected(TestResult.java:124)<br>
[java]
at junit.framework.TestResult.run(TestResult.java:109)<br>
[java]
at junit.framework.TestCase.run(TestCase.java:118)<br>
[java]
at junit.framework.TestSuite.runTest(TestSuite.java:208)<br>
[java]
at junit.framework.TestSuite.run(TestSuite.java:203)<br>
[java]
at junit.framework.TestSuite.runTest(TestSuite.java:208)<br>
[java]
at junit.framework.TestSuite.run(TestSuite.java:203)<br>
[java]
at<br>
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:130)<br>
[java]
at java.lang.Thread.run(Thread.java:534)<br>
[java] Caused by: java.sql.SQLException: ORA-00979: not
a GROUP BY<br>
expression<br>
<br>
[java]
at<br>
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)<br>
[java]
at<br>
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)<br>
[java]
at<br>
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)<br>
[java]
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)<br>
[java]
at<br>
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)<br>
[java]
at<br>
oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)<br>
[java]
at<br>
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java<br>
:1038)<br>
[java]
at<br>
oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)<br>
[java]
at<br>
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java<br>
:1133)<br>
[java]
at<br>
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273)<br>
[java]
at<br>
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement<br>
.java:188)<br>
[java]
at<br>
mondrian.rolap.SqlStatement.execute(SqlStatement.java:124)<br>
[java]
... 31 more<br>
_______________________________________________<br>
Mondrian mailing list<br>
Mondrian@pentaho.org<br>
http://lists.pentaho.org/mailman/listinfo/mondrian<br>
</font></tt>
<br>