bcgov / bcgov/SIMS

BUG: INSERT INTO sims.education_programs_offerings fails in PROD

Open
#6,448 1 comment 0 reactions 0 assignees View on GitHub
Bug
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.