1. Ticket Details

2. Issue Description

In Assam production not able to perform any operations. Unable to close the calls(both inbound and outbound). CPU utilization also more than 70-80%.When executing ecd monthly reports creating more cpu utilization&performance issues.

3. Root Cause Analysis (RCA)

Use one or more of the following techniques for RCA:

• 5 Whys

• Fishbone (Ishikawa) Diagram

• Fault Tree Analysis

• Log/Trace review

• Primary Root Cause Identified:Huge dataset extracted from production server and mysql sleep connections also not closing properly

• Why it happened: Extraxted ecd monthly reports containing more than 1 lakh records

• Why wasn't it caught earlier? Bulk report data extraction testing not happened in Dev&Preprod environments

4. Corrective Actions (Fixes for this instance)

Immediate actions to resolve the issue and restore service.

5. Preventive Actions (To prevent recurrence)

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

6. Verification of Effectiveness

Describe how you'll verify that the corrective and preventive actions have worked (e.g., logs, metrics, test cases, recurrence check).

7. Lessons Learned

Summarize learnings and recommendations to share with team or org-wide.

8. CAPA Review & Closure