Support #11001

[SCP ID :##5414##] : eStatement Cronjob unable to process Monthly statement bulk file

Added by Zahir Abd Latif about 4 years ago. Updated almost 4 years ago.

Status:Work Completed-End life cycleStart date:July 03, 2020
Priority:NormalDue date:
Assignee:Zahir Abd Latif% Done:

90%

Category:-Spent time:-
Target version:-

Description

Hi,
Kindly attend below request:-

eStatement Cronjob unable to process Monthly statement bulk file.
The cronjob will hit Out Of Memory Error: GC overhead Limit exceed when processing large bulk file.

History

#1 Updated by Nurul Athira Abdul Rahim about 4 years ago

  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

#2 Updated by Najmi Pasarudin about 4 years ago

  • Status changed from New - Begin Life Cycle to Development / Work In Progress

#3 Updated by Najmi Pasarudin about 4 years ago

  • % Done changed from 0 to 90

#4 Updated by Najmi Pasarudin about 4 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim

Issue:
eStatement cronjob cannot process IBCS file more than 500MB.

Finding:
eStatement cronjob is storing every mapped account number and details in Java memory before generating eStatement files.

Solution:
Update eStatement cronjob program to generate eStatement files by account number.
This will release Java memory before generating the next eStatement files.

Test scenario:
  1. Testing to be done by JTM
  2. Access Staging batch server at SACDA951
  3. Access /batch/BSN/BatchFilesSIT/eStatement/RawFile/
  4. Place IBCS eStatement file with size more than 500MB
  5. Expected result, after processed, the file should be processed and moved to /batch/BSN/BatchFilesSIT/eStatement/Archive/

Note:
Tested with 800MB file with 10000 account numbers. Took 11 hour to process.

#5 Updated by Nurul Athira Abdul Rahim about 4 years ago

  • Status changed from Internal Testing to System Integration Test

#6 Updated by Nurul Athira Abdul Rahim about 4 years ago

  • Status changed from System Integration Test to Development / Work In Progress
  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

140720 Tested and failed by Azyan. The file keep on processing from date 100720

#7 Updated by Najmi Pasarudin about 4 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim

Please email to Azyan to test again.

#8 Updated by Nurul Athira Abdul Rahim about 4 years ago

  • Status changed from Internal Testing to System Integration Test

#9 Updated by Nurul Athira Abdul Rahim about 4 years ago

  • Status changed from System Integration Test to User Acceptance Test
  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

Tested and passed by azyan

#10 Updated by Najmi Pasarudin about 4 years ago

  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim

Deployed UAT on 21/07/2020

#11 Updated by Najmi Pasarudin about 4 years ago

  • Status changed from User Acceptance Test to Pending Review

Deployed Production on 23/07/2020

#12 Updated by Nurul Athira Abdul Rahim almost 4 years ago

  • Status changed from Pending Review to Work Completed-End life cycle
  • Assignee changed from Nurul Athira Abdul Rahim to Zahir Abd Latif

Also available in: Atom PDF