> For clean Markdown of any page, append .md to the page URL. > For a complete documentation index, see https://ocient.ferndocs.com/guides/sql-reference/errors-and-warnings/llms.txt. > For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://ocient.ferndocs.com/_mcp/server. # Errors and Warnings > Learn about handling errors and warnings in Ocient to maintain smooth system operations. 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. | **-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**](/guides/sql-reference) [**Data Definition Language (DDL) Statement Reference**](/guides/sql-reference/data-definition-language-ddl-statement-reference) [**Data Integrity and Storage**](/guides/sql-reference/data-definition-language-ddl-statement-reference/data-integrity-and-storage) [**Query Analysis**](/guides/sql-reference/data-definition-language-ddl-statement-reference/query-analysis) [**System Catalog**](https://docs.ocient.com/system-catalog) > Learn about handling errors and warnings in Ocient to maintain smooth system operations.