{"summary":"Referee sync is blocked at NOT_STARTED (NO_SYNC_ATTEMPT): No referee assignments are stored locally and sync-referees has never been called for this game (no record in referee_sync_status).","processDiagnosis":{"currentStep":"NOT_STARTED","status":"NO_SYNC_ATTEMPT","humanMessage":"No referee assignments are stored locally and sync-referees has never been called for this game (no record in referee_sync_status).","blockingReason":"Frontend async sync may have not fired, or the endpoint was not called.","nextAction":"Call POST /api/game/0042500226/sync-referees.","isFrontendIssue":true,"isBackendIssue":false,"isSourceIssue":false,"isDbIssue":false},"processTimeline":[{"step":"LOCAL_DB_LOOKUP","status":"DONE","details":"assignmentRows=0, joinedCrew=0, tablesOk=True"},{"step":"SOURCE_FETCH","status":"NOT_RUN","details":"sync-referees not called yet"},{"step":"SOURCE_PARSE","status":"NOT_RUN","details":"sync-referees not called yet"},{"step":"DB_UPSERT","status":"NOT_RUN","details":"sync-referees not called yet"},{"step":"DB_VERIFY","status":"NOT_RUN","details":"No assignment rows to verify"},{"step":"FRONTEND_RENDER","status":"NOT_RUN","details":"No crew available to render"}],"syncStatus":{"lastAttemptAt":null,"lastStatus":null,"lastError":"","lastStep":"NOT_STARTED","lastHumanMessage":"No referee assignments are stored locally and sync-referees has never been called for this game (no record in referee_sync_status).","source":"nba_api_v2","sourceUrl":"https://stats.nba.com/stats/boxscoresummaryv2?GameID=0042500226","rawAssignmentsFound":0,"parsedCrewCount":0,"recommendedAction":"POST /api/game/0042500226/sync-referees"},"syncResult":null,"gameId":"0042500226","db":{"path":"/opt/render/project/src/data/nba.db","exists":true},"tables":{"refereesExists":true,"gameRefereeAssignmentsExists":true},"assignmentRows":[],"joinedCrew":[],"refereeTableSample":[{"id":1,"referee_key":"tony-brothers","name":"Tony Brothers","jersey_number":"25"},{"id":2,"referee_key":"brian-forte","name":"Brian Forte","jersey_number":"45"},{"id":3,"referee_key":"eric-dalen","name":"Eric Dalen","jersey_number":"37"},{"id":4,"referee_key":"tyler-ford","name":"Tyler Ford","jersey_number":"39"},{"id":5,"referee_key":"scott-foster","name":"Scott Foster","jersey_number":"48"}],"metrics":{"id":126,"game_id":"0042500226","game_date":"2026-05-16","away_team_abbr":"OKC","home_team_abbr":"LAL","away_score":null,"home_score":null,"total_fouls":null,"away_fouls":null,"home_fouls":null,"foul_differential":null,"total_fta":null,"away_fta":null,"home_fta":null,"fta_differential":null,"technical_fouls":null,"offensive_fouls":null,"shooting_fouls":null,"loose_ball_fouls":null,"flagrant_fouls":null,"clutch_fouls":null,"clutch_fta":null,"away_fga":null,"home_fga":null,"away_ftr":null,"home_ftr":null,"possessions_estimated":null,"fouls_per_100":null,"source":"player_boxscores+team_boxscores","metrics_json":"{\"game_date\": \"2026-05-16\", \"away_team_abbr\": \"OKC\", \"home_team_abbr\": \"LAL\", \"away_score\": null, \"home_score\": null, \"metrics_status\": \"UNKNOWN\", \"source_game_status_id\": 1, \"total_fouls\": null, \"away_fouls\": null, \"home_fouls\": null, \"foul_differential\": null, \"total_fta\": null, \"away_fta\": null, \"home_fta\": null, \"fta_differential\": null, \"technical_fouls\": null, \"offensive_fouls\": null, \"shooting_fouls\": null, \"loose_ball_fouls\": null, \"flagrant_fouls\": null, \"clutch_fouls\": null, \"clutch_fta\": null, \"away_fga\": null, \"home_fga\": null, \"away_ftr\": null, \"home_ftr\": null, \"possessions_estimated\": null, \"fouls_per_100\": null, \"source\": \"player_boxscores+team_boxscores\"}","computed_at":"2026-05-27T15:42:55Z","created_at":"2026-05-27T15:42:55Z","updated_at":"2026-05-27T15:42:55Z","metrics_status":"UNKNOWN","source_game_status_id":1},"missingMetricFields":["total_fouls","total_fta"],"metricsDebug":{"metricsStatus":"MISSING","gameStatusId":1,"officialFinalScore":{"away":null,"home":null},"needsRecompute":true,"recommendedAction":"POST /api/game/0042500226/recompute-referee-metrics"},"assignmentDebug":{"assignmentRowsCount":0,"recommendedAction":"POST /api/game/0042500226/sync-referees"},"diagnosis":{"status":"NO_ASSIGNMENTS","reason":"Tables exist but no rows in game_referee_assignments for game_id='0042500226'. Call POST /api/game/0042500226/sync-referees to fetch from NBA API."},"sourceDebug":{"source":"nba_api_v2","sourceUrl":"https://stats.nba.com/stats/boxscoresummaryv2?GameID=0042500226","sourceAvailable":false,"rawAssignmentsFound":0,"parsedCrewCount":0,"matchedGameId":"0042500226"},"dbDebug":{"dbPath":"/opt/render/project/src/data/nba.db","writable":true,"assignmentCountForGame":0,"totalAssignmentRows":363}}