{"record":{"id":"1f823aea24e0559c","repo":"BerriAI/litellm","slug":"failed-to-fetch-wau-analytics-e","errorCode":null,"errorMessage":"Failed to fetch WAU analytics: {e}","messagePattern":"Failed to fetch WAU analytics: (.+?)","errorType":"http","errorClass":"HTTPException","httpStatus":500,"severity":"error","filePath":"litellm/proxy/management_endpoints/user_agent_analytics_endpoints.py","lineNumber":420,"sourceCode":"        \"\"\"\n\n        db_response: Final = _ACTIVE_USERS_ROWS.validate_python(await _query_raw(prisma_client, sql_query, *params))\n\n        results: Final = [\n            TagActiveUsersResponse(\n                tag=row.tag,\n                active_users=row.active_users,\n                date=row.date,  # This will be \"Week 1 (Jan 15)\", \"Week 2 (Jan 8)\", etc.\n                period_start=row.period_start,\n                period_end=row.period_end,\n            )\n            for row in db_response\n        ]\n\n        return ActiveUsersAnalyticsResponse(results=results)\n\n    except Exception as e:\n        raise HTTPException(\n            status_code=500,\n            detail=f\"Failed to fetch WAU analytics: {e}\",\n        )\n\n\n@router.get(\n    \"/tag/mau\",\n    response_model=ActiveUsersAnalyticsResponse,\n    tags=[\"tag management\", \"user agent analytics\"],\n    dependencies=[Depends(user_api_key_auth)],\n)\nasync def get_monthly_active_users(\n    tag_filter: str | None = Query(\n        default=None,\n        description=\"Filter by specific tag (optional)\",\n    ),\n    tag_filters: list[str] | None = Query(\n        default=None,","sourceCodeStart":402,"sourceCodeEnd":438,"githubUrl":"https://github.com/BerriAI/litellm/blob/77b7c6c40c0c5aa5fbcb1d6a1825ac39ca8829b8/litellm/proxy/management_endpoints/user_agent_analytics_endpoints.py#L402-L438","documentation":"HTTPException wrapping any unexpected exception while computing weekly-active-user (WAU) analytics from the tag-spend/verification-token join — query failures, validation errors on returned rows, or date-bucketing problems. The exception text is embedded and the WAU endpoint aborts.","triggerScenarios":"Thrown at litellm/proxy/management_endpoints/user_agent_analytics_endpoints.py:420 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":["Check the embedded error and proxy logs; verify the database connection and date parameters, then retry."],"exampleFix":null,"handlingStrategy":"try-catch","validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"77b7c6c40c0c5aa5fbcb1d6a1825ac39ca8829b8","analyzedAt":"2026-08-18T11:44:31.656Z","contentChangedAt":null,"schemaVersion":2},"datasetVersion":"2026-09-14T00:17:10.932Z"}