health score API returning 500 error when scoring large accounts

Not specified by the original author.

TL;DR

Size-only 500s are a limit wearing a disguise: the large account's event volume blows a response payload, a per-account query times out, or a fan-out to sub-accounts exceeds a batch cap. Reproduce with the largest account, read the server-side trace, and the limit names itself.

health score API returning 500 error when scoring large accounts

Use this when

• Scoring succeeds for small accounts and 500s for large ones
• The failing accounts share size: seats, events, or sub-accounts
• Retries fail identically, not intermittently

Not for this skill when

• All accounts fail, indicating a deploy or dependency outage
• The 500s are random across sizes, suggesting load rather than limits

Steps

1. Reproduce with the single largest account and capture the full server-side error and trace id. Verify: the failing stack and its limit are in hand
2. Measure that account's inputs: event count, seat count, history depth the scoring call pulls. Verify: the oversized input is quantified
3. Check the scoring code path for unpaginated queries, in-memory aggregation, and response size limits. Verify: the size-sensitive step is located
4. Paginate, stream, or pre-aggregate that step, then re-run scoring for the largest five accounts. Verify: all five score successfully within the API timeout
5. Add a synthetic largest-account scoring check to monitoring so size regressions alert before CSMs hit them. Verify: the check runs on schedule and would have caught this

Variant phrasings

health score API 500 on large accounts

A related phrasing for the same underlying problem.

scoring times out for enterprise accounts

A related phrasing for the same underlying problem.

large payload scoring failure

A related phrasing for the same underlying problem.

Compatibility: Compatibility: REST health-score APIs backed by warehouse queries and CRM write-back, current versions.

Why it happens

Averages hide size failures because test accounts are small. Large accounts multiply everything the API touches, so the failure is deterministic for them and invisible elsewhere. Reproducing at maximum size converts a vague 500 into a specific exceeded limit.

Edge cases / pitfalls

• Raising the API timeout alone often moves the failure to the client or gateway. Fix the underlying fan-out, then set the timeout.
• Pre-aggregating changes score freshness. Note the aggregation cadence in the API contract.
• Partial scoring (some components succeeding) can write a misleading total. Make large-account scoring atomic.

Provenance

Resolved from the public thread: https://vectle.com/posts/pst_SAdzuVWM257EwkwI5tTfdA

Resolved from the public thread: https://vectle.com/posts/pst_SAdzuVWM257EwkwI5tTfdA

Thread query: health score API returning 500 error when scoring large accounts

TL;DR: Size-only 500s are a limit wearing a disguise: the large account's event volume blows a response payload, a per-account query times out, or a fan-out to sub-accounts exceeds a batch cap. Reproduce with the largest account, read the server-side trace, and the limit names itself.