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

[Kettle]

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

<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

<?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:

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?!

[Kettle]

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

[Taqua]

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).

[Kettle]

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

[Taqua]

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.

[Kettle]

I see only an ActionValidationException

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