Progress
SQL-92
Guide and Reference


Error Codes, SQLSTATE Values, and Messages

Table A–3 is a list of Progress SQL-92 error messages, ordered by error code number. The table shows the corresponding SQLSTATE value for each message.

Table A–3: Progress SQL-92 Error Codes and Messages
Error Code
SQL
STATE 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
Progress/SQL MM error
No more records exist
10102
2350i
Integrity constraint
Duplicate primary/index key value
10104
M0M06
Progress/SQL rss error
Specified index method is not supported
10107
N0N07
Flag
EIX_SCAN_EOP flag is set
10108
50903
Progress/SQL rds error
Duplicate record specified
10301
M0901
Progress/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
Progress/SQL rds error
Invalid transaction id
11102
50903
Progress/SQL rds error
TDS area specified is not found
11103
50504
Progress/SQL rds error
TDS not found for binding
11104
50505
Progress/SQL rds error
Transaction aborted
11105
50506
Progress/SQL rds error
Transaction error
11109
50510
Progress/SQL rds error
Invalid transaction handle
11111
50912
Progress/SQL rds error
Invalid isolation level
11300
M0M00
Progress/SQL rss error
Specified INFO type is not supported
11301
M0M01
Progress/SQL rss error
Specified index type is not supported
16001
22701
Data exception
MM– No data block
16002
70702
Progress SQL-92 MM error
MM– Bad swap block
16003
70703
Progress SQL-92 MM error
MM– No cache block
16004
22704
Data exception
MM– Invalid row number
16005
70705
Progress SQL-92 MM error
MM– Invalid cache block
16006
70706
Progress SQL-92 MM error
MM– Bad swap file
16007
70707
Progress SQL-92 MM error
MM– Row too big
16008
70708
Progress SQL-92 MM error
MM– Array initialized
16009
70709
Progress SQL-92 MM error
MM– Invalid chunk number
16010
70710
Progress SQL-92 MM error
MM– Cannot create table
16011
70711
Progress SQL-92 MM error
MM– Cannot alter table
16012
70712
Progress SQL-92 MM error
MM– Cannot drop table
16020
70713
Progress SQL-92 MM error
MM– TPL ctor error
16021
70714
Progress SQL-92 MM error
MM– Insertion error
16022
70715
Progress SQL-92 MM error
MM– Deletion error
16023
70716
Progress SQL-92 MM error
MM– Updation error
16024
70717
Progress SQL-92 MM error
MM– Fetching error
16025
70718
Progress SQL-92 MM error
MM– Sorting error
16026
70719
Progress SQL-92 MM error
MM– Printing error
16027
70720
Progress SQL-92 MM error
MM– TPLSCAN ctor error
16028
70721
Progress SQL-92 MM error
MM– Scan fetching error
16030
70722
Progress SQL-92 MM error
MM– Can’t create index
16031
70723
Progress SQL-92 MM error
MM– Can’t drop index
16032
70724
Progress SQL-92 MM error
MM– IXSCAN ctor error
16033
70725
Progress SQL-92 MM error
MM– IX ctor error
16034
70726
Progress SQL-92 MM error
MM– IX deletion error
16035
70727
Progress SQL-92 MM error
MM– IX appending error
16036
70728
Progress SQL-92 MM error
MM– IX insertion error
16037
70729
Progress SQL-92 MM error
MM– IX scan fetching error
16040
70730
Progress SQL-92 MM error
MM– Begin transaction
16041
70731
Progress SQL-92 MM error
MM– Commit transaction
16042
40000
Transaction rollback
***MM– Rollback transaction
16043
70732
Progress SQL-92 MM error
MM– Mark point
16044
70733
Progress SQL-92 MM error
MM– Rollback savepoint
16045
70734
Progress SQL-92 MM error
MM– Set & Get isolation
16050
70735
Progress SQL-92 MM error
MM– TID to char
16051
70736
Progress SQL-92 MM error
MM– char to TID
20000
50501
Progress SQL-92 rds error
SQL internal error
20001
50502
Progress SQL-92 rds error
Memory allocation failure
20002
50503
Progress SQL-92 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
Progress SQL-92 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
Progress SQL-92 rds error
Too many table references
20027
42528
Access rule violation
Bad field specification in order by clause
20028
50529
Progress SQL-92 rds error
An index with the same name already exists
20029
50530
Progress SQL-92 rds error
Index referenced not found
20030
22531
Data exception
Table space with same name already exists
20031
50532
Progress SQL-92 rds error
Cluster with same name already exists
20032
50533
Progress SQL-92 rds error
No cluster with this name
20033
22534
Data exception
Table space not found
20034
50535
Progress SQL-92 rds error
Bad free <specification_name> specification
20035
50536
Progress SQL-92 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 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
Progress SQL-92 rds error
Tuple size too high
20044
50545
Progress SQL-92 rds error
Array size too high
20045
08546
Connection exception
File does not exist or not accessible
20046
50547
Progress SQL-92 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
Progress SQL-92 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
Progress SQL-92 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
Progress SQL-92 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
Progress SQL-92 rds error
Statement 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
Progress SQL-92 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
Progress SQL-92 rds error
Permission denied
20122
5050r
Progress SQL-92 rds error
Procedure not found
20123
5050s
Progress SQL-92 rds error
Invalid arguments to procedure
20124
5050t
Progress SQL-92 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
Progress SQL-92 rds error
Revoke failed because of restrict
20134
5050v
Progress SQL-92 rds error
Invalid long datatype column references
20135
5050x
Progress SQL-92 rds error
Contains operator is not supported in this context
20135
m0m01
Progress SQL-92 diagnostics error
Diagnostics statement failed
20136
5050z
Progress SQL-92 rds error
Contains operator is not supported for this datatype
20137
50514
Progress SQL-92 rds error
Index is not defined or does not support CONTAINS
20138
50513
Progress SQL-92 rds error
Index on long fields requires that it can push down only CONTAINS
20140
50512
Progress SQL-92 rds error
Procedure already exists
20141
85001
Progress SQL-92 Stored procedure Compilation
Error in Stored Procedure Compilation
20142
86001
Progress SQL-92 Stored procedure Execution
Error in Stored Procedure Execution
20143
86002
Progress SQL-92 Stored procedure Execution
Too many recursions in call procedure
20144
86003
Progress SQL-92 Stored procedure Execution
Null value fetched.
20145
86004
Progress SQL-92 Stored procedure Execution
Invalid field reference
20146
86005
Progress SQL-92 Triggers
Trigger with this name already exists
20147
86006
Progress SQL-92 Triggers
Trigger with this name does not exist
20148
86007
Progress SQL-92 Triggers
Trigger Execution Failed
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
Progress SQL-92 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
Progress SQL-92 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
Progress SQL-92 Data exception
Table create returned invalid table id
23001
22564
Progress SQL-92 Data exception
Index create returned invalid index id
25128
j0j28
Progress SQL-92 odbc trans layer
Query terminated as max row limit exceeded for a remote table
25131
j0j29
Progress SQL-92 odbc trans layer
Unable to read column info from remote table
30001
5050w
Progress SQL-92 rds error
Query aborted on user request
30002
k0k02
Progress SQL-92 network interface
Invalid network handle
30003
k0k03
Progress SQL-92 network interface
Invalid sqlnetwork INTERFACE
30004
k0k04
Progress SQL-92 network interface
Invalid sqlnetwork INTERFACE procedure
30005
k0k05
Progress SQL-92 network interface
INTERFACE is already attached
30006
k0k06
Progress SQL-92 network interface
INTERFACE entry not found
30007
k0k07
Progress SQL-92 network interface
INTERFACE is already registered
30008
k0k08
Progress SQL-92 network interface
Mismatch in pkt header size and total argument size
30009
k0k09
Progress SQL-92 network interface
Invalid server id
30010
k0k10
Progress SQL-92 network interface
Reply does not match the request
30011
k0k02
Progress SQL-92 network interface
Memory allocation failure
30031
k0k11
Progress SQL-92 network interface
Error in transmission of packet
30032
k0k12
Progress SQL-92 network interface
Error in reception of packet
30033
k0k13
Progress SQL-92 network interface
No packet received
30034
k0k14
Progress SQL-92 network interface
Connection reset
30051
k0k15
Progress SQL-92 network interface
Network handle is inprocess handle
30061
k0k16
Progress SQL-92 network interface
Could not connect to sql network daemon
30062
k0k17
Progress SQL-92 network interface
Error in number of arguments
30063
k0k18
Progress SQL-92 network interface
Requested INTERFACE not registered
30064
k0k19
Progress SQL-92 network interface
Invalid INTERFACE procedure id
30065
k0k20
Progress SQL-92 network interface
Requested server executable not found
30066
k0k21
Progress SQL-92 network interface
Invalid configuration information
30067
k0k22
Progress SQL-92 network interface
INTERFACE not supported
30091
k0k23
Progress SQL-92 network interface
Invalid service name
30092
k0k24
Progress SQL-92 network interface
Invalid host
30093
k0k25
Progress SQL-92 network interface
Error in tcp/ip accept call
30094
k0k26
Progress SQL-92 network interface
Error in tcp/ip connect call
30095
k0k27
Progress SQL-92 network interface
Error in tcp/ip bind call
30096
k0k28
Progress SQL-92 network interface
Error in creating socket
30097
k0k29
Progress SQL-92 network interface
Error in setting socket option
30101
k0k30
Progress SQL-92 network interface
Interrupt occurred
40001
L0L01
Progress SQL-92 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<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
211013
3F001
Bad schema reference
SQL-92 cannot alter or drop a table created by 4GL 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 table or view 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
Progress 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


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095