Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Error publicar Reporte "Report validation failed."

  1. #1
    Join Date
    Dec 2008
    Posts
    25

    Default Error publicar Reporte "Report validation failed."

    Buenas tardes.
    Tengo unos informes diseñados con la versión 2.0. del Report Designer. Los he modificado con la versión 3.6 para convertirlos en .prpt
    Uno de los informes lo he modificado incluyendo los parámetros y no me ha dado problema, pero el segundo, el cual he modificado de la misma forma, me aparece el siguiente error cuando lo ejecuto en la consola de usuario: "Report validation failed"
    Por favor, si alguien puede ayudarme, lo agradecería.
    Gracias.
    Saludos

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

    Default

    Ya una pregunta clásica de mi parte: ¿el log de la plataforma no muestra nada más sobre el problema?
    (en) Path to Pentaho knowledge: (1:Search the Wiki > 2:Search the Forums > 3:Ask) or (1:Get a Subscription)
    (es) El camino al conocimiento en Pentaho: (1:Buscar en la Wiki > 2:Buscar en los Foros > 3:Preguntar) o (1:Comprar una Subscripción)

  3. #3
    Join Date
    Dec 2008
    Posts
    25

    Default

    Buenas.
    Gracias por contestar.
    Esto es lo que aparece en el fichero tomcat/bin/pentaho.log
    pero no sé a que puede ser debido el problema. Espero vuestra ayuda.
    Gracias de nuevo:

    Code:
    2010-07-04 17:54:32,681 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2010-07-04 17:54:35,025 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2010-07-04 17:54:35,134 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2010-07-04 17:54:35,244 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2010-07-04 17:55:58,701 ERROR [org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor] 30908546: Report processing failed.
    2010-07-04 17:55:58,701 ERROR [org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor] 30908546: Report processing failed.
    2010-07-04 17:55:58,701 ERROR [org.pentaho.reporting.platform.plugin.SimpleReportingComponent] [execute] Component execution failed.
    org.pentaho.reporting.engine.classic.core.ReportProcessingException: Unable to initialize the report
     at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:553)
     at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1371)
     at org.pentaho.reporting.platform.plugin.output.PageableHTMLOutput.generate(PageableHTMLOutput.java:97)
     at org.pentaho.reporting.platform.plugin.SimpleReportingComponent.execute(SimpleReportingComponent.java:1126)
     at org.pentaho.reporting.platform.plugin.ReportContentGenerator.createParameterContent(ReportContentGenerator.java:520)
     at org.pentaho.reporting.platform.plugin.ReportContentGenerator.createContent(ReportContentGenerator.java:122)
     at org.pentaho.platform.engine.services.solution.SimpleContentGenerator.createContent(SimpleContentGenerator.java:66)
     at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:259)
     at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:78)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
     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.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: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)
    ParentException: 
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT
         decode(sum(num_proced),0,0,trunc(sum(proc_normalizados)*100/sum(num_proced),2))
    FROM
         "V_NORMALIZ_FORM"
    WHERE
         fecha = ${FECHA}
     at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:236)
     at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:95)
     at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88)
     at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168)
     at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143)
     at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81)
     at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81)
     at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97)
     at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performSubReportQuery(DefaultFlowController.java:258)
     at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:433)
     at org.pentaho.reporting.engine.classic.core.states.process.EndSubReportHandler.commit(EndSubReportHandler.java:58)
     at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.commit(ProcessState.java:819)
     at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processPrepareLevels(AbstractReportProcessor.java:419)
     at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.performStructuralPreprocessing(AbstractReportProcessor.java:569)
     at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:483)
     at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1371)
     at org.pentaho.reporting.platform.plugin.output.PageableHTMLOutput.generate(PageableHTMLOutput.java:97)
     at org.pentaho.reporting.platform.plugin.SimpleReportingComponent.execute(SimpleReportingComponent.java:1126)
     at org.pentaho.reporting.platform.plugin.ReportContentGenerator.createParameterContent(ReportContentGenerator.java:520)
     at org.pentaho.reporting.platform.plugin.ReportContentGenerator.createContent(ReportContentGenerator.java:122)
     at org.pentaho.platform.engine.services.solution.SimpleContentGenerator.createContent(SimpleContentGenerator.java:66)
     at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:259)
     at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:78)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
     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.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: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)
    Last edited by tdidomenico; 07-05-2010 at 10:27 AM. Reason: Añadiendo tags "[CODE]" al log

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

    Default

    Definitivamente está fallando al intentar obtener el parámetro, con lo cual asumo que hay algún problema en la definición del parámetro en el PRD.

    ¿Cuando lo ejecutás dentro del mismo PRD, haciendo una vista previa, funciona correctamente?
    (en) Path to Pentaho knowledge: (1:Search the Wiki > 2:Search the Forums > 3:Ask) or (1:Get a Subscription)
    (es) El camino al conocimiento en Pentaho: (1:Buscar en la Wiki > 2:Buscar en los Foros > 3:Preguntar) o (1:Comprar una Subscripción)

  5. #5
    Join Date
    Dec 2008
    Posts
    25

    Default

    Buenas.
    Gracias por contestar.
    Efectivamente con PRD al ejecutar la previsualizacion funciona correctamente, es más me aparece el parámetro.
    Saludos

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

    Default

    Hm, no logro reproducir el error. ¿Alguna chance de que modifiques el reporte para dejarle un mínimo de datos y conectarlo con alguna de las tablas de sampledata? Así puedo reproducir el error en mi máquina y ver de qué se trata... No se me ocurre qué más recomendarte, de otra manera.

    ¡Saludos!
    (en) Path to Pentaho knowledge: (1:Search the Wiki > 2:Search the Forums > 3:Ask) or (1:Get a Subscription)
    (es) El camino al conocimiento en Pentaho: (1:Buscar en la Wiki > 2:Buscar en los Foros > 3:Preguntar) o (1:Comprar una Subscripción)

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.