Error map

ORA-01861 ORA-01861: literal does not match format string

SQL · layer 5, Data

Open the full error page →

Centre: this error. First ring: errors it is linked with (11). 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.

ORA-01861 — ORA-01861: literal does not match format string (SQL)ORA-0186122008 — ERROR: date/time field value out of range: "31/12/2024" — HINT: Perhaps you need a different "datestyle" setting. (PostgreSQL)22008ORA-01722 — ORA-01722: invalid number (SQL)ORA-017221292 — MySQL ERROR 1292 (22007): Incorrect datetime value: 'x' for column 'y' (MySQL)1292ORA-00001 — ORA-00001: unique constraint (SCHEMA.PK_X) violated (SQL)ORA-00001DateTimeParseException — java.time.format.DateTimeParseException: Text '31/12/2024' could not be parsed at index 2 (Java)DateTimeParseExcept…Unparseable date — java.text.ParseException: Unparseable date: "x" (Java)Unparseable datedate format — Dates mixed up: dd/mm/yyyy vs mm/dd/yyyy, ISO 8601 recommended (SQL)date formatORA-00018 — ORA-00018: maximum number of sessions exceeded (SQL)ORA-00018ORA-00020 — ORA-00020: maximum number of processes (150) exceeded (SQL)ORA-00020ORA-00028 — ORA-00028: your session has been killed (SQL)ORA-00028ORA-01843 — ORA-01843: not a valid month (SQL)ORA-01843invalid time value — RangeError: Invalid time value (JavaScript)invalid time value1690 — MySQL ERROR 1690 (22003): BIGINT UNSIGNED value is out of range (MySQL)169022P02 — ERROR: invalid input syntax for type integer: "abc" (PostgreSQL)22P028152 / 2628 — SQL Server: String or binary data would be truncated in table 'x', column 'y'. (Msg 2628) (SQL)8152 / 2628245 — 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)81151264 — 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)1366invalid_type — API Error: Invalid type — expected integer, received string (API)invalid_type1062 — MySQL ERROR 1062 (23000): Duplicate entry for key (MySQL)1062SQLite UNIQUE failed — sqlite3.IntegrityError: UNIQUE constraint failed: users.email (SQL)SQLite UNIQUE failedSQLite NOT NULL failed — sqlite3.IntegrityError: NOT NULL constraint failed: table.column (SQL)SQLite NOT NULL fai…NumberFormatException — java.lang.NumberFormatException: For input string: "x" (Java)NumberFormatExcepti…InputMismatchException — java.util.InputMismatchException (Scanner) (Java)InputMismatchExcept…ValueError — ValueError: invalid literal for int() with base 10: 'abc' (Python)ValueErrorinvalid_date — API Error: Invalid date format — expected ISO 8601 (YYYY-MM-DDTHH:mm:ssZ) (API)invalid_dateInput string was not in a correct format — System.FormatException: Input string was not in a correct format (.NET)Input string was no…error 9 — openssl verify error:num=9:certificate is not yet valid (SSL / TLS)error 9Setting locale failed — perl: warning: Setting locale failed / bash: warning: setlocale: LC_ALL: cannot change locale (Linux)Setting locale fail…= NULL — WHERE col = NULL returns no rows (use IS NULL) (SQL)= NULLNOT IN — NOT IN (subquery) returns no rows because the subquery contains NULL (SQL)NOT INExpiredToken — AWS: ExpiredToken — The security token included in the request is expired (AWS)ExpiredTokensession_start() — Warning: session_start(): Session cannot be started after headers have already been sent (PHP)session_start()ORA-00942 — ORA-00942: table or view does not exist (SQL)ORA-00942EADDRINUSE — Error: listen EADDRINUSE: address already in use :::3000 (Node.js)EADDRINUSEEPIPE — Error: write EPIPE (Node.js)EPIPEmaxBuffer exceeded — RangeError [ERR_CHILD_PROCESS_STDIO_MAXBUFFER]: stdout maxBuffer length exceeded (Node.js)maxBuffer exceededORA-01017 — ORA-01017: invalid username/password; logon denied (SQL)ORA-01017ORA-12154 — ORA-12154: TNS:could not resolve the connect identifier specified (SQL)ORA-12154ORA-12541 — ORA-12541: TNS:no listener (SQL)ORA-12541242 — SQL Server Msg 242: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value (SQL)242

Directly related (11)

22008PostgreSQL

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-01722SQL

ORA-01722: invalid number

Oracle tried to convert a string to a number and failed.

1292MySQL

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.

ORA-00001SQL

ORA-00001: unique constraint (SCHEMA.PK_X) violated

An insert/update duplicated a value in a unique or primary key constraint.

DateTimeParseExceptionJava

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.

Unparseable dateJava

java.text.ParseException: Unparseable date: "x"

SimpleDateFormat couldn’t parse the string with its pattern.

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.

ORA-00018SQL

ORA-00018: maximum number of sessions exceeded

The database reached its SESSIONS limit, so no new connection can be created.

ORA-00020SQL

ORA-00020: maximum number of processes (150) exceeded

The instance reached its PROCESSES limit, so new connections are refused.

ORA-00028SQL

ORA-00028: your session has been killed

An administrator, a resource limit or a profile terminated your session while it was idle or running.

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.

Two steps away (31)

invalid time valueJavaScript

RangeError: Invalid time value

A Date is invalid (NaN), and toISOString() or a formatting library couldn’t format it.

1690MySQL

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

Arithmetic on UNSIGNED columns produced a negative result.

22P02PostgreSQL

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

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

8152 / 2628SQL

SQL Server: String or binary data would be truncated in table 'x', column 'y'. (Msg 2628)

A value is longer than the column allows.

245SQL

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.

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.

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.

invalid_typeAPI

API Error: Invalid type — expected integer, received string

A request field has the wrong data type — a string where the API expects a number, a number where it expects a boolean, an object…

1062MySQL

MySQL ERROR 1062 (23000): Duplicate entry for key

An INSERT/UPDATE would create a duplicate value in a PRIMARY or UNIQUE key.

SQLite UNIQUE failedSQL

sqlite3.IntegrityError: UNIQUE constraint failed: users.email

An insert/update duplicated a value in a UNIQUE or PRIMARY KEY column in SQLite.

SQLite NOT NULL failedSQL

sqlite3.IntegrityError: NOT NULL constraint failed: table.column

A NULL went into a NOT NULL column in SQLite.

NumberFormatExceptionJava

java.lang.NumberFormatException: For input string: "x"

A string couldn’t be parsed as a number — it’s empty, has spaces/commas, is too large, or isn’t numeric.

InputMismatchExceptionJava

java.util.InputMismatchException (Scanner)

Scanner.nextInt()/nextDouble() read a token that isn’t that type.

ValueErrorPython

ValueError: invalid literal for int() with base 10: 'abc'

int() received a string that isn’t a whole number — empty, decimal, whitespace or text.

invalid_dateAPI

API Error: Invalid date format — expected ISO 8601 (YYYY-MM-DDTHH:mm:ssZ)

A date or timestamp in the request isn’t in the format the API expects — usually ISO 8601 with a time zone, or a Unix timestamp.

Input string was not in a correct format.NET

System.FormatException: Input string was not in a correct format

int.Parse/decimal.Parse/Convert.ToInt32 got a string that isn’t a valid number — empty, contains text, or uses another culture’s…

error 9SSL / TLS

openssl verify error:num=9:certificate is not yet valid

The certificate's notBefore date is in the future from the verifier's point of view.

Setting locale failedLinux

perl: warning: Setting locale failed / bash: warning: setlocale: LC_ALL: cannot change locale

Your session asks for a locale (often forwarded by SSH from your Mac/PC) that isn’t generated on the server.

= NULLSQL

WHERE col = NULL returns no rows (use IS NULL)

Comparing anything to NULL with = or never matches, because the result is UNKNOWN, not true.

NOT INSQL

NOT IN (subquery) returns no rows because the subquery contains NULL

If the list or subquery for NOT IN contains a single NULL, the whole condition is UNKNOWN and no rows come back.

ExpiredTokenAWS

AWS: ExpiredToken — The security token included in the request is expired

Temporary AWS credentials (STS/SSO/assumed role) have expired.

session_start()PHP

Warning: session_start(): Session cannot be started after headers have already been sent

session_start() ran after output was sent, so PHP can’t set the session cookie.

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.

EADDRINUSENode.js

Error: listen EADDRINUSE: address already in use :::3000

Another process is already listening on that port.

EPIPENode.js

Error: write EPIPE

Node wrote to a pipe or socket whose other end was already closed.

maxBuffer exceededNode.js

RangeError [ERR_CHILD_PROCESS_STDIO_MAXBUFFER]: stdout maxBuffer length exceeded

child_process.exec/execSync produced more output than its buffer allows (default 1 MB).

ORA-01017SQL

ORA-01017: invalid username/password; logon denied

Oracle rejected the credentials.

ORA-12154SQL

ORA-12154: TNS:could not resolve the connect identifier specified

The Oracle client couldn’t find the alias in tnsnames.ora (or the naming method can’t resolve it).

ORA-12541SQL

ORA-12541: TNS:no listener

Nothing listens on the Oracle host/port — the listener is down or you have the wrong port.

242SQL

SQL Server Msg 242: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

A date string couldn't be converted because it's invalid or in the wrong format for the session language.