<br><font size=2 face="sans-serif"> [java] 1) testDrillThrough(mondrian.xmla.XmlaBasicTest)mondrian.xmla.XmlaEx</font>
<br><font size=2 face="sans-serif">ception: Mondrian Error:XMLA Drill Through
SQL error</font>
<br><font size=2 face="sans-serif"> [java]
at mondrian.xmla.XmlaHandler.executeDrillThroughQuery(XmlaHandle</font>
<br><font size=2 face="sans-serif">r.java:932)</font>
<br><font size=2 face="sans-serif"> [java]
at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:217)</font>
<br><font size=2 face="sans-serif"> [java]
at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:135)</font>
<br><font size=2 face="sans-serif"> [java]
at mondrian.tui.XmlaSupport.processXmla(XmlaSupport.java:781)</font>
<br><font size=2 face="sans-serif"> [java]
at mondrian.tui.XmlaSupport.processXmla(XmlaSupport.java:764)</font>
<br><font size=2 face="sans-serif"> [java]
at mondrian.xmla.XmlaBasicTest.doTests(XmlaBasicTest.java:579)</font>
<br><font size=2 face="sans-serif"> [java]
at mondrian.xmla.XmlaBasicTest.doTestInline(XmlaBasicTest.java:5</font>
<br><font size=2 face="sans-serif">26)</font>
<br><font size=2 face="sans-serif"> [java]
at mondrian.xmla.XmlaBasicTest.doTest(XmlaBasicTest.java:501)</font>
<br><font size=2 face="sans-serif"> [java]
at mondrian.xmla.XmlaBasicTest.testDrillThrough(XmlaBasicTest.ja</font>
<br><font size=2 face="sans-serif">va:414)</font>
<br><font size=2 face="sans-serif"> [java]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</font>
<br><font size=2 face="sans-serif"> [java]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces</font>
<br><font size=2 face="sans-serif">sorImpl.java:39)</font>
<br><font size=2 face="sans-serif"> [java]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet</font>
<br><font size=2 face="sans-serif">hodAccessorImpl.java:25)</font>
<br><font size=2 face="sans-serif"> [java]
at mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.jav</font>
<br><font size=2 face="sans-serif">a:130)</font>
<br><font size=2 face="sans-serif"> [java]
at java.lang.Thread.run(Thread.java:619)</font>
<br><font size=2 face="sans-serif"> [java] Caused by:
mondrian.olap.MondrianException: Mondrian Error:Internal</font>
<br><font size=2 face="sans-serif">error: Error in drill through; sql=[select
`store`.`store_country` as `Store Cou</font>
<br><font size=2 face="sans-serif">ntry`, `store`.`store_state` as `Store
State`, `store`.`store_city` as `Store Ci</font>
<br><font size=2 face="sans-serif">ty`, `store`.`store_name` as `Store
Name`, `store`.`store_sqft` as `Store Sqft`,</font>
<br><font size=2 face="sans-serif"> `store`.`store_type` as `Store
Type`, `time_by_day`.`the_year` as `Year`, `time</font>
<br><font size=2 face="sans-serif">_by_day`.`quarter` as `Quarter`, `time_by_day`.`month_of_year`
as `Month`, `prod</font>
<br><font size=2 face="sans-serif">uct_class`.`product_family` as `Product
Family`, `product_class`.`product_depart</font>
<br><font size=2 face="sans-serif">ment` as `Product Department`, `product_class`.`product_category`
as `Product Ca</font>
<br><font size=2 face="sans-serif">tegory`, `product_class`.`product_subcategory`
as `Product Subcategory`, `produc</font>
<br><font size=2 face="sans-serif">t`.`brand_name` as `Brand Name`, `product`.`product_name`
as `Product Name`, `pr</font>
<br><font size=2 face="sans-serif">omotion`.`media_type` as `Media Type`,
`promotion`.`promotion_name` as `Promotio</font>
<br><font size=2 face="sans-serif">n Name`, `customer`.`state_province`
as `State Province`, `customer`.`city` as `</font>
<br><font size=2 face="sans-serif">City`, fname + ' ' + lname as `Name`,
`customer`.`customer_id` as `Name (Key)`,</font>
<br><font size=2 face="sans-serif">`customer`.`education` as `Education
Level`, `customer`.`gender` as `Gender`, `c</font>
<br><font size=2 face="sans-serif">ustomer`.`marital_status` as `Marital
Status`, `customer`.`yearly_income` as `Ye</font>
<br><font size=2 face="sans-serif">arly Income`, `sales_fact_1997`.`unit_sales`
as `Unit Sales` from `store` as `st</font>
<br><font size=2 face="sans-serif">ore`, `sales_fact_1997` as `sales_fact_1997`,
`time_by_day` as `time_by_day`, `p</font>
<br><font size=2 face="sans-serif">roduct_class` as `product_class`, `product`
as `product`, `promotion` as `promot</font>
<br><font size=2 face="sans-serif">ion`, `customer` as `customer` where
`sales_fact_1997`.`store_id` = `store`.`sto</font>
<br><font size=2 face="sans-serif">re_id` and `sales_fact_1997`.`time_id`
= `time_by_day`.`time_id` and `time_by_da</font>
<br><font size=2 face="sans-serif">y`.`the_year` = 1997 and `sales_fact_1997`.`product_id`
= `product`.`product_id`</font>
<br><font size=2 face="sans-serif"> and `product`.`product_class_id`
= `product_class`.`product_class_id` and `sale</font>
<br><font size=2 face="sans-serif">s_fact_1997`.`promotion_id` = `promotion`.`promotion_id`
and `sales_fact_1997`.`</font>
<br><font size=2 face="sans-serif">customer_id` = `customer`.`customer_id`
and `customer`.`state_province` = 'CA' a</font>
<br><font size=2 face="sans-serif">nd `customer`.`city` = 'Berkeley' order
by `store`.`store_country` ASC, `store`.</font>
<br><font size=2 face="sans-serif">`store_state` ASC, `store`.`store_city`
ASC, `store`.`store_name` ASC, `store`.`</font>
<br><font size=2 face="sans-serif">store_sqft` ASC, `store`.`store_type`
ASC, `time_by_day`.`the_year` ASC, `time_b</font>
<br><font size=2 face="sans-serif">y_day`.`quarter` ASC, `time_by_day`.`month_of_year`
ASC, `product_class`.`produc</font>
<br><font size=2 face="sans-serif">t_family` ASC, `product_class`.`product_department`
ASC, `product_class`.`produc</font>
<br><font size=2 face="sans-serif">t_category` ASC, `product_class`.`product_subcategory`
ASC, `product`.`brand_nam</font>
<br><font size=2 face="sans-serif">e` ASC, `product`.`product_name` ASC,
`promotion`.`media_type` ASC, `promotion`.</font>
<br><font size=2 face="sans-serif">`promotion_name` ASC, `customer`.`state_province`
ASC, `customer`.`city` ASC, fn</font>
<br><font size=2 face="sans-serif">ame + ' ' + lname ASC, `customer`.`customer_id`
ASC, `customer`.`education` ASC,</font>
<br><font size=2 face="sans-serif"> `customer`.`gender` ASC, `customer`.`marital_status`
ASC, `customer`.`yearly_in</font>
<br><font size=2 face="sans-serif">come` ASC]</font>
<br><font size=2 face="sans-serif"> [java]
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.</font>
<br><font size=2 face="sans-serif">java:755)</font>
<br><font size=2 face="sans-serif"> [java]
at mondrian.olap.Util.newInternal(Util.java:1083)</font>
<br><font size=2 face="sans-serif"> [java]
at mondrian.olap.Util.newError(Util.java:1099)</font>
<br><font size=2 face="sans-serif"> [java]
at mondrian.rolap.SqlStatement.handle(SqlStatement.java:204)</font>
<br><font size=2 face="sans-serif"> [java]
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:138)</font>
<br><font size=2 face="sans-serif"> [java]
at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:285)</font>
<br><font size=2 face="sans-serif"> [java]
at mondrian.xmla.XmlaHandler.executeDrillThroughQuery(XmlaHandle</font>
<br><font size=2 face="sans-serif">r.java:912)</font>
<br><font size=2 face="sans-serif"> [java]
... 24 more</font>
<br><font size=2 face="sans-serif"> [java] Caused by:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access</font>
<br><font size=2 face="sans-serif">Driver] You tried to execute a query
that does not include the specified express</font>
<br><font size=2 face="sans-serif">ion 'STORE COUNTRY' as part of an aggregate
function.</font>
<br><font size=2 face="sans-serif"> [java]
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)</font>
<br>
<br><font size=2 face="sans-serif"> [java]
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)</font>
<br><font size=2 face="sans-serif"> [java]
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)</font>
<br><font size=2 face="sans-serif"> [java]
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.jav</font>
<br><font size=2 face="sans-serif">a:338)</font>
<br><font size=2 face="sans-serif"> [java]
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatemen</font>
<br><font size=2 face="sans-serif">t.java:253)</font>
<br><font size=2 face="sans-serif"> [java]
at sun.jdbc.odbc.JdbcOdbcResultSet.calculateRowCount(JdbcOdbcRes</font>
<br><font size=2 face="sans-serif">ultSet.java:6353)</font>
<br><font size=2 face="sans-serif"> [java]
at sun.jdbc.odbc.JdbcOdbcResultSet.initialize(JdbcOdbcResultSet.</font>
<br><font size=2 face="sans-serif">java:155)</font>
<br><font size=2 face="sans-serif"> [java]
at sun.jdbc.odbc.JdbcOdbcStatement.getResultSet(JdbcOdbcStatemen</font>
<br><font size=2 face="sans-serif">t.java:424)</font>
<br><font size=2 face="sans-serif"> [java]
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatemen</font>
<br><font size=2 face="sans-serif">t.java:254)</font>
<br><font size=2 face="sans-serif"> [java]
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(Dele</font>
<br><font size=2 face="sans-serif">gatingStatement.java:188)</font>
<br><font size=2 face="sans-serif"> [java]
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:124)</font>
<br><font size=2 face="sans-serif"> [java]
... 26 more</font>
<br><font size=2 face="sans-serif"> [java]</font>
<br><font size=2 face="sans-serif"> [java] FAILURES!!!</font>
<br><font size=2 face="sans-serif"> [java] Tests run:
1277, Failures: 0, Errors: 1</font>
<br><font size=2 face="sans-serif"> [java]</font>
<br><font size=2 face="sans-serif"> [java] Time: 469.781</font>
<br><font size=2 face="sans-serif"> [java] Test stopped
due to errors.</font>
<br><font size=2 face="sans-serif"> [java] Java Result:
1</font>