Error map
242 SQL Server Msg 242: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
SQL · layer 5, Data
Centre: this error. First ring: errors it is linked with (9). 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.
Directly related (9)
SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245)
SQL Server tried to convert text to a number (often implicitly) and hit a non-numeric value.
Snowflake: Numeric value 'X' is not recognized
A text value couldn't be converted to a number while loading or casting.
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.
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.
SQL Server Msg 209: Ambiguous column name
A column exists in more than one table of the query and isn't qualified.
CASE expression returns mixed types: conversion failed / types cannot be matched
The branches of a CASE expression produce incompatible data types (text and number, date and string).
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.
SQL Server Msg 8114: Error converting data type varchar to numeric
A text value that isn't a valid number was converted to DECIMAL/NUMERIC.
ORA-01843: not a valid month
A date string couldn't be parsed because the month part doesn't match the expected format.
Two steps away (27)
ERROR: invalid input syntax for type integer: "abc"
A string couldn’t be converted to the column’s type (integer, numeric, boolean, date…).
SQL Server: Login failed for user 'x'. (Error 18456)
SQL Server rejected the login — wrong password, wrong authentication mode, or a disabled/missing login.
SQL Server: Invalid object name 'x'. (Msg 208)
The table/view doesn’t exist in the current database or schema.
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.
Snowflake: No active warehouse selected in the current session
The query needs compute, but the session has no warehouse set or usable.
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.
MySQL ERROR 1062 (23000): Duplicate entry for key
An INSERT/UPDATE would create a duplicate value in a PRIMARY or UNIQUE key.
MySQL ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
You inserted/updated a row whose foreign key value doesn’t exist in the referenced parent table.
PostgreSQL: ERROR: duplicate key value violates unique constraint
An INSERT/UPDATE would create a duplicate in a UNIQUE or PRIMARY KEY column — or the id sequence is behind the existing data.
Windows Error 0x80070005 (E_ACCESSDENIED): Access is denied
Windows refused an operation because the account or process lacks permission — seen in Windows Update, installers, Task Scheduler…
user is not in the sudoers file. This incident will be reported.
Your account isn’t allowed to use sudo.
java.nio.file.AccessDeniedException: /path
The OS denied a file operation to the Java process.
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.
MySQL ERROR 1066 (42000): Not unique table/alias: 'x'
The same table or alias appears twice in a FROM/JOIN without distinct aliases.
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.
AttributeError: 'X' object has no attribute 'y'
You accessed an attribute or method that doesn’t exist on that object type.
java.lang.ClassCastException: class A cannot be cast to class B
An object was cast to a type it isn’t.
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.
java.time.format.DateTimeParseException: Text '31/12/2024' could not be parsed at index 2
A java.time parse call got text that doesn’t match the expected format.
java.text.ParseException: Unparseable date: "x"
SimpleDateFormat couldn’t parse the string with its pattern.
MySQL ERROR 1292 (22007): Incorrect datetime value: 'x' for column 'y'
A string couldn’t be converted to DATE/DATETIME — wrong format, empty string, or a zero date in strict mode.
SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115)
A value or calculation exceeds the target data type’s range.
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".
GROUP_CONCAT / STRING_AGG result truncated or fails (group_concat_max_len, string length limit)
An aggregated string is cut off at 1024 characters (MySQL) or fails with a size error (SQL Server STRING_AGG, 8000 bytes).
ERROR: date/time field value out of range: "31/12/2024" — HINT: Perhaps you need a different "datestyle" setting.
PostgreSQL parsed a date in the wrong order (DMY vs MDY) or got an impossible value.
ORA-00001: unique constraint (SCHEMA.PK_X) violated
An insert/update duplicated a value in a unique or primary key constraint.
ORA-00018: maximum number of sessions exceeded
The database reached its SESSIONS limit, so no new connection can be created.
Map another error
Popular: 500400403ORA-009331064Critical errorFileNotFoundException assemblyTypeError