Support #12326
[SCP ID :##5977##] : ISS report issue
Status: | Work Completed-End life cycle | Start date: | September 10, 2021 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | RIB | Spent 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