---
title: Errors and Warnings
slug: kzZCXfnsekti8_oS9yEEh
description: Learn about handling errors and warnings in Ocient to maintain smooth system operations.
docTags: 
createdAt: Thu Jul 21 2022 17:05:13 GMT+0000 (Coordinated Universal Time)
updatedAt: Mon Mar 30 2026 18:52:34 GMT+0000 (Coordinated Universal Time)
---

The Ocient® System produces these error and warning codes as part of its operation. Refer to these codes for their description.

You can also execute this SQL statement using the `sys.sql_messages` system catalog table to view the codes and descriptions in the database: `SELECT * FROM sys.sql_messages`.

## Error Codes

The error codes are negative values that split into ranges by number such as -100s, -200s, and so on.&#x20;

| **-1xx Codes**  | **Description**                                                                                                                                                                                                    |
| --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| -100            | Unknown error occurred.                                                                                                                                                                                            |
| -101            | This is an internal error that indicates that a client (driver or connector) received an invalid response from the server.                                                                                         |
| -102            | Internal error that indicates a corruption of the serialized result set sent from the server to the client.                                                                                                        |
| -103            | Internal error that indicates an unexpected condition has happened.                                                                                                                                                |
| **-2xx Codes**  | **Description**                                                                                                                                                                                                    |
| -200            | A client attempted a connection with a malformed connection string.                                                                                                                                                |
| -201            | The connection to the server failed.                                                                                                                                                                               |
| -202            | The handshake with the server failed.                                                                                                                                                                              |
| -203            | The connection to the server was unexpectedly closed.                                                                                                                                                              |
| -204            | A network communications error has occurred.                                                                                                                                                                       |
| -205            | The client tried to connect to a database with a specified name, but no database with that name exists.                                                                                                            |
| -206            | The target node is offline.                                                                                                                                                                                        |
| **-3xx Codes**  | **Description**                                                                                                                                                                                                    |
| -300            | An argument to a driver method execution was invalid.                                                                                                                                                              |
| -301            | A driver method executed, but the input argument object was already closed.                                                                                                                                        |
| -302            | The cursor was not positioned in a valid row.                                                                                                                                                                      |
| -303            | An attempt was made to create a new result set, but the previous result set for the connection was still open.                                                                                                     |
| -304            | The user and password combination was incorrect.                                                                                                                                                                   |
| -305            | A statement that was not a query was passed to executeQuery().                                                                                                                                                     |
| -306            | A statement that was a query was passed to executeUpdate().                                                                                                                                                        |
| -307            | A NULL output buffer was passed to a driver method, where a NULL buffer is not allowed.                                                                                                                            |
| -308            | A driver execution was made that is not implemented.                                                                                                                                                               |
| -313            | An invalid parameter marker number was specified.                                                                                                                                                                  |
| -316            | No database connection exists.                                                                                                                                                                                     |
| -317            | Invalid data was detected for a parameter marker.                                                                                                                                                                  |
| -318            | The cursor was not in the required state.                                                                                                                                                                          |
| -319            | An invalid buffer length was specified.                                                                                                                                                                            |
| -320            | There is currently no result set.                                                                                                                                                                                  |
| -321            | A NULL indicator pointer was required but not specified.                                                                                                                                                           |
| -322            | A connection attribute that is not supported was specified in SQLBrowseConnect. The four supported attributes are: "DRIVER", "DSN", "UID", "PWD".                                                                  |
| -323            | An invalid descriptor record index was specified. Valid indices start at 1 and increase to the size specified by executing SQLSetDescField with the SQL\_DESC\_COUNT field.                                        |
| -324            | An invalid or inconsistent descriptor field type was specified in SQLSetDescRec.                                                                                                                                   |
| -325            | An invalid descriptor field was specified in SQLSetDescField.                                                                                                                                                      |
| -326            | The target handle passed to SQLCopyDesc was an IRD.                                                                                                                                                                |
| -327            | An implicit descriptor handle that was not the original was the specified value in the execution of SQLSetStmtAttr with the SQL\_ATTR\_APP\_PARAM\_DESC or SQL\_ATTR\_APP\_ROW\_DESC attribute.                    |
| -328            | Divide by zero.                                                                                                                                                                                                    |
| -329            | Invalid floating point operation that resulted in NaN or Inf.                                                                                                                                                      |
| -330            | The action conflicts with the current state of the database.                                                                                                                                                       |
| -331            | The unconditional DELETE FROM statement is rewritten using the TRUNCATE statement. In this case, the database does not create a plan that would appear in the results from the execution of the EXPLAIN statement. |
| -332            | Already in use. Used mostly in DDL when a resource or option is already assigned to the object.                                                                                                                    |
| -333            | Optional value was substituted.                                                                                                                                                                                    |
| -334            | This driver is unknown or the version support has been removed.                                                                                                                                                    |
| -335            | The execution of a client method was invalid.                                                                                                                                                                      |
| -336            | Cannot execute the new SQL statement as the system is processing a prior statement using the same connection in the background.                                                                                    |
| **-4xx Codes**  | **Description**                                                                                                                                                                                                    |
| -400            | One of the referenced columns does not exist.                                                                                                                                                                      |
| -401            | The requested data type conversion was invalid.                                                                                                                                                                    |
| -402            | Unknown data type.                                                                                                                                                                                                 |
| -403            | A column name was ambiguous in the context where it was used.                                                                                                                                                      |
| -404            | Two incompatible data types were specified as return types in a case statement.                                                                                                                                    |
| -405            | Join leads to a duplicate column name.                                                                                                                                                                             |
| -406            | Invalid POINT conversion from NULL.                                                                                                                                                                                |
| -407            | Column value is larger than internal limits.                                                                                                                                                                       |
| **-5xx Codes**  | **Description**                                                                                                                                                                                                    |
| -500            | Generic syntax error.                                                                                                                                                                                              |
| -501            | The SQL statement is not valid or not supported in the context where it was used.                                                                                                                                  |
| -502            | A duplicate common table expression name was detected.                                                                                                                                                             |
| -503            | The number of columns does not match the SELECT statement.                                                                                                                                                         |
| -504            | A negative limit was specified.                                                                                                                                                                                    |
| -505            | A negative offset was specified.                                                                                                                                                                                   |
| -506            | An incorrect number of arguments was specified in a function.                                                                                                                                                      |
| -507            | Aggregation of a constant value is invalid.                                                                                                                                                                        |
| -508            | An argument to a function had an incorrect data type.                                                                                                                                                              |
| -509            | An invalid comparison was detected.                                                                                                                                                                                |
| -510            | Aggregation was used in a context where it is not allowed (possibly something in a WHERE clause that belongs in a HAVING clause).                                                                                  |
| -511            | A HAVING clause did not have any aggregation in it.                                                                                                                                                                |
| -512            | An ORDER BY clause referenced a column by position and that position was out of range.                                                                                                                             |
| -513            | An expression of type list cannot be returned in a result set.                                                                                                                                                     |
| -514            | You cannot have an expression of type list within another list.                                                                                                                                                    |
| -515            | A list expression contains incompatible types.                                                                                                                                                                     |
| -516            | The function does not exist.                                                                                                                                                                                       |
| -517            | If the result of an expression is a time interval type, the result must be cast to an integral type.                                                                                                               |
| -518            | An invalid matrix literal was specified.                                                                                                                                                                           |
| -519            | A matrix literal had incorrect dimensions.                                                                                                                                                                         |
| -520            | An invalid query priority was specified.                                                                                                                                                                           |
| -521            | A column reference in a SELECT statement is invalid due to aggregation.                                                                                                                                            |
| -522            | Columns for the first and second SELECT statements for the UNION, EXCEPT, or INTERSECT statement are not compatible.                                                                                               |
| -523            | An expression in the CASE condition is not allowed.                                                                                                                                                                |
| -524            | An expression in the JOIN condition is not allowed.                                                                                                                                                                |
| -525            | Aggregation is not allowed in the PARTITION BY or ORDER BY clauses of a windowed aggregate.                                                                                                                        |
| -526            | A non-constant value was found where a constant was expected in an argument of a windowed aggregate.                                                                                                               |
| -527            | Range-based framing does not allow the PRECEDING or FOLLOWING keywords.                                                                                                                                            |
| -528            | ORDER BY with a column ordinal is not allowed in a windowed aggregate.                                                                                                                                             |
| -529            | A frame specification is not allowed if no ORDER BY clause is specified in a windowed aggregate.                                                                                                                   |
| -530            | UNBOUNDED PRECEDING is only allowed on the starting frame bound.                                                                                                                                                   |
| -531            | UNBOUNDED FOLLOWING is only allowed on the ending frame bound.                                                                                                                                                     |
| -532            | The ending frame bound cannot be less than the starting frame bound.                                                                                                                                               |
| -533            | No frame specification is allowed for this particular windowed aggregate.                                                                                                                                          |
| -534            | A window function requires a positive integer argument.                                                                                                                                                            |
| -535            | The specified window function requires an ORDER BY statement in the OVER() clause.                                                                                                                                 |
| -536            | Invalid aggregation.                                                                                                                                                                                               |
| -537            | Invalid expression.                                                                                                                                                                                                |
| -538            | A CASE expression within a CASE expression is not allowed.                                                                                                                                                         |
| -539            | Window function was used in a context where it is not allowed (perhaps in a predicate of a WHERE or HAVING clause).                                                                                                |
| **-6xx Codes**  | **Description**                                                                                                                                                                                                    |
| -600            | A referenced table does not exist.                                                                                                                                                                                 |
| -601            | The specified database already exists.                                                                                                                                                                             |
| -602            | The specified table already exists.                                                                                                                                                                                |
| -603            | The specified view already exists.                                                                                                                                                                                 |
| -604            | The specified view was not found.                                                                                                                                                                                  |
| -605            | The specified database was not found.                                                                                                                                                                              |
| -606            | The specified storage space was not found.                                                                                                                                                                         |
| -607            | The specified storage space already exists.                                                                                                                                                                        |
| -608            | The specified user does not exist.                                                                                                                                                                                 |
| -609            | The specified user already exists.                                                                                                                                                                                 |
| -610            | The specified password for the new user is invalid.                                                                                                                                                                |
| -611            | The specified group name already exists.                                                                                                                                                                           |
| -612            | The specified group does not exist.                                                                                                                                                                                |
| -613            | The specified connection already exists.                                                                                                                                                                           |
| -614            | The specified connection was not found.                                                                                                                                                                            |
| -615            | The referenced translation does not exist.                                                                                                                                                                         |
| -616            | A translation with that name exists.                                                                                                                                                                               |
| -617            | The specified user was not found in this group.                                                                                                                                                                    |
| -618            | The provided storage space has no storage cluster assigned.                                                                                                                                                        |
| -619            | The referenced table is a system table and not allowed for the export operation.                                                                                                                                   |
| -620            | The referenced pipeline does not exist.                                                                                                                                                                            |
| -621            | A pipeline with that name exists.                                                                                                                                                                                  |
| -622            | The pipeline is invalid.                                                                                                                                                                                           |
| -623            | The pipeline is unable to be correctly compiled.                                                                                                                                                                   |
| -624            | The referenced task does not exist.                                                                                                                                                                                |
| -625            | An index with that type and on that column already exists.                                                                                                                                                         |
| -626            | An index with that name already exists.                                                                                                                                                                            |
| -627            | The referenced table ID no longer exists.                                                                                                                                                                          |
| -628            | A connectivity pool with that name already exists.                                                                                                                                                                 |
| -629            | Cannot find a connectivity pool with the specified name.                                                                                                                                                           |
| -630            | Cannot drop the last connectivity pool from a node.                                                                                                                                                                |
| -638            | Could not find a SCHEMA with that name (Schema does not exist).                                                                                                                                                    |
| **-7xx Codes**  | **Description**                                                                                                                                                                                                    |
| -700            | The user does not have read authorization on a referenced table.                                                                                                                                                   |
| -701            | The user does not have authorization to create a database.                                                                                                                                                         |
| -702            | The user does not have modify authorization on a referenced table.                                                                                                                                                 |
| -703            | The user does not have authorization to create a view.                                                                                                                                                             |
| -704            | The user does not have modify authorization on a referenced database.                                                                                                                                              |
| -705            | The user does not have modify authorization on a referenced view.                                                                                                                                                  |
| -706            | The user does not have authorization to drop a referenced table.                                                                                                                                                   |
| -707            | The user does not have authorization to drop a referenced row.                                                                                                                                                     |
| -708            | The user does not have authorization to drop a referenced view.                                                                                                                                                    |
| -709            | The user does not have authorization to drop a referenced database.                                                                                                                                                |
| -710            | The user does not have authorization to create a table.                                                                                                                                                            |
| -711            | The user does not have authorization to create a storage space.                                                                                                                                                    |
| -712            | The user does not have authorization to drop a referenced storage space.                                                                                                                                           |
| -713            | The user does not have authorization to create a user.                                                                                                                                                             |
| -714            | The user does not have authorization to drop a user.                                                                                                                                                               |
| -715            | The user does not have the authority to create a group.                                                                                                                                                            |
| -716            | The user does not have the authority to drop the group.                                                                                                                                                            |
| -717            | The user does not have the authority to create a connection.                                                                                                                                                       |
| -718            | The user does not have the authority to drop the connection.                                                                                                                                                       |
| -719            | The user is not authorized to take this action.                                                                                                                                                                    |
| -720            | The user does not have the authority to modify the group.                                                                                                                                                          |
| -721            | The user does not have the authority to execute a plan.                                                                                                                                                            |
| -722            | The user does not have the authority to execute an inline plan.                                                                                                                                                    |
| -723            | The user does not have the authority to create a connectivity pool.                                                                                                                                                |
| -724            | The user does not have the authority to drop the connectivity pool.                                                                                                                                                |
| -725            | The user does not have the authority to modify the connectivity pool.                                                                                                                                              |
| -726            | Unable to drop some objects in the request.                                                                                                                                                                        |
| -728            | The user does not have the authority to drop the SCHEMA (Objects exist in the schema).                                                                                                                             |
| -733            | Session has expired. Refresh is necessary.                                                                                                                                                                         |
| **-8xx Codes**  | **Description**                                                                                                                                                                                                    |
| -800            | An MLMODEL with that name was not found.                                                                                                                                                                           |
| -801            | An MLMODEL with that name already exists.                                                                                                                                                                          |
| -802            | The user does not have the authority to create an MLMODEL.                                                                                                                                                         |
| -803            | The user does not have the authority to drop the MLMODEL.                                                                                                                                                          |
| -804            | Unable to create an MLMODEL due to a singular matrix.                                                                                                                                                              |
| -805            | Unable to create an MLMODEL because the training set is empty.                                                                                                                                                     |
| -806            | Unable to perform LUP decomposition on this singular matrix.                                                                                                                                                       |
| -807            | The user does not have the authority to modify the MLMODEL.                                                                                                                                                        |
| **-9xx Codes**  | **Description**                                                                                                                                                                                                    |
| -900            | Operation was canceled or aborted.                                                                                                                                                                                 |
| -901            | I/O error.                                                                                                                                                                                                         |
| -902            | Scalar Subquery Cardinality Violation.                                                                                                                                                                             |
| -903            | Numeric value out of range.                                                                                                                                                                                        |
| -904            | Plan compilation error.                                                                                                                                                                                            |
| -905            | TKT limit reached.                                                                                                                                                                                                 |
| -906            | Out of memory.                                                                                                                                                                                                     |
| -907            | Segment not available.                                                                                                                                                                                             |
| -908            | System is still initializing.                                                                                                                                                                                      |
| -909            | Out of temporary disk space.                                                                                                                                                                                       |
| -910            | Operation was automatically killed due to drop in the client connection.                                                                                                                                           |
| -911            | Failed to acquire OSN (Ownership Sequence Number). Data for querying is no longer available to the storage cluster.                                                                                                |
| **-10xx Codes** | **Description**                                                                                                                                                                                                    |
| -1000           | The privilege target already has the privilege.                                                                                                                                                                    |
| -1001           | The user does not have the authority to grant this privilege.                                                                                                                                                      |
| -1002           | The privilege target does not have that privilege.                                                                                                                                                                 |
| -1003           | The referenced role does not exist.                                                                                                                                                                                |
| -1004           | The provided object ID was not found.                                                                                                                                                                              |
| -1005           | Create task failure.                                                                                                                                                                                               |
| -1006           | Task already in progress.                                                                                                                                                                                          |
| -1007           | Could not find the supplied service class.                                                                                                                                                                         |
| -1008           | Supplied service class definition is invalid.                                                                                                                                                                      |
| **-11xx Codes** | **Description**                                                                                                                                                                                                    |
| -1100           | No available service classes for the user have available query slots.                                                                                                                                              |
| -1101           | The specified node is not found.                                                                                                                                                                                   |
| -1102           | Segment not found.                                                                                                                                                                                                 |
| -1111           | Cluster not found.                                                                                                                                                                                                 |
| -1112           | A cluster with that name exists.                                                                                                                                                                                   |
| -1120           | Query exceeded service class time limit.                                                                                                                                                                           |
| -1121           | Query exceeded session time limit.                                                                                                                                                                                 |
| -1122           | Query exceeded query time limit.                                                                                                                                                                                   |
| -1123           | Query exceeded service class row limit.                                                                                                                                                                            |
| -1124           | Query exceeded session row limit.                                                                                                                                                                                  |
| -1125           | Query exceeded query row limit.                                                                                                                                                                                    |
| -1126           | Query exceeded service class temporary disk limit.                                                                                                                                                                 |
| -1127           | Query exceeded session temporary disk limit.                                                                                                                                                                       |
| -1128           | Query exceeded query temporary disk limit.                                                                                                                                                                         |
| -1129           | Too many columns in result set for the service class.                                                                                                                                                              |
| -1130           | Too many columns in result set for the session.                                                                                                                                                                    |
| -1131           | Too many columns in result set for the query.                                                                                                                                                                      |
| **-12xx Codes** | **Description**                                                                                                                                                                                                    |
| -1200           | The security integration is disabled.                                                                                                                                                                              |
| -1201           | The security integration does not exist.                                                                                                                                                                           |
| -1202           | The request failed due to a network communications error.                                                                                                                                                          |
| -1203           | The Single Sign On request identifier could not be found.                                                                                                                                                          |
| -1204           | No session associated with the connection exists.                                                                                                                                                                  |
| -1205           | The supplied security token is invalid.                                                                                                                                                                            |
| -1206           | The supplied security token signature does not match the expected value.                                                                                                                                           |
| -1207           | The supplied security token has a signature fingerprint from an unknown entity.                                                                                                                                    |
| -1208           | The supplied security token has expired.                                                                                                                                                                           |
| -1220           | A network communications error occurred.                                                                                                                                                                           |
| -1221           | The OpenID provider rejected the request that indicates an internal server error.                                                                                                                                  |
| -1222           | The OpenID provider returned an invalid response that indicates an error with the provider.                                                                                                                        |
| -1223           | The request\_uri in the Authorization Request returns an error or contains invalid data.                                                                                                                           |
| -1224           | The OpenID provider does not support use of the request parameter.                                                                                                                                                 |
| -1225           | The OpenID provider does not support use of the request\_uri parameter.                                                                                                                                            |
| -1226           | The OpenID provider discovery document is invalid.                                                                                                                                                                 |
| -1227           | The database OpenID configuration is invalid.                                                                                                                                                                      |
| -1228           | The OpenID ID or access token has expired.                                                                                                                                                                         |
| -1229           | The ID or access token was signed by a key not known to the OpenID provider.                                                                                                                                       |
| -1230           | The signing key returned by the OpenID provider is invalid.                                                                                                                                                        |
| -1231           | The token contains an invalid claim.                                                                                                                                                                               |
| -1232           | The token was issued by an unknown OpenID provider.                                                                                                                                                                |
| -1233           | The token was issued for an alternate audience.                                                                                                                                                                    |
| -1234           | The token signature is invalid, which implies the token was manipulated enroute to the database.                                                                                                                   |
| -1235           | The specified ID token is invalid.                                                                                                                                                                                 |
| -1236           | The specified Access token is invalid.                                                                                                                                                                             |
| -1237           | The refresh token returned from the provider is invalid.                                                                                                                                                           |
| -1238           | The authentication server has timed out while waiting for client authentication.                                                                                                                                   |
| -1250           | The client is not authorized to request an authorization code using this method.                                                                                                                                   |
| -1251           | The resource owner or authorization server denied the request.                                                                                                                                                     |
| -1252           | The authorization server does not support obtaining an authorization code using this method.                                                                                                                       |
| -1253           | The requested scope is invalid, unknown, or malformed.                                                                                                                                                             |
| -1254           | The request is missing a required parameter, includes an invalid parameter value, includes a parameter more than once, or is otherwise malformed.                                                                  |
| -1255           | The authorization server encountered an unexpected condition that prevented it from fulfilling the request.                                                                                                        |
| -1256           | The authorization server is currently unable to handle the request due to a temporary overloading or maintenance of the server.                                                                                    |
| -1257           | Cannot lock table.                                                                                                                                                                                                 |
| -1258           | Cannot unlock table.                                                                                                                                                                                               |
| -1259           | Cannot delete from a join or a view with multiple tables.                                                                                                                                                          |
| **Other**       | **Description**                                                                                                                                                                                                    |
| -9999           | Undefined exception.                                                                                                                                                                                               |

## Warning Codes

The warning codes are positive values.

| **Warning Code** | **Description**                                                        |
| ---------------- | ---------------------------------------------------------------------- |
| +300             | Data received by a JDBC driver was truncated.                          |
| +301             | The driver is below the recommended threshold for the warning version. |
| +900             | A query returned an empty result set.                                  |
| +901             | The query is estimated to have a long execution time.                  |
| +1113            | The referenced object does not exist.                                  |
| +1114            | An object with that name exists.                                       |
| +1115            | Not authorized to take this action.                                    |
| +1116            | Restart the node for changes to take effect.                           |
| +1117            | Complete system restart required for changes to take effect.           |
| +1118            | Statement contains invalid syntax.                                     |
| +1119            | Unable to drop some objects in the request.                            |

## Related Links

[SQL Reference](<././SQL Reference.md>)

[Data Definition Language (DDL) Statement Reference](<./Data Definition Language _DDL_ Statement Reference.md>)

[Data Integrity and Storage](<./Data Definition Language _DDL_ Statement Reference/Data Integrity and Storage.md>)

[Query Analysis](<./Data Definition Language _DDL_ Statement Reference/Query Analysis.md>)

[System Catalog](https://docs.ocient.com/system-catalog)&#x20;
