2012-07-18 10:39:58,143 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http 2012-07-18 10:39:59,925 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http 2012-07-18 10:40:00,081 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http 2012-07-18 10:40:00,565 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http 2012-07-18 10:40:00,878 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http 2012-07-18 10:40:01,143 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http 2012-07-18 10:40:01,253 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http 2012-07-18 10:40:01,378 WARN [org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We don't support method overloading. Ignoring [public java.lang.String serializeModels(org.pentaho.metadata.model.Domain,java.lang.String,boolean) throws java.lang.Exception] 2012-07-18 10:40:01,393 WARN [org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We don't support method overloading. Ignoring [public java.lang.String serializeModels(org.pentaho.metadata.model.Domain,java.lang.String,boolean) throws java.lang.Exception] 2012-07-18 10:40:01,409 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http 2012-07-18 10:40:01,518 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http 2012-07-18 10:40:01,659 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http 2012-07-18 10:40:01,706 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http 2012-07-18 10:40:01,753 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http 2012-07-18 10:40:01,846 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http 2012-07-18 10:40:01,987 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http 2012-07-18 10:40:02,128 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http 2012-07-18 10:40:02,206 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http 2012-07-18 10:40:02,300 WARN [org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We don't support method overloading. Ignoring [public java.lang.String serializeModels(org.pentaho.metadata.model.Domain,java.lang.String,boolean) throws java.lang.Exception] 2012-07-18 10:40:02,315 WARN [org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We don't support method overloading. Ignoring [public java.lang.String serializeModels(org.pentaho.metadata.model.Domain,java.lang.String,boolean) throws java.lang.Exception] 2012-07-18 10:40:02,331 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http 2012-07-18 10:40:02,425 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http 2012-07-18 10:48:13,784 WARN [org.pentaho.platform.engine.services.runtime.TemplateUtil] not found: [Measures].[Cantidad] 2012-07-18 10:50:11,659 ERROR [com.tonbeller.wcf.component.RendererTag] trouble rendering table36d5c895-d0df-11e1-a893-151190fed51f com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Measures].[Cantidad]} ON COLUMNS, NON EMPTY Crossjoin(Hierarchize(Union(Union(Crossjoin({[Cliente.N_H_Cliente].[All Cliente.N_H_Clientes]}, {[Departamento.N_H_Departamento].[All Departamento.N_H_Departamentos]}), Crossjoin({[Cliente.N_H_Cliente].[All Cliente.N_H_Clientes]}, [Departamento.N_H_Departamento].[All Departamento.N_H_Departamentos].Children)), Crossjoin([Cliente.N_H_Cliente].[All Cliente.N_H_Clientes].Children, {[Departamento.N_H_Departamento].[All Departamento.N_H_Departamentos]}))), {([Producto.N_H_NombreProducto].[All Producto.N_H_NombreProductos], [Tiempo.N_H_Tiempo].[All Tiempo.N_H_Tiempos])}) ON ROWS from [ventas] ] 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:2758) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:92) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584) at java.lang.Thread.run(Thread.java:662) Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Measures].[Cantidad]} ON COLUMNS, NON EMPTY Crossjoin(Hierarchize(Union(Union(Crossjoin({[Cliente.N_H_Cliente].[All Cliente.N_H_Clientes]}, {[Departamento.N_H_Departamento].[All Departamento.N_H_Departamentos]}), Crossjoin({[Cliente.N_H_Cliente].[All Cliente.N_H_Clientes]}, [Departamento.N_H_Departamento].[All Departamento.N_H_Departamentos].Children)), Crossjoin([Cliente.N_H_Cliente].[All Cliente.N_H_Clientes].Children, {[Departamento.N_H_Departamento].[All Departamento.N_H_Departamentos]}))), {([Producto.N_H_NombreProducto].[All Producto.N_H_NombreProductos], [Tiempo.N_H_Tiempo].[All Tiempo.N_H_Tiempos])}) ON ROWS from [ventas] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:841) at mondrian.olap.Util.newInternal(Util.java:1539) at mondrian.olap.Util.newError(Util.java:1555) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:622) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:279) ... 74 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Populating member cache with members for [[Cliente.N_H_Cliente].[(All)], [Departamento.N_H_Departamento].[Nombre Departamento]]; sql=[select "dim_departamento"."nombre_departamento" as "c0", "dim_departamento"."nombre_departamento" as "c1" from "public"."dim_departamento" as "dim_departamento", "public"."fact_venta" as "fact_venta" where "fact_venta"."id_departamento" = "dim_departamento"."nombre_departamento" group by "dim_departamento"."nombre_departamento" order by "dim_departamento"."nombre_departamento" ASC] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:841) at mondrian.olap.Util.newInternal(Util.java:1539) at mondrian.olap.Util.newError(Util.java:1555) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:277) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:193) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:230) at mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:373) at mondrian.rolap.SqlTupleReader.readTuples(SqlTupleReader.java:519) at mondrian.rolap.RolapNativeSet$SetEvaluator.executeList(RolapNativeSet.java:226) at mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:178) at mondrian.olap.fun.CrossJoinFunDef$BaseListCalc.evaluateList(CrossJoinFunDef.java:1172) at mondrian.olap.fun.UnionFunDef$1.evaluateList(UnionFunDef.java:59) at mondrian.olap.fun.UnionFunDef$1.evaluateList(UnionFunDef.java:58) at mondrian.calc.impl.AbstractListCalc.evaluateTupleList(AbstractListCalc.java:89) at mondrian.olap.fun.HierarchizeFunDef$2.evaluateTupleList(HierarchizeFunDef.java:64) at mondrian.calc.impl.AbstractTupleListCalc.evaluateList(AbstractTupleListCalc.java:88) at mondrian.rolap.sql.CrossJoinArgFactory.expandNonNative(CrossJoinArgFactory.java:900) at mondrian.rolap.sql.CrossJoinArgFactory.checkCrossJoin(CrossJoinArgFactory.java:345) at mondrian.rolap.RolapNativeCrossJoin.createEvaluator(RolapNativeCrossJoin.java:105) at mondrian.rolap.RolapNativeRegistry.createEvaluator(RolapNativeRegistry.java:56) at mondrian.rolap.RolapSchemaReader.getNativeSetEvaluator(RolapSchemaReader.java:608) at mondrian.olap.DelegatingSchemaReader.getNativeSetEvaluator(DelegatingSchemaReader.java:235) at mondrian.olap.fun.CrossJoinFunDef$BaseTupleIterCalc.evaluateTupleIterable(CrossJoinFunDef.java:260) at mondrian.calc.impl.AbstractTupleIterCalc.evaluate(AbstractTupleIterCalc.java:52) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:733) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:576) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:542) at mondrian.rolap.RolapResult.(RolapResult.java:274) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:593) ... 75 more Caused by: org.postgresql.util.PSQLException: ERROR: el operador no existe: integer = character varying Hint: Ningún operador coincide con el nombre y el tipo de los argumentos. Puede ser necesario agregar conversiones explícitas de tipos. Position: 238 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:372) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:152) ... 99 more