Support #12326

[SCP ID :##5977##] : ISS report issue

Added by Zahir Abd Latif about 3 years ago. Updated about 3 years ago.

Status:Work Completed-End life cycleStart date:September 10, 2021
Priority:NormalDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:RIBSpent time:-
Target version:-

Description

Hi,
Kindly attend below request:-

FYI, ISS report for august 2021 was not successfully generated. I try generate manually and getting error out of memory as below.

Please help to check and do related changes or improvement to fix this issue. Kindly take note that number of transaction keep increase every month and expected same issue will happen again.

D:\batch_program\ISS_Batch>D:\Java\jdk1.8.0_151\bin\java -jar agro-iss-batch-manual.jar ###############################################
Manual Generate ISS Batch Files.
Important!! The program will pickup previous months records based on input report date.
Please enter report date (dd/MM/yyyy):
01/09/2021
[10/09/2021] [02:13:13:729] [INFO] [GenerateISSBatchFile]:59 - Start generate ISS report files. (Wed Sep 01 00:00:00 SGT 2021)
[10/09/2021] [02:13:13:744] [INFO] [GenerateISSBatchFile]:70 - AppConfig Path: D:/batch_program/ISS_Batch/AppConfig.properties
[10/09/2021] [02:13:13:744] [INFO] [GenerateISSBatchFile]:78 - Ready Generate Report: [NONTRNX]
[10/09/2021] [02:13:13:744] [INFO] [GenerateISSBatchFile]:96 - #######################################################
[10/09/2021] [02:13:13:744] [INFO] [GenerateISSBatchFile]:97 - Generate ISS Non Transaction Report
[10/09/2021] [02:14:05:576] [INFO] [GenerateISSBatchFile]:101 - No of Records: 3243437
[10/09/2021] [02:14:05:591] [INFO] [GenerateISSBatchFile]:106 - Report File Name: D:/REPORTS/ISS_Report/20210901NonTransaction.csv
[10/09/2021] [02:14:05:591] [INFO] [GenerateISSBatchFile]:122 - Start export report
Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoader.java:58)
Caused by: java.lang.OutOfMemoryError: GC overhead limit exceeded
at net.sf.jasperreports.engine.export.JRGridLayout.layoutGrid(JRGridLayout.java:308)
at net.sf.jasperreports.engine.export.JRGridLayout.<init>(JRGridLayout.java:140)
at net.sf.jasperreports.engine.export.JRCsvExporter.exportPage(JRCsvExporter.java:53)
at net.sf.jasperreports.engine.export.JRAbstractCsvExporter.exportReportToWriter(JRAbstractCsvExporter.java:241)
at net.sf.jasperreports.engine.export.JRAbstractCsvExporter.exportReport(JRAbstractCsvExporter.java:188)
at net.penril.iss.batch.GenerateISSBatchFile.GenerateFiles(GenerateISSBatchFile.java:135)
at net.penril.iss.batch.GenerateISSBatchManual.main(GenerateISSBatchManual.java:27)
... 5 more

D:\batch_program\ISS_Batch>pause
Press any key to continue . . .

History

#1 Updated by Stephanie Sufrapto about 3 years ago

  • Status changed from New - Begin Life Cycle to Work Completed-End life cycle
  • Assignee changed from Siti Balqis Othman to Zahir Abd Latif
  • % Done changed from 0 to 100

We suspect issue is caused by JRXML use to export the excel.
Solution:We change the to using file to padding csv which is lighter to use

Patch provided at 10//09/2021
Patch deployed to production at 12/09/2021

Also available in: Atom PDF