basquetWi + New ticket

AE631MI: cambio de linea guardado como Modificacion por la app y como Alta por el libro, dos periodos abiertos el mismo dia

Done high dmdb03-mba-l-cc

AE631MI: Leandro's app edit on 15/09 (linea 34->4, interno 45->144) was stored as MODIF (DEV id 220068) because clasificarTramiteEdicion did not exist yet (28873909 landed 17/09). The 0942 book now carries the same event as ALTA (import id 234320), so the dominio has two open periods on the same day and the ficha shows the app MODIF. The rule 'a change of linea/interno/empresa is an ALTA' ships in dev as of v5.5.191. Remaining: decide which period wins when an app period and a book period describe the same event (overlap with MOVILBA-400), and count the population with the db lane.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Activity

  • wi-cli-venus created · 4w ago
    parent=#3883
  • wi-cli-venus progress · 4w ago
    db02 2026-09-17 14:27: 20 dominios have an open app period and an open import period at the same time on DEV (AE631MI included). All 20 are inside MOVILBA-400's population (37 dominios with an open app period and no rutap_snapshot_id), but that population is broader: 17 of the 37 have no concurrently open import period.
  • wi-cli-venus assigned · 3w ago
    coder03-mba-l-ca / coder
  • coder04-mba-l-ca progress · 3w ago
    coder04-mba-l-ca | 2026-09-24 04:01 ART. Measured read-only DB on 2026-09-24: 4 vehiculo_id values in movilba_dev have simultaneous open app and import normalized periods; PROD movilba has 0. Original DEV 20-count has fallen but defect persists. DB reconciliation ownership unassigned; leaving backlog on parked coder03-mba-l-ca.
  • coder04-mba-l-ca progress · 3w ago
    coder04-mba-l-ca | 2026-09-24 04:04 ART. Read-only live query on movilba_dev and movilba: SELECT h.dominio FROM rutap.vehiculo_historial_normalizado h WHERE h.origen IN ('app','import') AND h.fecha_baja IS NULL GROUP BY h.vehiculo_id,h.dominio HAVING count(*) FILTER (WHERE h.origen='app')>0 AND count(*) FILTER (WHERE h.origen='import')>0 ORDER BY h.dominio. DEV returns AC736PL, AD761FY, AE893OO, AI458AR; PROD returns none. All four vehiculos.origen_ingreso=ssot_import; APP rows have creado_por=20425668650 and dates 2026-09-21/23, import rows snapshot 18/system_import dated 2026-09-20. Cannot tell whether the APP edits were disposable DEV tests or intended business changes from those fields. PROD is clean; this finding is DEV-only and makes no PROD-defect claim.
  • coder04-mba-l-ca progress · 3w ago
    coder04-mba-l-ca | 2026-09-24 04:33 ART. Elazar clarified on CLI that DEV app edits are disposable tests. Therefore the four DEV-only APP/import overlaps recorded at 04:04 are test-data artifacts, not evidence of a production business defect. PROD query returned zero overlaps. This supersedes the earlier uncertainty about those APP rows; no PROD remediation follows from this count.
  • coder03-mba-l-cc assigned · 2w ago
    db03-mba-l-cc
  • coder03-mba-l-cc assigned · 2w ago
    db04-mba-l-ca
  • coder03-mba-l-cc assigned · 1w ago
    db03-mba-l-cc / db
  • db03-mba-l-cc completed · 1w ago
    Re-confirmado PROD snapshot vigente (11), db03-mba-l-cc 2026-10-08: 0 vehiculos con periodo app y periodo import abiertos simultaneamente - identico a la medicion 2026-09-24 de coder04. Estructuralmente imposible hoy: PROD no tiene NINGUNA fila origen=app viva (confirmado esta sesion en MOVILBA-237, 5558/5558 filas vivas son origen=import). El caso DEV (AE631MI y los otros 3/4 dominios) es dato de prueba descartable por aclaracion de Elazar (2026-09-24 CLI), no defecto de produccion. La regla linea/interno/empresa=ALTA ya shippeo en dev v5.5.191. Cierra sin escritura - nada que decidir, PROD limpio.
  • audit-mba-l-cc audited · 1w ago
    audit pass: 2 SELECTs PROD
    payload
    {"scope":"2 SELECTs PROD","outcome":"pass","evidence":"0 origen=app live rows in PROD; 0 vehicles with simultaneous open app+import periods - matches claim exactly","reportRef":null}
bug
4w ago by wi-cli-venus
1w ago
2026-10-08 14:28