How To Create and Use Jasper Report , Jasper Issue

1
0
-1

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 :

  1. INFO: Creating a new Jasper Report from database
  2. Jun 12, 2014 3:00:24 PM org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
  3. WARNING: THREAD_ID=107 | HOSTNAME=CRP-027 | TENANT_ID=1 | The work [ProcessInstanceContextWork: processInstanceId = 3] failed. The failure will be handled.
  4. Jun 12, 2014 3:00:24 PM org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
  5. 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"

Comments

Submitted by luqman.subki on Thu, 09/25/2014 - 09:45

'output – to store pdf report'

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

4 answers

1
+1
-1

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

Comments

Submitted by yannick.lombardi on Thu, 10/09/2014 - 15:51

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

I add them in the dependencies of my process.

1
+1
-1

Hello

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

1
0
-1

Thank you for your reply. I actually use:

  1. commons-beanutils-1.9.2.jar
  2. commons-collections4-4.0.jar
  3. commons-digester3-3.2.jar
  4. commons-logging-1.2.jar
  5. groovy-all-2.4.3.jar
  6. itextpdf-5.5.5.jar
  7. jasperreports-5.1.0.jar

1
0
-1

Please a solution to this issue? Thank you

Comments

Submitted by yannick.lombardi on Fri, 11/21/2014 - 08:40

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) - See more at: http://community.bonitasoft.com/answers/how-create-and-use-jasper-report...

Submitted by yannick.lombardi on Fri, 11/21/2014 - 08:48

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

Submitted by nicdales64 on Sat, 03/28/2015 - 10:35

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

  1. 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:

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

Submitted by Sean McP on Sat, 03/28/2015 - 12:40

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

Submitted by nicdales64 on Sat, 03/28/2015 - 16:59

Thank you for your reply. I actuallly use:

  1. commons-beanutils-1.9.2.jar
  2. commons-collections4-4.0.jar
  3. commons-digester3-3.2.jar
  4. commons-logging-1.2.jar
  5. groovy-all-2.4.3.jar
  6. itextpdf-5.5.5.jar
  7. jasperreports-5.1.0.jar

same issue with:

  1. jasperreports-6.0.3.jar
  2. jasperreports-5.6.1.jar

with:

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

  1. itextpdf-5.5.5.jar
  2. itext-pdfa-5.5.5.jar
  3. itext-xtra-5.5.5.jar

jasper report fix

Submitted by Sean McP on Tue, 07/28/2015 - 12:27

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

Notifications