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.
8.Output – map output document.
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)
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
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
