java.lang.RuntimeException: Internal error: Member '[Store].[All Stores].[USA].[CA]' is not in hierarchy '[Store]' at mondrian.olap.MondrianResource.newInternal(MondrianResource.java:42)

Pentaho BI Platform Tracking | robinbagot | 1 decade ago
  1. 0

    In the FoodMart schema, if the order of definition of Cube Sales and Cube Warehouse is reversed, so that Warehouse is first and Sales is second, an error is encountered with the Role "California manager" that relates to the Cube Sales. [JPivot] 02 Oct 2003 03:04:40,927 ERROR [Session 899CB40274CA517CE1D0A2403698FAAC] com.tonbeller.jpivot.olap.OlapModelTag#doAfterBody: exception caught java.lang.RuntimeException: Internal error: Member '[Store].[All Stores].[USA].[CA]' is not in hierarchy '[Store]' at mondrian.olap.MondrianResource.newInternal(MondrianResource.java:42) at mondrian.olap.Util.newError(Util.java:439) at mondrian.rolap.RolapSchema.createRole(RolapSchema.java:183) at mondrian.rolap.RolapSchema.load(RolapSchema.java:125) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:93) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:34) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:249) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:89) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:60) at mondrian.olap.DriverManager.getConnection(DriverManager.java:133) at mondrian.olap.DriverManager.getConnection(DriverManager.java:49) at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:227) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:149) at com.tonbeller.jpivot.olap.model.OlapModelProxy.setDelegate(OlapModelProxy.java:81) at com.tonbeller.jpivot.olap.model.OlapModelProxy.setOlapModel(OlapModelProxy.java:70) at com.tonbeller.jpivot.olap.OlapModelTag.doAfterBody(OlapModelTag.java:71) at org.apache.jsp.mondrian_jsp._jspx_meth_jp_mondrianQuery_0(mondrian_jsp.java:95) at org.apache.jsp.mondrian_jsp._jspService(mondrian_jsp.java:57) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:575) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:498) at com.tonbeller.wcf.utils.IncludeTag.doStartTag(IncludeTag.java:84) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_include_0(testpage_jsp.java:205) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:104) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:108) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:99) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:134) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530) at java.lang.Thread.run(Thread.java:536)

    Pentaho BI Platform Tracking | 1 decade ago | robinbagot
    java.lang.RuntimeException: Internal error: Member '[Store].[All Stores].[USA].[CA]' is not in hierarchy '[Store]' at mondrian.olap.MondrianResource.newInternal(MondrianResource.java:42)
  2. 0

    In the FoodMart schema, if the order of definition of Cube Sales and Cube Warehouse is reversed, so that Warehouse is first and Sales is second, an error is encountered with the Role "California manager" that relates to the Cube Sales. [JPivot] 02 Oct 2003 03:04:40,927 ERROR [Session 899CB40274CA517CE1D0A2403698FAAC] com.tonbeller.jpivot.olap.OlapModelTag#doAfterBody: exception caught java.lang.RuntimeException: Internal error: Member '[Store].[All Stores].[USA].[CA]' is not in hierarchy '[Store]' at mondrian.olap.MondrianResource.newInternal(MondrianResource.java:42) at mondrian.olap.Util.newError(Util.java:439) at mondrian.rolap.RolapSchema.createRole(RolapSchema.java:183) at mondrian.rolap.RolapSchema.load(RolapSchema.java:125) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:93) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:34) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:249) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:89) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:60) at mondrian.olap.DriverManager.getConnection(DriverManager.java:133) at mondrian.olap.DriverManager.getConnection(DriverManager.java:49) at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:227) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:149) at com.tonbeller.jpivot.olap.model.OlapModelProxy.setDelegate(OlapModelProxy.java:81) at com.tonbeller.jpivot.olap.model.OlapModelProxy.setOlapModel(OlapModelProxy.java:70) at com.tonbeller.jpivot.olap.OlapModelTag.doAfterBody(OlapModelTag.java:71) at org.apache.jsp.mondrian_jsp._jspx_meth_jp_mondrianQuery_0(mondrian_jsp.java:95) at org.apache.jsp.mondrian_jsp._jspService(mondrian_jsp.java:57) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:575) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:498) at com.tonbeller.wcf.utils.IncludeTag.doStartTag(IncludeTag.java:84) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_include_0(testpage_jsp.java:205) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:104) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:108) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:99) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:134) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530) at java.lang.Thread.run(Thread.java:536)

    Pentaho BI Platform Tracking | 1 decade ago | robinbagot
    java.lang.RuntimeException: Internal error: Member '[Store].[All Stores].[USA].[CA]' is not in hierarchy '[Store]' at mondrian.olap.MondrianResource.newInternal(MondrianResource.java:42)
  3. 0

    (1): Run job with kitchen, using the following command: Kitchen.bat /file:c:\data-diagnostics\PDI\development\zombies\zombies_top.kjb /param:START_DATE=2015-03-01 /param:END_DATE=2015-04-01 Result: Success (2) Add logging step in one of the sub-transforms, to send START_DATE and END_DATE to the console log. Same command line as before. Result: The following exception, with job failure. C:\pentaho-53\pdi-ee\data-integration>"C:\Program Files\Java\jre7\\bin\java.exe" "-Xmx512m" "-XX:MaxPermSize=256m" "-Dja _USER=" "-DKETTLE_PASSWORD=" "-DKETTLE_PLUGIN_PACKAGES=" "-DKETTLE_LOG_SIZE_LIMIT=" "-DKETTLE_JNDI_ROOT=" -jar launcher\p taho.di.kitchen.Kitchen /file:c:\data-diagnostics\PDI\development\zombies\zombies_top.kjb /param:START_DATE 2015-03-01 /p Exception in thread "main" java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92) Caused by: java.lang.RuntimeException: Central Log Store is not initialized!!! at org.pentaho.di.core.logging.KettleLogStore.getInstance(KettleLogStore.java:185) at org.pentaho.di.core.logging.KettleLogStore.getAppender(KettleLogStore.java:235) at org.pentaho.di.core.logging.LogChannel.println(LogChannel.java:122) at org.pentaho.di.core.logging.LogChannel.logError(LogChannel.java:166) at org.pentaho.di.pan.CommandLineOption.parseArguments(CommandLineOption.java:418) at org.pentaho.di.kitchen.Kitchen.main(Kitchen.java:197) ... 5 more I'm inclined to think that this will happen any time logging is invoked.

    Pentaho BI Platform Tracking | 2 years ago | Bryce Lobdell
    java.lang.reflect.InvocationTargetException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    (1): Run job with kitchen, using the following command: Kitchen.bat /file:c:\data-diagnostics\PDI\development\zombies\zombies_top.kjb /param:START_DATE=2015-03-01 /param:END_DATE=2015-04-01 Result: Success (2) Add logging step in one of the sub-transforms, to send START_DATE and END_DATE to the console log. Same command line as before. Result: The following exception, with job failure. C:\pentaho-53\pdi-ee\data-integration>"C:\Program Files\Java\jre7\\bin\java.exe" "-Xmx512m" "-XX:MaxPermSize=256m" "-Dja _USER=" "-DKETTLE_PASSWORD=" "-DKETTLE_PLUGIN_PACKAGES=" "-DKETTLE_LOG_SIZE_LIMIT=" "-DKETTLE_JNDI_ROOT=" -jar launcher\p taho.di.kitchen.Kitchen /file:c:\data-diagnostics\PDI\development\zombies\zombies_top.kjb /param:START_DATE 2015-03-01 /p Exception in thread "main" java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92) Caused by: java.lang.RuntimeException: Central Log Store is not initialized!!! at org.pentaho.di.core.logging.KettleLogStore.getInstance(KettleLogStore.java:185) at org.pentaho.di.core.logging.KettleLogStore.getAppender(KettleLogStore.java:235) at org.pentaho.di.core.logging.LogChannel.println(LogChannel.java:122) at org.pentaho.di.core.logging.LogChannel.logError(LogChannel.java:166) at org.pentaho.di.pan.CommandLineOption.parseArguments(CommandLineOption.java:418) at org.pentaho.di.kitchen.Kitchen.main(Kitchen.java:197) ... 5 more I'm inclined to think that this will happen any time logging is invoked.

    Pentaho BI Platform Tracking | 2 years ago | Bryce Lobdell
    java.lang.reflect.InvocationTargetException
  6. 0

    Error in v1.0.1 ad hoc query [Archive] - Pentaho Community Forums

    pentaho.com | 6 months ago
    java.lang.RuntimeException: Internal error: Failed to parse query [select { [Measures].[Units Shipped], [Measures].[Units Ordered] } on columns, [Store].[Store Name].members on rows from Warehouse ]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.RuntimeException

      Internal error: Member '[Store].[All Stores].[USA].[CA]' is not in hierarchy '[Store]' at mondrian.olap.MondrianResource.newInternal(MondrianResource.java:42)

      at mondrian.olap.Util.newError()
    2. mondrian.olap
      Util.newError
      1. mondrian.olap.Util.newError(Util.java:439)
      1 frame