<div dir="ltr">Well I have had that experience too. It just hangs for hours and never finishes. So at this point is Mondrian 4 source code just broken? Kinda makes it hard to use. <div><br></div><div>This all feeds my fear that I shouldn't be using Mondrian 4 in my product. Not a lot of development is being made on it right now, significant work is still going into Mondrian 3 which means in order for Mondrian 4 to reach feature parity make it harder and harder to achieve. Mondrian 4 has been around for a long time, but it's still in beta and doesn't seem like it's moving towards stable anytime soon.</div><div><br></div><div>I have a sneaking suspicion I should port back to Mondrian 3 until Mondrian 4 is stable.</div><div><br></div><div>Any thoughts?</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Nov 11, 2016 at 7:59 PM, Julian Hyde <span dir="ltr"><<a href="mailto:julianhyde@gmail.com" target="_blank">julianhyde@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">You had a better experience than I did. I did<br>
<br>
$ cp mondrian.properties.template mondrian.properties<br>
$ mvn clean install<br>
<br>
and it just sat there, using up a lot of memory, burning very little<br>
CPU, and never finished.<br>
<br>
I don't have time to debug it, but I wish we could use maven-surefire<br>
(so that it prints test failures as it hits them, not at the end), and<br>
I wish it would use embedded hsqldb (as described in<br>
<a href="http://jira.pentaho.com/browse/MONDRIAN-2483" rel="noreferrer" target="_blank">http://jira.pentaho.com/<wbr>browse/MONDRIAN-2483</a>) rather than mysql. The<br>
tests might take a little longer to run, but everyone would be running<br>
the same environment.<br>
<span class="HOEnZb"><font color="#888888"><br>
Julian<br>
</font></span><div class="HOEnZb"><div class="h5"><br>
On Fri, Nov 11, 2016 at 9:24 AM, Charlie Hubbard<br>
<<a href="mailto:charlie@fuseanalytics.com">charlie@fuseanalytics.com</a>> wrote:<br>
> I switched over to Lagunitas and did a mvn clean install, and it still<br>
> failed with all of the same errors I was getting before. I removed my<br>
> mondrian.properties file and simply copied the mondrian.properties.template<br>
> -> mondrian.properties. It wouldn't run without doing that.<br>
><br>
> Charlie<br>
><br>
> Tests run: 3124, Failures: 7, Errors: 1, Skipped: 0, Time elapsed: 744.551<br>
> sec <<< FAILURE! - in mondrian.test.Main<br>
><br>
> testDrillThroughMultiPositionC<wbr>ompoundSlicer(mondrian.test.<wbr>DrillThroughTest)<br>
> Time elapsed: 0.165 sec <<< FAILURE!<br>
><br>
> junit.framework.<wbr>ComparisonFailure: expected:<...gender` as `Gender`,<br>
><br>
> `customer`.`marital_status` as `Marital Status`,<br>
><br>
> sum(`sales_fact_1997`.`unit_<wbr>sales`) as `Unit Sales`<br>
><br>
> from<br>
><br>
> `sales_fact_1997` as `sales_fact_1997`,<br>
><br>
> `customer` as `customer`,<br>
><br>
> `time_by_day` as `time_by_day`<br>
><br>
> where<br>
><br>
> `customer`.`marital_status` = 'M'<br>
><br>
> and<br>
><br>
> `customer`.`gender` = 'F'<br>
><br>
> and<br>
><br>
> ((`time_by_day`.`the_year` = 1997 and `time_by_day`.`quarter` = 'Q1' and<br>
> `time_by_day`.`the_year` = 1997) or (`time_by_day`.`the_year` = 1997 and<br>
> `time_by_day`.`quarter` = 'Q2' and `time_by_day`.`the_year` = 1997))<br>
><br>
> and<br>
><br>
> `sales_fact_1997`.`customer_<wbr>id` = `customer`.`customer_id`<br>
><br>
> and<br>
><br>
> `sales_fact_1997`.`time_id` = `time_by_day`.`time_id`<br>
><br>
> group by<br>
><br>
> `customer`.`gender`,...> but was:<...marital_status` as `Marital<br>
> Status`,<br>
><br>
> sum(`sales_fact_1997`.`unit_<wbr>sales`) as `Unit Sales`<br>
><br>
> from<br>
><br>
> `sales_fact_1997` as `sales_fact_1997`,<br>
><br>
> `customer` as `customer`,<br>
><br>
> `time_by_day` as `time_by_day`<br>
><br>
> where<br>
><br>
> `customer`.`marital_status` = 'M'<br>
><br>
> and<br>
><br>
> ((`customer`.`gender` = 'F' and `time_by_day`.`the_year` = 1997 and<br>
> `time_by_day`.`quarter` = 'Q1' and `time_by_day`.`the_year` = 1997) or<br>
> (`customer`.`gender` = 'F' and `time_by_day`.`the_year` = 1997 and<br>
> `time_by_day`.`quarter` = 'Q2' and `time_by_day`.`the_year` = 1997))<br>
><br>
> and<br>
><br>
> `sales_fact_1997`.`customer_<wbr>id` = `customer`.`customer_id`<br>
><br>
> and<br>
><br>
> `sales_fact_1997`.`time_id` = `time_by_day`.`time_id`<br>
><br>
> group by...><br>
><br>
> at junit.framework.Assert.<wbr>assertEquals(Assert.java:81)<br>
><br>
> at junit.framework.Assert.<wbr>assertEquals(Assert.java:87)<br>
><br>
> at mondrian.test.DiffRepository.<wbr>assertEquals(DiffRepository.<wbr>java:546)<br>
><br>
> at mondrian.test.TestContext.<wbr>assertSqlEquals(TestContext.<wbr>java:1982)<br>
><br>
> at<br>
> mondrian.test.<wbr>DrillThroughTest.<wbr>testDrillThroughMultiPositionC<wbr>ompoundSlicer(<wbr>DrillThroughTest.java:669)<br>
><br>
><br>
> testVirtualCubeCmBug(org.<wbr>olap4j.ConnectionTest) Time elapsed: 0 sec <<<<br>
> FAILURE!<br>
><br>
> junit.framework.<wbr>AssertionFailedError: expected:<[Warehouse Profit, Profit,<br>
> Units Ordered, Store Invoice, Unit Sales, Supply Time, Sales Count, Average<br>
> Warehouse Sale, Profit Per Unit Shipped, Warehouse Cost, Profit last Period,<br>
> Units Shipped, Store Sales, Warehouse Sales, Store Cost, Profit Growth]> but<br>
> was:<[Warehouse Profit, Profit, Store Invoice, Units Ordered, Unit Sales,<br>
> Sales Count, Supply Time, Average Warehouse Sale, Profit Per Unit Shipped,<br>
> Warehouse Cost, Profit last Period, Customer Count, Promotion Sales, Units<br>
> Shipped, Store Sales, Warehouse Sales, Store Cost, Profit Growth]><br>
><br>
> at junit.framework.Assert.fail(<wbr>Assert.java:47)<br>
><br>
> at junit.framework.Assert.<wbr>failNotEquals(Assert.java:282)<br>
><br>
> at junit.framework.Assert.<wbr>assertEquals(Assert.java:64)<br>
><br>
> at junit.framework.Assert.<wbr>assertEquals(Assert.java:71)<br>
><br>
> at org.olap4j.ConnectionTest.<wbr>testVirtualCubeCmBug(<wbr>ConnectionTest.java:2156)<br>
><br>
><br>
> testVirtualCubeCmBug(org.<wbr>olap4j.ConnectionTest) Time elapsed: 0.001 sec<br>
> <<< FAILURE!<br>
><br>
> junit.framework.<wbr>AssertionFailedError: expected:<[Warehouse Profit, Profit,<br>
> Units Ordered, Store Invoice, Unit Sales, Supply Time, Sales Count, Average<br>
> Warehouse Sale, Profit Per Unit Shipped, Warehouse Cost, Profit last Period,<br>
> Units Shipped, Store Sales, Warehouse Sales, Store Cost, Profit Growth]> but<br>
> was:<[Warehouse Profit, Profit, Store Invoice, Units Ordered, Unit Sales,<br>
> Sales Count, Supply Time, Average Warehouse Sale, Profit Per Unit Shipped,<br>
> Warehouse Cost, Profit last Period, Customer Count, Promotion Sales, Units<br>
> Shipped, Store Sales, Warehouse Sales, Store Cost, Profit Growth]><br>
><br>
> at junit.framework.Assert.fail(<wbr>Assert.java:47)<br>
><br>
> at junit.framework.Assert.<wbr>failNotEquals(Assert.java:282)<br>
><br>
> at junit.framework.Assert.<wbr>assertEquals(Assert.java:64)<br>
><br>
> at junit.framework.Assert.<wbr>assertEquals(Assert.java:71)<br>
><br>
> at org.olap4j.ConnectionTest.<wbr>testVirtualCubeCmBug(<wbr>ConnectionTest.java:2156)<br>
><br>
><br>
> testVirtualCubeCmBug(org.<wbr>olap4j.ConnectionTest) Time elapsed: 0 sec <<<<br>
> FAILURE!<br>
><br>
> junit.framework.<wbr>AssertionFailedError: expected:<[Warehouse Profit, Profit,<br>
> Units Ordered, Store Invoice, Unit Sales, Supply Time, Sales Count, Average<br>
> Warehouse Sale, Profit Per Unit Shipped, Warehouse Cost, Profit last Period,<br>
> Units Shipped, Store Sales, Warehouse Sales, Store Cost, Profit Growth]> but<br>
> was:<[Warehouse Profit, Profit, Store Invoice, Units Ordered, Unit Sales,<br>
> Sales Count, Supply Time, Average Warehouse Sale, Profit Per Unit Shipped,<br>
> Warehouse Cost, Profit last Period, Customer Count, Promotion Sales, Units<br>
> Shipped, Store Sales, Warehouse Sales, Store Cost, Profit Growth]><br>
><br>
> at junit.framework.Assert.fail(<wbr>Assert.java:47)<br>
><br>
> at junit.framework.Assert.<wbr>failNotEquals(Assert.java:282)<br>
><br>
> at junit.framework.Assert.<wbr>assertEquals(Assert.java:64)<br>
><br>
> at junit.framework.Assert.<wbr>assertEquals(Assert.java:71)<br>
><br>
> at org.olap4j.ConnectionTest.<wbr>testVirtualCubeCmBug(<wbr>ConnectionTest.java:2156)<br>
><br>
><br>
> testVirtualCubeCmBug(org.<wbr>olap4j.ConnectionTest) Time elapsed: 0.125 sec<br>
> <<< FAILURE!<br>
><br>
> junit.framework.<wbr>AssertionFailedError: expected:<[Warehouse Profit, Profit,<br>
> Units Ordered, Store Invoice, Unit Sales, Supply Time, Sales Count, Average<br>
> Warehouse Sale, Profit Per Unit Shipped, Warehouse Cost, Profit last Period,<br>
> Units Shipped, Store Sales, Warehouse Sales, Store Cost, Profit Growth]> but<br>
> was:<[Warehouse Profit, Profit, Store Invoice, Units Ordered, Unit Sales,<br>
> Sales Count, Supply Time, Average Warehouse Sale, Profit Per Unit Shipped,<br>
> Warehouse Cost, Profit last Period, Customer Count, Promotion Sales, Units<br>
> Shipped, Store Sales, Warehouse Sales, Store Cost, Profit Growth]><br>
><br>
> at junit.framework.Assert.fail(<wbr>Assert.java:47)<br>
><br>
> at junit.framework.Assert.<wbr>failNotEquals(Assert.java:282)<br>
><br>
> at junit.framework.Assert.<wbr>assertEquals(Assert.java:64)<br>
><br>
> at junit.framework.Assert.<wbr>assertEquals(Assert.java:71)<br>
><br>
> at org.olap4j.ConnectionTest.<wbr>testVirtualCubeCmBug(<wbr>ConnectionTest.java:2156)<br>
><br>
><br>
> testMondrian1133(mondrian.<wbr>test.SteelWheelsSchemaTest) Time elapsed: 0.003<br>
> sec <<< ERROR!<br>
><br>
> mondrian.olap.<wbr>MondrianException: Mondrian Error:Internal error: Error while<br>
> creating SQL connection: Jdbc=jdbc:mysql://localhost/<wbr>steelwheels;<br>
> JdbcUser=foodmart; JdbcPassword=foodmart<br>
><br>
> at mondrian.resource.<wbr>MondrianResource$_Def0.ex(<wbr>MondrianResource.java:992)<br>
><br>
> at mondrian.olap.Util.<wbr>newInternal(Util.java:2543)<br>
><br>
> at mondrian.olap.Util.newError(<wbr>Util.java:2559)<br>
><br>
> at mondrian.rolap.<wbr>RolapConnection.<init>(<wbr>RolapConnection.java:239)<br>
><br>
> at mondrian.rolap.RolapSchema.<<wbr>init>(RolapSchema.java:191)<br>
><br>
> at mondrian.rolap.<wbr>RolapSchemaUpgrader.upgrade(<wbr>RolapSchemaUpgrader.java:101)<br>
><br>
> at mondrian.rolap.<wbr>RolapSchemaLoader.loadStage0(<wbr>RolapSchemaLoader.java:254)<br>
><br>
> at<br>
> mondrian.rolap.<wbr>RolapSchemaLoader.<wbr>createSchema(<wbr>RolapSchemaLoader.java:4303)<br>
><br>
> at mondrian.rolap.<wbr>RolapSchemaPool.get(<wbr>RolapSchemaPool.java:210)<br>
><br>
> at mondrian.rolap.<wbr>RolapSchemaPool.get(<wbr>RolapSchemaPool.java:62)<br>
><br>
> at mondrian.rolap.<wbr>RolapConnection.<init>(<wbr>RolapConnection.java:160)<br>
><br>
> at mondrian.rolap.<wbr>RolapConnection.<init>(<wbr>RolapConnection.java:84)<br>
><br>
> at mondrian.olap.DriverManager.<wbr>getConnection(DriverManager.<wbr>java:112)<br>
><br>
> at mondrian.test.TestContext.<wbr>getConnection(TestContext.<wbr>java:394)<br>
><br>
> at mondrian.test.TestContext.<wbr>executeQuery(TestContext.java:<wbr>710)<br>
><br>
> at<br>
> mondrian.test.<wbr>SteelWheelsSchemaTest.<wbr>testMondrian1133(<wbr>SteelWheelsSchemaTest.java:<wbr>601)<br>
><br>
> Caused by: com.mysql.jdbc.exceptions.<wbr>jdbc4.<wbr>MySQLSyntaxErrorException:<br>
> Unknown database 'steelwheels'<br>
><br>
> at sun.reflect.<wbr>GeneratedConstructorAccessor20<wbr>7.newInstance(Unknown Source)<br>
><br>
> at<br>
> sun.reflect.<wbr>DelegatingConstructorAccessorI<wbr>mpl.newInstance(<wbr>DelegatingConstructorAccessorI<wbr>mpl.java:45)<br>
><br>
> at java.lang.reflect.Constructor.<wbr>newInstance(Constructor.java:<wbr>526)<br>
><br>
> at com.mysql.jdbc.Util.<wbr>handleNewInstance(Util.java:<wbr>408)<br>
><br>
> at com.mysql.jdbc.Util.<wbr>getInstance(Util.java:383)<br>
><br>
> at com.mysql.jdbc.SQLError.<wbr>createSQLException(SQLError.<wbr>java:1062)<br>
><br>
> at com.mysql.jdbc.MysqlIO.<wbr>checkErrorPacket(MysqlIO.java:<wbr>4226)<br>
><br>
> at com.mysql.jdbc.MysqlIO.<wbr>checkErrorPacket(MysqlIO.java:<wbr>4158)<br>
><br>
> at com.mysql.jdbc.MysqlIO.<wbr>checkErrorPacket(MysqlIO.java:<wbr>926)<br>
><br>
> at<br>
> com.mysql.jdbc.MysqlIO.<wbr>proceedHandshakeWithPluggableA<wbr>uthentication(MysqlIO.java:<wbr>1748)<br>
><br>
> at com.mysql.jdbc.MysqlIO.<wbr>doHandshake(MysqlIO.java:1288)<br>
><br>
> at com.mysql.jdbc.ConnectionImpl.<wbr>coreConnect(ConnectionImpl.<wbr>java:2508)<br>
><br>
> at com.mysql.jdbc.ConnectionImpl.<wbr>connectOneTryOnly(<wbr>ConnectionImpl.java:2541)<br>
><br>
> at com.mysql.jdbc.ConnectionImpl.<wbr>createNewIO(ConnectionImpl.<wbr>java:2323)<br>
><br>
> at com.mysql.jdbc.ConnectionImpl.<wbr><init>(ConnectionImpl.java:<wbr>832)<br>
><br>
> at com.mysql.jdbc.<wbr>JDBC4Connection.<init>(<wbr>JDBC4Connection.java:46)<br>
><br>
> at sun.reflect.<wbr>GeneratedConstructorAccessor12<wbr>6.newInstance(Unknown Source)<br>
><br>
> at<br>
> sun.reflect.<wbr>DelegatingConstructorAccessorI<wbr>mpl.newInstance(<wbr>DelegatingConstructorAccessorI<wbr>mpl.java:45)<br>
><br>
> at java.lang.reflect.Constructor.<wbr>newInstance(Constructor.java:<wbr>526)<br>
><br>
> at com.mysql.jdbc.Util.<wbr>handleNewInstance(Util.java:<wbr>408)<br>
><br>
> at com.mysql.jdbc.ConnectionImpl.<wbr>getInstance(ConnectionImpl.<wbr>java:417)<br>
><br>
> at<br>
> com.mysql.jdbc.<wbr>NonRegisteringDriver.connect(<wbr>NonRegisteringDriver.java:344)<br>
><br>
> at java.sql.DriverManager.<wbr>getConnection(DriverManager.<wbr>java:571)<br>
><br>
> at java.sql.DriverManager.<wbr>getConnection(DriverManager.<wbr>java:187)<br>
><br>
> at<br>
> org.apache.commons.dbcp.<wbr>DriverManagerConnectionFactory<wbr>.createConnection(<wbr>DriverManagerConnectionFactory<wbr>.java:51)<br>
><br>
> at<br>
> org.apache.commons.dbcp.<wbr>PoolableConnectionFactory.<wbr>makeObject(<wbr>PoolableConnectionFactory.<wbr>java:290)<br>
><br>
> at<br>
> org.apache.commons.pool.impl.<wbr>GenericObjectPool.<wbr>borrowObject(<wbr>GenericObjectPool.java:771)<br>
><br>
> at<br>
> org.apache.commons.dbcp.<wbr>PoolingDataSource.<wbr>getConnection(<wbr>PoolingDataSource.java:95)<br>
><br>
> at mondrian.rolap.<wbr>RolapConnection.<init>(<wbr>RolapConnection.java:212)<br>
><br>
> ... 36 more<br>
><br>
><br>
> On Thu, Nov 10, 2016 at 2:53 AM, Julian Hyde <<a href="mailto:julianhyde@gmail.com">julianhyde@gmail.com</a>> wrote:<br>
>><br>
>> You’re on the “lagunitas” branch, right?<br>
>><br>
>> I would build using “mvn clean install”. That said, I haven’t built in a<br>
>> while, and I get an error due to missing<br>
>> "pentaho#mondrian-data-<wbr>foodmart;1.0.0”. Does anyone else get that error?<br>
>><br>
>> Julian<br>
>><br>
>> On Nov 9, 2016, at 7:13 PM, Charlie Hubbard <<a href="mailto:charlie@fuseanalytics.com">charlie@fuseanalytics.com</a>><br>
>> wrote:<br>
>><br>
>> Hi,<br>
>><br>
>> I'm trying to build a jar file from Mondrian 4. Do I use the maven build<br>
>> or ant jar? What do I do about failing tests? It wants to load Steel<br>
>> Wheels, OLAP4J tests that don't seem to be there, both of which those fail.<br>
>> Other tests seem to fail out of the box as well.<br>
>><br>
>> I followed the instructions in the Dev Guide and setup mondrian.properties<br>
>> file pointing at mysql server.<br>
>><br>
>> Charlie<br>
>> --<br>
>> Charlie Hubbard | Chief Technology Officer<br>
>> Fuse Analytics | <a href="tel:404.234.8094" value="+14042348094">404.234.8094</a><br>
>> ______________________________<wbr>_________________<br>
>> Mondrian mailing list<br>
>> <a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
>> <a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" target="_blank">http://lists.pentaho.org/<wbr>mailman/listinfo/mondrian</a><br>
>><br>
>><br>
>><br>
>> ______________________________<wbr>_________________<br>
>> Mondrian mailing list<br>
>> <a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
>> <a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" target="_blank">http://lists.pentaho.org/<wbr>mailman/listinfo/mondrian</a><br>
>><br>
><br>
><br>
><br>
> --<br>
> Charlie Hubbard | Chief Technology Officer<br>
> Fuse Analytics | <a href="tel:404.234.8094" value="+14042348094">404.234.8094</a><br>
><br>
> ______________________________<wbr>_________________<br>
> Mondrian mailing list<br>
> <a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
> <a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" target="_blank">http://lists.pentaho.org/<wbr>mailman/listinfo/mondrian</a><br>
><br>
______________________________<wbr>_________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" target="_blank">http://lists.pentaho.org/<wbr>mailman/listinfo/mondrian</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">Charlie Hubbard | Chief Technology Officer<div><div><span style="font-weight:bold;background-color:rgb(255,255,255)"><font color="#0b5394">F</font><font color="#f6b26b">u</font><font color="#0b5394">se</font></span><font color="#0b5394" style="font-weight:bold"> Analytics</font><font color="#0b5394"> </font><font color="#000000">| </font><font color="#000000">404.234.8094</font></div></div></div></div>
</div>