[Mondrian] Broken Test :testDrillThrough(mondrian.xmla.XmlaBasicTest)

Julian Hyde julianhyde at speakeasy.net
Wed Mar 28 17:20:38 EDT 2007


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.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of Thiyagu Palanisamy
Sent: Wednesday, March 28, 2007 7:23 AM
To: mondrian at pentaho.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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070328/4b3093a7/attachment.html 


More information about the Mondrian mailing list