Error map

100038 Snowflake: Numeric value 'X' is not recognized

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.

100038 — Snowflake: Numeric value 'X' is not recognized (SQL)100038245 — SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245) (SQL)24522P02 — ERROR: invalid input syntax for type integer: "abc" (PostgreSQL)22P02002003 — Snowflake SQL compilation error: Object 'X' does not exist or not authorized (SQL)002003load job — BigQuery load job failed: schema mismatch / Provided Schema does not match table (Google Cloud / Firebase)load jobCASE — CASE expression returns mixed types: conversion failed / types cannot be matched (SQL)CASE8114 — SQL Server Msg 8114: Error converting data type varchar to numeric (SQL)8114000606 — Snowflake: No active warehouse selected in the current session (SQL)000606242 — SQL Server Msg 242: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value (SQL)24218456 — SQL Server: Login failed for user 'x'. (Error 18456) (SQL)18456208 — SQL Server: Invalid object name 'x'. (Msg 208) (SQL)208207 — SQL Server: Invalid column name 'x'. (Msg 207) (SQL)2071264 — MySQL ERROR 1264 (22003): Out of range value for column 'x' at row 1 (MySQL)12641366 — MySQL ERROR 1366 (HY000): Incorrect integer value: '' for column 'x' at row 1 (MySQL)13661690 — MySQL ERROR 1690 (22003): BIGINT UNSIGNED value is out of range (MySQL)1690readonly database — sqlite3.OperationalError: attempt to write a readonly database (SQL)readonly database5123 — SQL Server Msg 5123: CREATE FILE encountered operating system error 5 (Access is denied) while attempting to open the physical file (SQL)5123229 — SQL Server Msg 229: The SELECT permission was denied on the object (SQL)229SQLite no such column — sqlite3.OperationalError: no such column: x (SQL)SQLite no such colu…ORA-00942 — ORA-00942: table or view does not exist (SQL)ORA-00942ORA-00904 — ORA-00904: "X": invalid identifier (SQL)ORA-00904AttributeError — 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_TYPE8115 — SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115) (SQL)8115sorting — Numbers sort wrongly (1, 10, 2): VARCHAR column sorted as text (SQL)sorting209 — SQL Server Msg 209: Ambiguous column name (SQL)209aggregate in WHERE — ERROR: aggregate functions are not allowed in WHERE (use HAVING) / MySQL 1111 Invalid use of group function (SQL)aggregate in WHEREpool timeout — Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. All pooled connections were in use and max pool size was reached. (SQL)pool timeoutcartesian — Query returns far too many rows: accidental Cartesian product (missing JOIN condition) (SQL)cartesiandate 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)515ORA-01843 — ORA-01843: not a valid month (SQL)ORA-01843

Directly related (8)

Two steps away (24)

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.

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.

1264MySQL

MySQL ERROR 1264 (22003): Out of range value for column 'x' at row 1

A number is too large (or negative for UNSIGNED) for the column type.

1366MySQL

MySQL ERROR 1366 (HY000): Incorrect integer value: '' for column 'x' at row 1

An empty string or non-numeric text was inserted into an INT column under strict mode.

1690MySQL

MySQL ERROR 1690 (22003): BIGINT UNSIGNED value is out of range

Arithmetic on UNSIGNED columns produced a negative result.

readonly databaseSQL

sqlite3.OperationalError: attempt to write a readonly database

The process can’t write to the SQLite file or its directory.

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.

229SQL

SQL Server Msg 229: The SELECT permission was denied on the object

The login's user lacks the permission on that table, view or procedure.

SQLite no such columnSQL

sqlite3.OperationalError: no such column: x

SQLite can’t find the column — missing migration, typo, or a string written in double quotes.

ORA-00942SQL

ORA-00942: table or view does not exist

Oracle can’t see the table — it doesn’t exist, is in another schema, or you lack privileges on it.

ORA-00904SQL

ORA-00904: "X": invalid identifier

A column name in the statement doesn’t exist (or is misquoted).

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.

8115SQL

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

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

sortingSQL

Numbers sort wrongly (1, 10, 2): VARCHAR column sorted as text

A numeric-looking column stored as text sorts alphabetically, so "10" comes before "2".

209SQL

SQL Server Msg 209: Ambiguous column name

A column exists in more than one table of the query and isn't qualified.

aggregate in WHERESQL

ERROR: aggregate functions are not allowed in WHERE (use HAVING) / MySQL 1111 Invalid use of group function

An aggregate (SUM, COUNT, AVG) was used in WHERE, which filters rows before grouping.

pool timeoutSQL

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. All pooled connections were in use and max pool size was reached.

The application’s connection pool was exhausted — all connections busy or leaked.

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.

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.

ORA-01843SQL

ORA-01843: not a valid month

A date string couldn't be parsed because the month part doesn't match the expected format.