Error map

8114 SQL Server Msg 8114: Error converting data type varchar to numeric

SQL · layer 5, Data

Open the full error page →

Centre: this error. First ring: errors it is linked with (8). Outer ring: what those are linked with. Colours show the layer of a request each error belongs to. Click any dot to re-centre the map on it; hover to follow its connections. The centre dot opens the error page.

8114 — SQL Server Msg 8114: Error converting data type varchar to numeric (SQL)8114245 — SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245) (SQL)2458115 — SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115) (SQL)8115100038 — Snowflake: Numeric value 'X' is not recognized (SQL)100038sorting — Numbers sort wrongly (1, 10, 2): VARCHAR column sorted as text (SQL)sorting209 — SQL Server Msg 209: Ambiguous column name (SQL)209CASE — CASE expression returns mixed types: conversion failed / types cannot be matched (SQL)CASE242 — SQL Server Msg 242: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value (SQL)242GROUP_CONCAT — GROUP_CONCAT / STRING_AGG result truncated or fails (group_concat_max_len, string length limit) (SQL)GROUP_CONCAT22P02 — ERROR: invalid input syntax for type integer: "abc" (PostgreSQL)22P0218456 — SQL Server: Login failed for user 'x'. (Error 18456) (SQL)18456208 — SQL Server: Invalid object name 'x'. (Msg 208) (SQL)20822003 — ERROR: numeric field overflow — A field with precision 5, scale 2 must round to an absolute value less than 10^3 (PostgreSQL)22003207 — SQL Server: Invalid column name 'x'. (Msg 207) (SQL)2072627 — SQL Server: Violation of PRIMARY KEY constraint 'x'. Cannot insert duplicate key in object 'y'. (Msg 2627) (SQL)2627002003 — Snowflake SQL compilation error: Object 'X' does not exist or not authorized (SQL)002003000606 — Snowflake: No active warehouse selected in the current session (SQL)000606load job — BigQuery load job failed: schema mismatch / Provided Schema does not match table (Google Cloud / Firebase)load jobcartesian — Query returns far too many rows: accidental Cartesian product (missing JOIN condition) (SQL)cartesianinteger division — 5 / 2 = 2: integer division silently truncates the result (SQL)integer divisionCOUNT — COUNT(column) ignores NULLs: counts differ from COUNT(*) (SQL)COUNTambiguous column — Column reference is ambiguous / Column 'id' in field list is ambiguous (MySQL 1052) (SQL)ambiguous column1066 — MySQL ERROR 1066 (42000): Not unique table/alias: 'x' (SQL)1066LEFT JOIN — LEFT JOIN returns fewer rows: a WHERE filter on the right table turns it into an INNER JOIN (SQL)LEFT JOINAttributeError — AttributeError: 'X' object has no attribute 'y' (Python)AttributeErrorClassCastException — java.lang.ClassCastException: class A cannot be cast to class B (Java)ClassCastExceptionERR_INVALID_ARG_TYPE — TypeError [ERR_INVALID_ARG_TYPE]: The "path" argument must be of type string. Received undefined (Node.js)ERR_INVALID_ARG_TYPEdate format — Dates mixed up: dd/mm/yyyy vs mm/dd/yyyy, ISO 8601 recommended (SQL)date format515 — SQL Server Msg 515: Cannot insert the value NULL into column 'X', table 'Y'; column does not allow nulls (SQL)5155123 — SQL Server Msg 5123: CREATE FILE encountered operating system error 5 (Access is denied) while attempting to open the physical file (SQL)51231406 — MySQL ERROR 1406: Data too long for column (MySQL)1406

Directly related (8)

Two steps away (22)

22P02PostgreSQL

ERROR: invalid input syntax for type integer: "abc"

A string couldn’t be converted to the column’s type (integer, numeric, boolean, date…).

18456SQL

SQL Server: Login failed for user 'x'. (Error 18456)

SQL Server rejected the login — wrong password, wrong authentication mode, or a disabled/missing login.

208SQL

SQL Server: Invalid object name 'x'. (Msg 208)

The table/view doesn’t exist in the current database or schema.

22003PostgreSQL

ERROR: numeric field overflow — A field with precision 5, scale 2 must round to an absolute value less than 10^3

A number doesn’t fit the column’s numeric(precision, scale) or integer range.

207SQL

SQL Server: Invalid column name 'x'. (Msg 207)

SQL Server can’t find the column — typo, missing migration, or a string in double quotes with QUOTED_IDENTIFIER ON.

2627SQL

SQL Server: Violation of PRIMARY KEY constraint 'x'. Cannot insert duplicate key in object 'y'. (Msg 2627)

An insert duplicated a primary key or unique constraint value.

002003SQL

Snowflake SQL compilation error: Object 'X' does not exist or not authorized

The table/view/schema name can't be resolved in the current role, database and schema context, or the role lacks privileges.

000606SQL

Snowflake: No active warehouse selected in the current session

The query needs compute, but the session has no warehouse set or usable.

load jobGoogle Cloud / Firebase

BigQuery load job failed: schema mismatch / Provided Schema does not match table

A load job's file schema or column types don't match the destination table.

cartesianSQL

Query returns far too many rows: accidental Cartesian product (missing JOIN condition)

Two tables were joined without a condition, so every row of one pairs with every row of the other.

integer divisionSQL

5 / 2 = 2: integer division silently truncates the result

Dividing two integers returns an integer in most databases, so decimals are dropped.

COUNTSQL

COUNT(column) ignores NULLs: counts differ from COUNT(*)

`COUNT(col)` counts only non-NULL values, while `COUNT(*)` counts rows, so totals don't match.

ambiguous columnSQL

Column reference is ambiguous / Column 'id' in field list is ambiguous (MySQL 1052)

A column name exists in more than one joined table, so the database doesn’t know which one you mean.

1066SQL

MySQL ERROR 1066 (42000): Not unique table/alias: 'x'

The same table or alias appears twice in a FROM/JOIN without distinct aliases.

LEFT JOINSQL

LEFT JOIN returns fewer rows: a WHERE filter on the right table turns it into an INNER JOIN

A condition on the right-hand table in WHERE removes the NULL-extended rows that a LEFT JOIN was supposed to keep.

AttributeErrorPython

AttributeError: 'X' object has no attribute 'y'

You accessed an attribute or method that doesn’t exist on that object type.

ClassCastExceptionJava

java.lang.ClassCastException: class A cannot be cast to class B

An object was cast to a type it isn’t.

ERR_INVALID_ARG_TYPENode.js

TypeError [ERR_INVALID_ARG_TYPE]: The "path" argument must be of type string. Received undefined

A Node API got an argument of the wrong type — usually undefined because an env var or config value is missing.

date formatSQL

Dates mixed up: dd/mm/yyyy vs mm/dd/yyyy, ISO 8601 recommended

A date string like 03/04/2026 is read as March 4th or April 3rd depending on locale, so rows get wrong dates or conversion errors.

515SQL

SQL Server Msg 515: Cannot insert the value NULL into column 'X', table 'Y'; column does not allow nulls

An INSERT or UPDATE tried to put NULL into a NOT NULL column that has no default.

5123SQL

SQL Server Msg 5123: CREATE FILE encountered operating system error 5 (Access is denied) while attempting to open the physical file

SQL Server's service account can't read or write the .mdf/.ldf file when attaching or restoring.

1406MySQL

MySQL ERROR 1406: Data too long for column

The value is longer than the column allows (e.g. 300 characters into VARCHAR(255)), and strict mode rejects it instead of truncat…