i can't understand where is the root of the exception, because i'm very new to tomcat 5.5. maybe this generated log file can help. thank you very much for help me. <br>Hadi.<br><br><b><i>Julian Hyde &lt;jhyde@pentaho.org&gt;</i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;">   <meta http-equiv="Content-Type" content="text/html; charset=us-ascii"> <meta content="MSHTML 6.00.6001.17052" name="GENERATOR"> <div dir="ltr" align="left"><span class="345433415-05032008"><font color="#000080" face="Verdana" size="2">What's the root cause exception? You will find the full  stack trace in apache's log.</font></span></div> <div dir="ltr" align="left"><span class="345433415-05032008"><font color="#000080" face="Verdana" size="2"></font></span>&nbsp;</div> <div dir="ltr" align="left"><span class="345433415-05032008"><font color="#000080" face="Verdana" size="2">Julian</font></span></div><br> <blockquote
 style="border-left: 2px solid rgb(0, 0, 128); padding-left: 5px; margin-left: 5px; margin-right: 0px;">   <div class="OutlookMessageHeader" dir="ltr" align="left" lang="en-us">   <hr tabindex="-1">   <font face="Tahoma" size="2"><b>From:</b> mondrian-bounces@pentaho.org    [mailto:mondrian-bounces@pentaho.org] <b>On Behalf Of </b>hadi    ganteng<br><b>Sent:</b> Wednesday, March 05, 2008 5:07 AM<br><b>To:</b>    mondrian@pentaho.org<br><b>Subject:</b> [Mondrian] error with    hsqldb<br></font><br></div>   <div></div>when i changed the database into hsqldb i got an error, the error    is:<br><b>JPivot had an error    ...</b><br><br><b>org.apache.jasper.JasperException:    javax.servlet.jsp.JspException: javax.servlet.jsp.JspException: Mondrian    Error:Internal error: while building member cache; sql=[select    "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by    "time_by_day"."the_year" order by "time_by_day"."the_year"     
 ASC]</b><br><br>org.apache.jasper.JasperException:    javax.servlet.jsp.JspException: javax.servlet.jsp.JspException: Mondrian    Error:Internal error: while building member cache; sql=[select    "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by    "time_by_day"."the_year" order by "time_by_day"."the_year" ASC]<br>at    org.apache.jasper.servlet.JspServletWrapper.handle    JspException(JspServletWrapper.java:476)<br>at    org.apache.jasper.servlet.JspServletWrapper.servic    e(JspServletWrapper.java:371)<br>at    org.apache.jasper.servlet.JspServlet.serviceJspFil    e(JspServlet.java:315)<br>at    org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:265)<br>at    javax.servlet.http.HttpServlet.service(HttpServlet .java:803)<br>at    org.apache.catalina.core.ApplicationFilterChain.in    ternalDoFilter(ApplicationFilterChain.java:269)<br>at    org.apache.catalina.core.ApplicationFilterChain.do     
 Filter(ApplicationFilterChain.java:188)<br>at    com.tonbeller.wcf.controller.RequestFilter$MyHandl    er.normalRequest(RequestFilter.java:139)<br>at    com.tonbeller.wcf.controller.RequestSynchronizer.h    andleRequest(RequestSynchronizer.java:127)<br>at    com.tonbeller.wcf.controller.RequestFilter.doFilte    r(RequestFilter.java:263)<br>at    org.apache.catalina.core.ApplicationFilterChain.in    ternalDoFilter(ApplicationFilterChain.java:215)<br>at    org.apache.catalina.core.ApplicationFilterChain.do    Filter(ApplicationFilterChain.java:188)<br>at    org.apache.catalina.core.StandardWrapperValve.invo    ke(StandardWrapperValve.java:210)<br>at    org.apache.catalina.core.StandardContextValve.invo    ke(StandardContextValve.java:174)<br>at    org.apache.catalina.core.StandardHostValve.invoke(    StandardHostValve.java:127)<br>at    org.apache.catalina.valves.ErrorReportValve.invoke    (ErrorReportValve.java:117)<br>at     
 org.apache.catalina.core.StandardEngineValve.invok    e(StandardEngineValve.java:108)<br>at    org.apache.catalina.connector.CoyoteAdapter.servic    e(CoyoteAdapter.java:151)<br>at    org.apache.coyote.http11.Http11Processor.process(H    ttp11Processor.java:870)<br>at    org.apache.coyote.http11.Http11BaseProtocol$Http11    ConnectionHandler.processConnection(Http11BaseProt ocol.java:665)<br>at    org.apache.tomcat.util.net.PoolTcpEndpoint.process    Socket(PoolTcpEndpoint.java:528)<br>at    org.apache.tomcat.util.net.LeaderFollowerWorkerThr    ead.runIt(LeaderFollowerWorkerThread.java:81)<br>at    org.apache.tomcat.util.threads.ThreadPool$ControlR    unnable.run(ThreadPool.java:685)<br>at java.lang.Thread.run(Unknown    Source)<br><br>maybe the " in the sql caused the error, because hsqldb don't    accept " in the sql statement.<br>how can i fix this error? thx...for helping    me   <div>   </div><hr size="1">   Be a better friend, newshound, and know-it-all with Yahoo!  
 Mobile. <a href="http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ%20">Try    it now.</a></blockquote>_______________________________________________<br>Mondrian mailing list<br>Mondrian@pentaho.org<br>http://lists.pentaho.org/mailman/listinfo/mondrian<br></blockquote><br><div>        </div><hr size="1">Be a better friend, newshound, and  know-it-all with Yahoo! Mobile. <a href="http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ%20"> Try it now.</a><div>        </div><hr size="1">Be a better friend, newshound, and  know-it-all with Yahoo! Mobile. <a href="http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ%20"> Try it now.</a><p>&#32;

      <hr size=1>Never miss a thing.  <a href="http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs"> Make Yahoo your homepage.</a>