Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Jasper Report 0.4.6 Bi-Server 4.5 and a lot of praying

  1. #1
    Join Date
    Jul 2011
    Posts
    22

    Default Jasper Report 0.4.6 Bi-Server 4.5 and a lot of praying

    Hi Guys!
    I'm trying to do a sample task:

    I defined a report with jasper that produces a crosstab. This report doesn't receive any parameter, I'd like to launch it with an xaction.
    So I tried in 20 different ways and I tried also to define the jasperreports-conf.xml and pentaho-solutions/system/jasperreport in this way

    This is the file name jasperreports-conf.xml

    Code:
    <jasperreports>
        <!-- add any system-wide settings that you need here, paths to config files etc -->
    
        <imageHandling>
            <!-- The image URL is releative to the Pentaho base URL -->
            <imageUrl>getImage?image=</imageUrl>
            <!-- The image directory is in the Pentaho solution path -->
            <imageDir>system/tmp</imageDir>
        </imageHandling>
    
        <htmlExportOptions>
            <removeEmptySpaceBetweenRows>true</removeEmptySpaceBetweenRows>
        </htmlExportOptions>
    
        <!-- TODO: Add default JDBC connect info -->
        <driver><![CDATA[org.postgresql.Driver]]></driver>  
            <connection><![CDATA[jdbc:postgresql://esx-dixi.cilea.it:5432/unimidwh]]></connection>  
            <user-id><![CDATA[test]]></user-id>  
            <password><![CDATA[test]]></password>
    </jasperreports>
    As you can see I defined the connection also in the file above.


    Next step:

    I putted the report.jrxml file under pentaho-solutions/bi-developers. (The report works in a easy way by creating a crosstab.)

    I created an report.xaction file that is

    Code:
    <?xml version="1.0" encoding="UTF-8"?>
    <action-sequence> 
      <title>report</title>
      <version>1</version>
      <logging-level>ERROR</logging-level>
      <documentation> 
        <author>Cilea</author>  
        <description>Jasper</description>  
        <help/>  
        <result-type>report</result-type>  
        <icon/> 
      </documentation>
      <inputs/>
      <outputs/>
      <resources> 
        <report-definition> 
          <file> 
            <location>/var/biserver45/pentaho-solutions/bi-developers/report.jrxml</location>  
            <mime-type>text/plain</mime-type> 
          </file> 
        </report-definition> 
      </resources>
      <actions> 
        <action-definition> 
          <component-name>JasperReportsComponent</component-name>
          <action-type>Jasper</action-type>
          <action-resources> 
            <report-definition type="resource"/> 
          </action-resources>
          <action-outputs> 
            <report-output type="html" mapping="report"/> 
          </action-outputs>
          <component-definition> 
            <output-type><![CDATA[html]]></output-type>  
            <driver><![CDATA[org.postgresql.Driver]]></driver>  
            <connection><![CDATA[jdbc:postgresql://esx-dixi.cilea.it:5432/unimidwh]]></connection>  
            <user-id><![CDATA[test]]></user-id>  
            <password><![CDATA[test]]></password> 
          </component-definition> 
        </action-definition>
      </actions> 
    </action-sequence>
    So the kind of exception after about more than 20 tests and modifies is always this:

    Code:
    The Pentaho BI Platform reported an error while running an action sequence    Possible Causes:
    RuntimeContext.ERROR_0035 - Action validation failed. 
       Action Sequence:report.xaction
       Execution Stack:
    EXECUTING ACTION: Jasper (JasperReportsComponent) 
       Loop Index (1-based):N/A
       Error Time:venerdì 15 giugno 2012 9.23.13 CEST
       Error Type:ActionValidationException
       Session ID:joe
       Instance Id:f7f646b7-b6ba-11e1-9dab-e3c62aa76a9a
       Action Class:JasperReportsComponent
       Action Description:Jasper
        
            Hide Details 
      Stack Trace:
    org.pentaho.platform.api.engine.ActionValidationException: RuntimeContext.ERROR_0035 - Action validation failed. 	at org.pentaho.platform.engine.services.runtime.RuntimeContext.validateComponents(RuntimeContext.java:576) 	at org.pentaho.platform.engine.services.runtime.RuntimeContext.validateSequence(RuntimeContext.java:508) 	at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:397) 	at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:317) 	at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:193) 	at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159) 	at org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:167) 	at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:316) 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) 	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:102) 	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:293) 	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) 	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) 	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) 	at java.lang.Thread.run(Thread.java:662)


    SO How Can I try to find the mistake if it answers always in the same mode?!

  2. #2
    Join Date
    Jul 2011
    Posts
    22

    Default

    If it's not a bug Why If I place the samples that works on jboss in biserver 4.5 that's run on tomcat it retrieves that exception while in jboss works?!
    I putted the corrected library jasperreports*.jar in the lib folder of tomcat and also in the lib folder of pentaho.
    You can download the samples from here and unzip it with 7-zip http://www.rpmfind.net/linux/rpm2htm...y=pentaho-demo

  3. #3
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    You probably have a classpath conflict somewhere. JBoss is well known and hated for NOT isolating web-applications from JBoss' own use of open-source libraries. Therefore, if JBoss decides to use one of the apache-commons libraries (as an example, the actual library may be different), and you use the same library in a newer version (or incompatible lower version), then the JBoss version wins, and your web-app no longer works.

    All you can do is: Increase the log level on the server to see all errors, run the XAction, look at the *real* stacktrace and then try to fix the library conflict. Rinse and repeat until it works or until you hit a permanent roadblock.

    We stopped using JBoss as default deployment for that reason (and for the reason that it is slow, and really not needed if you never intend to run EJBs of any kind).
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  4. #4
    Join Date
    Jul 2011
    Posts
    22

    Default

    However I'm just using the version that I can download easily with the samples that uses the hsqldb so it's a problem of the version stable that I download about the conflicts on the library!!!!
    I simply added the sample of a version to another without changing library I added new library for jasperreport*.jar in lib of the tomcat. But I can also remove it and the problem is the same!
    How Can I Increase the log level?

    I usually see the stacktrace in catalina.out when I run the application.

    My nick in ##pentaho is AndromedaK

    Thank for your help
    Last edited by Kettle; 06-18-2012 at 09:19 AM.

  5. #5
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    So what does the stacktrace say? If you see a ClassNotFoundException or a NoClassDefFoundError, then check from what JAR that class is coming from and resolve that problem.

    Also: If you are really using jasperreports 0.4.6, or are you using jasperreports 4.6.0? In any case, in addition to potential problems with JBoss and its classpath, make sure that also the libraries used by JasperReports do not conflict with libraries used by the Pentaho platform. Again, there is no easy solution, and the jasperreports support inside the Pentaho platform has been stagnant for some time.

    I think we still rely on JasperReports 2.0.1 or so in the main codeline.

    There is a jasper-reports plugin available in the saiku project ci-server at
    http://ci.analytical-labs.com/view/P...orting-plugin/

    that may or may not work better than any sort of manual upgrade.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  6. #6
    Join Date
    Jul 2011
    Posts
    22

    Default

    I see only an ActionValidationException

    Code:
    org.pentaho.platform.api.engine.ActionValidationException: RuntimeContext.ERROR_0035 - Action validation failed.     at org.pentaho.platform.engine.services.runtime.RuntimeContext.validateComponents(RuntimeContext.java:576)     at org.pentaho.platform.engine.services.runtime.RuntimeContext.validateSequence(RuntimeContext.java:508)     at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:397)     at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:317)     at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:193)     at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159)     at org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:167)     at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:316)     at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)     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:102)     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:293)     at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)     at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)     at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776)     at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)     at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)     at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)     at java.lang.Thread.run(Thread.java:662)
    I was using 4.6.0 sorry me for the mistake.
    However I did a step behind by downloading the version that contains the sample that works in jboss.
    So I believed that the jboss samples of the jasper report should work in tomcat in the clean environment that I download from source-forge.

    In conclusion it doesn't work as jasper 4.6.0 with the jrxml that I created as in the sample installation that I retrieved from that rpm file.

    That plugin that you linked to me how do I have to install it? I'm trying to work with it and with his sample on the default bi-server installation.

    I just putted the folder of plugin under system-> jasperplugin-> files

    I putted all the jar that are into lib directory of tomcat and I also tried to put files:jasper-plugin.properties, pentaho-jasper.xsd, plugin.xml, settings.xml
    under system directory.

    Isn't a small guide to it or not? Is it a replace of the plugin that I found in the default bi-server-ce-4.5.0 stable?

    Thanks a lot
    Last edited by Kettle; 06-19-2012 at 04:54 AM.

Tags for this Thread

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.