BUG: INSERT INTO sims.education_programs_offerings fails in PROD
- Dominant language
- TypeScript
- Stars
- 29
- Forks
- 15
- PR merge metrics
- No merged PRs in 30d
Description
**Describe the Bug**
Query failed in sims-api-prod
Timestamp: 2026-08-07T21:19:35.812055099Z
`
query failed: INSERT INTO "sims"."education_programs_offerings"("created_at", "updated_at", "offering_name", "study_start_date", "study_end_date", "actual_tuition_costs", "program_related_costs", "mandatory_fees", "exceptional_expenses", "offering_delivered", "lacks_study_breaks", "offering_type", "offering_intensity", "year_of_study", "is_aviation_offering", "aviation_credential_type", "has_offering_wil_component", "offering_wil_type", "study_breaks", "offering_declaration", "assessed_date", "submitted_date", "offering_status", "course_load", "online_instruction_mode", "is_online_duration_same_always", "total_online_duration", "minimum_online_duration", "maximum_online_duration", "creator", "modifier", "program_id", "location_id", "assessed_by", "submitted_by", "offering_note", "parent_offering_id", "preceding_offering_id") VALUES (DEFAULT, DEFAULT, $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, DEFAULT, DEFAULT, $19, DEFAULT, $20, $21, $22, DEFAULT, DEFAULT, $23, DEFAULT...
error: error: invalid input syntax for type smallint: "86.11"
[Nest] 18 - 08/07/2026, 9:19:35 PM ERROR [AppAllExceptionsFilter] Unhandled exception, request path: /api/institutions/education-program-offering/location/9/education-program/1167
`
**Expected Behaviour**
Query should not fail and Input should be validated correctly
**Actual Behaviour**
Query fails - unsure of user impact
**Steps To Reproduce**
Steps to reproduce the behaviour:
Not sure. Noticed this error in database and sims-api pod logs.
**Technical details**
- [ ] Investigate possible smallint columns on DB that would be receiving a decimal and causing the exception provided above.
- [ ] Possible assumption is around the "Course load" that is defined as int2(smallint) in the table.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start at the /api/institutions/education-program-offering/location/9/education-program/1167 request and inspect the education_programs_offerings table, especially smallint columns and the Course load field. Trace which input produces the decimal value "86.11", then verify that input validation and the INSERT no longer fail for valid values.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, typescript
- Domain
- api, database
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Active
- Clarity
- Needs clarification
- Newbie friendliness
- 45/100