<div dir="ltr">
Caused by: java.sql.<p class="">SQLSyntaxErrorException: Table/View &#39;time_by_day&#39; does not exist. you must have time_by_day view/table in your database. if the table  exists in the database, you probably do not have the right permission for this table or you might have mistyped the table name in your xml schema.<br>
</p></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/7/31 Matt Campbell <span dir="ltr">&lt;<a href="mailto:mcampbell@pentaho.com" target="_blank">mcampbell@pentaho.com</a>&gt;</span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">


  
  <div text="#000000" bgcolor="#FFFFFF">
    <div>Hi Rachel,<br>
      Verify your foodmart database is up and running, and your test
      connection information is correct in mondrian.properties.<div class="im"><br>
      <br>
         java.sql.SQLSyntaxErrorException: Table/View &#39;time_by_day&#39; does
      not exist.<br>
      <br>
      <br>
      <br></div><div><div class="h5">
      On 07/31/2013 09:54 AM, Chacko, Rachel (Truven Health) wrote:<br>
    </div></div></div><div><div class="h5">
    <blockquote type="cite">
      
      
      
      <div>
        <p class="MsoNormal">I’m getting the error below trying to run
          the tests in mondrian 3.2 against the foodmart database. I see
          the same error with all tests and seem to be happening on
          setup. Any help is appreciated.<u></u><u></u></p>
        <p class="MsoNormal"><u></u> <u></u></p>
        <p class="MsoNormal">mondrian.olap.MondrianException: Mondrian
          Error:Named set in cube &#39;Sales&#39; has bad formula<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:821)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.rolap.RolapCube.resolveCalcMembers(RolapCube.java:876)<u></u><u></u></p>
        <p class="MsoNormal">                at
mondrian.rolap.RolapCube.createCalcMembersAndNamedSets(RolapCube.java:816)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.rolap.RolapCube.init(RolapCube.java:761)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.rolap.RolapCube.&lt;init&gt;(RolapCube.java:277)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.rolap.RolapSchema.load(RolapSchema.java:426)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.rolap.RolapSchema.load(RolapSchema.java:310)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.rolap.RolapSchema.&lt;init&gt;(RolapSchema.java:221)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.rolap.RolapSchema.&lt;init&gt;(RolapSchema.java:214)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:973)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:757)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.rolap.RolapConnection.&lt;init&gt;(RolapConnection.java:166)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.rolap.RolapConnection.&lt;init&gt;(RolapConnection.java:95)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.DriverManager.getConnection(DriverManager.java:110)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.DriverManager.getConnection(DriverManager.java:74)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.test.TestContext.getFoodMartConnection(TestContext.java:236)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.test.TestContext.getConnection(TestContext.java:209)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.test.TestContext.executeQuery(TestContext.java:515)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.test.TestContext.assertQueryReturns(TestContext.java:1053)<u></u><u></u></p>
        <p class="MsoNormal">                at
mondrian.test.FoodMartTestCase.assertQueryReturns(FoodMartTestCase.java:125)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.test.BasicQueryTest.testSample0(BasicQueryTest.java:445)<u></u><u></u></p>
        <p class="MsoNormal">                at
          sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<u></u><u></u></p>
        <p class="MsoNormal">                at
          sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<u></u><u></u></p>
        <p class="MsoNormal">                at
          sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
          Source)<u></u><u></u></p>
        <p class="MsoNormal">                at
          java.lang.reflect.Method.invoke(Unknown Source)<u></u><u></u></p>
        <p class="MsoNormal">                at
          junit.framework.TestCase.runTest(TestCase.java:164)<u></u><u></u></p>
        <p class="MsoNormal">                at
          junit.framework.TestCase.runBare(TestCase.java:130)<u></u><u></u></p>
        <p class="MsoNormal">                at
          junit.framework.TestResult$1.protect(TestResult.java:106)<u></u><u></u></p>
        <p class="MsoNormal">                at
          junit.framework.TestResult.runProtected(TestResult.java:124)<u></u><u></u></p>
        <p class="MsoNormal">                at
          junit.framework.TestResult.run(TestResult.java:109)<u></u><u></u></p>
        <p class="MsoNormal">                at
          junit.framework.TestCase.run(TestCase.java:120)<u></u><u></u></p>
        <p class="MsoNormal">                at
          junit.framework.TestSuite.runTest(TestSuite.java:230)<u></u><u></u></p>
        <p class="MsoNormal">                at
          junit.framework.TestSuite.run(TestSuite.java:225)<u></u><u></u></p>
        <p class="MsoNormal">                at
org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)<u></u><u></u></p>
        <p class="MsoNormal">                at
org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)<u></u><u></u></p>
        <p class="MsoNormal">                at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)<u></u><u></u></p>
        <p class="MsoNormal">                at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)<u></u><u></u></p>
        <p class="MsoNormal">                at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)<u></u><u></u></p>
        <p class="MsoNormal">                at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)<u></u><u></u></p>
        <p class="MsoNormal">Caused by: mondrian.olap.MondrianException:
          Mondrian Error:Failed to parse query &#39;WITH<u></u><u></u></p>
        <p class="MsoNormal">MEMBER [Measures].[Profit]<u></u><u></u></p>
        <p class="MsoNormal">  AS &#39;[Measures].[Store Sales] -
          [Measures].[Store Cost]&#39;,<u></u><u></u></p>
        <p class="MsoNormal">FORMAT_STRING = &quot;$#,##0.00&quot;,<u></u><u></u></p>
        <p class="MsoNormal">[$member_scope] = &#39;CUBE&#39;,<u></u><u></u></p>
        <p class="MsoNormal">MEMBER_ORDINAL = 6<u></u><u></u></p>
        <p class="MsoNormal">MEMBER [Measures].[Profit last Period]<u></u><u></u></p>
        <p class="MsoNormal">  AS &#39;COALESCEEMPTY((Measures.[Profit],
          [Time].[Time].PREVMEMBER),    Measures.[Profit])&#39;,<u></u><u></u></p>
        <p class="MsoNormal">FORMAT_STRING = &quot;$#,##0.00&quot;,<u></u><u></u></p>
        <p class="MsoNormal">MEMBER_ORDINAL = 18,<u></u><u></u></p>
        <p class="MsoNormal">[$member_scope] = &#39;CUBE&#39;<u></u><u></u></p>
        <p class="MsoNormal">MEMBER [Measures].[Profit Growth]<u></u><u></u></p>
        <p class="MsoNormal">  AS &#39;([Measures].[Profit] -
          [Measures].[Profit last Period]) / [Measures].[Profit last
          Period]&#39;,<u></u><u></u></p>
        <p class="MsoNormal">FORMAT_STRING = &quot;0.0%&quot;,<u></u><u></u></p>
        <p class="MsoNormal">[$member_scope] = &#39;CUBE&#39;,<u></u><u></u></p>
        <p class="MsoNormal">MEMBER_ORDINAL = 8<u></u><u></u></p>
        <p class="MsoNormal">SELECT FROM [Sales]&#39;<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:821)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:137)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:63)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.rolap.RolapCube.resolveCalcMembers(RolapCube.java:874)<u></u><u></u></p>
        <p class="MsoNormal">                ... 37 more<u></u><u></u></p>
        <p class="MsoNormal">Caused by: mondrian.olap.MondrianException:
          Mondrian Error:Error while parsing MDX statement &#39;WITH<u></u><u></u></p>
        <p class="MsoNormal">MEMBER [Measures].[Profit]<u></u><u></u></p>
        <p class="MsoNormal">  AS &#39;[Measures].[Store Sales] -
          [Measures].[Store Cost]&#39;,<u></u><u></u></p>
        <p class="MsoNormal">FORMAT_STRING = &quot;$#,##0.00&quot;,<u></u><u></u></p>
        <p class="MsoNormal">[$member_scope] = &#39;CUBE&#39;,<u></u><u></u></p>
        <p class="MsoNormal">MEMBER_ORDINAL = 6<u></u><u></u></p>
        <p class="MsoNormal">MEMBER [Measures].[Profit last Period]<u></u><u></u></p>
        <p class="MsoNormal">  AS &#39;COALESCEEMPTY((Measures.[Profit],
          [Time].[Time].PREVMEMBER),    Measures.[Profit])&#39;,<u></u><u></u></p>
        <p class="MsoNormal">FORMAT_STRING = &quot;$#,##0.00&quot;,<u></u><u></u></p>
        <p class="MsoNormal">MEMBER_ORDINAL = 18,<u></u><u></u></p>
        <p class="MsoNormal">[$member_scope] = &#39;CUBE&#39;<u></u><u></u></p>
        <p class="MsoNormal">MEMBER [Measures].[Profit Growth]<u></u><u></u></p>
        <p class="MsoNormal">  AS &#39;([Measures].[Profit] -
          [Measures].[Profit last Period]) / [Measures].[Profit last
          Period]&#39;,<u></u><u></u></p>
        <p class="MsoNormal">FORMAT_STRING = &quot;0.0%&quot;,<u></u><u></u></p>
        <p class="MsoNormal">[$member_scope] = &#39;CUBE&#39;,<u></u><u></u></p>
        <p class="MsoNormal">MEMBER_ORDINAL = 8<u></u><u></u></p>
        <p class="MsoNormal">SELECT FROM [Sales]&#39;<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:821)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.Parser.parseInternal(Parser.java:784)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:134)<u></u><u></u></p>
        <p class="MsoNormal">                ... 39 more<u></u><u></u></p>
        <p class="MsoNormal">Caused by: mondrian.olap.MondrianException:
          Mondrian Error:Internal error: Populating member cache with
          members for [[Time].[Year]]; sql=[select
          &quot;time_by_day&quot;.&quot;the_year&quot; from &quot;time_by_day&quot; as &quot;time_by_day&quot;
          group by &quot;time_by_day&quot;.&quot;the_year&quot; order by
          &quot;time_by_day&quot;.&quot;the_year&quot; ASC]<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:821)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.Util.newInternal(Util.java:1514)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.Util.newError(Util.java:1530)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.rolap.SqlStatement.handle(SqlStatement.java:249)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.rolap.SqlStatement.execute(SqlStatement.java:169)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:228)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:373)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.rolap.SqlTupleReader.readTuples(SqlTupleReader.java:520)<u></u><u></u></p>
        <p class="MsoNormal">                at
mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:480)<u></u><u></u></p>
        <p class="MsoNormal">                at
mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:467)<u></u><u></u></p>
        <p class="MsoNormal">                at
mondrian.rolap.SmartMemberReader.getMembersInLevel(SmartMemberReader.java:147)<u></u><u></u></p>
        <p class="MsoNormal">                at
mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMembersInLevel(RolapCubeHierarchy.java:678)<u></u><u></u></p>
        <p class="MsoNormal">                at
mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:479)<u></u><u></u></p>
        <p class="MsoNormal">                at
mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:464)<u></u><u></u></p>
        <p class="MsoNormal">                at
mondrian.rolap.RolapCube$RolapCubeSchemaReader.getLevelMembers(RolapCube.java:2699)<u></u><u></u></p>
        <p class="MsoNormal">                at
mondrian.rolap.RolapSchemaReader.getHierarchyRootMembers(RolapSchemaReader.java:84)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.Util.lookupHierarchyRootMember(Util.java:910)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.HierarchyBase.lookupChild(HierarchyBase.java:163)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.DimensionBase.lookupChild(DimensionBase.java:109)<u></u><u></u></p>
        <p class="MsoNormal">                at
mondrian.rolap.RolapSchemaReader.getElementChild(RolapSchemaReader.java:356)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.Util.lookupCompound(Util.java:595)<u></u><u></u></p>
        <p class="MsoNormal">                at
mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:394)<u></u><u></u></p>
        <p class="MsoNormal">                at
mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:112)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1575)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1546)<u></u><u></u></p>
        <p class="MsoNormal">                at
mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:112)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.Query$ScopedSchemaReader.lookupCompound(Query.java:1743)<u></u><u></u></p>
        <p class="MsoNormal">                at
mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:104)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.Util.lookup(Util.java:775)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.Id.accept(Id.java:108)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1945)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:104)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1945)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:104)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1945)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:104)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.Formula.accept(Formula.java:110)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:156)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.Query.resolve(Query.java:609)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.Query.resolve(Query.java:504)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.Query.&lt;init&gt;(Query.java:252)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.Query.&lt;init&gt;(Query.java:217)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.Parser.makeQuery(Parser.java:877)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1771)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.Parser.do_action(Parser.java:706)<u></u><u></u></p>
        <p class="MsoNormal">                at
          java_cup.runtime.lr_parser.parse(lr_parser.java:569)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.olap.Parser.parseInternal(Parser.java:779)<u></u><u></u></p>
        <p class="MsoNormal">                ... 40 more<u></u><u></u></p>
        <p class="MsoNormal">Caused by:
          java.sql.SQLSyntaxErrorException: Table/View &#39;time_by_day&#39;
          does not exist.<u></u><u></u></p>
        <p class="MsoNormal">                at
          org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
          Source)<u></u><u></u></p>
        <p class="MsoNormal">                at
          org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
          Source)<u></u><u></u></p>
        <p class="MsoNormal">                at
          org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
          Source)<u></u><u></u></p>
        <p class="MsoNormal">                at
          org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
          Source)<u></u><u></u></p>
        <p class="MsoNormal">                at
          org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
          Source)<u></u><u></u></p>
        <p class="MsoNormal">                at
          org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
          Source)<u></u><u></u></p>
        <p class="MsoNormal">                at
          org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown
          Source)<u></u><u></u></p>
        <p class="MsoNormal">                at
          org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown
          Source)<u></u><u></u></p>
        <p class="MsoNormal">                at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:174)<u></u><u></u></p>
        <p class="MsoNormal">                at
          mondrian.rolap.SqlStatement.execute(SqlStatement.java:150)<u></u><u></u></p>
        <p class="MsoNormal">                ... 86 more<u></u><u></u></p>
        <p class="MsoNormal">Caused by: java.sql.SQLException:
          Table/View &#39;time_by_day&#39; does not exist.<u></u><u></u></p>
        <p class="MsoNormal">                at
          org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
          Source)<u></u><u></u></p>
        <p class="MsoNormal">                at
          org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
          Source)<u></u><u></u></p>
        <p class="MsoNormal">                ... 96 more<u></u><u></u></p>
        <p class="MsoNormal"><u></u> <u></u></p>
        <p class="MsoNormal">Thanks,<u></u><u></u></p>
        <p class="MsoNormal">Rachel<u></u><u></u></p>
      </div>
    </blockquote>
    <br>
  </div></div></div>

<br>_______________________________________________<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" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Meral Özkaya
</div>