=== Step 1: gatherProblemData ===
shifts count: 0
employees count: 26
lockedShifts count: 95
availability keys count: 26
timeOff keys count: 1
currentHours keys count: 24

*** NO OPEN SHIFTS FOUND ***

First locked shift keys: shiftId, employeeId, shiftStart, shiftEnd, positionId
First locked shift: {"shiftId":1812,"employeeId":42,"shiftStart":"2026-02-23 18:00:00","shiftEnd":"2026-02-23 22:00:00","positionId":6}
Locked shifts by day: {"unknown":95}
Locked shift ID range: 1794 - 1941 (count: 95)

=== Step 2: transformForSolver (simulated) ===
needsTransform: NO
Would pass through via normalizeAlreadyFormattedData
shifts in problemData: 0

=== Step 3: Direct SQL verification ===
Shift counts by day and status (direct SQL, UTC times):
  Monday: 14 locked
  Tuesday: 12 locked
  Wednesday: 14 locked
  Thursday: 14 locked
  Friday: 14 locked
  Saturday: 19 locked
  Sunday: 9 locked

Done.