1. Ticket Details

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)

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