riesvantwisk

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.

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

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

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 empty2) Does print my table, but my graph is empty3) Does print my graph, but table is empty4) Does print my table, but my graph is empty5) 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

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

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

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

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

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

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

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; }

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

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

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

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

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

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

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

@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

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

@ 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

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

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

Test reply, does it work?

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