<div dir="ltr">I switched over to Lagunitas and did a mvn clean install, and it still failed with all of the same errors I was getting before. I removed my mondrian.properties file and simply copied the mondrian.properties.template -> mondrian.properties. It wouldn't run without doing that.<div><br></div><div>Charlie<div>
<p class="gmail-p1">Tests run: 3124, Failures: 7, Errors: 1, Skipped: 0, Time elapsed: 744.551 sec <<< FAILURE! - in mondrian.test.Main</p>
<p class="gmail-p1">testDrillThroughMultiPositionCompoundSlicer(mondrian.test.DrillThroughTest) Time elapsed: 0.165 sec <<< FAILURE!</p>
<p class="gmail-p1">junit.framework.ComparisonFailure: expected:<...gender` as `Gender`,</p>
<p class="gmail-p1"> `customer`.`marital_status` as `Marital Status`,</p>
<p class="gmail-p1"> sum(`sales_fact_1997`.`unit_sales`) as `Unit Sales`</p>
<p class="gmail-p1">from</p>
<p class="gmail-p1"> `sales_fact_1997` as `sales_fact_1997`,</p>
<p class="gmail-p1"> `customer` as `customer`,</p>
<p class="gmail-p1"> `time_by_day` as `time_by_day`</p>
<p class="gmail-p1">where</p>
<p class="gmail-p1"> `customer`.`marital_status` = 'M'</p>
<p class="gmail-p1">and</p>
<p class="gmail-p1"> `customer`.`gender` = 'F'</p>
<p class="gmail-p1">and</p>
<p class="gmail-p1"> ((`time_by_day`.`the_year` = 1997 and `time_by_day`.`quarter` = 'Q1' and `time_by_day`.`the_year` = 1997) or (`time_by_day`.`the_year` = 1997 and `time_by_day`.`quarter` = 'Q2' and `time_by_day`.`the_year` = 1997))</p>
<p class="gmail-p1">and</p>
<p class="gmail-p1"> `sales_fact_1997`.`customer_id` = `customer`.`customer_id`</p>
<p class="gmail-p1">and</p>
<p class="gmail-p1"> `sales_fact_1997`.`time_id` = `time_by_day`.`time_id`</p>
<p class="gmail-p1">group by</p>
<p class="gmail-p1"> `customer`.`gender`,...> but was:<...marital_status` as `Marital Status`,</p>
<p class="gmail-p1"> sum(`sales_fact_1997`.`unit_sales`) as `Unit Sales`</p>
<p class="gmail-p1">from</p>
<p class="gmail-p1"> `sales_fact_1997` as `sales_fact_1997`,</p>
<p class="gmail-p1"> `customer` as `customer`,</p>
<p class="gmail-p1"> `time_by_day` as `time_by_day`</p>
<p class="gmail-p1">where</p>
<p class="gmail-p1"> `customer`.`marital_status` = 'M'</p>
<p class="gmail-p1">and</p>
<p class="gmail-p1"> ((`customer`.`gender` = 'F' and `time_by_day`.`the_year` = 1997 and `time_by_day`.`quarter` = 'Q1' and `time_by_day`.`the_year` = 1997) or (`customer`.`gender` = 'F' and `time_by_day`.`the_year` = 1997 and `time_by_day`.`quarter` = 'Q2' and `time_by_day`.`the_year` = 1997))</p>
<p class="gmail-p1">and</p>
<p class="gmail-p1"> `sales_fact_1997`.`customer_id` = `customer`.`customer_id`</p>
<p class="gmail-p1">and</p>
<p class="gmail-p1"> `sales_fact_1997`.`time_id` = `time_by_day`.`time_id`</p>
<p class="gmail-p1">group by...></p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at junit.framework.Assert.assertEquals(Assert.java:81)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at junit.framework.Assert.assertEquals(Assert.java:87)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.test.DiffRepository.assertEquals(DiffRepository.java:546)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.test.TestContext.assertSqlEquals(TestContext.java:1982)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.test.DrillThroughTest.testDrillThroughMultiPositionCompoundSlicer(DrillThroughTest.java:669)</p>
<p class="gmail-p2"><br></p>
<p class="gmail-p1">testVirtualCubeCmBug(org.olap4j.ConnectionTest) Time elapsed: 0 sec <<< FAILURE!</p>
<p class="gmail-p1">junit.framework.AssertionFailedError: expected:<[Warehouse Profit, Profit, Units Ordered, Store Invoice, Unit Sales, Supply Time, Sales Count, Average Warehouse Sale, Profit Per Unit Shipped, Warehouse Cost, Profit last Period, Units Shipped, Store Sales, Warehouse Sales, Store Cost, Profit Growth]> but was:<[Warehouse Profit, Profit, Store Invoice, Units Ordered, Unit Sales, Sales Count, Supply Time, Average Warehouse Sale, Profit Per Unit Shipped, Warehouse Cost, Profit last Period, Customer Count, Promotion Sales, Units Shipped, Store Sales, Warehouse Sales, Store Cost, Profit Growth]></p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at junit.framework.Assert.fail(Assert.java:47)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at junit.framework.Assert.failNotEquals(Assert.java:282)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at junit.framework.Assert.assertEquals(Assert.java:64)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at junit.framework.Assert.assertEquals(Assert.java:71)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at org.olap4j.ConnectionTest.testVirtualCubeCmBug(ConnectionTest.java:2156)</p>
<p class="gmail-p2"><br></p>
<p class="gmail-p1">testVirtualCubeCmBug(org.olap4j.ConnectionTest) Time elapsed: 0.001 sec <<< FAILURE!</p>
<p class="gmail-p1">junit.framework.AssertionFailedError: expected:<[Warehouse Profit, Profit, Units Ordered, Store Invoice, Unit Sales, Supply Time, Sales Count, Average Warehouse Sale, Profit Per Unit Shipped, Warehouse Cost, Profit last Period, Units Shipped, Store Sales, Warehouse Sales, Store Cost, Profit Growth]> but was:<[Warehouse Profit, Profit, Store Invoice, Units Ordered, Unit Sales, Sales Count, Supply Time, Average Warehouse Sale, Profit Per Unit Shipped, Warehouse Cost, Profit last Period, Customer Count, Promotion Sales, Units Shipped, Store Sales, Warehouse Sales, Store Cost, Profit Growth]></p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at junit.framework.Assert.fail(Assert.java:47)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at junit.framework.Assert.failNotEquals(Assert.java:282)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at junit.framework.Assert.assertEquals(Assert.java:64)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at junit.framework.Assert.assertEquals(Assert.java:71)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at org.olap4j.ConnectionTest.testVirtualCubeCmBug(ConnectionTest.java:2156)</p>
<p class="gmail-p2"><br></p>
<p class="gmail-p1">testVirtualCubeCmBug(org.olap4j.ConnectionTest) Time elapsed: 0 sec <<< FAILURE!</p>
<p class="gmail-p1">junit.framework.AssertionFailedError: expected:<[Warehouse Profit, Profit, Units Ordered, Store Invoice, Unit Sales, Supply Time, Sales Count, Average Warehouse Sale, Profit Per Unit Shipped, Warehouse Cost, Profit last Period, Units Shipped, Store Sales, Warehouse Sales, Store Cost, Profit Growth]> but was:<[Warehouse Profit, Profit, Store Invoice, Units Ordered, Unit Sales, Sales Count, Supply Time, Average Warehouse Sale, Profit Per Unit Shipped, Warehouse Cost, Profit last Period, Customer Count, Promotion Sales, Units Shipped, Store Sales, Warehouse Sales, Store Cost, Profit Growth]></p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at junit.framework.Assert.fail(Assert.java:47)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at junit.framework.Assert.failNotEquals(Assert.java:282)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at junit.framework.Assert.assertEquals(Assert.java:64)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at junit.framework.Assert.assertEquals(Assert.java:71)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at org.olap4j.ConnectionTest.testVirtualCubeCmBug(ConnectionTest.java:2156)</p>
<p class="gmail-p2"><br></p>
<p class="gmail-p1">testVirtualCubeCmBug(org.olap4j.ConnectionTest) Time elapsed: 0.125 sec <<< FAILURE!</p>
<p class="gmail-p1">junit.framework.AssertionFailedError: expected:<[Warehouse Profit, Profit, Units Ordered, Store Invoice, Unit Sales, Supply Time, Sales Count, Average Warehouse Sale, Profit Per Unit Shipped, Warehouse Cost, Profit last Period, Units Shipped, Store Sales, Warehouse Sales, Store Cost, Profit Growth]> but was:<[Warehouse Profit, Profit, Store Invoice, Units Ordered, Unit Sales, Sales Count, Supply Time, Average Warehouse Sale, Profit Per Unit Shipped, Warehouse Cost, Profit last Period, Customer Count, Promotion Sales, Units Shipped, Store Sales, Warehouse Sales, Store Cost, Profit Growth]></p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at junit.framework.Assert.fail(Assert.java:47)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at junit.framework.Assert.failNotEquals(Assert.java:282)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at junit.framework.Assert.assertEquals(Assert.java:64)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at junit.framework.Assert.assertEquals(Assert.java:71)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at org.olap4j.ConnectionTest.testVirtualCubeCmBug(ConnectionTest.java:2156)</p>
<p class="gmail-p2"><br></p>
<p class="gmail-p1">testMondrian1133(mondrian.test.SteelWheelsSchemaTest) Time elapsed: 0.003 sec <<< ERROR!</p>
<p class="gmail-p1">mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:mysql://localhost/steelwheels; JdbcUser=foodmart; JdbcPassword=foodmart</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:992)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.olap.Util.newInternal(Util.java:2543)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.olap.Util.newError(Util.java:2559)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:239)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:191)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.rolap.RolapSchemaUpgrader.upgrade(RolapSchemaUpgrader.java:101)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.rolap.RolapSchemaLoader.loadStage0(RolapSchemaLoader.java:254)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.rolap.RolapSchemaLoader.createSchema(RolapSchemaLoader.java:4303)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:210)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:62)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:160)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:84)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.olap.DriverManager.getConnection(DriverManager.java:112)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.test.TestContext.getConnection(TestContext.java:394)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.test.TestContext.executeQuery(TestContext.java:710)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.test.SteelWheelsSchemaTest.testMondrian1133(SteelWheelsSchemaTest.java:601)</p>
<p class="gmail-p1">Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'steelwheels'</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at sun.reflect.GeneratedConstructorAccessor207.newInstance(Unknown Source)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at java.lang.reflect.Constructor.newInstance(Constructor.java:526)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at com.mysql.jdbc.Util.getInstance(Util.java:383)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:926)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1748)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1288)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2508)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2541)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2323)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at sun.reflect.GeneratedConstructorAccessor126.newInstance(Unknown Source)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at java.lang.reflect.Constructor.newInstance(Constructor.java:526)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at java.sql.DriverManager.getConnection(DriverManager.java:571)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at java.sql.DriverManager.getConnection(DriverManager.java:187)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:51)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:212)</p>
<p class="gmail-p1"><span class="gmail-Apple-tab-span"> </span>... 36 more</p></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Nov 10, 2016 at 2:53 AM, 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"><div style="word-wrap:break-word">You’re on the “lagunitas” branch, right?<div><br></div><div>I would build using “mvn clean install”. That said, I haven’t built in a while, and I get an error due to missing "pentaho#mondrian-data-<wbr>foodmart;1.0.0”. Does anyone else get that error?</div><div><br></div><div>Julian</div><div><br><div><blockquote type="cite"><div><div class="h5"><div>On Nov 9, 2016, at 7:13 PM, Charlie Hubbard <<a href="mailto:charlie@fuseanalytics.com" target="_blank">charlie@fuseanalytics.com</a>> wrote:</div><br class="m_-5258307506665159445Apple-interchange-newline"></div></div><div><div><div class="h5"><div dir="ltr">Hi,<div><br></div><div><div style="font-size:12.8px">I'm trying to build a jar file from Mondrian 4. Do I use the maven build or ant jar? What do I do about failing tests? It wants to load Steel Wheels, OLAP4J tests that don't seem to be there, both of which those fail. Other tests seem to fail out of the box as well. </div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">I followed the instructions in the Dev Guide and setup mondrian.properties file pointing at mysql server.</div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">Charlie</div>-- <br><div class="m_-5258307506665159445gmail_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>| </font><font><a href="tel:404.234.8094" value="+14042348094" target="_blank">404.234.8094</a></font></div></div></div></div>
</div></div></div></div>
______________________________<wbr>_________________<br>Mondrian mailing list<br><a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br><a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/<wbr>mailman/listinfo/mondrian</a><br></div></blockquote></div><br></div></div><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></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>