Error map
ORA-01861 ORA-01861: literal does not match format string
SQL · layer 5, Data
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.
Directly related (11)
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-01722: invalid number
Oracle tried to convert a string to a number and failed.
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-00001: unique constraint (SCHEMA.PK_X) violated
An insert/update duplicated a value in a unique or primary key constraint.
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.
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-00018: maximum number of sessions exceeded
The database reached its SESSIONS limit, so no new connection can be created.
ORA-00020: maximum number of processes (150) exceeded
The instance reached its PROCESSES limit, so new connections are refused.
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-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)
RangeError: Invalid time value
A Date is invalid (NaN), and toISOString() or a formatting library couldn’t format it.
MySQL ERROR 1690 (22003): BIGINT UNSIGNED value is out of range
Arithmetic on UNSIGNED columns produced a negative result.
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: String or binary data would be truncated in table 'x', column 'y'. (Msg 2628)
A value is longer than the column allows.
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.
SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115)
A value or calculation exceeds the target data type’s range.
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.
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.
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…
MySQL ERROR 1062 (23000): Duplicate entry for key
An INSERT/UPDATE would create a duplicate value in a PRIMARY or UNIQUE key.
sqlite3.IntegrityError: UNIQUE constraint failed: users.email
An insert/update duplicated a value in a UNIQUE or PRIMARY KEY column in SQLite.
sqlite3.IntegrityError: NOT NULL constraint failed: table.column
A NULL went into a NOT NULL column in SQLite.
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.
java.util.InputMismatchException (Scanner)
Scanner.nextInt()/nextDouble() read a token that isn’t that type.
ValueError: invalid literal for int() with base 10: 'abc'
int() received a string that isn’t a whole number — empty, decimal, whitespace or text.
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.
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…
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.
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.
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 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.
AWS: ExpiredToken — The security token included in the request is expired
Temporary AWS credentials (STS/SSO/assumed role) have expired.
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-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.
Error: listen EADDRINUSE: address already in use :::3000
Another process is already listening on that port.
Error: write EPIPE
Node wrote to a pipe or socket whose other end was already closed.
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-01017: invalid username/password; logon denied
Oracle rejected the credentials.
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-12541: TNS:no listener
Nothing listens on the Oracle host/port — the listener is down or you have the wrong port.
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.
Map another error
Popular: 500400403ORA-009331064Critical errorFileNotFoundException assemblyTypeError