Your browser was unable to load all of the resources. They may have been blocked by your firewall, proxy or browser configuration.
Press Ctrl+F5 or Ctrl+Shift+R to have your browser try again.

daust / JasperReportsIntegration

JasperReportsIntegration provides an interface to use the JasperReports reporting engine in an Oracle database application, specifically with Oracle Application Express (Oracle APEX).

Report output is blank #32

Balamurugan Metisinfo ·
#1

Dear Daust,

I am running into a challenge with JRI.
My environment is OCI - Oracle Linux 7.9 / tomcat 9.0.29 / jri-2.7.1-jasper-6.16.0.
Installation/deployment went fine.
Issue 1: It was erroring as the tomcat was not started in headless mode. On changing it to headless mode..
the test report shows a PDF output is a new tab.
But now the PDF is blank and I could not see any error in the log even after enabling the debug.

Can anyone help me here?

Regards,
Bala

  • replies 6
  • views 1.9K
  • likes 0
Balamurugan Metisinfo · Author
#2

The report preview in the studio exported the PDF correctly.

Attached is the Log generated during the test of the report.

2022-01-12 16:32:54,389 [INFO]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:156): service() start
2022-01-12 16:32:54,389 [DEBUG]-[webapp.AppConfig] de.oc.integration.jasper.webapp.AppConfig.isIpAddressAllowed(AppConfig.java:505): check ip address: xx.xx.xx.xx
2022-01-12 16:32:54,389 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:85): read variables from url call interface
2022-01-12 16:32:54,389 [INFO]-[servlet.ServletUtilities] de.oc.servlet.ServletUtilities.logRequestParameters(ServletUtilities.java:35): logRequestParameters() - start
2022-01-12 16:32:54,389 [INFO]-[servlet.ServletUtilities] de.oc.servlet.ServletUtilities.logRequestParameters(ServletUtilities.java:45): _repName: TJD_Blank
2022-01-12 16:32:54,389 [INFO]-[servlet.ServletUtilities] de.oc.servlet.ServletUtilities.logRequestParameters(ServletUtilities.java:45): _repFormat: pdf
2022-01-12 16:32:54,389 [INFO]-[servlet.ServletUtilities] de.oc.servlet.ServletUtilities.logRequestParameters(ServletUtilities.java:47): logRequestParameters() - end
2022-01-12 16:32:54,389 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:138): URL parameters including defaults:
2022-01-12 16:32:54,389 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:139): dataSource=default
2022-01-12 16:32:54,389 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:140): repName=TJD_Blank
2022-01-12 16:32:54,389 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:141): repFormat=pdf
2022-01-12 16:32:54,389 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:142): repLocale=de_DE
2022-01-12 16:32:54,389 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:143): repEncoding=UTF-8
2022-01-12 16:32:54,389 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:144): repTimeZone=GMT
2022-01-12 16:32:54,389 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:145): outFilename=null
2022-01-12 16:32:54,389 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:147): printUsePrinter=false
2022-01-12 16:32:54,389 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:148): printPrinterName=null
2022-01-12 16:32:54,389 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:149): printPrinterTray=null
2022-01-12 16:32:54,389 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:150): printCopies=1
2022-01-12 16:32:54,389 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:151): printDuplex=false
2022-01-12 16:32:54,389 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:152): printCollate=false
2022-01-12 16:32:54,389 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:153): printJobName=null
2022-01-12 16:32:54,389 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:155): saveIsEnabled=false
2022-01-12 16:32:54,390 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:156): saveFileName=null
2022-01-12 16:32:54,390 [DEBUG]-[webapp.URLCallInterface] de.oc.integration.jasper.webapp.URLCallInterface. (URLCallInterface.java:171): input values asserted
2022-01-12 16:32:54,390 [INFO]-[servlet.ServletUtilities] de.oc.jasper.ReportUtilities.compileJRXMLIfNecessary(ReportUtilities.java:110): compiling file /u01/app/JRI/reports/TJD_Blank.jrxml on the fly
2022-01-12 16:32:54,496 [INFO]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:190): report definition file found for report:TJD_Blank
2022-01-12 16:32:54,496 [DEBUG]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:192): reportFileDir: /u01/app/JRI/reports
2022-01-12 16:32:54,496 [DEBUG]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:204): set parameter baseDir:/u01/app/JRI/reports
2022-01-12 16:32:54,496 [DEBUG]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:207): set parameter SUBREPORT_DIR:/u01/app/JRI/reports/
2022-01-12 16:32:54,496 [DEBUG]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:213): set parameter REPORT_LOCALE:de_DE
2022-01-12 16:32:54,496 [DEBUG]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:222): set report timezone:GMT
2022-01-12 16:32:54,496 [DEBUG]-[db.ConnectionUtility] de.oc.db.ConnectionUtility.getConnection(ConnectionUtility.java:120): use JDBC to lookup dataSource:default
2022-01-12 16:32:54,496 [DEBUG]-[db.ConnectionUtility] de.oc.db.ConnectionUtility.getConnection(ConnectionUtility.java:151): initial pool size: 5
2022-01-12 16:32:54,496 [DEBUG]-[db.ConnectionUtility] de.oc.db.ConnectionUtility.getConnection(ConnectionUtility.java:152): min pool size: 5
2022-01-12 16:32:54,497 [DEBUG]-[db.ConnectionUtility] de.oc.db.ConnectionUtility.getConnection(ConnectionUtility.java:153): max pool size: 50
2022-01-12 16:32:54,497 [INFO]-[db.ConnectionUtility] de.oc.db.ConnectionUtility.getConnection(ConnectionUtility.java:155): successfully connected to jdbc:oracle:thin:@//xx.xx.xx.xx:1521/xxxxx with user: xxxx
2022-01-12 16:32:54,497 [INFO]-[db.ConnectionUtility] de.oc.db.ConnectionUtility.getConnection(ConnectionUtility.java:164): dataSource loaded:default
2022-01-12 16:32:54,497 [INFO]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:250): fill report
2022-01-12 16:32:54,499 [INFO]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:256): net.sf.jasperreports.jdbc.fetch.size=0
2022-01-12 16:32:54,499 [DEBUG]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:339): set contentType=application/pdf
2022-01-12 16:32:54,499 [INFO]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:360): export report
2022-01-12 16:32:54,501 [INFO]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:453): service() end

Dietmar Aust daust · Team
#3

Don't see any issue.

Please

  • post the url that is generated (without the hostname for security)
  • run the test.jrxml which is included in the distribution
  • post a screenshot of the output
  • post the logfile from rendering the test.jrxml

Thankx

Balamurugan Metisinfo · Author
#4

Dear Dietmar,

I have been testing the deployment with a old jrxml file and for some reason it is not giving the output.
As suggested by you, i tested with the test report given along with the distribution and it is working fine.
jri.png
The report output in pdf came out as expected. So i guess it is working fine.

I installed the lasted jasper studio 6.18.1 and created a simple report and the PDF came out good.
I will close this as not an issue. Thanks for helping.

Regards,
Bala

Dietmar Aust daust · Team
#5

Wonderful, glad it works now.

Keep in mind, when you deploy files (source .jrxml and compiled .jasper file) the timestamps will be checked. If the .jrxml is newer than the .jasper file OR the .jasper files does not exist, the .jrxml will be used and the .jasper file will be compiled on the fly.

Ideally, both versions should match for compatibility, the embedded jasper libraries in my integration and the libraries as part of JasperStudio. If your JasperStudio is newer and you run into issues (because the newer compiled .jasper file cannot be run by the integration), you might get lucky using the .jrxml file only and have it compiled on the fly.

Best of luck
~Dietmar.

Balamurugan Metisinfo · Author
#6

Dear Dietmar,

Thanks for your reply. I happen to see the below errors on running my old report .jrxml file. Can you let me know if there are ways to fix this?

2022-01-17 16:46:19,087 [ERROR]-[extensions.DefaultExtensionsRegistry] net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:213): Error instantiating extensions registry for chart.theme from jar:file:/u01/app/tomcat/apache-tomcat-9.0.29/webapps/jri/WEB-INF/lib/jasperreports-chart-themes-6.16.0.jar!/jasperreports_extension.properties
org.springframework.beans.factory.parsing.BeanDefinitionParsingException: Configuration problem: Failed to import bean definitions from relative location [chartConstantsBean.xml]
Offending resource: URL [jar:file:/u01/app/tomcat/apache-tomcat-9.0.29/webapps/jri/WEB-INF/lib/jasperreports-chart-themes-6.16.0.jar!/net/sf/jasperreports/chartthemes/spring/beans/chartThemesBeans.xml]; nested exception is org.springframework.beans.factory.parsing.BeanDefinitionParsingException: Configuration problem: Failed to import bean definitions from relative location [chartConstantsBean.xml]
Offending resource: URL [jar:file:/u01/app/tomcat/apache-tomcat-9.0.29/webapps/jri/WEB-INF/lib/jasperreports-chart-themes-6.16.0.jar!/net/sf/jasperreports/chartthemes/spring/beans/chartConstantsBean.xml]; nested exception is org.springframework.beans.factory.BeanDefinitionStoreException: Detected cyclic loading of URL [jar:file:/u01/app/tomcat/apache-tomcat-9.0.29/webapps/jri/WEB-INF/lib/jasperreports-chart-themes-6.16.0.jar!/net/sf/jasperreports/chartthemes/spring/beans/chartConstantsBean.xml] - check your import definitions!
at org.springframework.beans.factory.parsing.FailFastProblemReporter.error(FailFastProblemReporter.java:72)
at org.springframework.beans.factory.parsing.ReaderContext.error(ReaderContext.java:119)
at org.springframework.beans.factory.parsing.ReaderContext.error(ReaderContext.java:104)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.importBeanDefinitionResource(DefaultBeanDefinitionDocumentReader.java:266)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.parseDefaultElement(DefaultBeanDefinitionDocumentReader.java:191)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.parseBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:176)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.doRegisterBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:149)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.registerBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:96)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.registerBeanDefinitions(XmlBeanDefinitionReader.java:513)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:393)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:336)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:304)
at net.sf.jasperreports.extensions.SpringExtensionsRegistryFactory.getBeanFactory(SpringExtensionsRegistryFactory.java:111)
at net.sf.jasperreports.extensions.SpringExtensionsRegistryFactory.createRegistry(SpringExtensionsRegistryFactory.java:76)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.instantiateRegistry(DefaultExtensionsRegistry.java:299)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:274)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:194)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getRegistries(DefaultExtensionsRegistry.java:157)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getExtensions(DefaultExtensionsRegistry.java:129)
at net.sf.jasperreports.engine.DefaultJasperReportsContext.getExtensions(DefaultJasperReportsContext.java:277)
at net.sf.jasperreports.engine.component.ComponentsEnvironment.findBundles(ComponentsEnvironment.java:111)
at net.sf.jasperreports.engine.component.ComponentsEnvironment.getCachedBundles(ComponentsEnvironment.java:101)
at net.sf.jasperreports.engine.component.ComponentsEnvironment.getBundles(ComponentsEnvironment.java:89)
at net.sf.jasperreports.engine.xml.JRReportSaxParserFactory.getSchemaLocations(JRReportSaxParserFactory.java:103)
at net.sf.jasperreports.engine.xml.BaseSaxParserFactory.configureParser(BaseSaxParserFactory.java:163)
at net.sf.jasperreports.engine.xml.BaseSaxParserFactory.createParser(BaseSaxParserFactory.java:118)
at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createParser(JRXmlDigesterFactory.java:1601)
at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createDigester(JRXmlDigesterFactory.java:1570)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:264)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:220)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:195)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:186)
at net.sf.jasperreports.engine.JasperCompileManager.compileToFile(JasperCompileManager.java:254)
at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:555)
at de.oc.jasper.ReportUtilities.compileJRXMLIfNecessary(ReportUtilities.java:112)
at de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:367)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:860)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1591)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.springframework.beans.factory.parsing.BeanDefinitionParsingException: Configuration problem: Failed to import bean definitions from relative location [chartConstantsBean.xml]
Offending resource: URL [jar:file:/u01/app/tomcat/apache-tomcat-9.0.29/webapps/jri/WEB-INF/lib/jasperreports-chart-themes-6.16.0.jar!/net/sf/jasperreports/chartthemes/spring/beans/chartConstantsBean.xml]; nested exception is org.springframework.beans.factory.BeanDefinitionStoreException: Detected cyclic loading of URL [jar:file:/u01/app/tomcat/apache-tomcat-9.0.29/webapps/jri/WEB-INF/lib/jasperreports-chart-themes-6.16.0.jar!/net/sf/jasperreports/chartthemes/spring/beans/chartConstantsBean.xml] - check your import definitions!
at org.springframework.beans.factory.parsing.FailFastProblemReporter.error(FailFastProblemReporter.java:72)
at org.springframework.beans.factory.parsing.ReaderContext.error(ReaderContext.java:119)
at org.springframework.beans.factory.parsing.ReaderContext.error(ReaderContext.java:104)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.importBeanDefinitionResource(DefaultBeanDefinitionDocumentReader.java:266)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.parseDefaultElement(DefaultBeanDefinitionDocumentReader.java:191)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.parseBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:176)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.doRegisterBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:149)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.registerBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:96)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.registerBeanDefinitions(XmlBeanDefinitionReader.java:513)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:393)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:336)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:304)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.importBeanDefinitionResource(DefaultBeanDefinitionDocumentReader.java:250)
... 55 more
Caused by: org.springframework.beans.factory.BeanDefinitionStoreException: Detected cyclic loading of URL [jar:file:/u01/app/tomcat/apache-tomcat-9.0.29/webapps/jri/WEB-INF/lib/jasperreports-chart-themes-6.16.0.jar!/net/sf/jasperreports/chartthemes/spring/beans/chartConstantsBean.xml] - check your import definitions!
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:326)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:304)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.importBeanDefinitionResource(DefaultBeanDefinitionDocumentReader.java:250)
... 64 more
2022-01-17 16:46:19,087 [ERROR]-[extensions.DefaultExtensionsRegistry] net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:213): Error instantiating extensions registry for chart.theme from jar:file:/u01/app/tomcat/apache-tomcat-9.0.29/webapps/jri/WEB-INF/lib/jasperreports-chart-themes-6.16.0.jar!/jasperreports_extension.properties
org.springframework.beans.factory.parsing.BeanDefinitionParsingException: Configuration problem: Failed to import bean definitions from relative location [chartConstantsBean.xml]
Offending resource: URL [jar:file:/u01/app/tomcat/apache-tomcat-9.0.29/webapps/jri/WEB-INF/lib/jasperreports-chart-themes-6.16.0.jar!/net/sf/jasperreports/chartthemes/spring/beans/chartThemesBeans.xml]; nested exception is org.springframework.beans.factory.parsing.BeanDefinitionParsingException: Configuration problem: Failed to import bean definitions from relative location [chartConstantsBean.xml]
Offending resource: URL [jar:file:/u01/app/tomcat/apache-tomcat-9.0.29/webapps/jri/WEB-INF/lib/jasperreports-chart-themes-6.16.0.jar!/net/sf/jasperreports/chartthemes/spring/beans/chartConstantsBean.xml]; nested exception is org.springframework.beans.factory.BeanDefinitionStoreException: Detected cyclic loading of URL [jar:file:/u01/app/tomcat/apache-tomcat-9.0.29/webapps/jri/WEB-INF/lib/jasperreports-chart-themes-6.16.0.jar!/net/sf/jasperreports/chartthemes/spring/beans/chartConstantsBean.xml] - check your import definitions!
at org.springframework.beans.factory.parsing.FailFastProblemReporter.error(FailFastProblemReporter.java:72)
at org.springframework.beans.factory.parsing.ReaderContext.error(ReaderContext.java:119)
at org.springframework.beans.factory.parsing.ReaderContext.error(ReaderContext.java:104)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.importBeanDefinitionResource(DefaultBeanDefinitionDocumentReader.java:266)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.parseDefaultElement(DefaultBeanDefinitionDocumentReader.java:191)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.parseBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:176)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.doRegisterBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:149)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.registerBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:96)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.registerBeanDefinitions(XmlBeanDefinitionReader.java:513)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:393)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:336)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:304)
at net.sf.jasperreports.extensions.SpringExtensionsRegistryFactory.getBeanFactory(SpringExtensionsRegistryFactory.java:111)
at net.sf.jasperreports.extensions.SpringExtensionsRegistryFactory.createRegistry(SpringExtensionsRegistryFactory.java:76)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.instantiateRegistry(DefaultExtensionsRegistry.java:299)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:274)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:194)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getRegistries(DefaultExtensionsRegistry.java:157)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getExtensions(DefaultExtensionsRegistry.java:129)
at net.sf.jasperreports.engine.DefaultJasperReportsContext.getExtensions(DefaultJasperReportsContext.java:277)
at net.sf.jasperreports.engine.component.ComponentsEnvironment.findBundles(ComponentsEnvironment.java:111)
at net.sf.jasperreports.engine.component.ComponentsEnvironment.getCachedBundles(ComponentsEnvironment.java:101)
at net.sf.jasperreports.engine.component.ComponentsEnvironment.getBundles(ComponentsEnvironment.java:89)
at net.sf.jasperreports.engine.xml.JRReportSaxParserFactory.getSchemaLocations(JRReportSaxParserFactory.java:103)
at net.sf.jasperreports.engine.xml.BaseSaxParserFactory.configureParser(BaseSaxParserFactory.java:163)
at net.sf.jasperreports.engine.xml.BaseSaxParserFactory.createParser(BaseSaxParserFactory.java:118)
at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createParser(JRXmlDigesterFactory.java:1601)
at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createDigester(JRXmlDigesterFactory.java:1570)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:264)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:220)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:195)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:186)
at net.sf.jasperreports.engine.JasperCompileManager.compileToFile(JasperCompileManager.java:254)
at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:555)
at de.oc.jasper.ReportUtilities.compileJRXMLIfNecessary(ReportUtilities.java:112)
at de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:367)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:860)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1591)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.springframework.beans.factory.parsing.BeanDefinitionParsingException: Configuration problem: Failed to import bean definitions from relative location [chartConstantsBean.xml]
Offending resource: URL [jar:file:/u01/app/tomcat/apache-tomcat-9.0.29/webapps/jri/WEB-INF/lib/jasperreports-chart-themes-6.16.0.jar!/net/sf/jasperreports/chartthemes/spring/beans/chartConstantsBean.xml]; nested exception is org.springframework.beans.factory.BeanDefinitionStoreException: Detected cyclic loading of URL [jar:file:/u01/app/tomcat/apache-tomcat-9.0.29/webapps/jri/WEB-INF/lib/jasperreports-chart-themes-6.16.0.jar!/net/sf/jasperreports/chartthemes/spring/beans/chartConstantsBean.xml] - check your import definitions!
at org.springframework.beans.factory.parsing.FailFastProblemReporter.error(FailFastProblemReporter.java:72)
at org.springframework.beans.factory.parsing.ReaderContext.error(ReaderContext.java:119)
at org.springframework.beans.factory.parsing.ReaderContext.error(ReaderContext.java:104)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.importBeanDefinitionResource(DefaultBeanDefinitionDocumentReader.java:266)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.parseDefaultElement(DefaultBeanDefinitionDocumentReader.java:191)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.parseBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:176)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.doRegisterBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:149)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.registerBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:96)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.registerBeanDefinitions(XmlBeanDefinitionReader.java:513)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:393)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:336)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:304)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.importBeanDefinitionResource(DefaultBeanDefinitionDocumentReader.java:250)
... 55 more
Caused by: org.springframework.beans.factory.BeanDefinitionStoreException: Detected cyclic loading of URL [jar:file:/u01/app/tomcat/apache-tomcat-9.0.29/webapps/jri/WEB-INF/lib/jasperreports-chart-themes-6.16.0.jar!/net/sf/jasperreports/chartthemes/spring/beans/chartConstantsBean.xml] - check your import definitions!
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:326)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:304)
at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.importBeanDefinitionResource(DefaultBeanDefinitionDocumentReader.java:250)
... 64 more
2022-01-17 16:46:19,523 [WARN]-[xml.JRTextFieldFactory] net.sf.jasperreports.engine.xml.JRTextFieldFactory.createObject(JRTextFieldFactory.java:66): The 'isStretchWithOverflow' attribute is deprecated. Use the 'textAdjust' attribute instead.
2022-01-17 16:46:19,523 [WARN]-[xml.JRTextFieldFactory] net.sf.jasperreports.engine.xml.JRTextFieldFactory.createObject(JRTextFieldFactory.java:66): The 'isStretchWithOverflow' attribute is deprecated. Use the 'textAdjust' attribute instead.
2022-01-17 16:46:19,526 [WARN]-[xml.JRTextFieldFactory] net.sf.jasperreports.engine.xml.JRTextFieldFactory.createObject(JRTextFieldFactory.java:66): The 'isStretchWithOverflow' attribute is deprecated. Use the 'textAdjust' attribute instead.
2022-01-17 16:46:19,526 [WARN]-[xml.JRTextFieldFactory] net.sf.jasperreports.engine.xml.JRTextFieldFactory.createObject(JRTextFieldFactory.java:66): The 'isStretchWithOverflow' attribute is deprecated. Use the 'textAdjust' attribute instead.
2022-01-17 16:46:19,585 [WARN]-[xml.JRTextFieldFactory] net.sf.jasperreports.engine.xml.JRTextFieldFactory.createObject(JRTextFieldFactory.java:66): The 'isStretchWithOverflow' attribute is deprecated. Use the 'textAdjust' attribute instead.
2022-01-17 16:46:19,585 [WARN]-[xml.JRTextFieldFactory] net.sf.jasperreports.engine.xml.JRTextFieldFactory.createObject(JRTextFieldFactory.java:66): The 'isStretchWithOverflow' attribute is deprecated. Use the 'textAdjust' attribute instead.
2022-01-17 16:46:20,116 [INFO]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:190): report definition file found for report:Service_Ack
2022-01-17 16:46:20,116 [DEBUG]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:192): reportFileDir: /u01/app/JRI/reports
2022-01-17 16:46:20,117 [DEBUG]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:204): set parameter baseDir:/u01/app/JRI/reports
2022-01-17 16:46:20,117 [DEBUG]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:207): set parameter SUBREPORT_DIR:/u01/app/JRI/reports/
2022-01-17 16:46:20,117 [DEBUG]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:213): set parameter REPORT_LOCALE:de_DE
2022-01-17 16:46:20,117 [DEBUG]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:222): set report timezone:GMT
2022-01-17 16:46:20,120 [DEBUG]-[db.ConnectionUtility] de.oc.db.ConnectionUtility.getConnection(ConnectionUtility.java:120): use JDBC to lookup dataSource:default
2022-01-17 16:46:22,564 [DEBUG]-[db.ConnectionUtility] de.oc.db.ConnectionUtility.getConnection(ConnectionUtility.java:151): initial pool size: 5
2022-01-17 16:46:22,564 [DEBUG]-[db.ConnectionUtility] de.oc.db.ConnectionUtility.getConnection(ConnectionUtility.java:152): min pool size: 5
2022-01-17 16:46:22,564 [DEBUG]-[db.ConnectionUtility] de.oc.db.ConnectionUtility.getConnection(ConnectionUtility.java:153): max pool size: 50
2022-01-17 16:46:22,564 [INFO]-[db.ConnectionUtility] de.oc.db.ConnectionUtility.getConnection(ConnectionUtility.java:155): successfully connected to jdbc:oracle:thin:@//xx.xx.xx.xx:1521/xxxx.oraclevcn.com with user: xxxxx
2022-01-17 16:46:22,564 [INFO]-[db.ConnectionUtility] de.oc.db.ConnectionUtility.getConnection(ConnectionUtility.java:164): dataSource loaded:default
2022-01-17 16:46:22,564 [INFO]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:250): fill report
2022-01-17 16:46:23,024 [INFO]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:256): net.sf.jasperreports.jdbc.fetch.size=0
2022-01-17 16:46:23,041 [DEBUG]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:339): set contentType=application/pdf
2022-01-17 16:46:23,042 [INFO]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:360): export report
2022-01-17 16:46:23,137 [INFO]-[webapp.ReportWrapper] de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:453): service() end

Thanks in Advance,
Bala

Dietmar Aust daust · Team
#7

Hi Bala,

JRI tries to recompile the .jrxml file into .jasper and hits a compilation problem:

Offending resource: URL [jar:file:/u01/app/tomcat/apache-tomcat-9.0.29/webapps/jri/WEB-INF/lib/jasperreports-chart-themes-6.16.0.jar!/net/sf/jasperreports/chartthemes/spring/beans/chartConstantsBean.xml]; 
nested exception is org.springframework.beans.factory.BeanDefinitionStoreException: Detected cyclic loading of URL [jar:file:/u01/app/tomcat/apache-tomcat-9.0.29/webapps/jri/WEB-INF/lib/jasperreports-chart-themes-
6.16.0.jar!/net/sf/jasperreports/chartthemes/spring/beans/chartConstantsBean.xml] - check your import definitions!

Please

  • compile the report using JasperSoftStudio and deploy the .jasper file so that a recompile on-the-fly is not required.
  • upload the .jrxml file and I will check where the issue with the libraries might be.

Thank you
~Dietmar.