Table 1. SQL errors 20000 - 20264
| Error code | SQLSTATE value | Class condition | Subclass message |
|---|---|---|---|
| 20000 | 50501 | FairCom DB SQL RDS error | SQL internal error |
| 20001 | 50502 | FairCom DB SQL RDS error | Memory allocation failure |
| 20002 | 50503 | FairCom DB SQL RDS error | Open database failed |
| 20003 | 2a504 | Syntax error | Syntax error |
| 20004 | 28505 | Invalid auth specs | User not found |
| 20005 | 22506 | Data exception | Table/View/Synonym not found |
| 20006 | 22507 | Data exception |
Column not found/specified If you get this error and feel like you have the table or field it cannot find, check the case of the name in the database. Lowercase identifiers are case insensitive, but Delimited Identifiers (that are a reserved word or contain upper case) are always case sensitive and you must double-quote them in queries, see Delimited Identifiers in the SQL documentation. |
| 20007 | 22508 | Data exception | No columns in table |
| 20008 | 22509 | Data exception | Inconsistent types |
| 20009 | 22510 | Data exception | Column ambiguously specified |
| 20010 | 22511 | Data exception | Duplicate column specification |
| 20011 | 22512 | Data exception | Invalid length at column |
| 20012 | 22513 | Data exception | Invalid precision at column |
| 20013 | 22514 | Data exception | Invalid scale at column |
| 20014 | 22515 | Data exception | Missing input parameters |
| 20015 | 22516 | Data exception | Subquery returns multiple rows |
| 20016 | 22517 | Data exception | Null value supplied for a mandatory (not null) column |
| 20017 | 22518 | Data exception | Too many values specified |
| 20018 | 22519 | Data exception | Too few values specified |
| 20019 | 50520 | FairCom DB SQL RDS error | Cannot modify table referred to in subquery |
| 20020 | 42521 | Access rule violation | Bad column specification for group by clause |
| 20021 | 42522 | Access rule violation | Non-group-by expression in having clause |
| 20022 | 42523 | Access rule violation | Non-group-by expression in select clause |
| 20023 | 42524 | Access rule violation | Aggregate function not allowed here |
| 20024 | 0a000 | feature not supported | Sorry, operation not yet implemented |
| 20025 | 42526 | Access rule violation | Aggregate functions nested |
| 20026 | 50527 | FairCom DB SQL RDS error | Too many table references |
| 20027 | 42528 | Access rule violation | Bad field specification in order by clause |
| 20028 | 50529 | FairCom DB SQL RDS error | Index with the same name already exists |
| 20029 | 50530 | FairCom DB SQL RDS error | Index referenced not found |
| 20030 | 22531 | Data exception | Table space with same name already exists |
| 20031 | 50532 | FairCom DB SQL RDS error | Cluster with same name already exists |
| 20032 | 50533 | FairCom DB SQL RDS error | No cluster with this name |
| 20033 | 22534 | Data exception | Tablespace not found |
| 20034 | 50535 | FairCom DB SQL RDS error | Bad free percentage specification |
| 20035 | 50536 | FairCom DB SQL RDS error | At least column spec or null clause should be specified |
| 20036 | 07537 | dynamic SQL error | Statement not prepared |
| 20037 | 24538 | Invalid cursor state | Executing select statement |
| 20038 | 24539 | Invalid cursor state | Cursor not closed |
| 20039 | 24540 | Invalid cursor state | Open for non-Select statement |
| 20040 | 24541 | Invalid cursor state | Cursor not opened |
| 20041 | 22542 | Data exception | Table/View/Synonym already exists |
| 20042 | 2a543 | Syntax error | Distinct specified more than once in query |
| 20043 | 50544 | FairCom DB SQL RDS error | Tuple size too high |
| 20044 | 50545 | FairCom DB SQL RDS error | Array size too high |
| 20045 | 08546 | Connection exception | File does not exist or not accessible |
| 20046 | 50547 | FairCom DB SQL RDS error | Field value not null for some tuples |
| 20047 | 42548 | Access rule violation | Granting to self not allowed |
| 20048 | 42549 | Access rule violation | Revoking for self not allowed |
| 20049 | 22550 | Data exception | Keyword used for a name |
| 20050 | 21551 | Cardinality violation | Too many fields specified |
| 20051 | 21552 | Cardinality violation | Too many indexes on the table |
| 20052 | 22553 | Data exception | Overflow/Underflow error |
| 20053 | 08554 | Connection exception | Database not opened |
| 20054 | 08555 | Connection exception | Database not specified or improperly specified |
| 20055 | 08556 | Connection exception | Database not specified or Database not started |
| 20056 | 28557 | Invalid auth specs | No DBA access rights |
| 20057 | 28558 | Invalid auth specs | User has no RESOURCE privileges |
| 20058 | 40559 | Transaction | Rollback |
| 20059 | 22560 | Data exception | No files in the table space |
| 20060 | 22561 | Data exception | Table not empty |
| 20061 | 22562 | Data exception | Input parameter size too high |
| 20062 | 42563 | Syntax error | Full pathname not specified |
| 20063 | 50564 | FairCom DB SQL RDS error | Duplicate file specification |
| 20064 | 08565 | Connection exception | Invalid attach type |
| 20065 | 26000 | Invalid SQL statement name | Invalid statement type |
| 20066 | 33567 | Invalid SQL descriptor name | Invalid sqlda |
| 20067 | 08568 | Connection exception | More than one database can't be attached locally |
| 20068 | 42569 | Syntax error | Bad arguments |
| 20069 | 33570 | Invalid SQL descriptor name | SQLDA size not enough |
| 20070 | 33571 | Invalid SQL descriptor name | SQLDA buffer length too high |
| 20071 | 42572 | Access rule violation | Specified operation not allowed on the view |
| 20072 | 50573 | FairCom DB SQL RDS error | Server is not allocated |
| 20073 | 2a574 | Access rule violation | View query specification for view too long |
| 20074 | 2a575 | Access rule violation | View column list must be specified as expressions are given |
| 20075 | 21576 | Cardinality violation | Number of columns in column list is less than in select list |
| 20076 | 21577 | Cardinality violation | Number of columns in column list is more than in select list |
| 20077 | 42578 | Access rule violation | Check option specified for non-insertable view |
| 20078 | 42579 | Access rule violation | Given SQL statement is not allowed on the view |
| 20079 | 50580 | FairCom DB SQL RDS error | More Tables cannot be created. |
| 20080 | 44581 | Check option violation | View check option violation |
| 20081 | 22582 | Data exception | No of expressions projected on either side of set-op don't match |
| 20082 | 42583 | Access rule violation | Column names not allowed in order by clause for this statement |
| 20083 | 42584 | Access rule violation | Outerjoin specified on a complex predicate |
| 20084 | 42585 | Access rule violation | Outerjoin specified on a sub_query |
| 20085 | 42586 | Access rule violation | Invalid Outerjoin specification |
| 20086 | 42587 | Access rule violation | Duplicate table constraint specification |
| 20087 | 21588 | Cardinality violation | Column count mismatch |
| 20088 | 28589 | Invalid auth specs | Invalid user name |
| 20089 | 22590 | Data exception | System date retrieval failed |
| 20090 | 42591 | Access rule violation | Table columnlist must be specified as expressions are given |
| 20091 | 2a592 | Access rule violation | Query statement too long |
| 20092 | 2d593 | Invalid transaction | termination |
| 20093 | 22594 | Data exception | Synonym already exists |
| 20094 | hz595 | Remote database access | Database link with same name already exists |
| 20095 | hz596 | Remote database access | Database link not found |
| 20096 | 08597 | Connection exception | Connect String not specified/incorrect |
| 20097 | hz598 | Remote database access | Specified operation not allowed on a remote table |
| 20098 | 22599 | Data exception | More than one row selected by the query |
| 20099 | 24000 | Invalid cursor state | Cursor not positioned on a valid row |
| 20100 | 4250a | Access rule violation | Subquery not allowed here |
| 20101 | 2350b | Integrity constraint | No references for the table |
| 20102 | 2350c | Integrity constraint | Primary key column defined null |
| 20103 | 2350d | Integrity constraint | No matching key defined for the referenced table |
| 20104 | 2350e | Integrity constraint | Keys in reference constraint incompatible |
| 20105 | 5050f | FairCom DB SQL RDS error | Statement not allowed in readonly isolation level |
| 20106 | 2150g | Cardinality violation | Invalid ROWID |
| 20107 | hz50h | Remote database access | Remote Database not started |
| 20108 | 0850i | Connection exception | Remote Network Server not started |
| 20109 | hz50j | Remote database access | Remote Database Name not valid |
| 20110 | 0850k | Connection exception | TCP/IP Remote HostName is unknown |
| 20114 | 33002 | Invalid SQL descriptor name | Fetched Value NULL & indicator var not defined |
| 20115 | 5050l | FairCom DB SQL RDS error | References to the table/record present |
| 20116 | 2350m | Integrity constraint | Constraint violation |
| 20117 | 2350n | Integrity constraint | Table definition not complete |
| 20118 | 4250o | Access rule violation | Duplicate constraint name |
| 20119 | 2350p | Integrity constraint | Constraint name not found |
| 20120 | 22000 | Data exception | **use of reserved word |
| 20121 | 5050q | FairCom DB SQL RDS error | Permission denied |
| 20122 | 5050r | FairCom DB SQL RDS error | Procedure not found |
| 20123 | 5050s | FairCom DB SQL RDS error | Invalid arguments to procedure |
| 20124 | 5050t | FairCom DB SQL RDS error | Query conditionally terminated |
| 20125 | 0750u | Dynamic SQL-error | Number of open cursors exceeds limit |
| 20126 | 34000 | Invalid cursor name | ***Invalid cursor name |
| 20127 | 07001 | Dynamic SQL-error | Bad parameter specification for the statement |
| 20128 | 2250x | Data Exception | Numeric value out of range |
| 20129 | 2250y | Data Exception | Data truncated |
| 20130 | 40000 | FairCom DB SQL RDS error | Rolled back transaction |
| 20131 | 50522 | FairCom DB SQL RDS error | Value for Parameter marker is Missing |
| 20132 | 5050u | FairCom DB SQL RDS error | Revoke failed because of restrict |
| 20133 | 0a000 | Feature not supported | Sorry, feature not supported in this Edition |
| 20134 | 5050v | FairCom DB SQL RDS error | Invalid long datatype column references |
| 20135 | 5050x | FairCom DB SQL RDS error | Contains operator is not supported in this context |
| 20136 | 5050z | FairCom DB SQL RDS error | Contains operator is not supported for this datatype |
| 20137 | 50514 | FairCom DB SQL RDS error | Index is not defined or does not support CONTAINS |
| 20138 | 50513 | FairCom DB SQL RDS error | Index on long fields requires that it can push down only CONTAINS |
| 20139 | 50540 | FairCom DB SQL RDS error | Index on long fields not supported |
| 20140 | 50512 | FairCom DB SQL RDS error | Procedure already exists |
| 20141 | 85001 | FairCom DB SQL Stored procedure/function Compilation | Error in Stored Procedure/function Compilation |
| 20142 | 86001 | FairCom DB SQL Stored procedure/function Execution | Error in Stored Procedure/function Execution |
| 20143 | 86002 | FairCom DB SQL Stored procedure Execution | Too many recursions in call procedure |
| 20144 | 86003 | FairCom DB SQL Stored procedure Execution | Null value fetched |
| 20145 | 86004 | FairCom DB SQL Stored procedure Execution | Invalid field reference |
| 20146 | 86005 | FairCom DB SQL Triggers | Trigger with this name already exists |
| 20147 | 86006 | FairCom DB SQL Triggers | Trigger with this name does not exist |
| 20148 | 86007 | FairCom DB SQL Triggers | Trigger Execution Failed |
| 20150 | 50551 | FairCom DB SQL RDS error | View manager ID is not found |
| 20151 | 50515 | FairCom DB SQL RDS error | Cannot drop all columns; use DROP TABLE instead |
| 20152 | 50516 | FairCom DB SQL RDS error | Cannot preallocate memory for n cache items |
| 20153 | 50517 | FairCom DB SQL RDS error | Tree not present in cache ; search failed |
| 20154 | 50518 | FairCom DB SQL RDS error | Statement cache insert failed |
| 20155 | 50519 | FairCom DB SQL RDS error | Environment variable used for the creation of multi component index is not set properly |
| 20156 | 50521 | FairCom DB SQL RDS error | No SQL statement |
| 20157 | 50523 | FairCom DB SQL RDS error | Invalid Java Stored Procedure/Trigger method sequence |
| 20158 | 50524 | FairCom DB SQL RDS error | Can't create triggers on system tables |
| 20159 | 28590 | Invalid auth specs | Can't REVOKE privileges, you did not grant. |
| 20160 | 28591 | Feature not supported | Stored Procedure/Trigger Feature not supported |
| 20161 | 28592 | FairCom DB SQL Stored procedure Execution | Not all OUT/INOUT parameters are registered |
| 20162 | 28593 | FairCom DB SQL Stored procedure Execution | IN parameter can't be registered |
| 20163 | 28594 | FairCom DB SQL Stored procedure Execution | 'Scale' for registerOutParam not implemented |
| 20164 | 2a565 | Syntax error | Escape character must be character string of length 1 |
| 20165 | 2a566 | Syntax error | Missing or illegal character following the escape character |
| 20166 | 50547 | FairCom DB SQL RDS error | Column nullability and Default value do not match |
| 20169 | 2a568 | Query Execution Plan | Invalid plan table definition |
| 20170 | 2a569 | Query Execution Plan | No RESOURCE privileges to create plan table |
| 20171 | 2a570 | Query Execution Plan | No DBA access rights to create plan table |
| 20172 | 2a571 | Query Execution Plan | Plan table access denied |
| 20173 | 2a572 | Query Execution Plan | Statement ID not specified |
| 20174 | 24543 | FairCom DB SQL RDS error | Batch Update has resulted in resultset |
| 20175 | 42588 | Access rule violation | duplicate or conflicting NULL and/or NOT NULL specifications |
| 20176 | 2a573 | Query Execution Plan | Duplicate Statement ID specified |
| 20177 | 42589 | Access rule violation | Cannot define PRIMARY KEY constraint on nullable column |
| 20178 | 0A500 | Feature not supported | PERCENT and WITH TIES options not supported in TOP clause |
| 20179 | 0A501 | Data exception | View not found |
| 20181 | 0A503 | Data exception | Synonym not found |
| 20182 | 50525 | FairCom DB SQL RDS error | Function already exists |
| 20183 | 50526 | FairCom DB SQL RDS error | Function not found |
| 20184 | 22543 | Data exception | Table not found |
| 20185 | 22544 | Data exception | Literal length exceeds maximum limit |
| 20186 | 22585 | Data exception | Character column expected for LIKE predicate |
| 20187 | 08006 | Connection exception | JVM Initialization failed |
| 20188 | 22543 | Data exception | Multiple IDENTITY/DEFAULT clause specified or DEFAULT specified for IDENTITY column |
| 20189 | 22543 | Data exception | Insert/Update of an IDENTITY column not allowed |
| 20190 | 22543 | Data exception | Invalid IDENTITY Seed/Increment value specified |
| 20191 | 22543 | Data exception | Identity allowed only on columns of type Integer, Smallint, Tinyint, and Bigint |
| 20192 | 22543 | Data exception | IDENTITY cannot be specified if the table has only one column |
| 20193 | 50530 | FairCom DB SQL RDS error | Ambiguous Index reference , specify table name |
| 20194 | 21588 | Syntax error | Search condition required for recursive query |
| 20195 | 22566 | Invalid auth specs | User/Group already exists |
| 20196 | 22567 | Invalid auth specs | User/Group not found |
| 20197 | 22568 | Invalid auth specs | User already exists in User Group |
| 20198 | 22569 | Invalid auth specs | User Group not found |
| 20199 | 22570 | Invalid auth specs | User not found in User Group |
| 20200 | 22571 | Invalid auth specs | Cannot add a User Group to another User Group |
| 20201 | 21589 | SQL Stored procedure | Procedure has OUT/INOUT parameters |
| 20202 | 21590 | SQL Stored procedure | Procedure has no resultset |
| 20203 | 21591 | SQL Stored procedure | Scrollable cursor not supported on call statement |
| 20211 | 22800 | Data exception | Remote procedure call error |
| 20212 | 08801 | Connection exception | SQL client bind to daemon failed |
| 20213 | 08802 | Connection exception | SQL client bind to SQL server failed |
| 20214 | 08803 | Connection exception | SQL NETWORK service entry is not available |
| 20215 | 08804 | Connection exception | Invalid TCP/IP hostname |
| 20216 | hz805 | Remote database access | Invalid remote database name |
| 20217 | 08806 | Connection exception | Network error on server |
| 20218 | 08807 | Connection exception | Invalid protocol |
| 20219 | 2e000 | Invalid connection name | ***Invalid connection name |
| 20220 | 08809 | Connection exception | Duplicate connection name |
| 20221 | 08810 | Connection exception | No active connection |
| 20222 | 08811 | Connection exception | No environment defined database |
| 20223 | 08812 | Connection exception | Multiple local connections |
| 20224 | 08813 | Connection exception | Invalid protocol in connect_string |
| 20225 | 08814 | Connection exception | Exceeding permissible number of connections |
| 20226 | 80815 | FairCom DB SQL SNW errors | Bad database handle |
| 20227 | 08816 | Connection exception | Invalid host name in connect string |
| 20228 | 28817 | Invalid auth specs | Access denied (Authorization failed) |
| 20229 | 22818 | Data exception | Invalid date value |
| 20230 | 22819 | Data exception | Invalid date string |
| 20231 | 22820 | Data exception | Invalid number strings |
| 20232 | 22821 | Data exception | Invalid number string |
| 20233 | 22822 | Data exception | Invalid time value |
| 20234 | 22523 | Data exception | Invalid time string |
| 20235 | 22007 | Data exception | Invalid time stamp string |
| 20236 | 22012 | Data exception | Division by zero attempted |
| 20238 | 22615 | Data exception | Error in format type |
| 20239 | 2c000 | Invalid character set name | Invalid character set name specified |
| 20240 | 5050y | FairCom DB SQL RDS errors | Invalid collation name specified |
| 20241 | 08815 | Connection Exception | Service in use |
| 20242 | 22008 | Data exception | Invalid timestamp |
| 20243 | 2c001 | Illegal Buffer Size | Illegal Buffer Size specified |
| 20244 | 2c002 | Invalid Coercion | Invalid Coercion Value Specified |
| 20245 | 2c003 | Missing Dboption | Value for specified dboption not found |
| 20246 | 2c004 | Bad Dboption | Illegal Value specified for a dboption |
| 20247 | 2c005 | Invalid characters in String | String contains Invalid characters |
| 20248 | 22601 | Data Exception | Identifier too long |
| 20249 | 22602 | Data exception | Identifier incompatible character set |
| 20250 | 22603 | Data exception | Invalid identifier |
| 20251 | 22604 | Data exception | Quoted string not properly terminated |
| 20252 | 22605 | Data exception | Missing double quote in identifier |
| 20253 | 22606 | Invalid length | Storage Attribute too long |
| 20254 | 2f000 | Invalid handle | Invalid Environment Handle |
| 20255 | 08818 | Connection exception | Destination IP address validation failed; the destination IP address specified by the client is not authorized to access the server |
| 20256 | 08817 | Connection exception | Source IP address validation failed; client machine is not authorized to access the server |
| 20257 | 08557 | Connection exception | Length of the database name exceeds the maximum limit |
| 20258 | 5051a | FairCom DB SQL RDS error | Invalid lob datatype column references |
| 20259 | 50912 | FairCom DB SQL RDS error | Index on lob types requires CONTAINS operator |
| 20260 | 42523 | Access rule violation | Non-group-by expression in order by clause |
| 20261 | 42528 | Access rule violation | Order by field not found in SELECT DISTINCT list |
| 20262 | 42528 | Access rule violation | Order by in subquery without top or skip |
| 20263 | 08819 | Connection exception | Client Server mismatch; both must be either Non-Commercial Trial or Pro |
| 20264 | 2350p | Integrity constraint | Invalid constraint info from storage system |
Table 2. SQL errors 20265 - 20276: sequence errors
| Error code | SQLSTATE value | Class condition | Subclass message |
|---|---|---|---|
| 20265 | 50582 | dharma/SQL RDS error | CREATE SEQUENCE - Sequence with the same name already exists |
| 20266 | 42592 | Access rule violation | DROP SEQUENCE ALTER SEQUENCE - Sequence cannot be used here |
| 20267 | 50583 | dharma/SQL RDS error | DROP SEQUENCE ALTER SEQUENCE - Sequence not found |
| 20268 | 50584 | dharma/SQL RDS error | CREATE SEQUENCE ALTER SEQUENCE - START-WITH/CURRENT-VALUE cannot be greater than MAXVALUE |
| 20269 | 50585 | dharma/SQL RDS error | CREATE SEQUENCE ALTER SEQUENCE - START-WITH/CURRENT-VALUE cannot be less than MINVALUE |
| 20270 | 50586 | dharma/SQL RDS error | CREATE SEQUENCE ALTER SEQUENCE - Invalid sequence MINVALUE specified |
| 20271 | 50587 | dharma/SQL RDS error | CREATE SEQUENCE ALTER SEQUENCE - Invalid sequence INCREMENT specified |
| 20272 | 50588 | dharma/SQL RDS error | CREATE SEQUENCE ALTER SEQUENCE - START-WITH cannot be altered in sequence |
| 20273 | 50589 | dharma/SQL RDS error | CREATE SEQUENCE ALTER SEQUENCE - No options specified for ALTER SEQUENCE |
| 20274 | 50590 | dharma/SQL RDS error | CREATE SEQUENCE ALTER SEQUENCE - Sequence increment has exceeded MAXVALUE |
| 20275 | 50591 | dharma/SQL RDS error | CREATE SEQUENCE ALTER SEQUENCE - Sequence decrement has exceeded MINVALUE |
| 20276 | 42593 | Access rule violation | CREATE SEQUENCE ALTER SEQUENCE - Only SELECT and ALTER privileges are valid for sequences |
Table 3. SQL errors 20277 - 20304: RDS errors
| Error code | SQLSTATE value | Class condition | Subclass message |
|---|---|---|---|
| 20277 | m0m00 | dharma/SQL RDS error | Multiple databases not supported |
| 20278 | m0m00 | dharma/SQL RDS error | Parameters not supported for multiple row inserts |
| 20279 | 50592 | dharma/SQL RDS error | View contains a self reference |
| 20300 | 90901 | FairCom DB SQL/DBS errors | Column group column doesn't exist |
| 20301 | 90902 | FairCom DB SQL/DBS errors | Column group column already specified |
| 20302 | 90903 | FairCom DB SQL/DBS errors | Column group name already specified |
| 20303 | 90904 | FairCom DB SQL/DBS errors | Column groups haven't covered all columns |
| 20304 | 90905 | FairCom DB SQL/DBS errors | Column groups are not implemented in FairCom DB SQL storage |