The 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 theDocumentation Index
Fetch the complete documentation index at: https://docs.ocient.com/llms.txt
Use this file to discover all available pages before exploring further.
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. |