Annual Error Log Purge

This project addressed performance and storage issues in a legacy JD Edwards ERP system by automating the deletion of error log data older than five years. The solution maintains necessary audit data while enhancing system efficiency through scheduled cleanup jobs.

Problem

Statement

The client relies on JD Edwards ERP, a legacy system used for over 20 years. One application’s error log files have grown substantially over time, increasing record counts and impacting system storage and performance. Despite these issues, business users require continued access to error log data.

Solution

Proposed

  • Developed an automated process to delete error log data older than five years at the end of each year.
  • Scheduled this cleanup job within the Robot Job Scheduler to run automatically every year at 8 AM.
  • Ensured no need to retain purged data since these are only error logs.

Business

Values

01

Significantly reduces storage usage, improving overall system performance.

02

Retains error log data for the last five years to support audit and compliance needs.

03

Automates maintenance, reducing manual intervention and potential errors.