[iReport never finishes ...]

Hello,

iReport just says 'Generating Report' after 30 minutes I stopped the process,

how can I debug this and how to figure out why this takes so long.

Sometimes this happens when I changes something, and I can revert it back, However this time I asked somebody else to make the report so I have no idea where to look for the solution, if there is any.

 

 

 

[Jasper Reports guru fore hire?]

 hello!

I am making a second version of a report I created in the past.

The first report works fine with a XML datasource.

My second report doesn't work good where I see some sub-reports repeated (but not all parts). Data is good as I see, just empty pages, or blank sub-reports.

I am looking for a Jasper Reports + xpath person that can solve this and explain to me what I am doing wrong. My best estimate would be that he/she can explain this to me in a couple of hours (3-4)

I will supply the XML files and working report, aswell as my new XML files and my new report jrxml files.

Anybody the can give me a hand here?

Please mail me at ries@vantwisk.nl

Ries
quito/Ecuador

 

[Subreport causing empty page]

 I can second this on 3.7.1

what do people do to solve this? I can only assume lot's of people would complain.... Is there already a know run-around?

 

Ries

[XPath and subDataSource expressions]

 hey All,

I am using a subreport to generate additional data for a report.

My subreport generates a graph and calls up additional sub-reports to create additional tables.

Here are my options I tested:

1) ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("//page[@pageno=7 or @pageno=6]")

2) ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("//page[@pageno=7]")

3) ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("//page[@pageno=6]")

4) ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("//page[@pageno=6] | //page[@pageno=7]")

 

5) ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("//page")

 

 

1) Does print my table, but my graph is empty

2) Does print my table, but my graph is empty

3) Does print my graph, but table is empty

4) Does print my table, but my graph is empty

5) Doesn't print graph or table data

 

- The graph xpath expressions have been tested with full and partial XML data, so even when page7 is included, the data get's generated.

- All xpath expressions have been tested in xpanther under firefox, I know not a authority on xpath correctness, but all expressions have been looked up against specifications.

- No errors during report generation.

 

I honestly don't understand why I cannot pass a sub data source consist of my two pages, afterall.. it's just XML, right?

 

How would debug this problem? Usually I would step through code and find the problem, but iReport doesn't seem to have this capability using debuggers, or any way to output more sensible data, can it do that?

 

My main problem now is, how to debug instead of trial and error changing things around?

 

Ladtly, if I cannot figure it out. Anybody know a good company who can? (Against a normal hourly rate....)

 

Ries

 

 

 

 

[Importing large XML]

 hey All,

 

what is the best way to importy large XML files?

 

I need to process XML files in the site of 500MB, but I keep on getting out of memory errors.

Besides, processing XML looks a bit slow aswell (but it's not teh mayor problem).

 

 

Ries

 

[Excel found unreadable content in 'report.xml' ...]

Teodor,

 

well.. luckily there are more people that found the same sort of ghost so the ghost is quite visible however I will try to make a self-contained test case for you to checkout.

 

Ries

[Excel Error in Linux]

Same problem here, try to use JExcelApiExporter and see if that solves your problem.

 

I also tried jasperReports 3.1.4 with POI 3.2 final, but that didn't solve the problem.

 

Ries

[jasper reports 3.1.2 with poi 3.0.1 for Excel]

Same problem here,

 

I started to use JExcelApiExporter instead of using JRXlsExporter, for the same report I have some color problem (rather colors that shift to a different color) but currently my client reports that it works better.

 

BTW: In open office I don't have any problems opening the reports.

 

Ries

 

 

[Excel found unreadable content in 'report.xml' ...]

I found the possible cauze, but I don't understand wyet why.

 

Apparently when I use JExcelApiExporter I don't have the problem so it looks like there is a bug in JRXlsExporter or in the poi library?? is it correct to say that JRXlsExporter uses the POI libs??

 

Can anybody confirm/know something about this?

 

Ries

[Excel found unreadable content in 'report.xml' ...]

 I just updated to 3.1.4 with POI 3.2 with no change in the results.

Question: Is it possible to tell jasperreports the output version of excel??

Ries

[Excel found unreadable content in 'report.xml' ...]

Hey All, I am getting the below error sometimes for my Escel 2003/excel2007 users.

Excel found unreadable content in 'report.xml' Do you wsnt to recover the contents of this workbook?
If you trust the source of this workblook click yes

However open office opens that same document perfectly fine.

Currently I have no idea why this happens, below the core I use to generate a report:

All my data is in UTF-8, but I am sure that that couldn't be a issue.. When the users send me the repaired report, then at line xxx I see some garbaged characters, and that's all... in my own dataset I don't see anything that might cauze an issue (Data comes from PostgreSQL).

 

Hopefully somebody has a clue what's going on.

Ries

Code:

	public String  getJasperReport(List<Map<String, Object>> data, String basename, String reportname, String type) throws Exception {		JasperReport jasperReport;		JasperPrint jasperPrint;		String filename="";		basename = basename + "_" + String.valueOf(ACL.getUserID());		JRListMapDataSource ds = new JRListMapDataSource(data);		// Get path relative to our current deployment to find the temp directory		Map<String, Object> params = new HashMap<String, Object>();				URL U = Thread.currentThread().getContextClassLoader().getResource("../../tmp");			// Load report		InputStream strm = Thread.currentThread().getContextClassLoader().getResourceAsStream("../../jrxml/"+reportname+".jrxml");				jasperReport = JasperCompileManager.compileReport(strm);				jasperPrint=JasperFillManager.fillReport(jasperReport, params, ds);		//		generates PDF		if (type.compareTo("PDF") == 0) {			filename = basename+".pdf";			JasperExportManager.exportReportToPdfFile(jasperPrint, U.getPath() + filename);		}				// generate XLS		if (type.compareTo("XLS") == 0) {			filename = basename+".xls";			JRXlsExporter exporterXLS = new JRXlsExporter();			File destFile = new File(U.getPath() + filename);			exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT, jasperPrint);			exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_FILE_NAME, destFile.toString());			exporterXLS.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE); 			exporterXLS.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE); 			exporterXLS.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); 			exporterXLS.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE); 			exporterXLS.exportReport();		}				return filename;	}	

[More active forum on JasperETL]

 Hey All,

 

would it be better to close this forum and post questions in the general Jasper forums?

Bobody seems to be here anyways

 

Ries

[Please solve the problem of "Numeric Overflow"]

From what I understand you are trying to put some values into a table.

One of this tables cannot old the value you are trying to insert.

Try changing some types in your oracle table to old teh value you are inputting.

 

Ries

[Command line switch to delete files]

 Hey All,

I need command line switch to delete files, or not,

For example I would like to run a job like this:

java -Xms25......... --contect=windows --deletetmpfiles=true

When deletetmpfiles is set to true I want to delete theses file, if set to false I want to keep them.

See my image, I do have a component ok attached to the FileDelete_4?

My idea is to read the switch using using some java and put that into a context,

but I am not 100% sure how I can read that context and execute tFileDelete_4 or not..

Anybody got a good plan of attac for this?

Ries

 

 

[How to solve org.apache.jasper.JasperException: java.lang.NullPointerException ??]

Like what anandharaj was saying, it's mostly resources that are un-available.

It's currently kinda hard to explain to our client what they are seeing is really there fault. They have questions how to get back (back button doesn't always work in that case), and they have questions why it cannot tell us what was wrong.

I can currently think of two solutions:

 

1) Don't run the report in the web context, but seperate so that the exception can be caught and shown within the application rather then the application bailing out completely,

2) Do a pre-flight check on the jrxml to see if everything is available to run the report. If not show a message of what was wrong.

 

So far it seems to be only a case of missing re-sources though.

 

Ries

[Passwords]

Hey, 

The username and passwords for each users are stored in the database in the table : jiuser

Ries

[iReport 3.0.0 to JasperServer 3.0 getting could not load an entit]

hey All,

connecting from Ireport 3.0 to a jasperServer 2.1 worked fine,

but after I upgraded to 3.0 I get the following error :

 java.lang.Exception: 1 - could not load an entity: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource#77

We are running JasperServer on ubuntu under Glassfish and PostgreSQL 8.3

Anybody an idea??

 

Ries

[How to solve org.apache.jasper.JasperException: java.lang.NullPointerException ??]

Anandharaj Subramaniam
Wrote:

Hi, That is basically comes from JAVA, you can tune so that it wont appear on the screen but this is nothing to do with JS. Its fall back to JAVA itself and usually bases on the error message we can identify what is actuall problem.

 

Of course this comes from Java.... However it seems to happen when I make a mistake in a control or datasource or 'something'. However shouldn't JasperServer not catch ALL exceptions and tell me what is wrong rather then ignore the exception and bail out.

Of course I can take a look at the glassfish logfile and see where/why it happens and in what module but honestly it's JasperServer that should give me a good message what is wrong.

Ries

[JasperServer without MySQL]

 @All,

 

Just wanted to mention that compiling from source is easer then trying to convert the MySQL version to PostgreSQL.

That said, the DDL for PostgreSQL is outdated and from it looks is that the DDL for PostgreSQL shipped with JasperServer 3.0 is still at 2.1 version.

However following "Upgrade to 3.0" chapter will do tje Job.

 

Ries

[How to solve org.apache.jasper.JasperException: java.lang.NullPointerException ??]

 All,

Often when I make a slight mistake in a report query or in a input control I always get the below error in JasperServer.

 

How can I tell JasperServer to throw a usable message so i know what is actually wrong in my report rather then trying to guess at it?

 

Ries

 

HTTP Status 500 -

---

type Exception report

message

descriptionThe server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: java.lang.NullPointerException

 

root cause

java.lang.NullPointerException

 

note The full stack traces of the exception and its root causes are available in the Sun Java System Application Server 9.1_01 logs.

---

Sun Java System Application Server 9.1_01

 

 

[JasperServer without MySQL]

@ Sherman and Anandharaj,

In the mean time we got it running my converting the MySQL DDL to PostgreSQL. it's mostly search and replace some varchars and binary types. But for sure I will try the compile from source method and see if I can generate a DDL directly.

This will also allow me to test if it works under OSX leopard which would be nice (currently I run it under Ubuntu in parallels)

All I can say now is great product and we properly will have more fun when we start deploying more complicated reports.

thanks for your time and efforts to help me out!

Ries

 

[JasperServer without MySQL]

 I think I got it working on PostgreSQL,

 

I needed to change some other var chars(2000) to test fields.

If there is anybody who want's to test this, please let me know and will send you a DDL for PostgreSQL

 

Ries

[JasperServer without MySQL]

hey Anandharaj,

 

 

we have been workign on getting JasperServer to work under glassfish and PostgreSQL, however it does work partially and properly because of the the fact that our MySQL converted DDL is incorrect.Do you happen to have a DDL for PostgreSQL to share? 

If not, I will spend some more time to investigate the problems and see what fields types I need to use for PG

 

Ries

[Jasperserver & jasperanalysis on 64- bit version]

 Test reply, does it work?

[Jasperserver & jasperanalysis on 64- bit version]

 Did anybody had luck with JasperServer with the following configuration??

 

OSX Leopard 64 Bit

PostgreSQL 8.3.x

Glassfish latest (As of august 2008)

JasperServer latest

 

I keep on getting errors.

I really don't want to run on Tomcat because I don't want to run two application servers and all our applications are already on Glassfish. This goes teh same for Mysql, we really cannot run MySQL since we don't have the knowledge to trust MySQL with out datasets.

thanks,

Ries van Twisk