1. Ticket Details
| Field | Description |
|---|---|
| Ticket ID | AMM-1378 |
| Severity | High |
| Category | Bug |
| Affected Module / Feature |
2. Issue Description
After upgradation changes deployed in 104 Assam production call report details changes are not inserting through scheduler. We are getting error like t_detailcallreport table does not exist.
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: Unique identifier is missing in the entity class
Why it happened: Due to missing of unique identification of primary Id
Why wasn't it caught earlier? Due to upgradation and unable to analyze this data in test server due to improper data
4. Corrective Actions (Fixes for this instance)
| Action | Owner | Target Date | Status |
|---|---|---|---|
| Added GenerationType as IDENTITY in entity class | Ravi | Apr-23-2025 | Completed |
Immediate actions to resolve the issue and restore service.
5. Preventive Actions (To prevent recurrence)
| Action | Owner | Target Date | Status |
|---|---|---|---|
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
| Reviewed By | Date | Remarks |
|---|---|---|