...
| Ticket ID | AMM-1402 |
| Severity | Low / Medium / High / Critical Critical |
| Category | Bug / Outage / Performance / Data Issue / Other Performance |
| Affected Module / Feature | 104\ECD |
...
2. Issue Description
Clearly summarize the issue reported in the ticketIn 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)
...
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)
...