PDA

View Full Version : error Pivot.jsp



mfserrano
05-13-2009, 10:18 AM
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!

tdidomenico
05-13-2009, 02:08 PM
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!

mfserrano
05-13-2009, 06:00 PM
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?

tdidomenico
05-14-2009, 10:40 AM
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!

mfserrano
05-14-2009, 03:58 PM
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 morePor 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...
:confused:

tdidomenico
05-14-2009, 04:01 PM
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!

mfserrano
05-15-2009, 09:01 AM
La definicion del cubo es:

<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!!!! ;)

tdidomenico
05-18-2009, 11:32 AM
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/documentation/schema.php#Dimensions,_Hierarchies,_Levels

¡Saludos!

pabloym
06-03-2009, 12:21 PM
hola pudiste solucionarlo? yo tengo el mismo problema, gracias

pabloym
06-03-2009, 02:36 PM
<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>

tdidomenico
06-03-2009, 02:53 PM
¿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...

pabloym
06-05-2009, 02:21 PM
hola, pude solucionarlo finalmente pero ahora lo ejecuto y me sale la pantalla en blanco, no me muestra nada... que puede ser? muchas gracias!

tdidomenico
06-05-2009, 02:34 PM
¿Te fijaste si hay algún error reportado en el log (<bi-server>/tomcat/bin/pentaho.log)?

¡Saludos!

pabloym
06-05-2009, 02:55 PM
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

tdidomenico
06-08-2009, 10:40 AM
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!

luizao
02-02-2012, 06:32 PM
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.