The following table is a list of OpenEdge SQL error messages, ordered by error code number. The table shows the corresponding SQLSTATE value for each message.

Table 1. OpenEdge SQL error codes and messages
Error code SQLSTATE value Class condition Subclass message
00000 00000 Successful completion ***status okay.
100L 02000 No data **sql not found.
10002 22503 Data exception Tuple not found for the Specified TID.
10012 N0N12 Flag ETPL_SCAN_EOP.
10013 22914 Data Exception No more records to be fetched.
10100 2150b Cardinality violation Too many fields exist.
10101 70701 OpenEdge/SQL MM error No more records exist.
10102 2350i Integrity constraint Duplicate primary/index key value.
10104 M0M06 OpenEdge/SQL rss error Specified index method is not supported.
10107 N0N07 Flag EIX_SCAN_EOP flag is set.
10108 50903 OpenEdge/SQL rds error Duplicate record specified.
10301 M0901 OpenEdge/SQL rss error Table is locked and LCK_NOWAIT.
10400 22501 Data exception Invalid file size for alter log statement.
10920 22521 Data exception Already existing value specified.
11100 50901 OpenEdge/SQL rds error Invalid transaction id.
11102 50903 OpenEdge/SQL rds error TDS area specified is not found.
11103 50504 OpenEdge/SQL rds error TDS not found for binding.
11104 50505 OpenEdge/SQL rds error Transaction aborted.
11105 50506 OpenEdge/SQL rds error Transaction error.
11109 50510 OpenEdge/SQL rds error Invalid transaction handle.
11111 50912 OpenEdge/SQL rds error Invalid isolation level.
11300 M0M00 OpenEdge/SQL rss error Specified INFO type is not supported.
11301 M0M01 OpenEdge/SQL rss error Specified index type is not supported.
16001 22701 Data exception MM- No data block.
16002 70702 OpenEdge SQLMM error MM- Bad swap block.
16003 70703 OpenEdge SQLMM error MM- No cache block.
16004 22704 Data exception MM- Invalid row number.
16005 70705 OpenEdge SQL MM error MM- Invalid cache block.
16006 70706 OpenEdge SQL MM error MM- Bad swap file.
16007 70707 OpenEdge SQL MM error MM- Row too big.
16008 70708 OpenEdge SQL MM error MM- Array initialized.
16009 70709 OpenEdge SQL MM error MM- Invalid chunk number.
16010 70710 OpenEdge SQL MM error MM- Cannot create table.
16011 70711 OpenEdge SQL MM error MM- Cannot alter table.
16012 70712 OpenEdge SQL MM error MM- Cannot drop table.
16020 70713 OpenEdge SQL MM error MM- TPL ctor error.
16021 70714 OpenEdge SQL MM error MM- Insertion error.
16022 70715 OpenEdge SQL MM error MM- Deletion error.
16023 70716 OpenEdge SQL MM error MM- Updation error.
16024 70717 OpenEdge SQL MM error MM- Fetching error.
16025 70718 OpenEdge SQL MM error MM- Sorting error.
16026 70719 OpenEdge SQL MM error MM- Printing error.
16027 70720 OpenEdge SQL MM error MM- TPLSCAN ctor error.
16028 70721 OpenEdge SQL MM error MM- Scan fetching error.
16030 70722 OpenEdge SQL MM error MM- Can't create index.
16031 70723 OpenEdge SQL MM error MM- Can't drop index.
16032 70724 OpenEdge SQL MM error MM- IXSCAN ctor error.
16033 70725 OpenEdge SQL MM error MM- IX ctor error.
16034 70726 OpenEdge SQL MM error MM- IX deletion error.
16035 70727 OpenEdge SQL MM error MM- IX appending error.
16036 70728 OpenEdge SQL MM error MM- IX insertion error.
16037 70729 OpenEdge SQL MM error MM- IX scan fetching error.
16040 70730 OpenEdge SQL MM error MM- Begin transaction.
16041 70731 OpenEdge SQL MM error MM- Commit transaction.
16042 40000 Transaction rollback ***MM- Rollback transaction.
16043 70732 OpenEdge SQL MM error MM- Mark point.
16044 70733 OpenEdge SQL MM error MM- Rollback savepoint.
16045 70734 OpenEdge SQL MM error MM- Set & Get isolation.
16050 70735 OpenEdge SQL MM error MM- TID to char.
16051 70736 OpenEdge SQL MM error MM- Char to TID.
16054 70737 OpenEdge SQL MM error MM- Bad value list size to indirect sort.
20000 50501 OpenEdge SQL rds error SQL internal error.
20001 50502 OpenEdge SQL rds error Memory allocation failure.
20002 50503 OpenEdge 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.
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.
20012 22513 Data exception Invalid precision.
20013 22514 Data exception Invalid scale.
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 OpenEdge 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 OpenEdge SQL rds error Too many table references.
20027 42528 Access rule violation Bad field specification in order by clause.
20028 50529 OpenEdge SQL rds error An index with the same name already exists.
20029 50530 OpenEdge SQL rds error Index referenced not found.
20030 22531 Data exception Table space with same name already exists.
20031 50532 OpenEdge SQL rds error Cluster with same name already exists.
20032 50533 OpenEdge SQL rds error No cluster with this name.
20033 22534 Data exception Table space not found.
20034 50535 OpenEdge SQL rds error Bad free <specification_name> specification.
20035 50536 OpenEdge SQL rds error At least column spec or null clause should be specified.
20036 07537 Dynamic sql error 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 nonselect 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 OpenEdge SQL rds error Tuple size too high.
20044 50545 OpenEdge SQL rds error Array size too high.
20045 08546 Connection exception File does not exist or not accessible.
20046 50547 OpenEdge 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 this table.
20052 22553 Data exception Overflow 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 No RESOURCE privileges.
20058 40559 Transaction rollback Executing SQL statement for an aborted transaction.
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 OpenEdge 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 cannot 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 OpenEdge 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 noninsertable view.
20078 42579 Access rule violation Given SQL statement is not allowed on the view.
20079 50580 OpenEdge SQL rds error More tables cannot be created.
20080 44581 Check option violation View check option violation.
20081 22582 Data exception Number of expressions projected on either side of set‑op do not 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 column list must be specified as expressions are given.
20091 2a592 Access rule violation Query statement too long.
20092 2d593 Invalid transaction termination No tuples selected by the subquery for update.
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/Candidate 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 OpenEdge SQL rds error Not allowed in read only 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 OpenEdge 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 OpenEdge SQL rds error Permission denied.
20122 5050r OpenEdge SQL rds error Procedure not found.
20123 5050s OpenEdge SQL rds error Invalid arguments to procedure.
20124 5050t OpenEdge 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.
20132 5050u OpenEdge SQL rds error Revoke failed because of restrict.
20134 5050v OpenEdge SQL rds error Invalid long data type column references.
20135 5050x OpenEdge SQL rds error Contains operator is not supported in this context.
20135 m0m01 OpenEdge SQL diagnostics error Diagnostics statement failed.
20136 5050z OpenEdge SQL rds error Contains operator is not supported for this datatype.
20137 50514 OpenEdge SQL rds error Index is not defined or does not support CONTAINS.
20138 50513 OpenEdge SQL rds error Index on long fields requires that it can push down only CONTAINS.
20140 50512 OpenEdge SQL rds error Procedure already exists.
20141 85001 OpenEdge SQL Stored procedure Compilation Error in stored procedure compilation.
20142 86001 OpenEdge SQL Stored procedure Execution Error in Stored Procedure Execution.
20143 86002 OpenEdge SQL Stored procedure Execution Too many recursions in call procedure.
20144 86003 OpenEdge SQL Stored procedure Execution Null value fetched.
20145 86004 OpenEdge SQL Stored procedure Execution Invalid field reference.
20146 86005 OpenEdge SQL Triggers Trigger with this name already exists.
20147 86006 OpenEdge SQL Triggers Trigger with this name does not exist.
20148 86007 OpenEdge SQL Triggers Trigger Execution Failed.
20152 22001 Data exception Character string is too long.
20170 22P0 Data exception An invalid reference to a sequence was used.
20172 22565 Data exception Sequence already exists in current schema.
20173 0ALLV Feature not supported LIKE predicate for long data type uses unsupported feature.
20174 86010 OpenEdge SQL Triggers Invalid colnum number specified for Trigger OLDROW/NEWROW getValue/setValue method.
20175 86011 OpenEdge SQL Triggers Incompatible data type specified for Trigger OLDROW/NEWROW getValue/setValue method.
20176 85001 OpenEdge SQL Stored proc/Trigger IO error while compiling stored procedure/trigger.
20178 OaC01 Feature not supported Cannot rename table/column with check constraint.
20180 22915 Data exception Long data exceeds column width.
20181 22916 Data exception Long data exceeds maximum size of data that can be selected.
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 OpenEdge SQL snw error 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 OpenEdge SQL rds error Invalid collation name specified.
20241 08815 Connection exception Service in use.
20300 90901 DBS error Column group column does not exist.
20301 90902 DBS error Column group column already specified.
20302 90903 DBS error Column group name already specified.
20303 90904 DBS error Column groups have not covered all columns.
20304 90905 DBS error Column groups are not implemented in Progress storage.
20489 22948 Data exception This is a retired command and is no longer functional.
20490 22542 Data exception Password length has exceeded the maximum allowed limit.
23000 22563 OpenEdge SQL Data exception Table create returned invalid table id.
23001 22564 OpenEdge SQL Data exception Index create returned invalid index id.
25128 j0j28 OpenEdge SQL odbc trans layer Query terminated as max row limit exceeded for a remote table.
25131 j0j29 OpenEdge SQL odbc trans layer Unable to read column info from remote table.
30001 5050w OpenEdge SQL rds error Query aborted on user request.
30002 k0k02 OpenEdge SQL network interface Invalid network handle.
30003 k0k03 OpenEdge SQL network interface Invalid sqlnetwork INTERFACE.
30004 k0k04 OpenEdge SQL network interface Invalid sqlnetwork INTERFACE procedure.
30005 k0k05 OpenEdge SQL network interface INTERFACE is already attached.
30006 k0k06 OpenEdge SQL network interface INTERFACE entry not found.
30007 k0k07 OpenEdge SQL network interface INTERFACE is already registered.
30008 k0k08 OpenEdge SQL network interface Mismatch in pkt header size and total argument size.
30009 k0k09 OpenEdge SQL network interface Invalid server id.
30010 k0k10 OpenEdge SQL network interface Reply does not match the request.
30011 k0k02 OpenEdge SQL network interface Memory allocation failure.
30031 k0k11 OpenEdge SQL network interface Error in transmission of packet.
30032 k0k12 OpenEdge SQL network interface Error in reception of packet.
30033 k0k13 OpenEdge SQL network interface No packet received.
30034 k0k14 OpenEdge SQL network interface Connection reset.
30051 k0k15 OpenEdge SQL network interface Network handle is inprocess handle.
30061 k0k16 OpenEdge SQL network interface Could not connect to sql network daemon.
30062 k0k17 OpenEdge SQL network interface Error in number of arguments.
30063 k0k18 OpenEdge SQL network interface Requested INTERFACE not registered.
30064 k0k19 OpenEdge SQL network interface Invalid INTERFACE procedure id.
30065 k0k20 OpenEdge SQL network interface Requested server executable not found.
30066 k0k21 OpenEdge SQL network interface Invalid configuration information.
30067 k0k22 OpenEdge SQL network interface INTERFACE not supported.
30091 k0k23 OpenEdge SQL network interface Invalid service name.
30092 k0k24 OpenEdge SQL network interface Invalid host.
30093 k0k25 OpenEdge SQL network interface Error in tcp/ip accept call.
30094 k0k26 OpenEdge SQL network interface Error in tcp/ip connect call.
30095 k0k27 OpenEdge SQL network interface Error in tcp/ip bind call.
30096 k0k28 OpenEdge SQL network interface Error in creating socket.
30097 k0k29 OpenEdge SQL network interface Error in setting socket option.
30101 k0k30 OpenEdge SQL network interface Interrupt occurred.
40001 L0L01 OpenEdge SQL env error Error in reading configuration.
210001 08P00 Connection exception Failure to acquire share schema lock during connect.
210002 08004 Connection exception Failure in finding DLC environment variable.
210003 08004 Connection exception DLC environment variable exceeds maximum size <max_size> -> <DLC path>.
210004 08004 Connection exception Error opening convmap.cp file <filename> <path>.
210005 P1000 Unavailable resource Failure getting lock table on table <table_name>.
210011 08004 Internal error Fatal error identifying database log in SQL.
210012 22P00 Data exception Column <column_name> in table <table_name> has value exceeding its max length or precision.
210013 08004 Connection exception Unable to complete server connection. <function_name>; reason <summary_of_reason>.
210014 22P01 Data exception Column values too big to make key. Table <table_name>; index <index_name>.
210015 P1000 Unavailable resource Failure getting record lock on a record table <table_name>.
210016 P1001 Unavailable resource Lock table is full.
210017 P1002 Unavailable resource Failure to acquire exclusive schema lock for DDL operation.
210018 0AP01 Unsupported feature Update of word indexes not yet supported. Table <table_name>, index <index_name>.
210019 0A000 Unsupported feature Scan of word indexes not yet supported. Table <table_name>, index <index_name>.
210020 0AP03 Unsupported feature The first index created for a table may not be dropped.
210021 85001 Progress/SQL stored procedure compilation Location of the Java compiler was not specified.
210044 86008 OpenEdge stored procedure execution Need to recompile stored procedures (run scriptSQLConvertSPTP - refer to release notes).
210045 86009 OpenEdge SQL triggers Need to recompile triggers (run script SQLConvertSPTP - refer to release notes).
210047 22P00 OpenEdge SQL Update Statistics Table %s.%s at Rowid %s has column %s whose value exceeding its max length or precision.
210048 70101 Data exception Cache overflowed.
210049 22566 Data exception Unable to read sequence record.
210050 22564 Data exception The sequence was unable to cycle to another value.
210051 22563 Data exception Sequence not found.
210052 22P00 Data exception Maximum number of sequences already defined.
210054 2250z Data exception A sequence value was referenced outside of the defined range of values.
210055 42807 Access rule violation Operation not allowed on the read-only database.
210056 42700 Syntax error Syntax error at or about %s.
210057 85001 OpenEdge SQL Stored proc/Trigger OpenEdge/SQL Java Native Interface(JNI) version not supported.
210058 85001 OpenEdge SQL Stored proc/Trigger Error from Java compiler. Compiler messages follow.
210059 22P00 OpenEdge SQL statistics Database statistics (%s) updated for all tables.
210060 22P00 OpenEdge SQL statistics Database statistics (%s) updated for table %s.
210061 22P00 OpenEdge SQL statistics Database statistics (%s) updated by direct user SQL statement (%s).
210062 70101 OpenEdge SQL statement mgr mgr removed a prepared, never executed statement from statement cache. %s statements currently in use (%s cache).
210158 22555 Data exception Incorrect duration supplied for given periodicity.
210159 22555 Data exception Specify value for %s within limit %s
211013 3F001 Bad schema reference SQL cannot alter or drop a table or index created by ABL or SQL 89.
211014 3F002 Bad schema reference Incorrect view owner name on CREATE VIEW—cannot be PUB or _FOREIGN.
211015 3F003 Bad schema reference Database object (table, view, index, trigger, procedure, or synonym) owned by "sysprogress" cannot be created, dropped, or altered.
211016 3F004 Bad schema reference Database schema table cannot be created, dropped, or altered.
211017 3F004 Bad schema reference Attempt to insert, update, or delete a row in a schema table.
211018 0A000 Array reference error Array reference/update incorrect.
218001 P8P18 OpenEdge I18N NLS error Failure to create a NLS character set conversion handler.
219901 P0000 Internal error Internal error <error_num1> <error_meaning> in SQL from subsystem <subsystem_name> function <function_name> called from <calling_function> on <object_2> for <object_1>. Save log for Progress technical support.
219902 P0001 Internal error Failure reading schema during DDL operation.
219903 P0002 Internal error Inconsistent metadata - contact Progress technical support.
219907 22542 Data exception Can not switch AUS logging state while AUS service is disabled.
219951 40P00 Transaction rollback Fatal error <error_num> <error_meaning> in SQL from subsystem <subsystem_name> function <function_name> called from <calling_function> on <object_2> for <object_1>. Save log for Progress technical support.