Errors and Warnings

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 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 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 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 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 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 docid\ ulddmgdefqwa9p 2dqlz data definition language (ddl) statement reference docid\ wcqh0qqpm0gvf2x0gyzrq data integrity and storage docid 95mk5gpibah8w1zqvh5aa query analysis docid\ qajnit4hq47vdj9tspeso system catalog