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

Thiyagu Palanisamy tpalanis at thoughtworks.com
Wed Mar 28 10:23:15 EDT 2007


     [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/86f5200a/attachment.html 


More information about the Mondrian mailing list