Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


1. Ticket Details

FieldDescription
Ticket IDAMM-1352
SeverityCritical
CategoryBug
Affected Module / FeatureMMU

...

2. Issue Description

 Unable to do Data Sync.  In  In the Production_APL offline MMU - while syncing the data, getting some error related to websphere application/environment, data sync is failing. While attempting to sync, an error is encountered related to the WebSphere application: "Unexpected end of file from server". As a result, some tables/fields are not getting synced successfully.

...

3. Root Cause Analysis (RCA)

...

  • Primary Root Cause Identified: The data sync failed because large data batches exhausted server resources and the loop did not exit cleanly.  

  • Why it happened: The sync logic didn’t handle big data and connection limits properly, causing the server to close the request unexpectedly.

  • Why wasn't it caught earlier? No large-volume load testing was done, and the error messages didn’t show the real issue.

...

4. Corrective Actions (Fixes for this instance)

Optimize batch size and implement proper exit conditions to handle large data safelyIncrease server connection timeout and tune DB pool settings
Action
OwnerTarget DateStatus
Vanitha2025-07-23Completed
Vanitha2025-07-23Completed



Immediate actions to resolve the issue and restore service.

...

5. Preventive Actions (To prevent recurrence)

ActionOwnerTarget DateStatus
Review and optimize sync logic in each release cycleVanitha

Schedule data sync to run frequently in smaller batches to prevent large payload failures.Vanitha

Systemic changes, monitoring, alerting, process updates, or automation.

...

Implement batch processing for large data to avoid timeouts and failures.

Increase connection timeouts and server request handling capacity for heavy operations.

Schedule data syncs more frequently to reduce payload size and risk of failures.

...

8. CAPA Review & Closure

Reviewed ByDateRemarks



...