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