PPF402 Estado Actual shows stale expediente and conflicting tramite

MOVILBA-833 movilba Done high

PPF402 Baja and Alta saved as Modificacion in vehicle history

MOVILBA-832 movilba Done high

Eugenia and Eduardo Marca Motor access differs from reported permissions

MOVILBA-834 movilba In progress

EPIC: ASI-compliant MovilBA release handoff and production readiness

MOVILBA-821 movilba Backlog

└─ Make ASI Git delivery support a formal versioned release

MOVILBA-823 movilba In progress

└─ Package ASI database schema, migrations, initial data and recovery procedure

MOVILBA-822 movilba In progress

└─ Confirm ASI release requirements and approval path

MOVILBA-826 movilba In progress

└─ Write release-specific ASI README, UPGRADE and functional CHANGELOG

MOVILBA-828 movilba In progress

└─ Run formal ASI QA to HML to production release and capture acceptance

MOVILBA-825 movilba Backlog

└─ Document and verify OpenShift configuration, secrets and health probes

MOVILBA-824 movilba Backlog

└─ Deliver architecture, operations and user documentation through ASI channels

MOVILBA-830 movilba Backlog

└─ Collect ASI CI, test, security and QA assessment evidence

MOVILBA-827 movilba Backlog

└─ Resolve ASI homologation of the actual MovilBA runtime stack

MOVILBA-829 movilba Backlog

└─ Verify ASI application integrations by environment

MOVILBA-831 movilba Backlog

AA165MF modification reportedly leaves prior period open and shows two ALTA records

MOVILBA-803 movilba Done high

Trámites will enter pending altas and bajas when MovilBA use begins

MOVILBA-804 movilba Done

Pre-launch operational-log retention decision and safeguards

MOVILBA-799 movilba Backlog

└─ Define login-attempt retention without weakening rate limiting or evidence

MOVILBA-802 movilba Blocked

└─ Plan selective app_logs info retention without erasing audit events

MOVILBA-801 movilba Blocked

└─ Decide whether pre-launch log retention is needed

MOVILBA-800 movilba Todo

Daily Alta rejected when domain is absent from imported RUTAP snapshot

MOVILBA-796 movilba Done high

Bus Alta: make ID CANBUS optional and store 0 when blank

MOVILBA-798 movilba In progress high

Converge manual chassis catalog IDs across PROD and DEV

MOVILBA-797 movilba In progress

Para Elazar fila 32: criterios ADAS y MDVR

MOVILBA-657 movilba Done ↳ MOVILBA-652

Import 2026-10-13 RUTAP snapshot with unresolved chassis mappings

MOVILBA-794 movilba Done

└─ Confirm Mercedes chassis designation for AB139OT

MOVILBA-795 movilba Done

PMH980 historical period reportedly missing from general vehicle search/history

MOVILBA-792 movilba Done

dev01 colectivo creation failure, request 1a17c253-b32e-496b-8f7e-517fee578a8a

MOVILBA-793 movilba Done

Complete sede visibility and delegated evaluator attribution in practice exports

VENUS-489 venus Done

Terra needs a request-needs-info email mechanism (no equivalent exists); use it for Matias/ceda0a10

TERRA-296 terra Backlog

SMTP_REPLY_TO unset: no accessIssue operator notification has ever sent compliantly; 4 terra reports failed terminally 2026-10-01

TERRA-260 terra Done high

4 untracked Terra access reports, 10 days open, noProfile - check registry before assuming absent

TERRA-295 terra In progress high

get_practica_detail_bundle: fixed per-call planning of vPracticaHistorial puts the tail on the 10s cap, cancelling /mi-cursada under mild stalls

MARS-752 mars Done

└─ vPracticaHistorial planning-cost fix for get_practica_detail_bundle, split from MARS-752

MARS-809 mars Backlog

d1cb337d: duplicate práctica 87729, asistente Tabatha Ivanovich

PLUTO-786 pluto Done

SOP-MARS-72: support ticket at /practicas/nueva

MARS-805 mars Done

└─ SOP-MARS-73: ticket at /practicas/nueva

MARS-807 mars Done

└─ findDuplicateConducto gap: pre-check passes, insert still 23505s on uq_practicaToothConductos_tooth_label

MARS-808 mars Done high

└─ SOP-MARS-72 follow-up: pull Vercel runtime logs for 2026-10-09T20:30:01.5Z and 20:46:27.6Z, practica/create

MARS-806 mars Done high

The identity resolver's exact-legajo arm can never match a self-service access request against a bulk-imported user: the form stores bare 377/21, the roster stores OD-0377/21

MARS-797 mars Done high

Resolve db-mars-cc registry ownership after approved retirement

MARS-740 mars Done high

SCANNER_PROBE_RE gap: vendor appliance path /access/api/v1/system/ping pages on mars and pluto, 3 hits from 3 IPs

MARS-790 mars Blocked low

Image-proxy read path does not retry a 20s TTFB abort, so the student gets a 500 even though a fresh connection would likely be served

MARS-792 mars In progress low

bedel can write: updateImageRotation reachable by any read-only-all bedel via canViewPractica

MARS-747 mars Blocked low

Review-depth pilot: measure audit token burn and shallow-sample quality

MARS-802 mars Blocked low

No surface can add conductos to an existing practica, so a tipo change into endo costs the student their practica

MARS-785 mars Blocked low

Post-commit student notification is fire-and-forget: a transient INSERT timeout loses the in-app notice permanently, and its only redundancy is a sibling best-effort email

MARS-793 mars Backlog low

resolutionNote goes to the reporter verbatim as the email body, with nothing warning the author or screening internals

MARS-779 mars Blocked

administrar-actions.ts: "use server" file exports roster getters with no in-function gate (getDocenteMemberships, getAlumnoAssignments, getAlumnoAssignmentsForPeriodos, getComisionesWithCounts, getPeriodoDetail...)

MARS-748 mars Blocked

Endodoncia I comision LETTER CONFLICT (SOP-MARS-58): Mars follows the client 209-x-es-y mapping 6/6 and the catedra attendance sheet uses the other letter - client decision, not a data repair

MARS-728 mars Blocked

Review-depth pilot close: reconciliation is unverifiable by construction - Elazar decides keep classifier / drop pilot

MARS-705 mars Blocked

Nota/concepto-final grading column — spec needed from Elazar before build

MARS-444 mars Blocked

Cross-app nav-link normalization: one criteria for sidebar/navbar links per role in mars+pluto+venus

EVO-51 evolutiva Blocked

support-admin: no way to close an access request that duplicates an account the person already uses - access-reject emails a false denial

MARS-776 mars Blocked high

EPIC: move app email drains off Supabase pg_cron to venus systemd timers, keep an authenticated relay for transport

EVO-93 evolutiva Blocked high

/practicas list query hit the 10s statement_timeout twice for a real user: CTEs aggregate all practicas' teeth and images per call

MARS-736 mars Blocked high

Safeguard forced práctica unlock with student save grace period and teacher confirmation

MARS-738 mars Blocked high

EVO-12 mars leg: server-side 404/error capture replacing the client-only rail (filed because the leg lived only in an event body for 82 days)

MARS-724 mars Blocked high ↳ EVO-12

SOP support-api: stakeholder-pair-only private comments (CRUD + notify shipped)

MARS-467 mars Blocked high ↳ EVO-52

Support API: restrict internal-note visibility to Elazar plus ticket stakeholder

MARS-732 mars Blocked high

Disk used-vs-provisioned alarm: unreachable from SQL, and autoscale reports configured while inert below LARGE compute

MARS-711 mars Blocked high

WATCH: post-MARS-799 connection phase evidence

MARS-787 mars Backlog low

EVO-123: convert 11 UPDATE OF invariant guards to AFTER/no-column-list

MARS-801 mars Backlog

Queryable not-xray image view: count + % of uploaded práctica images flagged as NOT a real radiografía. Elazar 2026-06-26: he has not seen one real x-ray — ~99% are photos of a monitor screen, not actual radiographs. The image-analysis path already produces a flag (a 3-letter code/word per Elazar) that marks an image as not-an-xray. Build a DB view (db + coder) over the existing image-analysis data (likely imageUploadAnalysisEvents) that reports total images vs flagged-not-xray count and percentage, queryable any time (overall + optionally by periodo/comisión/recent-window). FIRST identify the actual flag field + its not-xray value. Read/analysis surface only, no enforcement/blocking. Build deferred — tracking only.

MARS-200 mars Blocked

statement_timeout errors spreading beyond MARS-736 scope: /practicas/[id] POST actions, /comisiones/[id], /alumnos

MARS-743 mars Blocked high

pg_net EXECUTE to PUBLIC: measure whether this ref grants net.http_post to every login role

MARS-712 mars Blocked high

Scoped new reader grants for TERRA-267/278 measurements

TERRA-285 terra Done high

Terra production pool connects as the postgres TABLE OWNER - no GRANT or trigger containment is enforceable in that schema until a non-owner app role exists (twin of PLUTO-670)

TERRA-281 terra In progress high

pg_net EXECUTE to PUBLIC: measure whether this ref grants net.http_post to every login role

PLUTO-736 pluto Blocked high

SOP-MARS-65: which email should Camila Mamani Cardozo use (blocks SOL-MARS-59)

MARS-760 mars Backlog ↳ MARS-746

SOP-MARS-58 follow-up: awaiting Romina Seron on D - Endo 1 libreta-digital login confirmation

MARS-745 mars Done low

SOP-MARS-69: Lucila Pirovani asks to delete practica a5070113

MARS-764 mars Done

Evaluation delegated-authorship (display docente, record real actor) — needs product ruling

VENUS-482 venus Done high

Docente roster -> assignable evaluation dropdown

VENUS-481 venus Done

Removal candidate: view agents.v_rutap_historial_carroceria_normalizacion_invariante

MOVILBA-757 movilba Done

Filtro Empresa en /vehiculos muestra entidades cesadas sin soft-delete (17 de Agosto inconsistente con otras)

MOVILBA-791 movilba Done

dev01 muestra columnas que PROD oculta, asi que la verificacion de Eugenia no verifica PROD

MOVILBA-462 movilba Done

Para Elazar fila 36: localizar Archivo Intercambio 26-06-2026

MOVILBA-658 movilba Done ↳ MOVILBA-652

dev01: 'Creado por' figura 'Sistema - Importacion' en dominios dados de alta por los agentes; la ultima alta (AI357EG) si muestra el nombre

MOVILBA-665 movilba Done high

Para Elazar fila 27: informar casuísticas de cesión o fusión

MOVILBA-653 movilba Done ↳ MOVILBA-652

Purga de logs fresh-start (app_logs + audit_log)

MOVILBA-9 movilba Done ↳ MOVILBA-1

La clave del resolver 'MT 17.0 V6200' apunta a la fila generica MT 17 y no a MT 17.0 LE, igual que el caso que MOVILBA-710 ya repunto

MOVILBA-759 movilba Blocked

Deferred physical DROP of dead columns on the rutap.vehiculo_historial_normalizado view graph (carroceria_modelo first)

MOVILBA-789 movilba Backlog low

rutap.v_export_estado_actual: vista DEV-only sin callers, no se porta a PROD y se borra de DEV; resuelve catalogos distinto a MOVILBA-469

MOVILBA-473 movilba Done low

Un veredicto sobre DDL marca el apply SIN EJERCITAR porque audit no es dueño de tabla, y svc_nextjs no tiene SELECT sobre dos objetos de rutap en PROD - el carril SI tiene psql de solo lectura en las dos bases

MOVILBA-648 movilba Done

La ficha muestra el expediente de LOTE en vez del per-vehiculo cuando un expediente cubre varios vehiculos

MOVILBA-78 movilba Blocked low

post-receive de dev en /srv: git clean de logs/ y SUDO_PASSWORD en texto plano - los dos necesitan a Elazar

MOVILBA-533 movilba Blocked

Export de vehiculos: falta ejercitar el boton de la UI (sesion NextAuth) y queda pendiente el criterio de collation

MOVILBA-58 movilba Blocked

El truncado a 40 del sufijo de borrado convive con 8 vistas que no truncan, asi que una etiqueta larga tendria dos largos

MOVILBA-744 movilba Blocked low

Wire el gate EX- de 179 al camino de escritura de expte_baja cuando 76 paso 3 lo abra

MOVILBA-228 movilba Done low

21 generateUUID sites in 9 route files still mint a request id outside getRequestId, so one request logs under several ids

MOVILBA-739 movilba Blocked low

Retire unnecessary nested vehicle subtype table in a future refactor

MOVILBA-388 movilba Deferred low

Residuo del aviso de refresh vencido: el gate de v5.5.8 corta ~45x normalizado por trafico, pero el flag no persiste en todos los caminos y todavia salen 6 por minuto para un usuario en DEV (PROD: 1 en 14 dias)

MOVILBA-301 movilba Blocked

dev01: transient 'sesion invalida, reintentar' error clears on retry

MOVILBA-234 movilba Blocked low

Calidad de dato en expediente / expediente_baja de vehiculo_historial: el campo no esta tipado (5 poblaciones medidas)

MOVILBA-39 movilba Done

└─ Cadena de expedientes RUTAP: 152 bajas cuyo expediente no es el alta del tramite siguiente

MOVILBA-38 movilba Blocked low

Tab Mantenimiento en la UI esta permanentemente vacio: 119 MANTENIMIENTO esta catalogado pero nada lo escribe nunca

MOVILBA-77 movilba Canceled low ↳ MOVILBA-534

RUTAP full-history refactor

MOVILBA-125 movilba Backlog high

└─ Estado del vehiculo como estado GUARDADO con periodos propios, editable y con fecha, no como campo derivado

MOVILBA-219 movilba Blocked high

└─ Leer el historial como intervalos de validez y no como altas y bajas: es lo que habilita los reportes que pide Eugenia

MOVILBA-99 movilba Done high

└─ Retirar el jsonb: una sola historia ancha y tipada, con export del libro que hace round-trip

MOVILBA-299 movilba Done urgent

└─ Ficha de vehiculo: desplegable de modificaciones que muestre TODOS los cambios, no solo los que tienen expediente

MOVILBA-71 movilba Done

└─ vehiculo_historial: no hay columna que diga cual es la fila vigente - borrado_en y creado_en estan sobrecargados

MOVILBA-12 movilba Done high

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

MOVILBA-722 movilba Done high

└─ Nada garantiza una sola fila abierta por chasis en el libro RUTAP: los gates usan max() y elegirian un ganador en silencio

MOVILBA-89 movilba Done

EPIC: unificar modificaciones de vehículo y normalizar Entidad → Línea → Vehículo

MOVILBA-167 movilba Backlog high

└─ Cadena entidad-linea-vehiculo: portador de estado actual para linea_id/entidad_id fuera de vehiculo_historial

MOVILBA-166 movilba Blocked high

└─ Resolver a mano las 9 filas de historial ocultas con periodo abierto (4 pares de doble import + AG732SW)

MOVILBA-171 movilba Done low

v_vehiculo_cadena debe ser el unico camino sancionado para leer historial, y publicar 'colectivos fisicos = count(distinct chasis)' aparte del conteo de filas

MOVILBA-68 movilba In progress low

Retire todo-rutap-tracker SQLite mirrors

MOVILBA-790 movilba Done

Ficha de vehiculo: cada Server Action del montaje arrastra un refetch RSC (~19 requests en ~1.6s, acotado)

MOVILBA-309 movilba Blocked low

proyectar_snapshot(): followups de la revision de db03

MOVILBA-340 movilba Backlog

└─ El proyector guarda un NULL de unidad propulsora como blanco y despues el flag lo excluye por ser blanco

MOVILBA-751 movilba Blocked low

└─ rutap.normalizar_si_no no saca el retorno de carro: una celda si/no con chr(13) hace ABORTAR el import via el gate de MOVILBA-494, no se pierde en silencio

MOVILBA-749 movilba Done

└─ normalizar_si_no no saca chr(13), asi que un valor con retorno de carro sigue resolviendo a NULL

MOVILBA-748 movilba Done

Hub precheck: bounce a coder->db/audit message that cites a repo path without a sha

MOVILBA-262 movilba Blocked low

Decision: no agent-facing view-model endpoint; one shared presenter plus a CLI entrypoint instead

MOVILBA-350 movilba Done low

El nivel de log del cliente se hornea en build y el del servidor se lee en runtime, asi que en el pod un cambio de ConfigMap los desincroniza

MOVILBA-734 movilba Done low

Columnas de negocio que guardan un id de catalogo sin FK que lo restrinja: 7 sin FK alguna mas la clase de FK a opciones(id) sin restringir catalogo

MOVILBA-738 movilba Blocked

└─ Instrumento MOVILBA-738: censo de FK a opciones - veredicto de audit antes del commit

MOVILBA-774 movilba Done

└─ FKs a opciones(id) sin restriccion de catalogo: censar cuantas columnas de negocio pueden guardar el id de un catalogo ajeno

MOVILBA-763 movilba Done

└─ Tres CATEGORY_MAPPINGS de ramales apuntan a un grupo inexistente

MOVILBA-775 movilba Done

Resolver llamado dos veces al navegar por busqueda: handler origen y efecto destino

MOVILBA-348 movilba Done low

Censar guardas de verdad que puedan ocultar Línea 0

MOVILBA-392 movilba Done low

Ocultar validadoras SUBE/OpenPass en toda la aplicacion - pantalla, formulario, exportaciones y API

MOVILBA-580 movilba Blocked

└─ GET /api/vehiculos/[id] emite las cuatro columnas de validadora porque findById selecciona la vista de detalle entera y ni el servicio ni la ruta recortan

MOVILBA-754 movilba Done high

└─ GET /api/vehiculos/[id]/historia emite los valores crudos de validadora SUBE/OpenPass: el filtro de ocultamiento vive solo en la capa de presentacion y la ruta no la llama

MOVILBA-753 movilba Done high

└─ obtenerComentariosImportacion no tiene gate de host propio y confia en un chequeo de cliente

MOVILBA-743 movilba Done

└─ ValidadoraEntitySection renderiza SUBE en las pantallas de linea, fuera del redirect de /validadoras

MOVILBA-742 movilba Done high

Calificar por catalogo 16 vistas con JOIN resolutor sin calificar y 14 selectores solo-campo (re-censo vivo)

MOVILBA-484 movilba In progress low ↳ MOVILBA-481

Prune del .md de agentes: sacar narracion e historial del camino eager

MOVILBA-602 movilba Done

carroceria_modelo y carroceria_fabricante son un solo hecho en dos columnas: portar y borrar, y sacar el campo bodyModel del historial

MOVILBA-468 movilba Done low

262 returns en src/actions sin requestId; 92 en archivos sin generateUUID (confirmado por dos derivaciones independientes)

MOVILBA-408 movilba Done

Admin opciones: explicar duplicados del catálogo con mensaje específico

MOVILBA-385 movilba Done low

El espejo a ASI esta caido por un RESET de TLS de repositorio-asi, no por el DNS que diagnostica el script: mba-deploy-pod.sh aborta y el pod se queda en su version vieja

MOVILBA-577 movilba Done

El expediente se guarda verbatim en vehiculo_historial y trimmeado+truncado a 110 en validadoras_historial para el mismo tramite

MOVILBA-571 movilba Blocked low ↳ MOVILBA-362

Sacar estado_id de v_vehiculos_lineas_entidades: nadie lo lee y su derivacion invita a heredar el defecto de 147

MOVILBA-214 movilba Done low ↳ MOVILBA-212

GRANT a rol individual con nombre de CUIT: agrupar en movilba_readonlyusergroup

MOVILBA-230 movilba Blocked

Vehiculo entidad differs from linea's assigned entidad: 35 rows/4 lineas + 11 rows/2 lineas with no assignment (v_audit_vehiculo_vs_linea_entidad)

MOVILBA-90 movilba Blocked

PROD svc_nextjs lacks UPDATE on rutap.v_vehiculo_historial_normalizado_fuente_actual - app soft-delete cascade hits permission denied

MOVILBA-788 movilba Done

PROD svc_nextjs lacks UPDATE on rutap.v_vehiculo_historial_normalizado_fuente_actual - soft-delete cascade hits permission denied

MOVILBA-786 movilba Done high

gitdeployprod.sh v2.3 blocks itself: rewrites .gitdeployprod-pre.sh INFO_VERSION stamp, then fails 'Uncommitted changes'; gitdeploydev --only leaves regenerated CHANGELOG.md dirty

MOVILBA-476 movilba Done

Preserve legacy colectivo subtype on edit after MOVILBA-360

MOVILBA-436 movilba Done

svc_nextjs (PROD) lacks UPDATE on rutap.v_vehiculo_historial_normalizado_fuente_actual - app soft-delete path may 42501

MOVILBA-785 movilba Canceled

Historical app-created vehicles still attribute creado_por to system_import despite audit_log CREATE

MOVILBA-182 movilba Blocked high

└─ 65 de 94 eventos CREATE de audit_log sobre vehiculos apuntan a una fila que no existe en ninguna tabla, y 26 de esos dominios viven hoy con otro id atribuido a system_import

MOVILBA-780 movilba Blocked

mba-deploy-pod.sh 784 fix: trash on whey errors 'requires at least 1 arg(s), only received 0' - trap not actually passing the dir

MOVILBA-787 movilba Done high

Los datos no se promueven entre ambientes: PROD se deriva del libro, nunca de DEV - y falta el gate que impida cargar un dominio que el libro no tiene

MOVILBA-306 movilba Done high

mba-deploy-pod.sh cleanup still fails on whey: host rm-shim is a PATH executable, 'command rm' doesn't bypass it

MOVILBA-784 movilba Done

getCurrentHistorial has 3 write-path callers, wrong-row risk not exercised

MOVILBA-782 movilba Done

El desempate del periodo vigente esta duplicado a mano en TypeScript y en SQL y nada lo mantiene sincronizado

MOVILBA-542 movilba Done

mba-deploy-pod.sh EXIT trap cleanup silently fails on whey, 88 dirs/22G accumulated

MOVILBA-783 movilba Done high

El predicado de fabricante vive en dos objetos sin definicion compartida y cada copia se parchea a mano

MOVILBA-766 movilba Done low

v_snapshot_catalog_preflight tiene su propia copia del join de fabricante que MOVILBA-722 parcheo solo en el proyector, asi que marca filas que el proyector ya resuelve

MOVILBA-746 movilba Done

Libro: la fila 5181 de Base dice Tipo_Motor GNC y Unidad_Propulsora GO

MOVILBA-778 movilba Done

Libro: la columna Tipo_Motor mezcla dos ejes, clases de emision y combustibles

MOVILBA-777 movilba Done

El loader de 227 inserta vehiculo_historial con tramite_id NULL cuando la celda tramite del libro viene vacia

MOVILBA-282 movilba Done high

└─ El loader descarta los avisos del servidor: ningun .py de tools/ lee conn.notices, asi que el RAISE WARNING del proyector no aparece en la salida de la corrida (afecta MOVILBA-282 y MOVILBA-492)

MOVILBA-771 movilba Done

Politica de catalogo: cinco opciones vivas de unidad propulsora que el libro nunca dice, una de ellas referenciada

MOVILBA-371 movilba Done low

Las 5 citas bwi#N que sobreviven en pending-prod-changes.md son el registro operativo de lo que falta en PROD, no historia

MOVILBA-781 movilba Done

Deuda de evidencia en los alias de chasis aprobados: 41 triples / 202 filas sin fuente citada

MOVILBA-772 movilba Done

Remove unsupported bwi#60 citation from motivo catalog validation comment

MOVILBA-776 movilba Done low

Los 12 comentarios con bwi#N citan ids del namespace viejo y hay que establecer si existe un mapeo recuperable antes de borrar la cita

MOVILBA-779 movilba Done

El reporte historico emite el contrato de maquina en ocho campos binarios del catalogo

MOVILBA-465 movilba Done low

El verificador 400 no confirma rollback cuando aborta a mitad de la fixture

MOVILBA-770 movilba Done

supautils force-grant census: public functions holding EXECUTE outside their allowed set (R6 forbidden-set read, inventory only)

PLUTO-785 pluto Backlog low

Orphaned active userRoles survive user soft-delete (hygiene)

PLUTO-639 pluto Blocked low

└─ Restore soft-deleted users with explicit role regrant decision

PLUTO-783 pluto Backlog

no demo/seed exclusion mechanism exists - vPracticaParticipantFacts cannot exclude demo prácticas from scoped teacher stats

PLUTO-103 pluto Backlog low

Add value/codigo machine-key column to lookupOptions

PLUTO-551 pluto Backlog low

Audit + sync prod public-fn DDL drift to checked-in migrations (search_path pins) — pluto mirror of venus EVO-8

PLUTO-153 pluto Backlog low

PLUTO-139 outcome: add 6 scope-join FK indexes, drop 2 zero-scan indexes, retire the dead isUserRowSafeToSupersede fn

PLUTO-724 pluto Backlog low

EVO-123: convert 4 UPDATE OF invariant guards to AFTER/no-column-list

PLUTO-780 pluto Backlog

Todo .ts bajo tools/ gatea dev y prod por typecheck pero esta fuera de eslint, asi que un artefacto de verificacion que no compila bloquea a todos los carriles

MOVILBA-768 movilba Done

mba_health_gate curlea la URL dos veces por intento y puede dar un falso OK que corta el loop

MOVILBA-628 movilba Done

El espejo drizzle/schema.ts acumulo 13 hunks de atraso contra movilba_dev, y solo uno es de MOVILBA-367

MOVILBA-764 movilba Done

El censo de 585 no proyecta relowner ni relacl, asi que 104 vistas se reportan iguales mientras PROD tiene 95 ACL explicitas y DEV 12, y el control E de MOVILBA-123 es una linea verde en la pata DEV

MOVILBA-773 movilba Done ↳ MOVILBA-585

PROD FIRST en todos los ejes: deploy e import van primero a prod, dev y pod despues juntos

MOVILBA-603 movilba Done

Ficha y exportaciones emiten carroceriaCategoria con etiqueta de catálogo

MOVILBA-769 movilba Done high

El reporte historico emite el contrato de maquina en dos campos de catalogo

MOVILBA-765 movilba Done high

Línea: un fallo de consulta y un resultado vacío no deben verse iguales

MOVILBA-389 movilba Done

Pantalla y PDF contestan distinto el Tramite de un mismo evento sin tramite_id

MOVILBA-464 movilba Blocked

Un periodo vigente de origen app, sin snapshot y con columnas del libro en NULL, tapa el valor que el libro si trae

MOVILBA-400 movilba Done

Decidir la vigencia del catálogo categoria_regulatoria antes de cambiar su resolver

MOVILBA-767 movilba Blocked

KING LONG XMQ6127E electric book row needs model identity from Eugenia

MOVILBA-708 movilba Blocked ↳ MOVILBA-365

Ya reportado: la contradiccion GNV/GO de AI259HP es convencion documentada (MOVILBA-365), un solo dominio, y el valor GO solo sobrevive en una fila de historia dada de baja

MOVILBA-760 movilba Done low

proyectar_snapshot resuelve chasis solo contra v_rutap_latest, asi que ningun snapshot que no sea la punta puede resolver aunque el mapeo este aprobado

MOVILBA-367 movilba Done high

Los ids de public.chasis no coinciden entre PROD y DEV, asi que todo literal de chasis id en una migracion o control es especifico de una base

MOVILBA-758 movilba Done high

└─ Clasificacion estatica de los 102 literales de chasis_id en 31 archivos de migracion: historico aplicado, pendiente, o control reutilizable

MOVILBA-762 movilba Done high

Aplicar el sufijo de borrado_en en las 12 vistas, PROD y despues DEV, sin carve-out para tipo_asociacion

MOVILBA-737 movilba Done high

Throttle de login por IP sola: una direccion compartida bloquea a todos sus usuarios

MOVILBA-740 movilba Done low

No hay duplicado de chasis que convergir: los 32 nombres del catalogo son identicos en PROD y DEV y 8 difieren solo en el id surrogado, ya salvado con literales por base

MOVILBA-728 movilba Done

└─ Identidad de modelo para AGRALE MT 17: cual de los ids 123, 143 y 135 describe el modelo del libro, con fuente de fabricante

MOVILBA-755 movilba Done

Paridad de cuerpo PROD/DEV: 2 de 117 vistas divergen de verdad (las otras 68 diferencias de texto son idioma de deparser PG15 vs PG17), owner 117/117 y grants 108/117

MOVILBA-731 movilba Done

El esquema agents no existe en PROD y en DEV tiene agents.v_vehiculo_lookup con 70 columnas

MOVILBA-750 movilba Done

El esquema agents no existe en PROD y DEV tiene agents.v_vehiculo_lookup con 70 columnas: deriva de objetos, no de filas

MOVILBA-747 movilba Done high

Celdas con el literal '0' en el snapshot vigente: 5308 id_canbus, 2974 id_adas, 1128 id_mdvr, 18 motor_nro - verificar contra el libro antes de decidir si es fidelidad o defecto nuestro

MOVILBA-756 movilba Done

Seleccion de fila: 223 vehiculos vigentes muestran un expediente de alta que no es el suyo (mas 132 observaciones y 9 IDs) - el estado actual sale de una fila CERRADA

MOVILBA-174 movilba Blocked high ↳ MOVILBA-155

change-password no le ofrece salida al que olvido la password: falta el link a pedir el mail de reset

MOVILBA-328 movilba Done low

Import must not abort on missing masters (entidad/linea/catalogo)

MOVILBA-519 movilba Blocked

FKs manuales para los mapeos etiqueta-del-libro -> catalogo que hoy viven como CASE de texto adentro de prosrc

MOVILBA-490 movilba Done

└─ Motor manufacturer book-label aliases need FK carrier after MOVILBA-490 phase 1

MOVILBA-752 movilba Blocked

v_snapshot_catalog_preflight never fires - no positive control on any branch

MOVILBA-611 movilba Done

El DROP de vehiculos_datos_colectivos.observaciones tiene GO para PROD pero DEV figura dropeada tres semanas antes y no hay archivo PROD

MOVILBA-745 movilba Blocked high

Las pantallas tiraban el requestId del servidor

MOVILBA-407 movilba Done

└─ Ocho archivos y 14 capturas descartan el requestId emitido por el servidor

MOVILBA-761 movilba Done

└─ Los 13 archivos que no usan ningun helper de error: sin captura no hay id que correlacionar - forma distinta de 407, sin trazar

MOVILBA-741 movilba Done

v_vehiculos_export.ultima_modificacion publica creado_en, no la fecha del tramite

MOVILBA-556 movilba Blocked

Tracker Eugenia 2026-09-17: items abiertos de la hoja Para Elazar

MOVILBA-449 movilba Done high

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

MOVILBA-452 movilba Done high

└─ Plate change: keep prior plate as retired vehicle while preserving history

MOVILBA-526 movilba Done high

Validadoras: nueva entidad con historia (alta/baja/transferencia via expediente), dos tipos, asignable a lineas/vehiculos

MOVILBA-52 movilba Deferred high

└─ Validadora embarcada: desvincular al cambiar dominio o dar de baja el vehiculo, y re-adjudicar sin recrear (casos 2 y 5)

MOVILBA-266 movilba Deferred high

log() interno pasa una etiqueta literal como requestId y app_logs.request_id queda NULL por descarte de UUID_RE

MOVILBA-732 movilba Done low

Rendiciones API: contractual release and current-state safety

MOVILBA-185 movilba Done high

└─ Rendiciones: use 20 as the default page size

MOVILBA-188 movilba Done

└─ Rendiciones: remove or correct fecha_ultima_actualizacion

MOVILBA-195 movilba Done

└─ Rendiciones: regression tests for current vehicle state sources

MOVILBA-189 movilba Done high

Criterio MDVR: camaras_internas o id_mdvr distinto de cero implica MDVR = SI

MOVILBA-634 movilba Done

Decision: ocultar categoria de carroceria por ser todos M3, contra el campo obligatorio que ya shipeo en 546

MOVILBA-714 movilba Done

15 dominios: book records a zero-duration row same-day as the real opening period - question for Eugenia

MOVILBA-727 movilba Blocked

└─ Clarify same-day period for OPB348

MOVILBA-819 movilba Done

└─ Clarify same-day period for AI105QP

MOVILBA-817 movilba Done

└─ Clarify same-day period for AI058QM

MOVILBA-816 movilba Done

└─ Clarify same-day period for AI024HE

MOVILBA-815 movilba Done

└─ Clarify same-day period for AI023DC

MOVILBA-814 movilba Done

└─ Clarify same-day period for AH850GK

MOVILBA-813 movilba Done

└─ Clarify AE922FE in stakeholder draft

MOVILBA-820 movilba Backlog

└─ Clarify same-day period for AI357IV

MOVILBA-818 movilba Backlog

└─ Clarify same-day period for AH850FS

MOVILBA-812 movilba Backlog

└─ Clarify same-day period for AG358KX

MOVILBA-811 movilba Backlog

└─ Clarify same-day period for AE971FF

MOVILBA-810 movilba Backlog

└─ Clarify same-day period for AE971FE

MOVILBA-809 movilba Backlog

└─ Clarify same-day period for AE922FX

MOVILBA-808 movilba Backlog

└─ Clarify same-day period for AE352LD

MOVILBA-807 movilba Backlog

└─ Clarify same-day period for AD919PL

MOVILBA-806 movilba Backlog

└─ Clarify same-day period for AB259JY

MOVILBA-805 movilba Backlog

Un pase de dominio (cambio de linea/interno/empresa) es ALTA, no MODIFICACION

MOVILBA-461 movilba Done high

Catalog text whitelists can silently empty UI views after label changes

MOVILBA-387 movilba Done

Simplificar MovilBA: censo de tablas, columnas, vistas, rutas y pantallas que nada usa, para quitarlas

MOVILBA-667 movilba Done high

└─ Removal candidate: view rutap.v_vdc_mdvr_import_baseline

MOVILBA-690 movilba Done

└─ Removal candidate: view rutap.v_rutap_ultima_alta_por_dominio

MOVILBA-689 movilba Done

└─ Removal candidate: view rutap.v_rutap_rows_norm

MOVILBA-688 movilba Done

└─ Removal candidate: view rutap.v_rutap_latest_empresas

MOVILBA-687 movilba Done

└─ Removal candidate: view public.v_vehiculos_historial_mas_items

MOVILBA-686 movilba Done

└─ Removal candidate: view public.v_usuario_permisos

MOVILBA-685 movilba Done

└─ Removal candidate: view public.v_users

MOVILBA-684 movilba Done

└─ Removal candidate: view public.v_ui_users

MOVILBA-683 movilba Done

└─ Removal candidate: view public.v_numeros_telefonicos

MOVILBA-681 movilba Done

└─ Removal candidate: view public.v_direcciones_postales

MOVILBA-680 movilba Done

└─ Removal candidate: view public.v_correos_electronicos

MOVILBA-677 movilba Done

└─ Removal candidate: view public.v_audit_integridad

MOVILBA-675 movilba Done

└─ Removal candidate: view public.v_asociaciones_entidad_persona

MOVILBA-674 movilba Done

└─ Column candidate: public.vehiculos_archive.numero_serie_carroceria

MOVILBA-700 movilba Done

└─ Removal candidate: view public.v_db_users_footprint_detalle

MOVILBA-703 movilba Done

└─ Removal candidate: view public.v_db_users_footprint

MOVILBA-701 movilba Done

└─ Removal candidate: view public.v_db_users_sin_login

MOVILBA-679 movilba Done

└─ Removal candidate: view public.v_db_users_dominio_falso

MOVILBA-678 movilba Done

└─ Removal candidate: view public.v_auth_methods_stats

MOVILBA-676 movilba Done

logger.ts persists app_logs.user_id and ip_address as NULL on every row - unawaited Promise behind an any-typed require

MOVILBA-735 movilba Done

Reportes: dashboard de reportes por rol, reportes a medida, filtros y rangos de fecha

MOVILBA-158 movilba Deferred ↳ MOVILBA-440

└─ Reportes a medida: alcance, persistencia y permisos

MOVILBA-164 movilba In progress low

└─ Reporte 4: filtros por fecha de negocio RUTAP

MOVILBA-163 movilba Blocked low

└─ Reporte 3: PDF por vehículo desde su ficha

MOVILBA-443 movilba Done high

└─ La ficha y la API muestran la modificación como Vigencia desde

MOVILBA-525 movilba Done high

Parque Movil: filtros por empresa, linea e interno en la lista de vehiculos

MOVILBA-713 movilba Done

El hook pre-deploy reporta un chequeo que crasheo como si el artefacto estuviera desactualizado

MOVILBA-325 movilba Done

logCaughtError console.error: redact raw err.message/stack before Vercel log

VENUS-484 venus Done low

Semantic catalog and full-history fidelity against the approved RUTAP book

MOVILBA-704 movilba Done high ↳ MOVILBA-186

└─ Two historical Agrale chassis links lag approved MOVILBA-710 resolver

MOVILBA-719 movilba Done

Retirar los nombres legacy fecha_vigencia_desde/hasta: el nombre canonico sigue al header del libro (Fecha_Alta/Fecha_Baja)

MOVILBA-242 movilba Blocked high

El import matchea las grafias equivalentes de chasis por regla en normalizar_clave_chasis, en vez de un alias curado a mano por grafia

MOVILBA-575 movilba Done

normalizar_clave_chasis reemplaza GAS|GNC|CNG sin limite de palabra, asi que PEGASO se vuelve PEGNCO

MOVILBA-729 movilba Done high

DB audit pass 2026-10-08: appEvents PII census + RLS/migrations/advisors/drift

VENUS-485 venus Backlog

└─ appEvents historical email residue: 1354 rows pre-redaction, purge needs ruling

VENUS-486 venus Done

└─ venus99: advisor hygiene - duplicate authId index, evaluadoresExternos FK cover, applog_notify_error pin

VENUS-487 venus Done low

└─ Advisor: pg_trgm/unaccent in public schema - relocation not attempted

VENUS-488 venus Backlog someday

Deriva DEV/PROD en public: de los seis objetos del censo 09-22 sobreviven tres, y en dos de ellos la flecha apunta al reves de como se filo

MOVILBA-537 movilba Blocked

logger.ts:207 llama al shim getLogContext sin await, asi que app_logs.user_id y ip_address son NULL en todas las filas desde 2026-05-20

MOVILBA-736 movilba Canceled high

Census residual raw chassis-model column before any database drop

MOVILBA-395 movilba Blocked

Vehicle chassis must not contradict its propulsion

MOVILBA-401 movilba Done

Un deploy mientras alguien carga un alta le cuesta todo lo tipeado: no hay persistencia de borrador

MOVILBA-334 movilba Done high

└─ Borrador de alta se borra en cada navegación SPA

MOVILBA-733 movilba Done

El nivel debug no se escribe en app_logs desde 2026-05-14: 50 testigos ciegos y al menos una cifra ya calculada sobre un denominador congelado

MOVILBA-330 movilba Done

drizzle-kit emite TypeScript invalido y literales bigint inconsistentes al regenerar schema.ts

MOVILBA-324 movilba Done

Store vehicle-history body category as a catalog ID

MOVILBA-709 movilba Done ↳ MOVILBA-546

El CUIT es el identificador en tres capas, por eso reaparece en todo archivo que toque datos

MOVILBA-229 movilba Done high

audit_log no es un rastro completo sino parcial por camino, y el patron se repite en vehiculos, entidades, choferes y validadoras: decidir si se instrumenta todo o se declara best-effort

MOVILBA-646 movilba Done

appEvents errorMessage/errorStack: coarse auth errors on applicant auth-admin paths

VENUS-483 venus Done low

appEvents.actor: write userId, not staff email

VENUS-452 venus Done low

appEvents toast text: strip embedded email addresses

VENUS-454 venus Done low

appEvents detail still logs alumno/admin email under key 'email'

VENUS-456 venus Done

Repair the source attendance data before trusting the counts

WEBCERTI-20 webcertify Backlog

Decide the Explorer threshold: 3, not 2

WEBCERTI-19 webcertify Backlog high

La ficha y el export dan fechas distintas para el mismo vehiculo: 1386 de 1736

MOVILBA-88 movilba Done

View-as writes attributed to real admin

VENUS-299 venus Blocked

Admin action: agregar participante omitido a una practica fuera de la ventana de 48h

VENUS-372 venus Blocked

Remove viewport-size logging to appEvents

VENUS-191 venus Blocked low

P3c comparative-stats /informes/stats (alumno ranking + cohort agg, titular-scoped)

VENUS-93 venus Done

El armado del PDF de la ficha vive dentro del handler del cliente, asi que no hay forma de medirlo sin navegador y tres items estan parados ahi

MOVILBA-643 movilba Canceled high

v_vehiculos_export_periodo_actual proyecta el texto crudo de carroceria_categoria en vez de la etiqueta del catalogo

MOVILBA-730 movilba Canceled high

RUTAP importer stamps batch date into fecha_ultima_actualizacion

MOVILBA-145 movilba Done high

Las 15 vistas envoltorio de soft-delete: paquete firmado, ensayado en dev y prod y auditado, pero SIN GO, SIN ejecutor asignado (db02 se retiro) y sin consumidor identificado - es el unico del dia que AGREGA superficie en vez de corregir algo

MOVILBA-122 movilba Done low

Política: PROD replica el snapshot RUTAP vigente en PostgreSQL

MOVILBA-13 movilba Deferred

└─ Import RUTAP no reproducible de punta a punta: fuente/DSN/apply manuales y conciliacion solo en salida del operador

MOVILBA-59 movilba In progress

Copia de datos dev->prod (dev SSOT) - ejecutada, falta purga de archives

MOVILBA-11 movilba Deferred

xlsx has no npm fix: decide CDN source, replace with exceljs, or document risk acceptance

MOVILBA-615 movilba Done

DECIDIR que muestra la lista de lineas cuando la entidad de una linea esta soft-deleteada - hoy NO pasa en ningun entorno

MOVILBA-100 movilba Done

Make user-visible error IDs match app_logs

MOVILBA-413 movilba Done

Decision: is a re-plate (cambio de dominio) its own modification subtype?

MOVILBA-246 movilba Blocked

Catorce columnas col_39..col_52 vacias en rutap.rutap_rows hacen que el conteo de columnas del libro no cierre

MOVILBA-374 movilba Done low

Restrict Liquidación report access without changing existing reports

MOVILBA-444 movilba Done high ↳ MOVILBA-268

Que le pasa a la app cuando se borra logicamente CUALQUIER opcion del catalogo - barrido de todas las superficies, no solo SOTAMIT

MOVILBA-123 movilba Done

lezama-down email alert via Hostinger php-api heartbeat

MOVILBA-711 movilba Blocked

Rebuild the generated certificate to match the client's templates

WEBCERTI-18 webcertify Done

SHA-addressed reads in the movilba-web shared checkout: PreToolUse deny-hook

MOVILBA-263 movilba Blocked

El espejo a ASI dejo de correr en cada deploy a dev: push-to-gcaba.sh vuelve a ser manual y ahora puede fallar

MOVILBA-298 movilba Done

El doc de backups declara canonica una carpeta que no tiene los dumps programados - 235 dumps viven en /var/backups/postgresql/ y el doc no la nombra

MOVILBA-650 movilba Done

MovilBA owns its full deploy toolchain - no sh.git core or aux scripts

MOVILBA-460 movilba Done high

reconciliar_snapshot particiona por (vehiculo_id, dominio), la misma forma que fue defecto en v_vehiculo_historial_actual - latente hoy porque esta gateado a una fila por vehiculo

MOVILBA-561 movilba Done

uq_personas_cuit_cuil_activo existe en PROD y no en DEV: DEV acepta CUITs duplicados que PROD rechaza

MOVILBA-503 movilba Done low

Un periodo escrito por la app deja en NULL los campos descriptivos del SSOT y las cuatro superficies los resuelven DESDE EL PERIODO, asi que muestran 'No registrado' con el dato presente en el vehiculo base

MOVILBA-572 movilba Done high

Editar solo observaciones abre un periodo de negocio en el historial

MOVILBA-335 movilba Done

creado_en no es orden de escritura en 2441 de 4052 filas de vehiculo_historial: 8 consumidores lo leen como recencia; el dano visible es chico (2 vehiculos mal en el export) y el arreglo barato solo alcanza a 12 de 134

MOVILBA-113 movilba Done low

federated-logout nunca descifra el JWT: decode con salt '' contra un token cifrado con salt = nombre de cookie

MOVILBA-296 movilba Done

Approved RUTAP carroceria resolver and tracker evidence

MOVILBA-245 movilba Done high ↳ MOVILBA-203

Post-import validate fecha_ultima_actualizacion business-date derivation

MOVILBA-146 movilba Done

48 migraciones faltaban en dev y ya estan commiteadas (671c26c8); quedan afuera dos con CUIT reales y 18 volcados .tsv

MOVILBA-370 movilba Done high

GATE del rebuild-por-import: los triggers NO hay que deshabilitarlos (TRUNCATE no dispara ROW triggers), validadoras_historial esta vacia, y el gate de re-habilitacion + fidelidad

MOVILBA-226 movilba Done high ↳ MOVILBA-155

tools/import/legacy-history-reference-source.test.ts esta en rojo y nadie lo estaba corriendo: el pin de cardinalidad espera 1 scanner crudo y hay 2

MOVILBA-558 movilba Done

db03: CLAUDE.md GO-requirement pointer fix needs audit

MOVILBA-604 movilba Done

v_vehiculo_historial publica borrado_en como fecha de fin de periodo y ordena por creado_en: una columna de auditoria decide lo que el usuario lee

MOVILBA-225 movilba Done high

v_vehiculos_detalle.historial: tres defectos en el mismo subquery JSON

MOVILBA-232 movilba Done high

Repair confirmed SSOT projection/export defects

MOVILBA-445 movilba Done high ↳ MOVILBA-435

v_vehiculos_export.fecha_alta sigue la cadena de chasis, no el dominio; 131 vehiculos sin ningun tramite 'Alta' en historial

MOVILBA-280 movilba Done

parque-movil list(): filtrar por el alias del join a opciones lo hace ciego a las opciones retiradas

MOVILBA-312 movilba Done

121 filas de vehiculo_historial sin periodo en el libro quedan fuera de todo gate (+2 periodos duplicados en el libro)

MOVILBA-237 movilba Done

Los LATERAL de los catalogos que NO son tramite siguen eligiendo en silencio con ORDER BY id LIMIT 1

MOVILBA-290 movilba Done

4 pre-existing failures in tools/tests, invisible because nothing ran them

MOVILBA-515 movilba Done

Libro: ID_ADAS con '########' (desborde de Excel) en 42 filas - pregunta al tracker de Eugenia

MOVILBA-244 movilba Done

Dos periodos invertidos vivos (AH850GD, AH940VA) y ningun CHECK de fecha_baja >= fecha_alta

MOVILBA-240 movilba Done

periodo_veh.fecha_baja no-nulo pero anterior a fecha_alta chasis-matched (AI058QN/AI058QQ)

MOVILBA-457 movilba Done

v_vehiculos_export no tiene el mismo cuerpo en las dos bases: PROD lee el expediente de vdc y DEV del periodo vigente, y DEV ya diverge en 11 filas

MOVILBA-565 movilba Done

GitHub to Vercel did not trigger a deployment for commit b8dd248

WEBCERTI-17 webcertify Backlog low

Issue certificates as A4 landscape PDFs

WEBCERTI-16 webcertify Done high

Epic: webcertify production launch

WEBCERTI-9 webcertify Backlog

└─ Visual redesign: modern, sleek look and feel across all pages

WEBCERTI-15 webcertify Done high

└─ Supabase CLI: project-scoped SUPABASE_ACCESS_TOKEN in agent settings.local.json

WEBCERTI-3 webcertify Done low

└─ Enable Google OAuth provider on Supabase (client id/secret + redirect URI)

WEBCERTI-2 webcertify Done

└─ Bind sign-in identity to the Google sub, not the claim email

WEBCERTI-14 webcertify Backlog low

└─ Google Cloud OAuth client for webcertify sign-in

WEBCERTI-12 webcertify Done

└─ Contrast-checked semantic color tokens plus light/dark/system theme

WEBCERTI-13 webcertify Done

└─ RLS disabled on all 10 public tables

WEBCERTI-5 webcertify Done low

└─ Vercel MCP: integration grant lacks webcertify-pensanta-com

WEBCERTI-11 webcertify Backlog someday

└─ Prod: POST /auth/login returns 500

WEBCERTI-10 webcertify Done high

└─ Delegate audit/tests to coder-webcertify-ca

WEBCERTI-8 webcertify Done someday

└─ End-to-end prod ingest test: upload a real Zoom .xlsx on webcertify.pensanta.com, confirm preview, commit, KPIs

WEBCERTI-7 webcertify Backlog

└─ Bootstrap app_users <-> auth.users: 0 auth users, 2 app_users

WEBCERTI-6 webcertify Done

└─ Migration history: supabase_migrations.schema_migrations absent - CLI db push would re-apply all 5 migrations

WEBCERTI-4 webcertify Backlog low

└─ Vercel prod env vars: DATABASE_URL (pooler, password), NEXT_PUBLIC_SUPABASE_URL, NEXT_PUBLIC_SUPABASE_PUBLISHABLE_KEY, APP_ORIGIN

WEBCERTI-1 webcertify Done low

Evaluation export: sede show/hide toggle

VENUS-480 venus Done

Libro: 2 pares motor_nro truncado (AG358KX, AE168VP) - pregunta al tracker de Eugenia

MOVILBA-720 movilba Done

Materializer double-inserts a zero-length stub row alongside the real opening row - 15 vehiculos in snapshot 11/21, introduced by MOVILBA-89/125 cutover

MOVILBA-726 movilba Canceled high

Libro: 28 celdas nro_dominio con whitespace en los extremos - pregunta al tracker de Eugenia

MOVILBA-721 movilba Done

42 PROD / 67 DEV rows share one expte_alta across multiple live periods - verify legitimate multi-period, not bifurcation

MOVILBA-725 movilba Done

Aperturas DUPLICADAS del loader: 84 vehiculos con el mismo expte_alta en dos filas vivas (la version abierta-abierta son 89)

MOVILBA-285 movilba Done high

El motivo del rechazo de una validacion no llega a la pantalla: la UI dice error generico y el detalle queda solo en el log de runtime

MOVILBA-369 movilba Done high

Historial del vehículo: alinear el orden de secciones con las categorías

MOVILBA-724 movilba Done

Memory sweep: split project_enamel_shipped_surface_state.md, re-verify stale memory files

ENAMEL-93 enamel Backlog

Import final parity gate compares retired VDC dates after MOVILBA-242

MOVILBA-723 movilba Done high ↳ MOVILBA-518

RUTAP: 42 celdas ################ en ID ADAS siguen en el libro del 20/08 - lo dimos por cerrado el 14/08 habiendo arreglado solo NUESTRA copia

MOVILBA-75 movilba Done high

Interno ya vinculado a otro dominio (LID108): se puede cargar duplicado

MOVILBA-717 movilba Canceled

Fecha de carga vs fecha de expediente: que ve la empresa y es la fecha de carga solo visual

MOVILBA-715 movilba Done

Ningun camino de ship corre next build: un cambio que rompe el build pasa lint, typecheck, tests y el PASS de auditoria, y se descubre despues del push

MOVILBA-612 movilba Done high

Chasis: link por VIN de AB126BE/BG/CZ a chasis 116 y aprobacion de las tres ternas SCANIA K280 a chasis 124

MOVILBA-398 movilba Done

~22 vehiculos donde rutap no tiene NADA de entidad y el libro si nombra algo

MOVILBA-320 movilba Done

Workflow por roles: ningun gate nombra un agente; carriles efimeros por disponibilidad de tokens

MOVILBA-448 movilba Done high

MOVILBA-46 PARTE 2: la constancia de baja se recibe y se descarta - decidir persistencia o corregir el rotulo

MOVILBA-106 movilba Done

Inventario de instrucciones .md que todavia suponen el modelo retirado de importar a DEV y promover a PROD

MOVILBA-586 movilba Done

Caracterizar las ~1350 filas donde chasis_modelo del catalogo difiere del texto del libro: cuantas son grafia y cuantas son OTRO modelo

MOVILBA-597 movilba Done high

└─ MOVILBA-597: MT15.0 V5500 live backfill, 6 vehicles

MOVILBA-718 movilba Done

Alta de colectivo puede dejar vehiculo + historial sin fila VDC ni linea (7 huerfanos en DEV, creados despues del gate de linea del 09-15)

MOVILBA-594 movilba Done high

Alta bloqueada: la fecha de expediente se rechaza siempre (anterior, actual y futura)

MOVILBA-712 movilba Done high

Un escritor de la UI creo filas de vehiculo_historial sin fecha de apertura, dos veces en agosto

MOVILBA-286 movilba Done high

Siete items priority 0-2 estan bloqueados por UN solo instrumento ausente: una cuenta de dev01 con permiso de ESCRITURA

MOVILBA-651 movilba Done urgent

Unificar edicion de vehiculo/colectivo bajo un solo camino que siempre exija expediente

MOVILBA-46 movilba Done high

Script nuevo + sqlite nuevo: tabla ancha consultable del TODO tracker, sin re-parsear xlsx cada vez

MOVILBA-716 movilba Done

pacientes archive coverage + cross-práctica demographic propagation

VENUS-86 venus Done low

userGroups write-side liveness is narrower than read-side: future-dated toAt INSERT skips all write guards

ENAMEL-81 enamel In progress high

fn_notify_applog_err COALESCEs userAgent to empty string in NOTIFY payload

PLUTO-770 pluto Done low

VENUS-155 Phase 3: sexo code hardening is a lookup-table question, not a CHECK

VENUS-469 venus Done low

supautils force-grant census: public functions holding EXECUTE outside their allowed set (R6 forbidden-set read, inventory only)

MARS-803 mars Done low

Resolve provenance/allowed-set for applog_reader EXECUTE on fn_dbperf_statements_top50

MARS-804 mars Backlog

PLUTO-782 app refusal for deleted roleless student target

PLUTO-784 pluto Done high

Does mars's .gitpush-pre.sh read ONLY_PATHS? The v5.6 producer shipped fleet-wide; the consumer is per-repo and unchecked

OPS-291 agent-ops Done

Deleted users retain active-role grants in view and teacher validator

PLUTO-782 pluto Done high

applog-listen tsx units keep stale in-memory code after source push

VENUS-479 venus Backlog low

v_appEvents_404 groups by a half-dead key: no venus 404 writer populates appEvents.path (NULL on 100% of 969 rows)

VENUS-328 venus Done

venus .gitpush-pre.sh ignores ONLY_PATHS, so VENUS-471 is fixed in the producer and unfixed in its only consumer

VENUS-476 venus Done

pre-push hook's committed-violation language overclaims: diff-scoped findings cannot see a clean committed violation outside --only

VENUS-478 venus Backlog low

venus pre-push invariant lints cannot see a committed violation, and defer one as soon as its file is dirtied

VENUS-477 venus Backlog low

Vercel MCP connection lost project scope - Class-A PTD build/runtime log reads are unavailable fleet-wide

OPS-293 agent-ops Backlog

Practicas teacher-mode scopeCheck asserts roster membership, not role - same hole PLUTO-510 closed on the student path

PLUTO-739 pluto Done low

Census enamel's functions against the EVO-114 R6 forbidden-set shape (report only, no REVOKE authority)

ENAMEL-92 enamel Backlog low

Does enamel's .gitpush-pre.sh read ONLY_PATHS? The v5.6 producer shipped fleet-wide; the consumer is per-repo and unchecked

OPS-292 agent-ops Done

Shared lookupOptions NULL scope confirmed intentional; no backfill

TERRA-294 terra Done

Joomla /media/ scanner probe pages in all five apps - propagate one alt

EVO-115 evolutiva Done low

supautils force-grant census: public functions holding EXECUTE outside their allowed set (R6 forbidden-set read, inventory only)

ENAMEL-91 enamel Backlog low

Does pluto's .gitpush-pre.sh read ONLY_PATHS? The v5.6 producer shipped fleet-wide; the consumer is per-repo and unchecked

OPS-290 agent-ops Backlog

Enamel migration stem allocation has no serialiser: TERRA-282's origin-tag claim gate is terra-only, so two enamel lanes drafting concurrently can both claim the same enamel_NNN

ENAMEL-88 enamel Done

supautils force-grants EXECUTE on new functions to PUBLIC/anon/authenticated despite default-privilege revocation - every Evolutiva CREATE FUNCTION needs an explicit same-migration REVOKE, and no commons file says so

EVO-114 evolutiva Done high

EVO-123: convert 3 UPDATE OF invariant guards to AFTER/no-column-list

VENUS-473 venus Done

Generalise terra's atomic migration-stem claim engine into sh.git with per-repo config

OPS-289 agent-ops Backlog

Write the migration preflight/postflight skeleton as a shared file

ENAMEL-90 enamel Done

gitpushvercelstatus.sh finds no deployments for Mars although Vercel deployed d1053b5

OPS-288 agent-ops Done

Stale documented DB credential location in enamel-db-agents.md

ENAMEL-89 enamel Done low

userAgent ''-vs-NULL: trigger COALESCE + 2 callers leak empty string (diagnosability)

VENUS-344 venus Done low

Harden migration dry-run tooling against embedded COMMIT/BEGIN

PLUTO-582 pluto Done low

Access-report failure census: schema-cache burst and validation toast (resolved)

TERRA-288 terra Done high

vUserGroups role gate uses a bare toAt IS NULL, so a future-end grant confers no app role while still conferring clinical write

TERRA-286 terra In progress high

gitpush.sh gated version-target resolution on BUMP_LEVEL, so a no-bump push was silent about the version it did not move - and the push-to-deploy floor was reading that version as proof

OPS-287 agent-ops Blocked

pluto general archive-reason validator: the candidate regex rejects the .gitpush-pre.sh L204 mandated 'system:migration:<slug>' form

PLUTO-767 pluto Done

Review-depth pilot: keep measuring; verdict issued-but-not-recorded is the open finding

MARS-687 mars Done

gitpush.sh releases the push gate bare; hand it to the FIFO head with successor @next

OPS-285 agent-ops Blocked

Adopt successor:"@next" on gitpush-core.sh's push-gate unlock, or keep the bare unlock - the FIFO queue is non-binding without it

OPS-286 agent-ops Canceled high

friction rail does not resolve acceso:reportar, so access-report friction counts read zero

TERRA-291 terra Done

└─ Add LoginCard render coverage for untrusted error query values

TERRA-293 terra Backlog low

UPDATE OF keys on the statement SET list, not final NEW: every final-row-invariant trigger in the fleet using it is blind to a neighbouring trigger's rewrite

EVO-123 evolutiva Done high

D8: move the canonical-pieza 23505 recovery compare from JS into SQL now that migration 117 is applied

PLUTO-781 pluto Done low ↳ PLUTO-98

schema SSOT export carries no RLS policy quals or metadata, so no revert can ever be proven against git

VENUS-472 venus Done high

api.pensanta.com RSTs a FRACTION of connects while serving others: not listener loss, not load, upstream of PHP - a per-account connection limiter nobody can measure

EVO-103 evolutiva Blocked high

Daily trash purge runs INLINE under LiteSpeed: one real customer request per day pays the full trash-walk

EVO-119 evolutiva In progress low

api-images box stats.php threshold fallback still 80; only the box .env carries 75

EVO-118 evolutiva Done low ↳ EVO-58

the 2026-09-09 acceso:reportar burst: cause named and fixed by d3ea382; per-person attribution permanently unreadable, fixed forward by febd0bf1

TERRA-292 terra Done low

logEventTx lets a telemetry write abort its caller's business transaction (4 callers)

VENUS-460 venus Done

VENUS-367 — telemetry delivery-health: failed friction writes are indistinguishable from zero friction

VENUS-367 venus Done

pre-push scan blocks every lane on another lane's untracked file

VENUS-471 venus Done

Measure the connection-layer fixes, then decide on MARS-690 - reminder DMs start 2026-09-09

MARS-691 mars Done

gitpush.sh exported ONLY_PATHS only at the push step, so every repo hook gating on it ran whole-tree - and inherited a stale value when the caller had one

OPS-284 agent-ops Done high

Scoped gitpush proceeds unserialised when hub identity is missing in shared checkout

TERRA-290 terra Backlog low

Migration stem allocation has no serialiser: terra_239 is claimed by two unapplied drafts (TERRA-276 and TERRA-277), and a doubly-claimed stem applies cleanly once and is unreproducible

TERRA-282 terra Done high

EVO-123: convert 10 UPDATE OF invariant guards to AFTER/no-column-list

ENAMEL-87 enamel Backlog

EVO-123: convert 11 UPDATE OF invariant guards to AFTER/no-column-list

TERRA-289 terra Backlog

Record the node-pg error code, elapsed ms and furthest connection phase (DNS/TCP/TLS/SCRAM-start/SCRAM-done) per failed acquisition attempt - the post-failure breaker snapshot cannot attribute a layer and that is what MARS-787 is blocked on

MARS-799 mars Done

BUILD (dispatch-ready, Elazar-launched per bs-mqpzo3ly470 — do NOT act between sessions): Pluto admin "Cambiar email de acceso" server action (canonical change-login-Gmail, decision bs-mqq2v3r1802). New action in src/lib/admin-actions.ts, gate withCap(manageUsers) NOT fullAccess (reportes-trap, mem pluto-view-as-architecture). Input targetUserId+newEmail. In ONE txn w/ setArchiveContext (users is trigger-archived): (1) isAllowlistedEmail(new); (2) dedup-reject if canonicalizeEmail(new) belongs to another live user (id!=target, deletedAt IS NULL); (3) UPDATE users.email=new (emailCanonical GENERATED auto-regens, mem pluto-stored-generated-column-no-recompute) + SET users.authId=NULL so new Google identity re-links next login; (4) cleanup stale auth.users row for OLD identity via service-role admin deleteUser so old account cannot log back in; (5) userAuditLog email delta old->new; (6) optional fire welcome email to new address. Re-login on new gmail = proof-of-control (auth/callback matches by canonicalizeEmail(users.email)==canon(auth email), stamps new authId, same row -> roles/practicas intact). UI: "Cambiar email de acceso" in admin-user-detail.tsx with AlertDialog confirm (account-takeover-shaped). Touches auth/identity -> pre-impl audit design-ping + pre-push audit diff review per push-to-done.

PLUTO-202 pluto Done

The admin-minimum guard's advisory lock is an UNFORCED control: its mutual-exclusion effect cannot be rehearsed rollback-only, and forcing it red needs a disposable DB or authorised committed DML on the sole live admin grant

ENAMEL-86 enamel Backlog high

A mail-subscription grant confers practica-creation: createTerraPractica's actor gate accepts ANY live Terra membership, so every existing membership grant carries clinical-write capability

TERRA-277 terra Done high

└─ Participant eligibility admits the bedel-only support service actor as a recorded practica teammate

TERRA-279 terra Backlog high

└─ Re-test inactive Terra grant refusal if either shared guard changes

TERRA-287 terra Backlog low

Stamp breaker telemetry with deployment/container identity and a trip generation so opens and closes can be correlated

MARS-783 mars Done low

Catalog census of Pluto migration effects absent from production

PLUTO-774 pluto Done

Message leg of the truthful top-X/N-hours report: hub-message-census.sh, rows and sends side by side with the aro half declared unavailable

KPI-80 kpi Done high ↳ KPI-66

enamel has no .gitpush-pre.sh, so an enamel push runs no tests, no typecheck and no lint - the per-repo hook is the only check path and the other four repos have one

ENAMEL-83 enamel Canceled

Mars DB exporter can silently lose schema sections under a lower-privilege DSN (PLUTO-772 class)

MARS-800 mars Done

venus has no live schema-drift watcher, so every schema-contract test reads a snapshot that can lag prod

VENUS-470 venus Backlog low

Applied Pluto migrations missing from registry can be skipped by registry-driven rebuild

PLUTO-779 pluto Backlog

api-images deploy manifest: inc/idempotency.php absent from RUNTIME_FILES (fatal 500 on every POST), plus two pre-existing require-order bugs that made every prior deploy serve 500s

EVO-122 evolutiva Done high

Supabase saturation: instance-wide execution stalls (Oct-5 class) + PostgREST retry loop + Nano tier - root cause and fix plan (planning cost UNMEASURED: track_planning off)

MARS-769 mars Blocked high

Una practica no se puede corregir despues de creada: la unica excepcion es el postoperatorio, y todo lo cargado al crear (marca, injerto, zona, piezas, regiones, complicaciones intra, antecedentes) queda mal para siempre

TERRA-181 terra Todo high

Should enamel have a second admin? Live count is one with zero headroom

ENAMEL-85 enamel Canceled

api-images: off-box backup of uploads/ with a REHEARSED restore - 2.64GB exists in exactly one place, and it is the precondition for the first ?purge=1 caller

EVO-121 evolutiva Backlog

chore(lookup): lookupOptions.campo is the authored value-code column (shipped)

VENUS-155 venus Done low

Enamel has exactly one live admin grant with zero headroom - decide whether a second is provisioned

ENAMEL-84 enamel Backlog

export-db.py round 2: columns from pg_catalog, column count in the completeness guard, generated-column default fixed

VENUS-468 venus Done low

metrics_replay() has never been called: the metrics spool drains nowhere, fleet-wide

OPS-211 agent-ops Blocked high

file-history minting is only stoppable host-wide: no per-path exclusion exists, and a file's FIRST snapshot is exempt from eviction forever

OPS-283 agent-ops Backlog

reactivateInactive motivo has no persistence other than the truncated archive-reason slice

PLUTO-769 pluto Blocked

audit-venus-ca retro-review queue (reviewer outage since 2026-07-23)

VENUS-307 venus Done

RLS enablement prerequisites: the four-part single-change list for the five policy tables

VENUS-401 venus Todo

└─ pg-harness silently omits auth-based RLS policies on fresh up

VENUS-475 venus Done

└─ RLS enablement: alumno write-path policies and caller-role proof

VENUS-474 venus Done

The fleet live-version PTD check is degenerate on venus: package.json has not bumped for three consecutive pushes, so version-match cannot distinguish a deploy from its two predecessors

VENUS-467 venus Backlog

Post-window edit fulfillment: after 48h, student requests correction via botón Ayuda ticket → admin can edit ANY field (no per-field lock unless PM/Puia/Elazar restrict). Policy set Elazar 2026-06-26. Fulfillment mechanism (admin-edit-via-ticket UI vs manual) NOT built yet per his 'not for now'; this WI holds the agreed design.

VENUS-56 venus Blocked

B6 student-vs-student/camada compare (design-pending)

VENUS-43 venus Blocked low

CU-15b: alumno-facing 'ver posición relativa a su camada' — BLOCKED on client anonymization contract (own-position-only vs named-peers). New alumno_postgrado exposure to a KPI surface isStaffRole blocks today; needs self-scoped predicate (effective.id===id) + client ruling on whether alumno sees named peers or only aggregate/own-position. Client flagged 'muy verde, hay que darle forma'. Class-A. Follow-up to CU-15(A) staff camada-compare.

VENUS-105 venus Blocked

CR G8+G10 — structured pre-op diagnosis + post-op medication fields (v2 candidate, client-decision-pending)

VENUS-295 venus Blocked

Pathology/treatment conflation cleanup — client mixed patologías with tratamientos in option lists

VENUS-290 venus Blocked

Mendez Bovio DNI client-confirm: source xlsx has dni=95438931 (9-prefix, out-of-AR-range) + surname 'Bovio' absent in source → identity ambiguity, hold until client confirms value+identity before backfill

VENUS-59 venus Blocked

C2 shared tratamiento pool Quistes/Tumores/Cancer — reverses confirmed §10, needs Sebastian go

VENUS-48 venus Blocked low

D5 Otros modulo empty ok? — ask Sebastian

VENUS-53 venus Blocked low

D4 keep/drop Enucleacion coadyuvante (Tumores) — ask Sebastian

VENUS-52 venus Blocked low

D3 Infecciones cervicofaciales tratamientos — ask Sebastian

VENUS-51 venus Blocked low

D1 patient localidad field for residence distribution — ask Sebastian

VENUS-49 venus Blocked low

CLIENT QUESTION BUNDLE: eleven venus rows are parked on one unasked set of client questions (Sebastian/Puia)

VENUS-466 venus Backlog

appEvents: hash recipient email addresses in email telemetry

VENUS-453 venus Done low

applog-listen@terra and @enamel LISTEN on a channel their database never signals - the shared enamel/terra DB has no notify trigger on appEvents, so those two apps have no real-time rail and are covered only by the digest default that was never rolled back

VENUS-465 venus Backlog

accessRequests rejection motivo: route it in full to reviewNotes, coded suffix only in the archive reason

PLUTO-778 pluto Done

applog digest re-pages every row the real-time rail already paged: applog-pull@ never sets APPLOG_RT_STATE_FILE, so the suppression reads a nonexistent path and returns empty SILENTLY

VENUS-464 venus Done

PLUTO-184 benign-platform 404 suppression has never worked: assetlinks.json has written 1325 info/navigation rows since 2026-07-08 under a documented zero-row design

PLUTO-777 pluto Done low

export-db.py reads privilege-filtered information_schema and never renders indexes (PLUTO-772 port)

VENUS-457 venus Done low

scanner-probe-drift.test.ts compares against pluto's WORKING TREE, so it goes red on an uncommitted sibling edit and blocks every venus push

VENUS-461 venus Done

scanner-probe drift test compares against pluto's uncommitted worktree, not origin

VENUS-459 venus Done

sqlite-safe-backup row-count bracket cannot bound a non-monotonic table - a transient lock row deleted the hub backup

EVO-120 evolutiva Canceled

sqlite-safe-backup row-count bracket cannot bound a non-monotonic table - a transient lock row deleted the hub backup

VENUS-463 venus Backlog

Venus coder lane cannot read Vercel runtime logs (MCP get_runtime_logs 403) - Class-A PTD instrument unreachable

VENUS-462 venus Backlog high

appEvents writes all fail since 07:53Z: logger-core still INSERTs dropped column path

VENUS-458 venus Done urgent

pluto-commons.md archive-trigger count: 23 measured as 24, and the literal count removed rather than incremented

PLUTO-776 pluto Done low

EVO-115 step 2: Joomla /media/<component>/ scanner-probe alt + 6 append-only vectors

PLUTO-775 pluto Done

Admin storage tile for mars/venus/terra, or cancel the scope (tile half of EVO-58)

EVO-117 evolutiva Canceled low ↳ EVO-58

userGroups write triggers skip any grant with a future toAt, so a future-dated INSERT evades the deleted-user, inactive-group and enamel-admin-minimum guards while the corrected read counts it as current

ENAMEL-82 enamel Canceled high