movilba
MOVILBA-51
· child of MOVILBA-39 Calidad de dato en expediente / expediente_baja de vehiculo_historial: el campo no esta tipado (5 poblaciones medidas) Done
Eugenia to resolve AE100DI nonmechanical chassis discrepancy after current-book check
Done high
dmdb04-mba-l-ca
The historical two-chassis comparison in this item was narrowed by the 2026-09-01 verified event: among open-book rows, AE100DI remained a nonmechanical difference (RUTAP 8AB368187LA149594 versus PROD 8AB368187LA148664), and AG045KB was separated as our truncation defect MOVILBA-176. The older description also mentioned AC163PG, but its present status is not established by this sweep; do not count it as an open second Eugenia decision without a fresh comparison. The decision owed by Eugenia is which AE100DI chassis identifier is authoritative, after rechecking the current approved book and installed PROD value. No inferred replacement or manual overwrite is authorized. Original two-case evidence remains in BWI descriptionChanged history.
Sub-tickets — 1/1 done
Activity
-
parent=#2616
-
2026-08-20: DM directo a Elazar sobre las 2 divergencias no-mecanicas RUTAP-vs-prod sigue sin respuesta (enviado ~08-19). Reintentar o escalar si sigue sin respuesta.
-
coder-mba-l-cc / coder
-
db03-mba-l-ca / db
-
Re-medido el 2026-09-01 por coder02-mba-l-cc: fila ABIERTA de cada dominio en 2026-09-01-1440-parque-rutap.xlsx contra v_vehiculos_export de PROD (1600 dominios con fila abierta). Normalizando a alfanumerico quedan 2 diferencias, y solo UNA es pregunta para Eugenia: AE100DI, libro 8AB368187LA149594 vs PROD 8AB368187LA148664 - dos chasis realmente distintos. La otra, AG045KB (libro 8AB368187PA151842, PROD B368187PA1518), es truncamiento NUESTRO: PROD guarda una subcadena, le faltan 2 caracteres al principio y 2 al final. Se separo a MOVILBA-176. Este item queda como 1 caso, no 2.
-
db03-mba-l-cc
-
db02-mba-l-cc
-
db04-mba-l-ca
-
db04-mba-l-ca 2026-09-24 04:03 -03 — SELECT-only current-state check: DEV movilba_dev snapshot 18 and PROD movilba snapshot 5 both identify 2026-09-19-0648-parque-rutap-corrected.xlsx with 5528 source rows. The two nonmechanical chassis divergences were not reconciled with Eugenia's latest answer. Status unchanged; no DB write.
-
db04-mba-l-ca 2026-09-24 04:13 -03 — Eugenia must identify the authoritative chassis number for AE100DI: the 2026-09-01 verified event reports RUTAP 8AB368187LA149594 versus PROD 8AB368187LA148664 after normalizing punctuation, and states only this case remains for her; the old title's second case is not a currently established second decision. Before applying her answer, recheck the pinned current book and installed PROD value. No DB write.
-
Eugenia to resolve AE100DI nonmechanical chassis discrepancy after current-book check
-
was: db-mba-l-cc, censo prod-vs-RUTAP 2026-08-18. AE100DI (RUTAP 8AB368187LA149594 vs prod 8AB368187LA148664) y AC163PG (RUTAP 953258S45HR709471 vs prod 953258S48HR706080) - difieren en varios digitos, no mecanico. No se puede determinar cual fuente tiene el chasis verdadero sin Eugenia.
-
db04-mba-l-ca 2026-09-24 04:13 -03 — Corrected obsolete two-case title/description to match this item's 2026-09-01 verified event, which retained AE100DI as Eugenia's question and split AG045KB to MOVILBA-176. AC163PG current state and current-book/PROD AE100DI comparison were not measured in this step. Block reason names Eugenia's exact authority decision; old text remains in descriptionChanged history.
-
db04-mba-l-ca 2026-09-24 04:28 -03 — New read-only check invalidates the current stakeholder-question premise for AE100DI. In /data-lezama/movilba/libro/2026-09-23-1128-parque-rutap.xlsx Base, AE100DI rows 67,68,1144,1145 all have Chasis_Nro 8AB368187LA149594 (E/K cells). In PROD, PGOPTIONS default_transaction_read_only=on; SELECT current_database(),current_user returned movilba|svc_nextjs; SELECT id,dominio,numero_serie_chasis FROM public.vehiculos WHERE dominio=AE100DI AND borrado_en IS NULL returned 3807|AE100DI|8AB368187LA149594. Old PROD value 8AB368187LA148664 is no longer present for this live vehicle. No unresolved chassis-authority discrepancy established today; did not ask Eugenia or write DB. Await coder03 reconciliation before disposition.
-
cleared: db04-mba-l-ca 2026-09-24 04:13 -03 — Eugenia must identify the authoritative chassis number for AE100DI: the 2026-09-01 verified event reports RUTAP 8AB368187LA149594 versus PROD 8AB368187LA148664 after normalizing punctuation, and states only this case remains for her; the old title's second case is not a currently established second decision. Before applying her answer, recheck the pinned current book and installed PROD value. No DB write.
-
db04-mba-l-ca 2026-09-24 04:43 -03 — Cerrado: la discrepancia AE100DI no se reproduce al 2026-09-24. Libro corregido SHA-pinned 2026-09-19-0648-parque-rutap-corrected.xlsx (SHA-256 6fd1b9dfa5207508bbd5726e1765c9dc5bb37a6930f54170468b05706c5bc42d), hoja Base, cuatro filas AE100DI (67, 68, 1143, 1144), todas 8AB368187LA149594. SELECT-only en DEV movilba_dev y PROD movilba; en ambos, public.vehiculos id 3807 está live con 8AB368187LA149594; rutap.vehiculo_historial_normalizado contiene cuatro períodos AE100DI, todos ese mismo número (tres cerrados y uno abierto), y búsqueda literal exacta de 8AB368187LA148664 dio cero en vehiculos, el historial normalizado completo y vehiculos_datos_colectivos. public.vehiculo_historial no existe en ninguna base; revisé además public.v_vehiculo_historial en PROD por coincidencia literal, sin resultado. No se ejercitó la aplicación/importación ni se evaluaron otros dominios o identificadores; no se hizo ninguna escritura de DB.
bug
2026-08-19 by wi-cli-venus
3w ago
2026-09-24 07:43