PDA

View Full Version : Internal error: Error while creating RolapSch



kinkoi
06-05-2003, 12:08 PM
Hi, I got the following error I clicked on "JPivot pivot table" link (http://localhost:8080/mondrian/testpage.jsp?query=mondrian).
Here is what I did:
1. Installed jakarta-tomcat-4.1.18
2. Installed j2sdk1.4.0
3. Download mondrian-06.
4. Set JAVA_HOME
5. Start Tomcat and hit
http://localhost:8080/mondrian.
Did I miss something? Thank you.
Kinkoi
org.apache.jasper.JasperException: Internal error: Error while creating RolapSchema (provider=Mondrian; Jdbc=jdbc:odbc:MondrianFoodMart; Catalog=jndi:/localhost/mondrian/WEB-INF/queries/FoodMart.xml)
org.apache.jasper.JasperException: Internal error: Error while creating RolapSchema (provider=Mondrian; Jdbc=jdbc:odbc:MondrianFoodMart; Catalog=jndi:/localhost/mondrian/WEB-INF/queries/FoodMart.xml) 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

kinkoi
06-05-2003, 12:11 PM
I also extraced mondrian.war from the zip file to TOMCAT_HOME/webapps/mondrian.war.

jhyde
06-05-2003, 12:14 PM
I don't see a root-cause exception here. What's in Tomcat's log?

kinkoi
06-05-2003, 12:50 PM
2003-06-05 16:01:20 ApplicationDispatcher[/mondrian] Servlet.service() for servlet jsp threw exception
org.apache.jasper.JasperException: Internal error: Error while creating RolapSchema (provider=Mondrian; Jdbc=jdbc:odbc:MondrianFoodMart; Catalog=jndi:/localhost/mondrian/WEB-INF/queries/FoodMart.xml)
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.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:47)
at org.apache.jsp.testpage_jsp._jspx_meth_wcf_include_0(testpage_jsp.java:174)
at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:99)
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: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)
----- Root Cause -----
javax.servlet.ServletException: Internal error: Error while creating RolapSchema (provider=Mondrian; Jdbc=jdbc:odbc:MondrianFoodMart; Catalog=jndi:/localhost/mondrian/WEB-INF/queries/FoodMart.xml)
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:528)
at org.apache.jsp.mondrian_jsp._jspService(mondrian_jsp.java:67)
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:47)
at org.apache.jsp.testpage_jsp._jspx_meth_wcf_include_0(testpage_jsp.java:174)
at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:99)
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: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)

jhyde
06-05-2003, 12:56 PM
I suspect that the catalog URL 'jndi:/localhost/mondrian/WEB-INF/queries/FoodMart.xml' is only valid if the webapp is reading from mondrian.war, whereas you are running from TOMCAT_HOME/webapps/mondrian.
Stop Tomcat, remove TOMCAT_HOME/webapps/mondrian, and restart. Tomcat should automatically expand TOMCAT_HOME/webapps/mondrian.war when it starts.

kinkoi
06-05-2003, 01:30 PM
I changed the Tomcat server.xml setting not to unpack the war files. After I removed the TOMCAT_HOME/webapps/mondrian directory and restarted the server, I'm still getting the same error. I confirm that the mondrian directory doesn't exist anymore.
<Host name="localhost" debug="0" appBase="webapps"
unpackWARs="false" autoDeploy="true">

jhyde
06-05-2003, 01:37 PM
Fyi, my settings are
<Host name="localhost" debug="0" appBase="webapps"
unpackWARs="true" autoDeploy="true">
(I let Tomcat unpack the WAR for me.)
Does that ODBC DSN 'MondrianFoodMart' exist? That is another possible cause of the problem.

kinkoi
06-05-2003, 01:49 PM
That is my original setting too. Base on your previous mail, I thought the mondrian.war should not be unpack, therefore I set unpackWARs to "false".
I don't ODBC DSN. I just followed section 3.1 on the installation instruction. (http://apoptosis.dyndns.org:8080/@md=d&cd=//open/mondrian/doc/&c=
9L6@//open/mondrian/doc/install.html
#3_Getting_Mondrian)

jhyde
06-05-2003, 07:45 PM
Follow section 4.1 -- create the ODBC DSN -- and let me know if it works any better.

kinkoi
06-06-2003, 06:16 AM
I'm still getting the same error after create the DSN.
Can I follow the instruction of "Appendix B. How to debug Tomcat using IntelliJ" to debug it?

ebengtso
06-07-2003, 01:34 AM
I'm having the same error..
Steps to install
1. mondrian.war to my webapps dir
2. created a system DSN named 'MondrianFoodMart'
Version 0.6 downloaded from sourceforge.net

ebengtso
06-07-2003, 01:44 AM
Worked after a machine restart.. :O

ebengtso
06-07-2003, 01:46 AM
It is the adress mondrian is running..
It will be online 12x7
http://www.emploigratis.com/mondrian/

kinkoi
06-07-2003, 11:45 AM
Thank you for the information. It is working now.
Here is what I did:
1. restart the machine.
2. try to delete the my old system DSN named 'MondrianFoodMart' but fail.
3. create a new system DSN named 'MondrianFoodMart'.
4. start tomcat
5. hit the localhost:8080/mondrian link.
It works !!
Here is a screen shot of my DSN setting.
http://home.attbi.com/~kinkoi/odbc.jpg
I still don't know why I can't configure or remove my old DSN.