PDA

View Full Version : Internal error: while counting members of lev



shaunstoltz
09-18-2003, 10:17 AM
Hi, have had no problems with 0.6 and rc1, when loaded 1.0 have problem with mysql db.
error follows:
org.apache.jasper.JasperException: Internal error: while counting members of level '[Pay Type].[Pay Type]'; sql=[select count(DISTINCT `position`.`pay_type`) as `c0` from `employee` as `employee`, `position` as `position` where `employee`.`position_id` = `position`.`position_id`]
org.apache.jasper.JasperException: Internal error: while counting members of level '[Pay Type].[Pay Type]'; sql=[select count(DISTINCT `position`.`pay_type`) as `c0` from `employee` as `employee`, `position` as `position` where `employee`.`position_id` = `position`.`position_id`] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:248) 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:71) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:62) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:89) 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)
mondrian.properies follows:
# Uncomment the following lines to run subsets of the test suite
mondrian.test.Class=mondrian.olap.fun.BuiltinFunTable
mondrian.test.Name=testToggleDrillState
# Comma-separated list of JDBC drivers
mondrian.jdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver,com.mysql.jdbc.Driver
# JDBC connect string used by the test suite.
mondrian.foodmart.jdbcURL=jdbc:odbc:MondrianFoodMart
#mondrian.foodmart.jdbcURL=jdbc:oracle:oci8:foodmart/foodmart@realm1
mondrian.foodmart.jdbcURL=jdbc:odbc:MondrianFoodMart
#mondrian.foodmart.jdbcURL=jdbc:hsqldb:demo/hsql/FoodMart
mondrian.foodmart.jdbcURL=jdbc:mysql://localhost/foodmart?user=root&password=
# Tracing
mondrian.trace.level=2
# Additional products. Uncomment the ones you have installed.
#catalina.home=C:/jakarta-tomcat-4.1.24
#weblogic.home=C:/bea/wlserver6.1
# End mondrian.properties
mondrian.jsp in \queries follows:
<mondrian:query id="query01" jdbcDriver="com.mysql.jdbc.Driver" jdbcUrl="jdbc:mysql://localhost/foodmart?user=root&password=xmlsql" catalogUri="/WEB-INF/queries/FoodMart.xml">
Any help appreciated

shaunstoltz
09-24-2003, 11:32 AM
Problem solved by removing reference to this dimension in foodmart.xml