raph

OK thanks to everyone for their various comments. We also implemented the new font resolving capabilities in JR, so hopefully this sort of thing will not crop up again in the future. Raphael

FWIW, I never figured out what was going wrong. Instead we migrated to a different server running SuSE Entreprise Linux (SLES) and everything was back to normal. The issue is with CentOS and it's obviously some missing/different packages, but I'm not experienced enough to know exactly why ... Good luck ! Raphael

Hello, We are using JasperReports 3.7.6 and are experiencing a strange problem when trying to generate reports from our Tomcat 6 production server. The problem appears when we undeploy the web application and upload a new version. If we stop the container and then restart, the problem disappears. If the report relies on any fonts that are in the ressource file, the generation fails. If not, the stacktrace still appears in the log, but the report is generated anyway. See the complete Stacktrace below, with debugging information from JasperReports. Thanks for your help : let me know if I should post this in the tracker ... Best regards, Raphael Neve [/code]Code:2010-11-04 11:59:38,362 DEBUG xml.JRXmlDigesterFactory - Using SAX parser factory class net.sf.jasperreports.engine.xml.JRReportSaxParserFactory2010-11-04 11:59:38,367 DEBUG xml.JRXmlDigesterFactory - Instantiated SAX parser factory of type org.apache.xerces.jaxp.SAXParserFactoryImpl2010-11-04 11:59:38,372 DEBUG tensions.ExtensionsEnvironment - Instantiating extensions registry class net.sf.jasperreports.extensions.DefaultExtensionsRegistry2010-11-04 11:59:38,375 DEBUG ions.DefaultExtensionsRegistry - Loading registries for cache key WebappClassLoader delegate: false repositories: /WEB-INF/classes/----------> Parent Classloader:org.apache.catalina.loader.StandardClassLoader@533553352010-11-04 11:59:38,376 DEBUG util.JRLoader - Found resource jasperreports_extension.properties at jar:file:/srv/tomcat6/webapps/Artemis/WEB-INF/lib/jasperreports-3.7.6.jar!/jasperreports_extension.properties in classloader WebappClassLoader delegate: false repositories: /WEB-INF/classes/----------> Parent Classloader:org.apache.catalina.loader.StandardClassLoader@533553352010-11-04 11:59:38,377 DEBUG util.JRLoader - Found resource jasperreports_extension.properties at jar:file:/srv/tomcat6/webapps/Artemis/WEB-INF/lib/jasperreports-fonts-3.7.6.jar!/jasperreports_extension.properties in classloader WebappClassLoader delegate: false repositories: /WEB-INF/classes/----------> Parent Classloader:org.apache.catalina.loader.StandardClassLoader@533553352010-11-04 11:59:38,377 DEBUG util.JRLoader - Found resource jasperreports_extension.properties at jar:file:/srv/tomcat6/webapps/Artemis/WEB-INF/lib/jasperreports-fonts-artemis.jar!/jasperreports_extension.properties in classloader WebappClassLoader delegate: false repositories: /WEB-INF/classes/----------> Parent Classloader:org.apache.catalina.loader.StandardClassLoader@533553352010-11-04 11:59:38,378 DEBUG ions.DefaultExtensionsRegistry - Loading JasperReports extension properties resource jar:file:/srv/tomcat6/webapps/Artemis/WEB-INF/lib/jasperreports-3.7.6.jar!/jasperreports_extension.properties2010-11-04 11:59:38,380 DEBUG ions.DefaultExtensionsRegistry - Instantiating registry of type net.sf.jasperreports.extensions.DefaultExtensionsRegistryFactory for property net.sf.jasperreports.extension.registry.factory.default2010-11-04 11:59:38,381 DEBUG ions.DefaultExtensionsRegistry - Instantiating extensions registry for default using factory class net.sf.jasperreports.extensions.DefaultExtensionsRegistryFactory2010-11-04 11:59:38,382 DEBUG ions.DefaultExtensionsRegistry - Instantiating registry of type net.sf.jasperreports.governors.GovernorExtensionsRegistryFactory for property net.sf.jasperreports.extension.registry.factory.governor2010-11-04 11:59:38,382 DEBUG ions.DefaultExtensionsRegistry - Instantiating extensions registry for governor using factory class net.sf.jasperreports.governors.GovernorExtensionsRegistryFactory2010-11-04 11:59:38,384 DEBUG ions.DefaultExtensionsRegistry - Instantiating registry of type net.sf.jasperreports.components.ComponentsExtensionsRegistryFactory for property net.sf.jasperreports.extension.registry.factory.components2010-11-04 11:59:38,384 DEBUG ions.DefaultExtensionsRegistry - Instantiating extensions registry for components using factory class net.sf.jasperreports.components.ComponentsExtensionsRegistryFactory2010-11-04 11:59:38,418 DEBUG ions.DefaultExtensionsRegistry - Loading JasperReports extension properties resource jar:file:/srv/tomcat6/webapps/Artemis/WEB-INF/lib/jasperreports-fonts-3.7.6.jar!/jasperreports_extension.properties2010-11-04 11:59:38,418 DEBUG ions.DefaultExtensionsRegistry - Instantiating registry of type net.sf.jasperreports.engine.fonts.SimpleFontExtensionsRegistryFactory for property net.sf.jasperreports.extension.registry.factory.simple.font.families2010-11-04 11:59:38,418 DEBUG ions.DefaultExtensionsRegistry - Instantiating extensions registry for simple.font.families using factory class net.sf.jasperreports.engine.fonts.SimpleFontExtensionsRegistryFactory2010-11-04 11:59:38,520 DEBUG ions.DefaultExtensionsRegistry - Loading JasperReports extension properties resource jar:file:/srv/tomcat6/webapps/Artemis/WEB-INF/lib/jasperreports-fonts-artemis.jar!/jasperreports_extension.properties2010-11-04 11:59:38,520 DEBUG ions.DefaultExtensionsRegistry - Instantiating registry of type net.sf.jasperreports.engine.fonts.SimpleFontExtensionsRegistryFactory for property net.sf.jasperreports.extension.registry.factory.fonts2010-11-04 11:59:38,520 DEBUG ions.DefaultExtensionsRegistry - Instantiating extensions registry for fonts using factory class net.sf.jasperreports.engine.fonts.SimpleFontExtensionsRegistryFactory2010-11-04 11:59:38,523 ERROR ions.DefaultExtensionsRegistry - Error instantiating extensions registry for fontsjava.lang.NullPointerException at java.io.Reader.<init>(Reader.java:72) at java.io.InputStreamReader.<init>(InputStreamReader.java:90) at net.sf.jasperreports.engine.fonts.SimpleFontExtensionHelper.loadFontFamilies(SimpleFontExtensionHelper.java:172) at net.sf.jasperreports.engine.fonts.SimpleFontExtensionHelper.loadFontFamilies(SimpleFontExtensionHelper.java:142) at net.sf.jasperreports.engine.fonts.SimpleFontExtensionsRegistryFactory.createRegistry(SimpleFontExtensionsRegistryFactory.java:63) at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.instantiateRegistry(DefaultExtensionsRegistry.java:238) at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:213) at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:162) at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getRegistries(DefaultExtensionsRegistry.java:132) at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getExtensions(DefaultExtensionsRegistry.java:104) at net.sf.jasperreports.engine.component.ComponentsEnvironment.findComponentBundles(ComponentsEnvironment.java:90) at net.sf.jasperreports.engine.component.ComponentsEnvironment.getCachedComponentBundles(ComponentsEnvironment.java:78) at net.sf.jasperreports.engine.component.ComponentsEnvironment.getComponentBundles(ComponentsEnvironment.java:66) at net.sf.jasperreports.engine.xml.JRReportSaxParserFactory.getSchemaLocations(JRReportSaxParserFactory.java:157) at net.sf.jasperreports.engine.xml.JRReportSaxParserFactory.configureParser(JRReportSaxParserFactory.java:138) at net.sf.jasperreports.engine.xml.JRReportSaxParserFactory.createParser(JRReportSaxParserFactory.java:103) at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createParser(JRXmlDigesterFactory.java:1332) at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createDigester(JRXmlDigesterFactory.java:1307) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:205) at fr.microtec.artemis.reporting.ReportGenerator.getBonLivraison(ReportGenerator.java:123) at fr.microtec.artemis.controller.managers.CommandesManager.creationBonLivraison(CommandesManager.java:2579) at fr.microtec.artemis.controller.servlets.secure.BonsLivr.doProcessRequest2(BonsLivr.java:145) at fr.microtec.artemis.controller.servlets.secure.FilterServlet.doProcessRequest(FilterServlet.java:82) at fr.microtec.artemis.controller.servlets.secure.SecureServlet.verifSessionOuverte(SecureServlet.java:99) at fr.microtec.artemis.controller.servlets.secure.SecureServlet.processRequest(SecureServlet.java:49) at fr.microtec.artemis.controller.servlets.secure.SecureServlet.doGet(SecureServlet.java:143) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.extremecomponents.table.filter.AbstractExportFilter.doFilter(AbstractExportFilter.java:49) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:735)2010-11-04 11:59:38,527 DEBUG xml.JRXmlDigesterFactory - Adding components schema at jar:file:/srv/tomcat6/webapps/Artemis/WEB-INF/lib/jasperreports-3.7.6.jar!/net/sf/jasperreports/components/components.xsd2010-11-04 11:59:38,527 DEBUG xml.JRXmlDigesterFactory - Instantiating grammar pool of type org.apache.xerces.util.XMLGrammarPoolImpl for cache key WebappClassLoader delegate: false repositories: /WEB-INF/classes/----------> Parent Classloader:org.apache.catalina.loader.StandardClassLoader@533553352010-11-04 11:59:40,038 DEBUG fill.JRBaseFiller - Fill 828387680: created for bonlivraison2010-11-04 11:59:40,125 DEBUG fill.JRBaseFiller - Fill 828387680: filling report2010-11-04 11:59:40,130 DEBUG fill.JRFillDataset - Fill 828387680: Creating sql query executer2010-11-04 11:59:40,136 DEBUG query.JRJdbcQueryExecuter - SQL query string: select c.code, PS.NOM, PS.ADR1, PS.ADR2, PS.BP, PS.CP, PS.VILLE, PS.TEL, PS.FAX, PS.EMAIL, PAP.NOM as nom_pays, pc.code_faconnier, pc.lnom as nom_faconnier, pc.lad1, pc.lad2, pc.lcp as cp_faconnier, pc.lville as ville_faconnier, pc.lpays, pc.lemail as email_faconnier, pc.ltel as tel_faconnier, pc.lfax as fax_faconnier, pcc.promod_prodtype, pcc.promod_prodcode, pcc.taillefra, pp.libelle as typelibelle, c.date_cmd, sum(pcc.promod_prodqty) as quant, pcc.numero_cde_etiquette, pcc.famille, pcc.codebarre, ppd.libelle as libprod, ppd.libelle_en as libprod_en, ppd.libelle_es as libprod_es, cl.code_pick, c.commentaires, (select min(code) from livraisons where commande = c.code and annulation = 'Non' and proforma = 'Non') as code_livr_pick, pcc.colisage, (select min(code) from livraisons where commande = c.code and proforma = 'Oui') as pick_proforma, cl.nom as nom_pickfrom COMMANDES Cjoin PRINTSHOPS PS ON PS.CODE = C.PRINTSHOPjoin PROMOD_COMMANDES PC on PC.CODE = C.CODEjoin PROMOD_COMMANDES_CORPS PCC on PCC.PROMOD_COMMANDE = PC.CODEleft outer join PROMOD_PRODUITS PPD on PCC.promod_prodcode like (PPD.CODE)left outer join PROMOD_PRODTYPES PP on PP.code = pcc.promod_prodtypeleft outer join PAYS PAP on PAP.PIMKIE_CODE = PS.PAYSleft outer join CLIENTS CL on CL.CODE = C.CLIENTwhere C.CODE_BL = ?and pcc.visible = 'Oui'group by c.code, PS.NOM, PS.ADR1, PS.ADR2, PS.BP, PS.CP, PS.VILLE, PS.TEL, PS.FAX, PS.EMAIL, PAP.NOM, pc.code_faconnier, pc.lnom, pc.lad1, pc.lad2, pc.lcp, pc.lville, pc.lpays, pc.lemail, pc.ltel, pc.lfax, pcc.promod_prodtype, pcc.promod_prodcode, pcc.taillefra, pp.libelle, c.date_cmd, pcc.numero_cde_etiquette, pcc.famille, pcc.codebarre, ppd.libelle, ppd.libelle_en, cl.code_pick, c.commentaires, pcc.colisage, ppd.libelle_es, cl.nomhaving sum(pcc.promod_prodqty) > 0order by pcc.numero_cde_etiquette, c.code, pcc.promod_prodtype, pcc.taillefra,pcc.promod_prodcode2010-11-04 11:59:40,140 DEBUG query.JRJdbcQueryExecuter - Parameter #1 (code of type java.lang.Integer): 504592010-11-04 11:59:40,238 DEBUG fill.JRBaseFiller - Fill 828387680: adding page 12010-11-04 11:59:40,239 DEBUG fill.JRVerticalFiller - Fill 828387680: page header2010-11-04 11:59:40,274 DEBUG fill.JRVerticalFiller - Fill 828387680: CODE_CMD header2010-11-04 11:59:40,288 DEBUG fill.JRFillDataset - Fill 828387680: closing query executer

Hello there, We have a web application that has been working nicely for several years on a Fedora Linux production server. Inside this application are many reports made with JasperReports 3.5. Recently we upgraded to a new production server running CentOS. The application runs correctly, but there are minor differences in alignment and metrics of the fonts. As a result, some of the text areas truncate the text they contain. More worrying is the Barcode4J component we have in some of the reports. In this component the text of the barcode does not appear at all. Any amount of resizing doesn't seem to make it reappear. I was wondering what the problem could be. I did a "fc-list" on both the old and the new machine, and they had big differences in installed fonts. So I copied over all the fonts from the old server into the /usr/share/fonts directory. Now "fc-list" shows the same list on the new and the old server, but the problem remains the same. The font used is "Helvetica"... nothing very exotic! Any help or pointers would be greatly appreciated. Thanks, Raphael Neve Post Edited by raphneve at 06/10/2010 12:25

Hi there, I was wondering if iReport / Jasperreports had support for making PDF documents containing forms that a person can fill in and then print out ? Thanks for the information, Raphael Neve Post Edited by Raphael Neve at 03/17/09 12:28

Hello all ! I am using JasperReports 1.3.1 and iReport 1.3.1. I am having the following strange problem with a SubReport. I have a main report that lists some information in the detail band. There is a group header/footer and on the footer, I want a little table that makes a summary of the current group (using a subreport). Then the next group gets printed with all the details and then another group footer containing the subreport. The problem I am encountering is that when there is only I group (and therefore the subreport gets printed only ONCE), everything works perfectly. As soon as there are several groups, I get the following error when running the report : Error filling print... Unable to get next record. net.sf.jasperreports.engine.JRException: Unable to get next record. at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:99) at net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:842) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:760) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1078) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:111) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:751) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:660) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:815) at java.lang.Thread.run(Unknown Source) Caused by: org.firebirdsql.jdbc.FBSQLException: The result set is closed at org.firebirdsql.jdbc.FBResultSet.checkCursorMove(FBResultSet.java:217) at org.firebirdsql.jdbc.FBResultSet.next(FBResultSet.java:249) at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:95) ... 11 more Print was not filled. Try using an EmptyDataSource... The database I am using is Firebird. Since it says "The result set is closed", the idea I have is that once the subreport prints the first time, it closes or unhooks the connection which means any subsequent attempts to rerun the subreport fail with the above error message. Has anyone ever had this problem in the past? I have bought the iReport manual, searched the newsgroups and even followed the flash tutorials on building subreports, but I seem to be doing everything right (I'm obviously not though, right?! ;) ) Thanks for your help, Raphael