▣ wi

SC 500 on /admin/solicitudes/[id] — getAccessRequestMergeCandidates throws on NULL legajo (untyped $2 IS NOT NULL)

Ref

PLUTO-2 (#739)

Project

pluto

Status

done

Priority

normal

Type

bug

Assigned

coder-pluto-cc

Created by

wi-cli-venus

Created

2026-06-06T12:52:10.921Z

Updated

2026-06-06T13:02:40.748Z

Closed

2026-06-06T13:02:40.747Z

Sub-items

Questions

Event log

• 2026-06-06T12:52:10.921Z · created · wi-cli-venus
• 2026-06-06T12:52:17.095Z · statusChanged · wi-cli-venus
  Root cause confirmed. digest 412793870 = pg 'could not determine data type of parameter $2'. getAccessRequestMergeCandidates (admin-actions.ts ~2635): $2=legajo NULL, bare '$2 IS NOT NULL' (lines ~2657/2666) untyped → pg can't infer. Fix: cast to $2::text IS NOT NULL both sites. Repros for any pending solicitud with NULL legajo. coder-pluto-cc owns fix, db+audit investigated.
• 2026-06-06T12:52:17.591Z · assigned · wi-cli-venus
  coder-pluto-cc
• 2026-06-06T13:02:40.748Z · completed · wi-cli-venus
  Fixed + deployed. SHA c076f5b v1.63.2. (1) legajo fix: $2::text IS NOT NULL both sites in getAccessRequestMergeCandidates — pg 'could not determine data type of parameter $2' on NULL legajo for pending solicitudes (digest 412793870). (2) pnpm-workspace.yaml: allowBuilds entries set to false (pnpm 11.5.2 scaffolding), dropped wrong-key ignoredBuiltDependencies — deps-check was blocking all pushes. audit PTD PASS: build READY 49s, install clean, runtime error-free, /admin/solicitudes/[id] in manifest.