Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Can not find Default Member with name "[Time.Weekly].[All Time.Weeklys].[1997]" in Hi

  1. #1
    Join Date
    Nov 2007
    Posts
    8

    Question Can not find Default Member with name "[Time.Weekly].[All Time.Weeklys].[1997]" in Hi

    Hi All,

    I am trying to run the Mondrian demo with mysql.
    I followed the installation instruction for non-embedded database to load the foodmart database and deploy the web application.

    However, instead of getting query results , I got the following error message when trying the simple MDX queries from the link 'Basic interface for ad hoc queries':

    mondrian.olap.MondrianException: Mondrian Error:Internal error: Can not find Default Member with name "[Time.Weekly].[All Time.Weeklys].[1997]" in Hierarchy "Time.Weekly"
    at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:752)
    at mondrian.olap.Util.newInternal(Util.java:1168)
    at mondrian.rolap.RolapHierarchy.init(RolapHierarchy.java:294)
    at mondrian.rolap.RolapDimension.init(RolapDimension.java:194)
    at mondrian.rolap.RolapCube.init(RolapCube.java:1046)
    at mondrian.rolap.RolapCube.<init>(RolapCube.java:258)
    at mondrian.rolap.RolapSchema.load(RolapSchema.java:425)
    at mondrian.rolap.RolapSchema.load(RolapSchema.java:324)
    at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:215)
    at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:79)
    at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:872)
    at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:689)
    at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:149)
    at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:80)
    at mondrian.olap.DriverManager.getConnection(DriverManager.java:190)
    at mondrian.olap.DriverManager.getConnection(DriverManager.java:131)
    at mondrian.olap.DriverManager.getConnection(DriverManager.java:55)
    at mondrian.web.servlet.MDXQueryServlet.processRequest(MDXQueryServlet.java:84)
    at mondrian.web.servlet.MDXQueryServlet.doGet(MDXQueryServlet.java:228)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
    at java.lang.Thread.run(Thread.java:595)
    Any help is highly appreciated!

    Thank you for your time!

    Regards,

    Howard

  2. #2
    Join Date
    Apr 2008
    Posts
    3

    Default "[Time.Weekly].[All Time.Weeklys].[1997]" in Hierarchy "Time.Weekly"

    I have the same problem. None of the example queries work.
    mondrian 3.0.2.10775
    Apache Tomcat/5.0.28
    jvm 1.6.0_05-b13
    mysql 5.0.16

    Has somebody get the demo work with a mysql?
    All hints and tips are welcome.
    Thanks
    pd

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.