Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Error Messages : Error codes, SQLSTATE values, and messages
 

Error codes, SQLSTATE values, and messages

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