Hitachi Vantara Pentaho Community Forums
Results 1 to 16 of 16

Thread: error Pivot.jsp

  1. #1
    Join Date
    May 2009
    Posts
    13

    Default error Pivot.jsp

    tengo el siguiente error

    "An error occurred while rendering Pivot.jsp. Please see the log for details."

    Este error solamente ocurre cuando analizo un cubo creado por mi (creado y publicado en workbench), ya que cuando pruebo con el cubo de ejemplo, si me muestra todo. Que estoy haciendo mal?

    Gracias!

  2. #2
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    Ayudaría que dieras más detalles: versión de la plataforma, cómo estás intentando abrir el cubo (asumo que desde el arbol de la plataforma). Si pudieras mostrar el log, mejor aún.

    ¡Saludos!

  3. #3
    Join Date
    May 2009
    Posts
    13

    Default

    Estimado, muchas gracias por responder...

    Estoy utilizando la ultima version de pentaho. AL ingresar al portal, realizo un nuevo analizis, y le indico el esquema y cubo que deseo ver... y el resultado que es el siguiente mensaje:

    "Error Occurred While getting Resultset

    An error occurred while rendering Pivot.jsp. Please see the log for details"


    Te recuerdo que al abrir el cubo de ejemplo que viene con Pentaho, de la misma forma indicada anteriormente, no me indica ningun error y me muestra el cubo y los graficos sin problemas.

    Que log deseas que te muestre?

  4. #4
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    Arriesgaría que la causa es que está mal definido el cubo.

    Para poder obtener el log, primero deberías modificar el archivo "tomcat\webapps\pentaho\WEB-INF\classes\log4j.xml", y cambiar los "WARN" a "ERROR", para que muestre los errores.

    Luego reinicias el servidor Pentaho, intentas ejecutar lo que te da error, y el error debería quedar almacenado en el archivo "tomcat\bin\pentaho.log".

    Revisalo y pega aquí las secciones que creas relevantes, ó adjunta el archivo completo. Si lo pegas por favor hazlo entre tags para código (el símbolo "#" en la barra de herramientas).

    ¡Saludos!

  5. #5
    Join Date
    May 2009
    Posts
    13

    Default

    Code:
     2009-05-14 15:32:57,312 INFO  [CWM] CWM - Loaded CWM model into the default repository.
    2009-05-14 15:36:31,953 ERROR [com.tonbeller.wcf.component.RendererTag] trouble rendering table01
    com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Measures].[Aporte]} ON COLUMNS,
      NON EMPTY {([Time.New Hierarchy 0].[All Time.New Hierarchy 0s], [Informacion.New Hierarchy 0].[All Informacion.New Hierarchy 0s])} ON ROWS
    from [Proyectos]
    ]
        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._jspx_meth_wcf_005frender_005f8(Pivot_jsp.java:3164)
        at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:1834)
        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:81)
        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:164)
        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:129)
        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:55)
        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].[Aporte]} ON COLUMNS,
      NON EMPTY {([Time.New Hierarchy 0].[All Time.New Hierarchy 0s], [Informacion.New Hierarchy 0].[All Informacion.New Hierarchy 0s])} ON ROWS
    from [Proyectos]
    ]
        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)
        ... 73 more
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select max("proyecto"."aporte") as "m0" from "proyecto" as "proyecto"]
        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)
        ... 74 more
    Caused by: java.sql.SQLException: Table not found in statement [select max("proyecto"."aporte") as "m0" from "proyecto"]
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
        at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
        at mondrian.rolap.SqlStatement.execute(SqlStatement.java:128)
        ... 87 more
    Por lo que entedí es que no encuentra la tabla proyecto no? pero yo la veo desde workbench, y en el administrador de pentaho, tambien esta mi bd...

  6. #6
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    Sí, aparentemente no puede acceder a esa tabla, pero no necesariamente porque esta no existe.

    ¿Podrás publicar tu definición de cubo, para revisar que no haya errores en la misma?

    ¡Saludos!

  7. #7
    Join Date
    May 2009
    Posts
    13

    Default

    La definicion del cubo es:
    Code:
    <Cube name="Proyectos" cache="true" enabled="true">
            <Table name="proyecto">
            </Table>
            <Dimension type="TimeDimension" foreignKey="ano" name="Time">
                    <Hierarchy name="New Hierarchy 0" hasAll="true" primaryKey="ano" primaryKeyTable="tiempo">
                            <Table name="tiempo">
                            </Table>
                    </Hierarchy>
            </Dimension>
            <Dimension type="StandardDimension" foreignKey="id_colegio" name="Informacion">
                    <Hierarchy name="New Hierarchy 0" hasAll="true" primaryKey="id_colegio" primaryKeyTable="sobre_proyecto">
                            <Table name="sobre_proyecto">
                            </Table>
                    </Hierarchy>
            </Dimension>
            <Measure name="Aporte" column="aporte" formatString="#######,###" aggregator="max" visible="true">
            </Measure>
    </Cube>
    El modelo es super sencillo... una tabla de hecho (proyectos) y dos dimensiones (sobre_proyecto, tiempo).
    He estado buscado como hacer un cubo creando el xml directamente... pero no he encontrado nada claro...

    Muchas gracias por tu tiempo!!!!
    Last edited by mfserrano; 05-15-2009 at 09:34 AM.

  8. #8
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    Si no me equivoco, te están faltando las definiciones de niveles dentro de las dimensiones. Aquí tenés la referencia para editar el XML a mano: http://mondrian.pentaho.org/document...rchies,_Levels

    ¡Saludos!

  9. #9

    Default

    hola pudiste solucionarlo? yo tengo el mismo problema, gracias

  10. #10

    Default mi cubo es este, me pueden ayudar porfavor

    <Schema name="ventas2">
    <Cube name="Cubo1" cache="true" enabled="true">
    <Table name="ventas">
    </Table>
    <Dimension type="StandardDimension" foreignKey="producto_id" name="producto" caption="producto">
    <Hierarchy name="New Hierarchy 0" hasAll="true" primaryKey="producto_id">
    <Table name="producto">
    </Table>
    <Level name="superfamilia" column="producto_superfamilia" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
    </Level>
    <Level name="familia" column="producto_familia" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
    </Level>
    <Level name="subfamilia" column="producto_subfamilia" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
    </Level>
    </Hierarchy>
    </Dimension>
    <Dimension type="StandardDimension" foreignKey="vendedor_id" name="vendedor" caption="vendedor">
    <Hierarchy name="New Hierarchy 0" hasAll="true" primaryKey="vendedor_id">
    <Table name="vendedor">
    </Table>
    </Hierarchy>
    </Dimension>
    <Dimension type="StandardDimension" foreignKey="sucursal_id" name="sucursal" caption="sucursal">
    <Hierarchy name="New Hierarchy 0" hasAll="true" primaryKey="sucursal_id">
    <Table name="sucursal">
    </Table>
    </Hierarchy>
    </Dimension>
    <Dimension type="StandardDimension" foreignKey="proveedor_id" name="proveedor" caption="proveedor">
    <Hierarchy name="New Hierarchy 0" hasAll="true" primaryKey="proveedor_id">
    <Table name="proveedor">
    </Table>
    </Hierarchy>
    </Dimension>
    <Dimension type="StandardDimension" foreignKey="cliente_id" name="cliente" caption="cliente">
    <Hierarchy name="New Hierarchy 0" hasAll="true" primaryKey="cliente_id">
    <Table name="cliente">
    </Table>
    </Hierarchy>
    </Dimension>
    <Dimension type="TimeDimension" foreignKey="tiempo_id" name="tiempo" caption="tiempo">
    <Hierarchy name="New Hierarchy 0" hasAll="true" primaryKey="tiempo_id">
    <Table name="tiempo">
    </Table>
    <Level name="ano" column="tiempo_ano" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
    </Level>
    <Level name="cuarto" column="tiempo_cuarto" type="Numeric" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
    </Level>
    <Level name="mes" column="tiempo_mes_numero" type="String" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
    </Level>
    </Hierarchy>
    </Dimension>
    <Measure name="ventas_cantidad" column="ventas_cantidad" datatype="Integer" aggregator="sum" caption="ventas_cantidad" visible="true">
    </Measure>
    <Measure name="ventas_precio" column="ventas_precio" datatype="Integer" aggregator="sum" caption="ventas_precio" visible="true">
    </Measure>
    <Measure name="ventas_total" column="ventas_total" datatype="Integer" aggregator="sum" caption="ventas_total" visible="true">
    </Measure>
    </Cube>
    </Schema>

  11. #11
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    ¿Probaste definiéndole al menos un nivel a las dimensiones "vendedor", "sucursal", "proveedor" y "cliente"?

    No estoy seguro de que sea un requerimiento en todos los casos, pero no encontré documentación específica al respecto. Vale la pena probar...

  12. #12

    Default

    hola, pude solucionarlo finalmente pero ahora lo ejecuto y me sale la pantalla en blanco, no me muestra nada... que puede ser? muchas gracias!

  13. #13
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    ¿Te fijaste si hay algún error reportado en el log (<bi-server>/tomcat/bin/pentaho.log)?

    ¡Saludos!

  14. #14

    Default si mira este es el error, cambie el cubo

    2009-06-05 14:06:43,687 INFO [CWM] CWM - Loaded CWM model into the default repository.
    2009-06-05 14:10:30,718 ERROR [org.pentaho.platform.util.logging.Logger] Error: Pentaho
    2009-06-05 14:10:30,718 ERROR [org.pentaho.platform.util.logging.Logger] Error: Pentaho
    2009-06-05 14:10:30,734 ERROR [org.pentaho.platform.util.logging.Logger] misc-org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection: MDXConnection.ERROR_0002 - Invalid connection properties: PoolNeeded=false; Provider=mondrian; Catalog=solution:/ejemplos/EJEMPLO2.xml
    mondrian.olap.MondrianException: Mondrian Error:Named set in cube 'Sales' has bad formula
    at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
    at mondrian.rolap.RolapCube.resolveCalcMembers(RolapCube.java:742)
    ...
    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:Failed to parse query 'WITH
    MEMBER [Measures].[Profit]
    AS '[Measures].[Store Sales] - [Measures].[Store Cost]',
    FORMAT_STRING = "$#,##0.00",
    [$member_scope] = 'CUBE',
    MEMBER_ORDINAL = 3
    SELECT FROM [Sales]'
    at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
    at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:134)
    at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:63)
    at mondrian.rolap.RolapCube.resolveCalcMembers(RolapCube.java:740)
    ... 95 more
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while parsing MDX statement 'WITH
    MEMBER [Measures].[Profit]
    AS '[Measures].[Store Sales] - [Measures].[Store Cost]',
    FORMAT_STRING = "$#,##0.00",
    [$member_scope] = 'CUBE',
    MEMBER_ORDINAL = 3
    SELECT FROM [Sales]'
    at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
    at mondrian.olap.Parser.parseInternal(Parser.java:772)
    at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:129)
    ... 97 more
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Populating member cache with members for [[Time].[Year]]; 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 mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
    ...
    org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
    at mondrian.rolap.SqlStatement.execute(SqlStatement.java:128)
    ... 123 more
    2009-06-05 14:10:30,734 ERROR [org.pentaho.platform.util.logging.Logger] misc-org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection: MDXConnection.ERROR_0002 - Invalid connection properties: PoolNeeded=false; Provider=mondrian; Catalog=solution:/ejemplos/EJEMPLO2.xml
    mondrian.olap.MondrianException: Mondrian Error:Named set in cube 'Sales' has bad formula
    at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
    ...
    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:Failed to parse query 'WITH
    MEMBER [Measures].[Profit]
    AS '[Measures].[Store Sales] - [Measures].[Store Cost]',
    FORMAT_STRING = "$#,##0.00",
    [$member_scope] = 'CUBE',
    MEMBER_ORDINAL = 3
    SELECT FROM [Sales]'
    at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
    at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:134)
    at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:63)
    at mondrian.rolap.RolapCube.resolveCalcMembers(RolapCube.java:740)
    ... 95 more
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while parsing MDX statement 'WITH
    MEMBER [Measures].[Profit]
    AS '[Measures].[Store Sales] - [Measures].[Store Cost]',
    FORMAT_STRING = "$#,##0.00",
    [$member_scope] = 'CUBE',
    MEMBER_ORDINAL = 3
    SELECT FROM [Sales]'
    at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
    at mondrian.olap.Parser.parseInternal(Parser.java:772)
    at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:129)
    ... 97 more
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Populating member cache with members for [[Time].[Year]]; 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 mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
    at mondrian.olap.Util.newInternal(Util.java:1435)
    ...
    32908026-1244225429000:1244225427940.analysisview.xactionBase.ERROR_0002 - Ejecución fallida del Componente
    java.lang.NullPointerException
    at java.util.regex.Matcher.getTextLength(Unknown Source)
    at java.util.regex.Matcher.reset(Unknown Source)
    at java.util.regex.Matcher.<init>(Unknown Source)
    at java.util.regex.Pattern.matcher(Unknown Source)
    at ...
    [org.pentaho.platform.plugin.action.mondrian.PivotViewComponent] Error end:
    2009-06-05 14:10:30,750 ERROR [org.pentaho.platform.engine.services.runtime.RuntimeContext] 26aa58ad-51fc-11de-875f-bddb9a2e89b5:RUNTIME:context-32908026-1244225429000:1244225427940.analysisview.xaction RuntimeContext.ERROR_0012 - [es_33] ActionDefinition for PivotViewComponent did not execute successfully
    2009-06-05 14:10:30,750 ERROR [org.pentaho.platform.engine.services.runtime.RuntimeContext] 26aa58ad-51fc-11de-875f-bddb9a2e89b5:RUNTIME:context-32908026-1244225429000:1244225427940.analysisview.xaction RuntimeContext.ERROR_0012 - [es_33] ActionDefinition for PivotViewComponent did not execute successfully
    2009-06-05 14:12:49,125 ERROR [org.pentaho.platform.util.logging.Logger] Error: Pentaho
    2009-06-05 14:12:49,125 ERROR [org.pentaho.platform.util.logging.Logger] Error: Pentaho
    2009-06-05 14:12:49,125 ERROR [org.pentaho.platform.util.logging.Logger] misc-org.pentaho.platform.plugin.services.connections.mondrian.MDXConnection: MDXConnection.ERROR_0002 - Invalid connection properties: PoolNeeded=false; Provider=mondrian; Catalog=solution:/ejemplos/EJEMPLO3.mondrian.xml
    mondrian.olap.MondrianException: Mondrian Error:Named set in cube 'Sales' has bad formula
    at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
    at mondrian.rolap.RolapCube.resolveCalcMembers(RolapCube.java:742)
    at mondrian.rolap.RolapCube.createCalcMembersAndNamedSets(RolapCube.java:683)
    ...
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'WITH
    MEMBER [Measures].[Profit]
    AS '[Measures].[Store Sales] - [Measures].[Store Cost]',
    FORMAT_STRING = "$#,##0.00",
    [$member_scope] = 'CUBE',
    MEMBER_ORDINAL = 3
    SELECT FROM [Sales]'
    at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
    at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:134)
    at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:63)
    at mondrian.rolap.RolapCube.resolveCalcMembers(RolapCube.java:740)
    ... 95 more
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while parsing MDX statement 'WITH
    MEMBER [Measures].[Profit]
    AS '[Measures].[Store Sales] - [Measures].[Store Cost]',
    FORMAT_STRING = "$#,##0.00",
    [$member_scope] = 'CUBE',
    MEMBER_ORDINAL = 3
    SELECT FROM [Sales]'
    at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
    at mondrian.olap.Parser.parseInternal(Parser.java:772)
    at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:129)
    ... 97 more
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Populating member cache with members for [[Time].[Year]]; 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

  15. #15
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    Aparentemente tenés mal la definición del MEMBER ese que muestra en el log. Te recomendaría probar con una fórmula bien básica a ver si funciona, y si lo hace intentar corregir tu código para eliminar el error.

    ¡Saludos!

  16. #16
    Join Date
    Oct 2011
    Posts
    2

    Default

    Yo tambien tengo el mismo problema :@ el problema no esta en los cubos. Probe navegarlo con otra herramienta y funciona perfectamente la definicion del cubo.

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.