PDA

View Full Version : Problem opening cubes with public ip



lele1979
12-12-2007, 06:26 PM
Hy all,
I'm working with Pentaho 1.2 version, mysql and portlet.
My problem is:
When i execute cubes in localhost they work very well, but when i try to execute them with pulic ip i receive this error:


17:01:35,781 INFO [MondrianModel] connectString=provider=Mondrian;DataSource=java:co mp/env/jdbc/MYSQL;Catalog=http://217.133.22.20:8080/pentaho/GetMondrianModel?model=bi/FederlazioDW/Contabilita_federlazio.mondrian.xml
17:01:35,781 INFO [MondrianModel] jdbcDriver=null
17:01:35,781 INFO [OlapModelProxy] destroying: com.tonbeller.jpivot.olap.model.
CachingOlapModel@1fabe2a
17:01:35,781 INFO [MondrianModel]
17:01:35,781 INFO [OlapModelProxy] initializing: com.tonbeller.jpivot.olap.model.CachingOlapModel@4 1a196
17:01:35,781 INFO [MondrianModel] com.tonbeller.jpivot.mondrian.MondrianModel@d79cbb
17:01:35,781 INFO [MondrianModel] connectProperties=provider=Mondrian; DataSource=java:comp/env/jdbc/MYSQL; Catalog=http://217.133.22.20:8080/pentaho/GetMondrianModelmodel=bi/FederlazioDW/Contabilita_federlazio.mondrian.xml
17:01:56,828 ERROR [OlapModelTag]Mondrian.olap.MondrianException: Mondrian Error:Internal error: while parsing catalog http://217.133.22.20:8080/pentaho/Ge...o.mondrian.xml (http://217.133.22.20:8080/pentaho/GetMondrianModel?model=bi/FederlazioDW/Contabilita_federlazio.mondrian.xml)
at mondrian.resource.MondrianResource$_Def0.ex(Mondri anResource.java:850)
at mondrian.olap.Util.newInternal(Util.java:924)
at mondrian.olap.Util.newError(Util.java:940)
at mondrian.rolap.RolapSchema.load(RolapSchema.java:2 39)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java :174)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java :52)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.ja va:781)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.ja va:606)
at mondrian.rolap.RolapConnection.<init>(RolapConnect ion.java:141)
at mondrian.rolap.RolapConnection.<init>(RolapConnect ion.java:76)
at mondrian.olap.DriverManager.getConnection(DriverMa nager.java:120)
at mondrian.olap.DriverManager.getConnection(DriverMa nager.java:87)
at com.tonbeller.jpivot.mondrian.MondrianModel.initia lize(MondrianModel.java:400)
at com.tonbeller.jpivot.olap.model.OlapModelDecorator .initialize(OlapModelDecorator.java:129)
at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.i nitialize(OlapModelProxy.java:76)
at com.tonbeller.jpivot.tags.PageStateManager.initial izeAndShow(PageStateManager.java:37)
at com.tonbeller.jpivot.tags.OlapModelProxy.initializ eAndShow(OlapModelProxy.java:161)
at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(Ol apModelTag.java:76)
at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp .java:340)
at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:810)
at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:810)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
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:202)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
at org.pentaho.core.system.SystemStatusFilter.doFilte r(SystemStatusFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doF ilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationV alve.invoke(SecurityAssociationValve.java:175)
at org.apache.catalina.authenticator.AuthenticatorBas e.invoke(AuthenticatorBase.java:432)
at org.jboss.web.tomcat.security.JaccContextValve.inv oke(JaccContextValve.java:74)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread .run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)
Caused by: org.eigenbase.xom.XOMException: Document parse failed
at org.eigenbase.xom.wrappers.GenericDOMParser.parse( Unknown Source)
at mondrian.rolap.RolapSchema.load(RolapSchema.java:2 18)
... 48 more
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl .java:305)
at java.net.PlainSocketImpl.connectToAddress(PlainSoc ketImpl.java:171)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.j ava:158)
at java.net.Socket.connect(Socket.java:452)
at java.net.Socket.connect(Socket.java:402)
at sun.net.NetworkClient.doConnect(NetworkClient.java :139)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:402 (http://www.http.httpclient.openserver(httpclient.java:402/))
at sun.net.www.http.HttpClient.openServer(HttpClient.java:618 (http://www.http.httpclient.openserver(httpclient.java:618/))
at sun.net.www.http.HttpClient.<init>(HttpClient.java :306)
at sun.net.www.http.HttpClient.<init>(HttpClient.java :267)
at sun.net.www.http.HttpClient.New(HttpClient.java:339 (http://www.http.httpclient.new(httpclient.java:339/))
at sun.net.www.http.HttpClient.New(HttpClient.java:320 (http://www.http.httpclient.new(httpclient.java:320/))
at sun.net.www.http.HttpClient.New(HttpClient.java:315 (http://www.http.httpclient.new(httpclient.java:315/))
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(H ttpURLConne (http://www.protocol.http.httpurlconnection.plainconnect(httpurlconne/)ction.java:521)
at sun.net.www.protocol.http.HttpURLConnection.connect(HttpUR LConnection (http://www.protocol.http.httpurlconnection.connect(httpurlconnection/).java:498)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream (HttpURLCon (http://www.protocol.http.httpurlconnection.getinputstream(httpurlcon/)nection.java:626)
at java.net.URL.openStream(URL.java:913)
... 50 more

17:01:56,828 ERROR [RequestFilter] exeption
org.apache.jasper.JasperException:javax.servlet.js p.JspException: Mondrian Error:Internal error: while parsing catalog http://217.133.22.20:8080/pentaho/Ge...o.mondrian.xml (http://217.133.22.20:8080/pentaho/GetMondrianModel?model=bi/FederlazioDW/Contabilita_federlazio.mondrian.xml)
at org.apache.jasper.servlet.JspServletWrapper.handle JspException(JspServletWrapper.java:510)
at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:375)

at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:810)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
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:202)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
at org.pentaho.core.system.SystemStatusFilter.doFilte r(SystemStatusFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doF ilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationV alve.invoke(SecurityAssociationValve.java:175)
at org.apache.catalina.authenticator.AuthenticatorBas e.invoke(AuthenticatorBase.java:432)
at org.jboss.web.tomcat.security.JaccContextValve.inv oke(JaccContextValve.java:74)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread .run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)
17:01:56,828 ERROR [RequestFilter] cause
javax.servlet.ServletException: javax.servlet.jsp.JspException: Mondrian Error:Internal error: while parsing catalog http://217.133.22.20:8080/pentaho/Ge...o.mondrian.xml (http://217.133.22.20:8080/pentaho/GetMondrianModel?model=bi/FederlazioDW/Contabilita_federlazio.mondrian.xml)
at org.apache.jasper.runtime.PageContextImpl.doHandle PageException(PageContextImpl.java:854)
at org.apache.jasper.runtime.PageContextImpl.handlePa geException(PageContextImpl.java:791)
at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp .java:1025)
at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:810)
at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:810)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
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:202)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
at org.pentaho.core.system.SystemStatusFilter.doFilte r(SystemStatusFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doF ilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationV alve.invoke(SecurityAssociationValve.java:175)
at org.apache.catalina.authenticator.AuthenticatorBas e.invoke(AuthenticatorBase.java:432)
at org.jboss.web.tomcat.security.JaccContextValve.inv oke(JaccContextValve.java:74)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread .run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)
17:01:56,828 INFO [RequestFilter] redirecting to error page PivotError
17:01:56,828 INFO [RequestFilter] Request Execution total time: 21078 ms

IThe problem is only with cubes, it seems a problem with connection to db, but i'm not sure....The problem is when i try to open cubes, also from dashboards.
Anyone knows where is the problem and how i can solve it?
Thank you very much for reply!