PDA

View Full Version : RE: [Mondrian] Broken Test



Julian Hyde
03-28-2007, 05:30 PM
Thiyagu,

Can you please log a bug for this?

It's a weird problem, because Access is complaining that it's an
aggregate query, but it isn't: there is no GROUP BY clause, and no agg
functions. I think Access is dillusional. :)

Also, when I run the query through the Access UI, it works just fine.

Note that I logged a different problem with
XmlaBasicTest.testDrillThrough this morning.

Julian


_____

From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org]
On Behalf Of Thiyagu Palanisamy
Sent: Wednesday, March 28, 2007 7:23 AM
To: mondrian (AT) pentaho (DOT) org
Subject: [Mondrian] Broken Test
:testDrillThrough(mondrian.xmla.XmlaBasicTest)



[java] 1)
testDrillThrough(mondrian.xmla.XmlaBasicTest)mondrian.xmla.XmlaEx
ception: Mondrian Error:XMLA Drill Through SQL error
[java] at
mondrian.xmla.XmlaHandler.executeDrillThroughQuery(XmlaHandle
r.java:932)
[java] at
mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:217)
[java] at
mondrian.xmla.XmlaHandler.process(XmlaHandler.java:135)
[java] at
mondrian.tui.XmlaSupport.processXmla(XmlaSupport.java:781)
[java] at
mondrian.tui.XmlaSupport.processXmla(XmlaSupport.java:764)
[java] at
mondrian.xmla.XmlaBasicTest.doTests(XmlaBasicTest.java:579)
[java] at
mondrian.xmla.XmlaBasicTest.doTestInline(XmlaBasicTest.java:5
26)
[java] at
mondrian.xmla.XmlaBasicTest.doTest(XmlaBasicTest.java:501)
[java] at
mondrian.xmla.XmlaBasicTest.testDrillThrough(XmlaBasicTest.ja
va:414)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
[java] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces
sorImpl.java:39)
[java] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
hodAccessorImpl.java:25)
[java] at
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.jav
a:130)
[java] at java.lang.Thread.run(Thread.java:619)
[java] Caused by: mondrian.olap.MondrianException: Mondrian
Error:Internal
error: Error in drill through; sql=[select `store`.`store_country` as
`Store Cou
ntry`, `store`.`store_state` as `Store State`, `store`.`store_city` as
`Store Ci
ty`, `store`.`store_name` as `Store Name`, `store`.`store_sqft` as
`Store Sqft`,
`store`.`store_type` as `Store Type`, `time_by_day`.`the_year` as
`Year`, `time
_by_day`.`quarter` as `Quarter`, `time_by_day`.`month_of_year` as
`Month`, `prod
uct_class`.`product_family` as `Product Family`,
`product_class`.`product_depart
ment` as `Product Department`, `product_class`.`product_category` as
`Product Ca
tegory`, `product_class`.`product_subcategory` as `Product Subcategory`,
`produc
t`.`brand_name` as `Brand Name`, `product`.`product_name` as `Product
Name`, `pr
omotion`.`media_type` as `Media Type`, `promotion`.`promotion_name` as
`Promotio
n Name`, `customer`.`state_province` as `State Province`,
`customer`.`city` as `
City`, fname + ' ' + lname as `Name`, `customer`.`customer_id` as `Name
(Key)`,
`customer`.`education` as `Education Level`, `customer`.`gender` as
`Gender`, `c
ustomer`.`marital_status` as `Marital Status`,
`customer`.`yearly_income` as `Ye
arly Income`, `sales_fact_1997`.`unit_sales` as `Unit Sales` from
`store` as `st
ore`, `sales_fact_1997` as `sales_fact_1997`, `time_by_day` as
`time_by_day`, `p
roduct_class` as `product_class`, `product` as `product`, `promotion` as
`promot
ion`, `customer` as `customer` where `sales_fact_1997`.`store_id` =
`store`.`sto
re_id` and `sales_fact_1997`.`time_id` = `time_by_day`.`time_id` and
`time_by_da
y`.`the_year` = 1997 and `sales_fact_1997`.`product_id` =
`product`.`product_id`
and `product`.`product_class_id` = `product_class`.`product_class_id`
and `sale
s_fact_1997`.`promotion_id` = `promotion`.`promotion_id` and
`sales_fact_1997`.`
customer_id` = `customer`.`customer_id` and `customer`.`state_province`
= 'CA' a
nd `customer`.`city` = 'Berkeley' order by `store`.`store_country` ASC,
`store`.
`store_state` ASC, `store`.`store_city` ASC, `store`.`store_name` ASC,
`store`.`
store_sqft` ASC, `store`.`store_type` ASC, `time_by_day`.`the_year` ASC,
`time_b
y_day`.`quarter` ASC, `time_by_day`.`month_of_year` ASC,
`product_class`.`produc
t_family` ASC, `product_class`.`product_department` ASC,
`product_class`.`produc
t_category` ASC, `product_class`.`product_subcategory` ASC,
`product`.`brand_nam
e` ASC, `product`.`product_name` ASC, `promotion`.`media_type` ASC,
`promotion`.
`promotion_name` ASC, `customer`.`state_province` ASC, `customer`.`city`
ASC, fn
ame + ' ' + lname ASC, `customer`.`customer_id` ASC,
`customer`.`education` ASC,
`customer`.`gender` ASC, `customer`.`marital_status` ASC,
`customer`.`yearly_in
come` ASC]
[java] at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.
java:755)
[java] at mondrian.olap.Util.newInternal(Util.java:1083)
[java] at mondrian.olap.Util.newError(Util.java:1099)
[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.xmla.XmlaHandler.executeDrillThroughQuery(XmlaHandle
r.java:912)
[java] ... 24 more
[java] Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft
Access
Driver] You tried to execute a query that does not include the specified
express
ion 'STORE COUNTRY' as part of an aggregate function.
[java] at
sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)

[java] at
sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
[java] at
sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
[java] at
sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.jav
a:338)
[java] at
sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatemen
t.java:253)
[java] at
sun.jdbc.odbc.JdbcOdbcResultSet.calculateRowCount(JdbcOdbcRes
ultSet.java:6353)
[java] at
sun.jdbc.odbc.JdbcOdbcResultSet.initialize(JdbcOdbcResultSet.
java:155)
[java] at
sun.jdbc.odbc.JdbcOdbcStatement.getResultSet(JdbcOdbcStatemen
t.java:424)
[java] at
sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatemen
t.java:254)
[java] at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(Dele
gatingStatement.java:188)
[java] at
mondrian.rolap.SqlStatement.execute(SqlStatement.java:124)
[java] ... 26 more
[java]
[java] FAILURES!!!
[java] Tests run: 1277, Failures: 0, Errors: 1
[java]
[java] Time: 469.781
[java] Test stopped due to errors.
[java] Java Result: 1


_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian