Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-126183

Report in XLS format is not being generated

    Details

      Description

       Description:
      Report in XLS format is not being generated

       Steps to Reproduce:

      1. Go to Site Menu > Configuration > Reports Admin
      2. Add a definition with the jrxml file attached (reports_admin_template_source_sample_class_name.jrxml)
      3. Click on kebab menu > Add Report
      4. Create a report with a XLS format
      5. Go to Reports tab and click on the definition

       Expected Result:
      Report is generated and can be downloaded

       Actual Result:
      Report is never generated and the following exception is thrown:

      Exception in thread "liferay/report_request-4" java.lang.NoClassDefFoundError: org/apache/poi/hssf/util/HSSFColor$WHITE
      	at net.sf.jasperreports.engine.export.JRXlsExporter.<init>(JRXlsExporter.java:188)
      	at net.sf.jasperreports.engine.export.JRXlsExporter.<init>(JRXlsExporter.java:210)
      	at com.liferay.portal.reports.engine.console.jasper.internal.exporter.XlsReportFormatExporter.getJRExporter(XlsReportFormatExporter.java:36)
      	at com.liferay.portal.reports.engine.console.jasper.internal.exporter.BaseReportFormatExporter.format(BaseReportFormatExporter.java:37)
      	at com.liferay.portal.reports.engine.console.jasper.internal.ReportEngineImpl.execute(ReportEngineImpl.java:115)
      	at com.liferay.portal.reports.engine.messaging.ReportRequestMessageListener.doReceive(ReportRequestMessageListener.java:65)
      	at com.liferay.portal.kernel.messaging.BaseMessageListener.doReceive(BaseMessageListener.java:48)
      	at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:34)
      	at com.lifer2021-01-21 01:51:30.830 ERROR [liferay/reports_admin-2][SerialDestination:64] Unable to process message {destinationName=liferay/reports_admin, response=null, responseDestinationName=null, responseId=40918, payload=c[email protected]5c0424c2, values={defaultLocale=en_US, companyId=20100, groupId=0, principalName=20128, [email protected]1782d338, siteDefaultLocale=en_US, themeDisplayLocale=en_US}}
      com.liferay.portal.kernel.messaging.MessageListenerException: java.lang.NullPointerException
      	at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:41)
      	at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:74)
      	at com.liferay.portal.messaging.internal.SerialDestination$1.run(SerialDestination.java:59)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      	at java.lang.Thread.run(Thread.java:748)
      Caused by: java.lang.NullPointerException
      	at com.liferay.portal.reports.engine.ByteArrayReportResultContainer.getResults(ByteArrayReportResultContainer.java:72)
      	at com.liferay.portal.reports.engine.console.internal.messaging.AdminMessageListener.doReceive(AdminMessageListener.java:52)
      	at com.liferay.portal.kernel.messaging.BaseMessageListener.doReceive(BaseMessageListener.java:48)
      	at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:34)
      	... 5 more
      ay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:74)
      	at com.liferay.portal.messaging.internal.ParallelDestination$1.run(ParallelDestination.java:56)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      	at java.lang.Thread.run(Thread.java:748)
      Caused by: java.lang.ClassNotFoundException: org.apache.poi.hssf.util.HSSFColor$WHITE cannot be found by com.liferay.portal.reports.engine.console.jasper_4.0.0
      	at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:508)
      	at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:419)
      	at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:411)
      	at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:151)
      	at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
      	... 13 more
      

       

      Verified on master DXP: 985126786959cb024dc2083697ea461964df7ffc

        Attachments

          Activity

            People

            Assignee:
            rodrigo.cunha Rodrigo Cunha
            Reporter:
            rodrigo.cunha Rodrigo Cunha
            Participants of an Issue:
            Recent user:
            Enterprise Release HU
            Engineering Assignee:
            Rafael Praxedes
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              34 weeks, 5 days ago

                Packages

                Version Package
                7.3.6 CE GA7
                7.3.7 CE GA8
                7.3.X
                7.4.0 CE GA1 DXP 7,4
                Master