8115 🗃️ SQL

SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115)

A value or calculation exceeds the target data type’s range.

Seen on: SQL

Meaning

SUM/COUNT over large data exceeding int, numeric precision too small, or converting large numbers into smaller types.

Common causes

  • SUM of int values exceeding 2,147,483,647
  • numeric(p,s) too small
  • Converting large values to smaller types

⚡ Quick fix

  1. Cast to bigint before aggregating
  2. Use COUNT_BIG
  3. Increase numeric precision

Detailed fix by platform

SQL

  1. SELECT SUM(CAST(Amount AS bigint)) FROM dbo.Payments;

How to diagnose

  1. Expression — Which conversion/aggregate?
  2. Recent change — Did it start after a deploy, upgrade, or configuration change? Compare with the last working version.

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.