Hi,<br><br>I am trying to flush the dimension cache by following code - <br><br> org.olap4j.metadata.Schema OlapSchema = olapConnection.getOlapSchema();<br> NamedList<org.olap4j.metadata.Cube> cubeList = OlapSchema.getCubes();<br>
org.olap4j.metadata.Member m = null;<br> for(org.olap4j.metadata.Cube cube: cubeList) {<br> m = cube.lookupMember(IdentifierNode.parseIdentifier( "[Time].[2013].[Jul2013]").getSegmentList());<br>
final CacheControl cacheControl = olapConnection.getCacheControl(null);<br> CacheControl.MemberSet regionTime = cacheControl.createMemberSet(mondrian.olap.Member)m, false);<br> cacheControl.flush(regionTime);<br>
<br> }<br><br>But this throws runtime error saying MondrianOlap4jMember cannot be casted to mondrian.olap.Member.<br><br>-Mayur<br><br><div class="gmail_quote">On Wed, Jul 31, 2013 at 7:39 PM, <span dir="ltr"><<a href="mailto:mondrian-request@pentaho.org" target="_blank">mondrian-request@pentaho.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send Mondrian mailing list submissions to<br>
<a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:mondrian-request@pentaho.org">mondrian-request@pentaho.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:mondrian-owner@pentaho.org">mondrian-owner@pentaho.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Mondrian digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: Error running tests against foodmart db<br>
(Chacko, Rachel (Truven Health))<br>
2. Re: Error running tests against foodmart db (Meral Ozkaya)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Wed, 31 Jul 2013 14:06:48 +0000<br>
From: "Chacko, Rachel (Truven Health)"<br>
<<a href="mailto:rachel.chacko@truvenhealth.com">rachel.chacko@truvenhealth.com</a>><br>
Subject: Re: [Mondrian] Error running tests against foodmart db<br>
To: Mondrian developer mailing list <<a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a>><br>
Message-ID:<br>
<<a href="mailto:0858eb0328ce43db8eaaf279b8494d85@BY2PR07MB073.namprd07.prod.outlook.com">0858eb0328ce43db8eaaf279b8494d85@BY2PR07MB073.namprd07.prod.outlook.com</a>><br>
<br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
I?m using the derby database.<br>
<br>
From: <a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a> [mailto:<a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a>] On Behalf Of Luc Boudreau<br>
Sent: Wednesday, July 31, 2013 9:58 AM<br>
To: Mondrian developer mailing list<br>
Subject: Re: [Mondrian] Error running tests against foodmart db<br>
<br>
<br>
On Wed, Jul 31, 2013 at 9:54 AM, Chacko, Rachel (Truven Health) <<a href="mailto:rachel.chacko@truvenhealth.com">rachel.chacko@truvenhealth.com</a><mailto:<a href="mailto:rachel.chacko@truvenhealth.com">rachel.chacko@truvenhealth.com</a>>> wrote:<br>
Caused by: java.sql.SQLException: Table/View 'time_by_day' does not exist.<br>
<br>
This is probably why it is not working. What's the backend DB? Does it require tables to be prefixed by their schema name?<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://lists.pentaho.org/pipermail/mondrian/attachments/20130731/0faa81a5/attachment-0001.html" target="_blank">http://lists.pentaho.org/pipermail/mondrian/attachments/20130731/0faa81a5/attachment-0001.html</a><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Wed, 31 Jul 2013 17:09:26 +0300<br>
From: Meral Ozkaya <<a href="mailto:meral.ozkaya@gmail.com">meral.ozkaya@gmail.com</a>><br>
Subject: Re: [Mondrian] Error running tests against foodmart db<br>
To: Mondrian developer mailing list <<a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a>><br>
Message-ID:<br>
<CAO2Y5KbG-zO9=<a href="mailto:LhxZtKtPMk_OwqDNHbFMsydah7R%2BUAQPjZa7A@mail.gmail.com">LhxZtKtPMk_OwqDNHbFMsydah7R+UAQPjZa7A@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="windows-1252"<br>
<br>
Caused by: java.sql.<br>
<br>
SQLSyntaxErrorException: Table/View 'time_by_day' does not exist. you must<br>
have time_by_day view/table in your database. if the table exists in the<br>
database, you probably do not have the right permission for this table or<br>
you might have mistyped the table name in your xml schema.<br>
<br>
<br>
2013/7/31 Matt Campbell <<a href="mailto:mcampbell@pentaho.com">mcampbell@pentaho.com</a>><br>
<br>
> Hi Rachel,<br>
> Verify your foodmart database is up and running, and your test connection<br>
> information is correct in mondrian.properties.<br>
><br>
><br>
> java.sql.SQLSyntaxErrorException: Table/View 'time_by_day' does not<br>
> exist.<br>
><br>
><br>
><br>
> On 07/31/2013 09:54 AM, Chacko, Rachel (Truven Health) wrote:<br>
><br>
> I?m getting the error below trying to run the tests in mondrian 3.2<br>
> against the foodmart database. I see the same error with all tests and seem<br>
> to be happening on setup. Any help is appreciated.****<br>
><br>
> ** **<br>
><br>
> mondrian.olap.MondrianException: Mondrian Error:Named set in cube 'Sales'<br>
> has bad formula****<br>
><br>
> at<br>
> mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:821)****<br>
><br>
> at<br>
> mondrian.rolap.RolapCube.resolveCalcMembers(RolapCube.java:876)****<br>
><br>
> at<br>
> mondrian.rolap.RolapCube.createCalcMembersAndNamedSets(RolapCube.java:816)<br>
> ****<br>
><br>
> at mondrian.rolap.RolapCube.init(RolapCube.java:761)****<br>
><br>
> at mondrian.rolap.RolapCube.<init>(RolapCube.java:277)****<br>
><br>
> at mondrian.rolap.RolapSchema.load(RolapSchema.java:426)**<br>
> **<br>
><br>
> at mondrian.rolap.RolapSchema.load(RolapSchema.java:310)**<br>
> **<br>
><br>
> at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:221)<br>
> ****<br>
><br>
> at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:214)<br>
> ****<br>
><br>
> at<br>
> mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:973)****<br>
><br>
> at<br>
> mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:757)****<br>
><br>
> at<br>
> mondrian.rolap.RolapConnection.<init>(RolapConnection.java:166)****<br>
><br>
> at<br>
> mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95)****<br>
><br>
> at<br>
> mondrian.olap.DriverManager.getConnection(DriverManager.java:110)****<br>
><br>
> at<br>
> mondrian.olap.DriverManager.getConnection(DriverManager.java:74)****<br>
><br>
> at<br>
> mondrian.test.TestContext.getFoodMartConnection(TestContext.java:236)****<br>
><br>
> at<br>
> mondrian.test.TestContext.getConnection(TestContext.java:209)****<br>
><br>
> at<br>
> mondrian.test.TestContext.executeQuery(TestContext.java:515)****<br>
><br>
> at<br>
> mondrian.test.TestContext.assertQueryReturns(TestContext.java:1053)****<br>
><br>
> at<br>
> mondrian.test.FoodMartTestCase.assertQueryReturns(FoodMartTestCase.java:125)<br>
> ****<br>
><br>
> at<br>
> mondrian.test.BasicQueryTest.testSample0(BasicQueryTest.java:445)****<br>
><br>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native<br>
> Method)****<br>
><br>
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown<br>
> Source)****<br>
><br>
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown<br>
> Source)****<br>
><br>
> at java.lang.reflect.Method.invoke(Unknown Source)****<br>
><br>
> at junit.framework.TestCase.runTest(TestCase.java:164)****<br>
><br>
> at junit.framework.TestCase.runBare(TestCase.java:130)****<br>
><br>
> at<br>
> junit.framework.TestResult$1.protect(TestResult.java:106)****<br>
><br>
> at<br>
> junit.framework.TestResult.runProtected(TestResult.java:124)****<br>
><br>
> at junit.framework.TestResult.run(TestResult.java:109)****<br>
><br>
> at junit.framework.TestCase.run(TestCase.java:120)****<br>
><br>
> at junit.framework.TestSuite.runTest(TestSuite.java:230)**<br>
> **<br>
><br>
> at junit.framework.TestSuite.run(TestSuite.java:225)****<br>
><br>
> at<br>
> org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)<br>
> ****<br>
><br>
> at<br>
> org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)<br>
> ****<br>
><br>
> at<br>
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)<br>
> ****<br>
><br>
> at<br>
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)<br>
> ****<br>
><br>
> at<br>
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)<br>
> ****<br>
><br>
> at<br>
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)<br>
> ****<br>
><br>
> Caused by: mondrian.olap.MondrianException: Mondrian Error:Failed to parse<br>
> query 'WITH****<br>
><br>
> MEMBER [Measures].[Profit]****<br>
><br>
> AS '[Measures].[Store Sales] - [Measures].[Store Cost]',****<br>
><br>
> FORMAT_STRING = "$#,##0.00",****<br>
><br>
> [$member_scope] = 'CUBE',****<br>
><br>
> MEMBER_ORDINAL = 6****<br>
><br>
> MEMBER [Measures].[Profit last Period]****<br>
><br>
> AS 'COALESCEEMPTY((Measures.[Profit], [Time].[Time].PREVMEMBER),<br>
> Measures.[Profit])',****<br>
><br>
> FORMAT_STRING = "$#,##0.00",****<br>
><br>
> MEMBER_ORDINAL = 18,****<br>
><br>
> [$member_scope] = 'CUBE'****<br>
><br>
> MEMBER [Measures].[Profit Growth]****<br>
><br>
> AS '([Measures].[Profit] - [Measures].[Profit last Period]) /<br>
> [Measures].[Profit last Period]',****<br>
><br>
> FORMAT_STRING = "0.0%",****<br>
><br>
> [$member_scope] = 'CUBE',****<br>
><br>
> MEMBER_ORDINAL = 8****<br>
><br>
> SELECT FROM [Sales]'****<br>
><br>
> at<br>
> mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:821)****<br>
><br>
> at<br>
> mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:137)****<br>
><br>
> at<br>
> mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:63)****<br>
><br>
> at<br>
> mondrian.rolap.RolapCube.resolveCalcMembers(RolapCube.java:874)****<br>
><br>
> ... 37 more****<br>
><br>
> Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while<br>
> parsing MDX statement 'WITH****<br>
><br>
> MEMBER [Measures].[Profit]****<br>
><br>
> AS '[Measures].[Store Sales] - [Measures].[Store Cost]',****<br>
><br>
> FORMAT_STRING = "$#,##0.00",****<br>
><br>
> [$member_scope] = 'CUBE',****<br>
><br>
> MEMBER_ORDINAL = 6****<br>
><br>
> MEMBER [Measures].[Profit last Period]****<br>
><br>
> AS 'COALESCEEMPTY((Measures.[Profit], [Time].[Time].PREVMEMBER),<br>
> Measures.[Profit])',****<br>
><br>
> FORMAT_STRING = "$#,##0.00",****<br>
><br>
> MEMBER_ORDINAL = 18,****<br>
><br>
> [$member_scope] = 'CUBE'****<br>
><br>
> MEMBER [Measures].[Profit Growth]****<br>
><br>
> AS '([Measures].[Profit] - [Measures].[Profit last Period]) /<br>
> [Measures].[Profit last Period]',****<br>
><br>
> FORMAT_STRING = "0.0%",****<br>
><br>
> [$member_scope] = 'CUBE',****<br>
><br>
> MEMBER_ORDINAL = 8****<br>
><br>
> SELECT FROM [Sales]'****<br>
><br>
> at<br>
> mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:821)****<br>
><br>
> at mondrian.olap.Parser.parseInternal(Parser.java:784)****<br>
><br>
> at<br>
> mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:134)****<br>
><br>
> ... 39 more****<br>
><br>
> Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error:<br>
> Populating member cache with members for [[Time].[Year]]; sql=[select<br>
> "time_by_day"."the_year" from "time_by_day" as "time_by_day" group by<br>
> "time_by_day"."the_year" order by "time_by_day"."the_year" ASC]****<br>
><br>
> at<br>
> mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:821)****<br>
><br>
> at mondrian.olap.Util.newInternal(Util.java:1514)****<br>
><br>
> at mondrian.olap.Util.newError(Util.java:1530)****<br>
><br>
> at<br>
> mondrian.rolap.SqlStatement.handle(SqlStatement.java:249)****<br>
><br>
> at<br>
> mondrian.rolap.SqlStatement.execute(SqlStatement.java:169)****<br>
><br>
> at<br>
> mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:228)****<br>
><br>
> at<br>
> mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:373)****<br>
><br>
> at<br>
> mondrian.rolap.SqlTupleReader.readTuples(SqlTupleReader.java:520)****<br>
><br>
> at<br>
> mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:480)<br>
> ****<br>
><br>
> at<br>
> mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:467)<br>
> ****<br>
><br>
> at<br>
> mondrian.rolap.SmartMemberReader.getMembersInLevel(SmartMemberReader.java:147)<br>
> ****<br>
><br>
> at<br>
> mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMembersInLevel(RolapCubeHierarchy.java:678)<br>
> ****<br>
><br>
> at<br>
> mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:479)<br>
> ****<br>
><br>
> at<br>
> mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:464)<br>
> ****<br>
><br>
> at<br>
> mondrian.rolap.RolapCube$RolapCubeSchemaReader.getLevelMembers(RolapCube.java:2699)<br>
> ****<br>
><br>
> at<br>
> mondrian.rolap.RolapSchemaReader.getHierarchyRootMembers(RolapSchemaReader.java:84)<br>
> ****<br>
><br>
> at<br>
> mondrian.olap.Util.lookupHierarchyRootMember(Util.java:910)****<br>
><br>
> at<br>
> mondrian.olap.HierarchyBase.lookupChild(HierarchyBase.java:163)****<br>
><br>
> at<br>
> mondrian.olap.DimensionBase.lookupChild(DimensionBase.java:109)****<br>
><br>
> at<br>
> mondrian.rolap.RolapSchemaReader.getElementChild(RolapSchemaReader.java:356)<br>
> ****<br>
><br>
> at mondrian.olap.Util.lookupCompound(Util.java:595)****<br>
><br>
> at<br>
> mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:394)<br>
> ****<br>
><br>
> at<br>
> mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:112)<br>
> ****<br>
><br>
> at<br>
> mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1575)****<br>
><br>
> at<br>
> mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1546)****<br>
><br>
> at<br>
> mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:112)<br>
> ****<br>
><br>
> at<br>
> mondrian.olap.Query$ScopedSchemaReader.lookupCompound(Query.java:1743)****<br>
><br>
> at<br>
> mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:104)<br>
> ****<br>
><br>
> at mondrian.olap.Util.lookup(Util.java:775)****<br>
><br>
> at mondrian.olap.Id.accept(Id.java:108)****<br>
><br>
> at<br>
> mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)****<br>
><br>
> at<br>
> mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1945)****<br>
><br>
> at<br>
> mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:104)****<br>
><br>
> at<br>
> mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)****<br>
><br>
> at<br>
> mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1945)****<br>
><br>
> at<br>
> mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:104)****<br>
><br>
> at<br>
> mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)****<br>
><br>
> at<br>
> mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1945)****<br>
><br>
> at<br>
> mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:104)****<br>
><br>
> at<br>
> mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)****<br>
><br>
> at mondrian.olap.Formula.accept(Formula.java:110)****<br>
><br>
> at<br>
> mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:156)****<br>
><br>
> at mondrian.olap.Query.resolve(Query.java:609)****<br>
><br>
> at mondrian.olap.Query.resolve(Query.java:504)****<br>
><br>
> at mondrian.olap.Query.<init>(Query.java:252)****<br>
><br>
> at mondrian.olap.Query.<init>(Query.java:217)****<br>
><br>
> at mondrian.olap.Parser.makeQuery(Parser.java:877)****<br>
><br>
> at<br>
> mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1771)***<br>
> *<br>
><br>
> at mondrian.olap.Parser.do_action(Parser.java:706)****<br>
><br>
> at java_cup.runtime.lr_parser.parse(lr_parser.java:569)***<br>
> *<br>
><br>
> at mondrian.olap.Parser.parseInternal(Parser.java:779)****<br>
><br>
> ... 40 more****<br>
><br>
> Caused by: java.sql.SQLSyntaxErrorException: Table/View 'time_by_day' does<br>
> not exist.****<br>
><br>
> at<br>
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown<br>
> Source)****<br>
><br>
> at<br>
> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)****<br>
><br>
> at<br>
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown<br>
> Source)****<br>
><br>
> at<br>
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown<br>
> Source)****<br>
><br>
> at<br>
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)<br>
> ****<br>
><br>
> at<br>
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)<br>
> ****<br>
><br>
> at<br>
> org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)****<br>
><br>
> at<br>
> org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source)****<br>
><br>
> at<br>
> org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:174)<br>
> ****<br>
><br>
> at<br>
> mondrian.rolap.SqlStatement.execute(SqlStatement.java:150)****<br>
><br>
> ... 86 more****<br>
><br>
> Caused by: java.sql.SQLException: Table/View 'time_by_day' does not exist.<br>
> ****<br>
><br>
> at<br>
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown<br>
> Source)****<br>
><br>
> at<br>
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown<br>
> Source)****<br>
><br>
> ... 96 more****<br>
><br>
> ** **<br>
><br>
> Thanks,****<br>
><br>
> Rachel****<br>
><br>
><br>
><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>
><br>
<br>
<br>
--<br>
Meral ?zkaya<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://lists.pentaho.org/pipermail/mondrian/attachments/20130731/8e21d7e4/attachment.html" target="_blank">http://lists.pentaho.org/pipermail/mondrian/attachments/20130731/8e21d7e4/attachment.html</a><br>
<br>
------------------------------<br>
<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>
<br>
End of Mondrian Digest, Vol 80, Issue 20<br>
****************************************<br>
</blockquote></div><br>