IVR prompt not found for some of the 'partner_code' names

[Sachinbisht27]

Describe the bug We are receiving error logs on the monitoring dashboard for a few partner code names that these partner code names are not added to the database.

Add diagnosis details On Diagnosis, we found that these partner code names are not added to the database.

Error text payload:

sourceLocation: {
file: "/workspace/api/services/prompt_service.py"
function: "handle_prompt_response"
line: "51"
}
spanId: "4b0464ff5ef3d973"
split: null
textPayload: "IVR prompt not found for name 'partner_code' and response 'kanpur_nagar'"
timestamp: "2024-10-24T10:01:32.729260Z"
trace: "projects/cryptic-gate-211900/traces/b8dd3b318b58a6c06b4557f7e99dee96"
traceSampled: false
}

Expected behavior

• All the partner codes should be added to the database using the correct naming convention.

Screenshots

Additional context NA

Root cause

• No database seeding for the Kanpur_nagar partner code name.

Action items

• [x] Add the partner code name in the IVR_promt table in the database.
• [x] Backfill the user's response in the registration table.

Criticality Medium

Acceptance Criteria

• The user details for all the users should be updated properly.

Documentation Add whatever documentation will be required here.

[Sachinbisht27]

Diagnosis Report

Issue Summary
We noticed error logs in the monitoring dashboard indicating that some partner codes are missing from the database. This causes issues when trying to process IVR (Interactive Voice Response) prompts for these partner codes.

What We Found
After checking, we discovered that these specific partner codes were not added to the database, which led to the system being unable to process the IVR prompts correctly.

Error Details
Here’s the error message we received:

• File: /workspace/api/services/prompt_service.py
• Function: handle_prompt_response
• Error Message:

  IVR prompt not found for name 'partner_code' and response 'kanpur_nagar'

This indicates that the partner code "kanpur_nagar" is not available in the database.

What Should Happen
All partner codes must be pre-loaded into the database with the correct names. This ensures that the system can process user responses and keypresses without any errors.

Root Cause
The partner code "kanpur_nagar" was added to RapidPro but wasn’t added to the database table (IVR_prompt). As a result, when the system compared user responses to the database, it couldn’t find a match.

Impact

• The users' responses are being saved in the database.

• However, the fields that should be updated (mapped to their partner codes) are not being updated because the partner code doesn’t exist in the database.

  Fixes Implemented

  1. Added Missing Partner Code: The partner code "kanpur_nagar" was added to the IVR_prompt table in the database.
  2. Backfilled User Responses: We updated the missing fields for all users who selected this partner code, ensuring their responses are now mapped correctly.