Import gate: CUMMINS 6 CIL motor text needs exact CUMMINS catalog alias

Sub-tickets

Activity

• db04-mba-l-ca created · 1w ago
  parent=#3027
• db04-mba-l-ca progress · 1w ago
  2026-10-06 read-only PROD then DEV: both projectors prosrc md5 70f70566f2cf7437146b5ef7b7a0a014, manufacturer CUMMINS id24 live, no live CUMMINS 6 CIL catalog row. MOVILBA-496 retired that model-description-as-manufacturer row. Exact alias DDL draft /data-lezama/movilba/migration-evidence/2026-10-06-movilba-722-cummins-6-cil-alias-DRAFT.sql SHA256 c53685afd4f0383b0e83ab5784a79cb456d255cc670e3d527a285cce0f25b101. PROD+DEV ROLLBACK rehearsals PASS: old join 0, new join 1, owner/ACL unchanged, installed definition exact replacement; post-rollback md5 unchanged both. No apply yet, audit requested.
• audit-mba-l-cc audited · 1w ago
  audit pass: Draft read in full (SHA c53685af verified), preconditions checked independently against DEV+PROD
  payload

  {"scope":"Draft read in full (SHA c53685af verified), preconditions checked independently against DEV+PROD","outcome":"pass","evidence":"fabricantes id=24='CUMMINS' live, no 'CUMMINS 6 CIL' catalog row (496 precedent holds). proyectar_snapshot prosrc md5=70f70566 matches on both bases. Book 2026-10-06-1140-parque-rutap.xlsx row 5560/AH992CY motor='CUMMINS 6 CIL' confirmed via direct read. Exact-string CASE, no suffix stripping; raw_motor untouched; owner/ACL check present. Not yet applied.","reportRef":null}

• db04-mba-l-ca progress · 1w ago
  2026-10-06 after audit PASS event 19:45:18Z: applied audited SQL SHA256 c53685af... with COMMIT to PROD movilba first, then DEV movilba_dev. Independent post-commit reads: both pg_proc.prosrc md5 90b37746290abbdf138f692f13cc1737, exact CUMMINS 6 CIL anchor count 1; PROD owner movilba_owner, DEV owner movilba_user, ACL unchanged NULL. Repository SQL copy byte-identical to applied artifact; docs/migrations/README.md row prepared. No SSOT import or data-row update by this change. Await post-apply docs audit, then SHIP.
• audit-mba-l-cc audited · 1w ago
  audit pass: Post-apply: repo migration file + README.md row
  payload

  {"scope":"Post-apply: repo migration file + README.md row","outcome":"pass","evidence":"sha256sum confirms repo file byte-identical to audited draft (c53685af). Live rutap.proyectar_snapshot prosrc md5=90b37746 on both PROD and DEV, matching README's claim. README wording (PROD-first, scope, raw_motor preserved, import pending with db03) verified accurate. SHIP cleared.","reportRef":null}

• db04-mba-l-ca progress · 1w ago
  Post-apply audit PASS event 2026-10-06T19:47:42.985Z covers byte-identical SQL repo copy and README row. Sent exact two-path SHIP to coder03 (hub tag db04-mba-l-ca-mux3cqiqfrv0); released both file locks. DDL live PROD+DEV, routine 1140 snapshot rehearsal with db03. Close only after repo artifact is shipped under project DoD.
• db04-mba-l-ca completed · 1w ago
  2026-10-06 DoD verified: exact CUMMINS 6 CIL alias applied PROD then DEV after audit PASS; installed projector prosrc md5 90b37746290abbdf138f692f13cc1737 in both. SQL+README committed in v5.6.178 (ancestor of current v5.6.179 PROD); DEV and pod health serviceId 25297=v5.6.178, PROD serviceId 25434=v5.6.179. The 2026-10-06-1140 book then committed as PROD snapshot 11 and DEV snapshot 21, each md5 eb2e2683ccdd16a33be4a34b7b56088b and 5558 raw+normalized rows. No further alias work.