Story: Hotfix: Windows build and SQL schema validation fail on main
Table of Contents
This page documents a story in Sprint 25. It captures the goal, current status, acceptance criteria, and the tasks that compose it.
1. Goal
Latest main is red on Windows: the MSVC build fails on a warnings-as-errors warning, and the Clang build fails to link ores.ore.api. The SQL schema validator also rejects the ores_ore_ component prefix. Two further defects break the local fleet: the marketdata service reads the ore series key shapes without a grant, and the web service cannot resolve the environment its checkout reports. Restore a green build and a healthy fleet.
2. Status
| Field | Value |
|---|---|
| State | DONE |
| Parent sprint | Sprint 25 |
| Now | Nothing. |
| Waiting on | Nothing. |
| Next | Nothing. |
| Last touched | 2026-09-19 |
3. Acceptance
- The SQL schema validator accepts the
ores_ore_component prefix. - The Windows MSVC and Clang jobs compile and link ores.ore.api.
ores.marketdata.servicereads the ore series key shapes and stays up.ores.web.serviceresolves its declared environment and stays up.
4. Tasks
| Task | State | Start | End | Description |
|---|---|---|---|---|
| Scaffold story: Hotfix: Windows build and SQL schema validation fail on main | DONE | 2026-09-19 | 2026-09-19 | Story scaffolding rides this task: documents, sprint wiring, and the scaffold PR. Close it before merging that PR. |
| Fix the Windows build and the SQL component prefix | DONE | 2026-09-19 | 2026-09-19 | Initial task for: Hotfix: Windows build and SQL schema validation fail on main |
5. Decisions
- The
ores_ore_prefix is registered in the validator rather than renaming the table.projects/ores.oreis a component of the product, so the table name is correct and the registry was incomplete. - The two remaining validator warnings stay out of this hotfix. They
belong to the market series asset class junction, and task
7E064C21-14EA-401C-A73D-35EA1743EED7 in the
complete-market-series-classificationstory already owns them.
6. Out of scope
DROP_001andRLS_001onores_marketdata_market_series_asset_classes_tbl. The junction template ignores therls_tenant_isolationflag, and the table is absent frommarketdata_drop.sql. Task 7E064C21-14EA-401C-A73D-35EA1743EED7 covers both.
7. Result
Five defects on main are fixed on hotfix/main-ci-red, and the branch
carries no other change.
The Windows build is restored: the MSVC warning C4244 no longer stops
the compile, and ores.ore.api.dll now links the libfort symbols its
series key shape table calls. The SQL validator accepts the ores_ore_
component prefix, which removes the NAMING_010 and NAMING_002
warnings.
The local fleet is healthy again. The marketdata service receives the
select grant it needs on the ore tables, so it no longer dies on the
first series classification. The web service resolves the declared
environment its checkout reports, because compass env configure now
writes ORES_WEB_ENV. Every one of the 24 units runs.
The two remaining validator warnings stay red on Linux. They need codegen work on the junction template, and task 7E064C21-14EA-401C-A73D-35EA1743EED7 already owns that work.
Details and evidence are in the implementation task.