How To Create and Use Jasper Report , Jasper Issue

Hello,
I’m total new on this environment.
I’m using

Bonita soft 6.3 Community version.
I’m using external database Oracle 10G
I want to generate report for oracle for that I try to use jasper report as follow but it through error
Pl provides what I mistaken?

** Procedure: **

Oracle table structure ZZ_TEST
Column: ID, FIRST, LAST, AGE

1.I want to list all data into report .using I report I create jrxml file.
2.Create three tasks as per documentation and do as follow connector configuration.
3.On pool define to document: input – Jrxml file and output – to store pdf report.
4.Connector > add > Create report > execute after task.
5.Input all db config.
6.Input jrxml – map to input doc.
7.Input parameter – blank because I use just select * from query.
Input_screen
8.Output – map output document.
Out_screen
9.I run process but it put into fail state : show following engine log

Log :

INFO: Creating a new Jasper Report from database
Jun 12, 2014 3:00:24 PM org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
WARNING: THREAD_ID=107 | HOSTNAME=CRP-027 | TENANT_ID=1 | The work [ProcessInstanceContextWork: processInstanceId = 3] failed. The failure will be handled.
Jun 12, 2014 3:00:24 PM org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
WARNING: THREAD_ID=107 | HOSTNAME=CRP-027 | TENANT_ID=1 | org.bonitasoft.engine.core.connector.exception.SConnectorException : “PROCESS_DEFINITION_ID=5532830963579574202 | PROCESS_NAME=hhhh | PROCESS_VERSION=1.0 | PROCESS_INSTANCE_ID=3 | ROOT_PROCESS_INSTANCE_ID=3 | FLOW_NODE_DEFINITION_ID=-4964180250993706074 | FLOW_NODE_INSTANCE_ID=12 | FLOW_NODE_NAME=jassper | CONNECTOR_DEFINITION_IMPLEMENTATION_CLASS_NAME=f | CONNECTOR_INSTANCE_ID=4 | org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: java.lang.NoClassDefFoundError: net/sf/jasperreports/engine/JasperCompileManager”

Hello

it seem the different jasper Library are not deploy in the tomcat (message is java.lang.NoClassDefFoundError: net/sf/jasperreports/engine/)

you need to add the following files in tomcathome/lib forlder:
1.commons-beanutils-x.x.x.jar

2.commons-collections-x.x.x.jar

3.commons-digester-x.x.jar

4.commons-logging-x.x.jar

5.groovy-all-x.x.x.jar(if the report language is deafult Groovy)

6.iText-x.x.x.jar(For PDF Exports)

Could you please send me how to run bonitasoft community with oracle???

Please a solution to this issue?
Thank you

Thank you for your reply. I actually use:

commons-beanutils-1.9.2.jar
commons-collections4-4.0.jar
commons-digester3-3.2.jar
commons-logging-1.2.jar
groovy-all-2.4.3.jar
itextpdf-5.5.5.jar
jasperreports-5.1.0.jar

‘output – to store pdf report’

Exactly what and how to declare this? And what the functions of MIME type? Anyone?

I had the same issue and after adding this library it works fine.

I add them in the dependencies of my process.

Like it is said above :

you need to add the following files in tomcathome/lib forlder:
1.commons-beanutils-x.x.x.jar

2.commons-collections-x.x.x.jar

3.commons-digester-x.x.jar

4.commons-logging-x.x.jar

5.groovy-all-x.x.x.jar(if the report language is deafult Groovy)

6.iText-x.x.x.jar(For PDF Exports)

  1. You dowload the libraries
  2. You import them in Development/Manage jars
  3. You add them in the dependencies of your process (Configuration)
    http://img4.hostingpics.net/pics/239736librairiesJasper.png

I’ve installed all the *.jar files above, but I keep getting the same error message:

org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: java.lang.NoClassDefFoundError: net/sf/jasperreports/engine/JasperCompileManager"

using Bonita Community 6.4.1. While after installing Bonita Community 6.5 I get:

org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: java.lang.NoClassDefFoundError: org/apache/commons/digester/Digester

I’m running a 64-bit ubuntu 14.04

You don’t say what version of Jasper you are running…could this have something to do with it? Library versions possibly? It looks like a different level of Jasper…

Thank you for your reply. I actuallly use:

commons-beanutils-1.9.2.jar
commons-collections4-4.0.jar
commons-digester3-3.2.jar
commons-logging-1.2.jar
groovy-all-2.4.3.jar
itextpdf-5.5.5.jar
jasperreports-5.1.0.jar

same issue with:

jasperreports-6.0.3.jar
jasperreports-5.6.1.jar

with:

commons-digester-2.1.jar

works for htm reports, both with jasperreports-6.0.3.jar and jasperreports-5.6.1.jar
With itext-5.5.5 generates *.pdf also. Be sure to install entire *.zip archive which contains

itextpdf-5.5.5.jar
itext-pdfa-5.5.5.jar
itext-xtra-5.5.5.jar

jasper report fix

Hi there,

trying to get this to work and think I have versioning problems…

org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: java.lang.NoClassDefFoundError: org/apache/commons/digester/Digester

Can someone give a DEFINITIVE list of jars to be installed for jasper reporting.

can you also where (URL) to get the version of Jasper Studio you used to generate your reports.

Many thanks and best regards