[prev in list] [next in list] [prev in thread] [next in thread]
List: mondrian
Subject: RE: [Mondrian] error with hsqldb
From: hadi ganteng <narou71185 () yahoo ! com>
Date: 2008-03-09 16:23:06
Message-ID: 377924.82536.qm () web58904 ! mail ! re1 ! yahoo ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
do you mean by the loader is the server? if the answer is yes, then i've ran the \
server when this error generated. thank you very much.
Hadi.
Julian Hyde <jhyde@pentaho.org> wrote: This error in the stdout log:
Caused by: java.sql.SQLException: Table not found in statement [select \
"time_by_day"."the_year" as "c0" from "time_by_day"]
is the cause. Apparently there is no table with that name. Did you run the loader?
Julian
---------------------------------
From: hadi ganteng [mailto:narou71185@yahoo.com]
Sent: Friday, March 07, 2008 3:20 AM
To: jhyde@pentaho.org; Mondrian developer mailing list
Subject: RE: [Mondrian] error with hsqldb
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. Hadi.
Julian Hyde <jhyde@pentaho.org> wrote: What's the root cause \
exception? You will find the full stack trace in apache's log.
Julian
---------------------------------
From: mondrian-bounces@pentaho.org \
[mailto:mondrian-bounces@pentaho.org] On Behalf Of hadi \
ganteng
Sent: Wednesday, March 05, 2008 5:07 AM
To: mondrian@pentaho.org
Subject: [Mondrian] error with hsqldb
when i changed the database into hsqldb i got an error, the error is:
JPivot had an error ...
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]
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] at \
org.apache.jasper.servlet.JspServletWrapper.handle \
JspException(JspServletWrapper.java:476) at \
org.apache.jasper.servlet.JspServletWrapper.servic \
e(JspServletWrapper.java:371) at \
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:315) at \
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:265) at \
javax.servlet.http.HttpServlet.service(HttpServlet .java:803) at \
org.apache.catalina.core.ApplicationFilterChain.in \
ternalDoFilter(ApplicationFilterChain.java:269) at \
org.apache.catalina.core.ApplicationFilterChain.do \
Filter(ApplicationFilterChain.java:188) at \
com.tonbeller.wcf.controller.RequestFilter$MyHandl \
er.normalRequest(RequestFilter.java:139) at \
com.tonbeller.wcf.controller.RequestSynchronizer.h \
andleRequest(RequestSynchronizer.java:127) at \
com.tonbeller.wcf.controller.RequestFilter.doFilte r(RequestFilter.java:263) \
at org.apache.catalina.core.ApplicationFilterChain.in \
ternalDoFilter(ApplicationFilterChain.java:215) at \
org.apache.catalina.core.ApplicationFilterChain.do \
Filter(ApplicationFilterChain.java:188) at \
org.apache.catalina.core.StandardWrapperValve.invo \
ke(StandardWrapperValve.java:210) at \
org.apache.catalina.core.StandardContextValve.invo \
ke(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.invok \
e(StandardEngineValve.java:108) at \
org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:151) \
at org.apache.coyote.http11.Http11Processor.process(H \
ttp11Processor.java:870) at org.apache.coyote.http11.Http11BaseProtocol$Http11 \
ConnectionHandler.processConnection(Http11BaseProt ocol.java:665) at \
org.apache.tomcat.util.net.PoolTcpEndpoint.process \
Socket(PoolTcpEndpoint.java:528) at \
org.apache.tomcat.util.net.LeaderFollowerWorkerThr \
ead.runIt(LeaderFollowerWorkerThread.java:81) at \
org.apache.tomcat.util.threads.ThreadPool$ControlR \
unnable.run(ThreadPool.java:685) at java.lang.Thread.run(Unknown Source)
maybe the " in the sql caused the error, because hsqldb don't accept " in the \
sql statement. how can i fix this error? thx...for helping me
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try \
it now._______________________________________________ Mondrian mailing \
list Mondrian@pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian
---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
[Attachment #5 (text/html)]
do you mean by the loader is the server? if the answer is yes, then i've ran the \
server when this error generated.<br>thank you very \
much.<br>Hadi.<br><br><b><i>Julian Hyde <jhyde@pentaho.org></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="216283804-08032008"><font \
color="#000080" face="Verdana" size="2">This error in the stdout \
log:</font></span></div> <div dir="ltr" align="left"><span \
class="216283804-08032008"></span> </div> <div dir="ltr" align="left"><span \
class="216283804-08032008"><font color="#000080" face="Verdana" size="2">Caused by: \
java.sql.SQLException: Table not found in statement [select "time_by_day"."the_year" \
as "c0" from "time_by_day"]<br></font></span></div> <div dir="ltr" \
align="left"><span class="216283804-08032008"><font color="#000080" face="Verdana" \
size="2">is the cause. Apparently there is no table with that name. Did you run the \
loader?</font></span></div> <div dir="ltr" align="left"><span \
class="216283804-08032008"><font color="#000080" face="Verdana" \
size="2"></font></span> </div> <div dir="ltr" align="left"><span \
class="216283804-08032008"><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> hadi ganteng \
[mailto:narou71185@yahoo.com] <br><b>Sent:</b> Friday, March 07, 2008 3:20 \
AM<br><b>To:</b> jhyde@pentaho.org; Mondrian developer mailing \
list<br><b>Subject:</b> RE: [Mondrian] error with hsqldb<br></font><br></div> \
<div></div>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 \
<jhyde@pentaho.org></i></b> wrote: <blockquote class="replbq" \
style="border-left: 2px solid rgb(16, 16, 255); padding-left: 5px; margin-left: \
5px;"> <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> </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"> Looking for last minute shopping deals? <a \
href="http://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsearch/category.php?category=shopping">Find \
them fast with Yahoo! Search.</a></blockquote></blockquote><br><p>  <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 \
"> Try it now.</a>
_______________________________________________
Mondrian mailing list
Mondrian@pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic