Error map

ORA-00904 ORA-00904: "X": invalid identifier

SQL · layer 5, Data

Open the full error page →

Centre: this error. First ring: errors it is linked with (12). 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-00904 — ORA-00904: "X": invalid identifier (SQL)ORA-00904ORA-00942 — ORA-00942: table or view does not exist (SQL)ORA-00942ORA-01017 — ORA-01017: invalid username/password; logon denied (SQL)ORA-01017ORA-01722 — ORA-01722: invalid number (SQL)ORA-01722ORA-00001 — ORA-00001: unique constraint (SCHEMA.PK_X) violated (SQL)ORA-00001ORA-00054 — ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired (SQL)ORA-00054ORA-12154 — ORA-12154: TNS:could not resolve the connect identifier specified (SQL)ORA-12154Document failed validation — MongoDB: MongoServerError: Document failed validation (code 121) (MongoDB)Document failed val…208 — SQL Server: Invalid object name 'x'. (Msg 208) (SQL)208207 — SQL Server: Invalid column name 'x'. (Msg 207) (SQL)207ORA-00933 — ORA-00933: SQL command not properly ended (SQL)ORA-00933ORA-06512 — ORA-06512: at "SCHEMA.PROC", line N (SQL)ORA-06512ORA-12514 — ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (SQL)ORA-125141146 — MySQL ERROR 1146 (42S02): Table 'db.table' doesn't exist (MySQL)1146SQLite no such column — sqlite3.OperationalError: no such column: x (SQL)SQLite no such colu…ORA-01400 — ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE"."COLUMN") (SQL)ORA-014001045 — MySQL ERROR 1045 (28000): Access denied for user (MySQL)10451698 — MySQL ERROR 1698 (28000): Access denied for user 'root'@'localhost' (MySQL)1698role does not exist — FATAL: role "x" does not exist (PostgreSQL)role does not exist8152 / 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)81151062 — 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…Deadlock — Deadlock found when trying to get lock; try restarting transaction (SQL)DeadlockLock wait timeout — Lock wait timeout exceeded; try restarting transaction (MySQL 1205) (SQL)Lock wait timeout1213 — MySQL ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction (MySQL)1213Network-related error — SQL Server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. (provider: Named Pipes Provider, error: 40 / TCP Provider, error: 26) (SQL)Network-related err…ORA-12541 — ORA-12541: TNS:no listener (SQL)ORA-12541ORA-12505 — ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (SQL)ORA-125051054 — MySQL ERROR 1054 (42S22): Unknown column in 'field list' (MySQL)105442P01 — PostgreSQL: ERROR: relation "x" does not exist (PostgreSQL)42P01422 — HTTP 422 Unprocessable Content (HTTP)422544 — SQL Server: Cannot insert explicit value for identity column in table 'x' when IDENTITY_INSERT is set to OFF. (SQL)544certificate chain not trusted — SQL Server: The certificate chain was issued by an authority that is not trusted. (SQL)certificate chain n…additionalProperties — API Error: Request failed schema validation (must NOT have additional properties / Additional properties are not allowed) (API)additionalPropertiesExecution Timeout Expired — SQL Server: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (SQL)Execution Timeout E…1064 — MySQL ERROR 1064 (42000): You have an error in your SQL syntax (MySQL)1064ambiguous column — Column reference is ambiguous / Column 'id' in field list is ambiguous (MySQL 1052) (SQL)ambiguous columnGROUP BY — Column must appear in the GROUP BY clause / isn't in GROUP BY (MySQL 1055 only_full_group_by) (SQL)GROUP BY

Directly related (12)

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

ORA-01017: invalid username/password; logon denied

Oracle rejected the credentials.

ORA-01722SQL

ORA-01722: invalid number

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

ORA-00001SQL

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

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

ORA-00054SQL

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

DDL or a NOWAIT lock couldn’t get the lock because another session holds it.

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).

Document failed validationMongoDB

MongoDB: MongoServerError: Document failed validation (code 121)

The collection has a JSON Schema validator and the inserted/updated document doesn’t satisfy it.

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.

ORA-00933SQL

ORA-00933: SQL command not properly ended

Oracle found extra clauses or syntax it doesn’t support at the end of a statement.

ORA-06512SQL

ORA-06512: at "SCHEMA.PROC", line N

A stack-trace line from PL/SQL — the real error is the ORA- code above it.

ORA-12514SQL

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

The listener is up but doesn’t know the service name you requested.

Two steps away (28)

1146MySQL

MySQL ERROR 1146 (42S02): Table 'db.table' doesn't exist

The query references a table that MySQL can’t find in that database.

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

ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE"."COLUMN")

A NULL was inserted into a NOT NULL column.

1045MySQL

MySQL ERROR 1045 (28000): Access denied for user

MySQL rejected the login — wrong password, wrong user/host combination, or the user doesn’t exist.

1698MySQL

MySQL ERROR 1698 (28000): Access denied for user 'root'@'localhost'

root uses the auth_socket/unix_socket plugin (Ubuntu/Debian default), so password logins as root fail.

role does not existPostgreSQL

FATAL: role "x" does not exist

PostgreSQL has no login role with that name.

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.

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.

DeadlockSQL

Deadlock found when trying to get lock; try restarting transaction

Two transactions waited on each other’s locks; the database killed one so the other could continue.

Lock wait timeoutSQL

Lock wait timeout exceeded; try restarting transaction (MySQL 1205)

A query waited too long for a row lock held by another transaction and gave up.

1213MySQL

MySQL ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction

MySQL detected a deadlock between two transactions and rolled one back.

Network-related errorSQL

SQL Server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. (provider: Named Pipes Provider, error: 40 / TCP Provider, error: 26)

The client couldn’t reach the SQL Server instance — wrong server name/instance, TCP disabled, firewall, or SQL Browser not runnin…

ORA-12541SQL

ORA-12541: TNS:no listener

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

ORA-12505SQL

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

The connect string uses a SID the listener doesn’t know — often a service name passed as SID.

1054MySQL

MySQL ERROR 1054 (42S22): Unknown column in 'field list'

The query references a column that doesn’t exist in the table (or an unquoted string being read as a column).

42P01PostgreSQL

PostgreSQL: ERROR: relation "x" does not exist

The table/view isn’t found — missing migration, wrong schema, or a case-sensitive quoted name.

422HTTP

HTTP 422 Unprocessable Content

The request is well-formed, but the data fails validation (e.g. invalid email, missing required field).

544SQL

SQL Server: Cannot insert explicit value for identity column in table 'x' when IDENTITY_INSERT is set to OFF.

An INSERT supplied a value for an IDENTITY column.

certificate chain not trustedSQL

SQL Server: The certificate chain was issued by an authority that is not trusted.

The client requires an encrypted connection and doesn’t trust SQL Server’s (often self-signed) certificate.

additionalPropertiesAPI

API Error: Request failed schema validation (must NOT have additional properties / Additional properties are not allowed)

The JSON body doesn’t match the endpoint’s schema — an unknown property, wrong nesting, or a missing required object.

Execution Timeout ExpiredSQL

SQL Server: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

The command ran longer than the client’s CommandTimeout (default 30 seconds).

1064MySQL

MySQL ERROR 1064 (42000): You have an error in your SQL syntax

MySQL couldn’t parse the query. The text after “near” shows where parsing failed.

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.

GROUP BYSQL

Column must appear in the GROUP BY clause / isn't in GROUP BY (MySQL 1055 only_full_group_by)

You selected a column that is neither grouped nor aggregated, so the result would be ambiguous.