Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: error in user conlose when new analisys view

  1. #1
    Join Date
    Sep 2009
    Posts
    21

    Default error in user conlose when new analisys view

    hi all:
    i´m new and i´m novice (sorry for my english)
    i just make my firts publishing, and when i try a new analisys view at pentaho user console i can select my schema and my cube, but when press OK i receive the next emssage
    " An error occurred while rendering Pivot.jsp. Please see the log for details.
    "
    i make tables on spoon from excell files.open db in workbech,define cube on it and schema from schema workbech in G: , and publish it into admin on
    "H:\pentaho\biserver-ce-3.0.0-STABLE\biserver-ce\pentaho-solutions\admin"

    in not sure is the problem is relative to the save fordels or anything else
    Im new so im not sure if i must copy any file into any biserver folder.
    or maybe i left behind any necesary step.

    here is the log.
    "
    2009-10-02 16:50:37,375 ERROR [com.tonbeller.wcf.component.RendererTag] trouble rendering tablef13b88dc-af62-11de-a2c2-91700d551144
    com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Measures].[muerte total]} ON COLUMNS,
    NON EMPTY {[loc.paises].[All loc.paisess]} ON ROWS
    from [cube1]
    ]
    at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:305)
    at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54)
    at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48)
    at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54)
    at com.tonbeller.jpivot.table.TableComponent.updateOlapModel(TableComponent.java:246)
    at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:251)
    at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:235)
    at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137)
    at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:2475)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
    at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
    at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
    at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
    at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
    at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
    at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
    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.invoke(StandardEngineValve.java:108)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
    at java.lang.Thread.run(Unknown Source)
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Measures].[muerte total]} ON COLUMNS,
    NON EMPTY {[loc.paises].[All loc.paisess]} ON ROWS
    from [cube1]
    ]
    at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
    at mondrian.olap.Util.newInternal(Util.java:1435)
    at mondrian.olap.Util.newError(Util.java:1451)
    at mondrian.rolap.RolapConnection.execute(RolapConnection.java:625)
    at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:279)
    ... 72 more
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select avg(`sanida_tabl`.`hombres`) as `m0` from `sanida_tabl` as `sanida_tabl`]
    at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
    at mondrian.olap.Util.newInternal(Util.java:1435)
    at mondrian.olap.Util.newError(Util.java:1451)
    at mondrian.rolap.SqlStatement.handle(SqlStatement.java:211)
    at mondrian.rolap.SqlStatement.execute(SqlStatement.java:142)
    at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:243)
    at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:204)
    at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:341)
    at mondrian.rolap.agg.SegmentLoader.load(SegmentLoader.java:75)
    at mondrian.rolap.agg.Aggregation.load(Aggregation.java:171)
    at mondrian.rolap.agg.AggregationManager.loadAggregation(AggregationManager.java:89)
    at mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:495)
    at mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:431)
    at mondrian.rolap.FastBatchingCellReader.loadAggregation(FastBatchingCellReader.java:206)
    at mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:187)
    at mondrian.rolap.RolapResult.executeBody(RolapResult.java:752)
    at mondrian.rolap.RolapResult.<init>(RolapResult.java:397)
    at mondrian.rolap.RolapConnection.execute(RolapConnection.java:597)
    ... 73 more
    Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'proyecto.sanida_tabl' doesn't exist
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:3250)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:3179)
    at com.mysql.jdbc.Statement.executeQuery(Statement.java:1207)
    at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
    at mondrian.rolap.SqlStatement.execute(SqlStatement.java:128)
    ... 86 more
    "

    im not capable to understant it. please, what this means???
    thanks all.

  2. #2

    Default

    it says the sql its generating is correct, you probably have an issue with your schema definition.

    Tom
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  3. #3
    Join Date
    Sep 2009
    Posts
    21

    Default

    thank for you answer.
    im using biserver-ce-3.0.0-STABLE
    i make the schema following the video from
    http://www.pentaho.com/products/demo...ales_tools.php

    why kind of error must i search on the scheme??
    it´s a simple cube with 1 dim and 1 measure.

  4. #4
    Join Date
    Sep 2009
    Posts
    21

    Default

    is necesary use metadata editor after schemaworkbech and before any report or analisys view???

    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.