Mimer SQL Programmer's Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


Internal Mimer SQL Return Codes


Here the internal Mimer SQL return code values are listed together with the associated text message. See Run-time Errors for details on how to retrieve this information after an exception has been raised.

The codes are grouped according to function as follows:

Code numbers
Functional group
> 0
Warnings, messages
= 0
Success
100
No data
-100 to -999
ODBC error codes
-10000 to -10999
Data-dependent errors
-11000 to -11999
Limits exceeded
-12000 to -12999
SQL statement errors
-13000 to -13999
Not currently used
-14000 to -14999
Program-dependent errors
-15000 to -15999
Not currently used
-16000 to -16999
Databank and table errors
-17000 to -17999
Not currently used
-18000 to -18999
Miscellaneous errors
-19000 to -19999
Internal errors
-20000 to -20999
Not currently used
-21000 to -21999
Communication errors
-22000 to -22999
JDBC error codes

Corrective action is given in general terms for each group of codes. When reporting errors to Mimer support, make sure you include the internal Mimer SQL return code.

Warnings and Messages

No corrective action is normally required for internal Mimer SQL return code values greater than zero.

Number
Explanation
54
Character string was truncated
55
Insufficient item descriptor areas
56
Privilege not revoked
57
Privilege not granted
58
Zero bits were added to the binary string
90
Login failure
91
Soft enter performed
92
No cursor state was saved on stack
94
Message text not found
100
Row not found for FETCH, UPDATE or DELETE, or the result of a query is an empty table
100
No data - Item number is greater than the value of count

ODBC Errors and Warnings

These errors occur when ODBC calls to Mimer SQL fail for some reason.

Number
Explanation
-100
Illegal sequence
-101
Out of memory
-102
Option out of range
-103
Function not supported
-104
Connection not open
-105
Connection in use
-106
Invalid argument value
-107
Invalid transaction operation code
-108
Internal network buffer overflow
-109
Invalid C data type
-110
Invalid SQL data type
-111
Bad address
-112
Function already active
-113
Operation canceled
-114
Wrong number of parameters
-115
Use ODBC function SQLTransact to commit or rollback transaction
-116
Statement is not in a prepared state
-117
Invalid transaction state
-118
Unknown statement type
-119
Unknown internal data type
-120
Extype corrupt
-121
Invalid buffer length
-122
String data truncated
-123
Numeric data truncated
-124
Numeric value out of range
-125
Invalid numeric value
-126
Bad parameter passed to numeric package
-127
Invalid column number
-128
Database name mandatory
-129
Connect dialog failed
-130
Data truncated
-131
Invalid connection string attribute
-132
Invalid cursor state
-133
Invalid parameter number
-134
Descriptor type out of range
-135
Invalid type passed to DICOA3
-136
Function type out of range
-137
Invalid cursor name
-138
Duplicate cursor name
-139
Cursor hash table corrupt
-140
ODBC database control block chain corrupt
-141
Option type out of range
-142
Option value not supported
-143
Option not supported
-144
Invalid row or keyset size
-145
Invalid concurrency option
-146
Invalid fetch type
-147
Not a scrollable cursor
-148
Row position out of range
-149
Only one SQLPutData for fixed length parameter
-150
SQLPutData does not support block cursors
-151
Driver not capable
-152
Table type out of range
-153
Invalid string length
-154
Data type out of range
-155
Syntax error found in escape clause
-156
DDO buffer overflow
-157
Uniqueness option type out of range
-158
Accuracy option type out of range
-159
Column type out of range
-160
Scope type out of range
-161
Nullable type out of range
-162
Internal type mismatch
-163
Conversion between data types not supported
-164
Invalid date, time, or timestamp
-165
Restricted data type attribute violation
-166
Date, time, or timestamp data truncated
-167
Database has not been configured. Run Configure MIMER 7.1
-168
Translated native SQL string was truncated
-169
ODBC extension DATE, TIME or TIMESTAMP is not supported
-170
ODBC extension OUTER JOIN is not supported
-171
ODBC extension for procedure invocation is not supported
-172
Unrecognized first word in escape clause, expected 'CALL','FN','OJ','D','T' or 'TS'
-173
This server version does not support the used scalar function
-174
Unrecognized scalar function found in escape clause
-175
Argument missing in scalar function
-176
Too many arguments in scalar function
-177
Syntax error, incomplete escape clause
-178
Syntax error, unmatched apostrophe in string literal
-179
Syntax error, unmatched quote in delimited identifier
-180
Invalid data type specified in scalar function CONVERT
-181
Information type out of range
-182
Parameter type may only be used with procedures
-183
Parameter type out of range
-184
Update and delete where current fully supported (not simulated)
-185
Option value changed
-186
Static scrollable cursor used instead of keyset or dynamic cursor
-187
Error in row, please check next error code
-188
Cancel treated as FreeStatement/CLOSE
-189
Attempt to fetch before the result set returned the first rowset
-190
Invalid cursor position
-191
Unknown first parameter in scalar function TIMESTAMPADD
-192
Unknown first parameter in scalar function TIMESTAMPDIFF
-193
Bad parameter passed to datetime package
-194
Out of critical section objects
-196
Invalid attribute option identifier
-197
Attribute cannot be set now
-198
General error
-199
Invalid use of an automatically allocated descriptor
-200
Invalid descriptor field identifier
-201
Invalid descriptor index
-202
Associated statement not prepared
-203
Interval second fraction truncated
-204
Interval truncation error
-205
Interval convert error
-206
Year to month interval cannot be converted to a numeric value because it is not a single field
-207
Interval cannot be converted to a numeric value because it is not a single field
-208
Invalid interval literal
-209
Interval leading field truncation error
-210
Interval trailing field truncated
-211
Binary data truncated
-212
Binary truncation error
-213
Binary length invalid
-214
Binary data invalid
-215
Binary not supported
-216
Inconsistent descriptor information
-217
Cannot modify IRD
-218
Invalid use of null pointer
-219
Character data not hexadecimal
-220
Internal error
-221
Significant parts of datetime/interval string truncated
-222
Interval field truncation
-223
String data truncated
-224
Binary data truncated
-225
String data truncated
-226
Binary data truncated

Data-dependent Errors

These errors arise when an SQL statement cannot be executed correctly because of the data content of variables, expressions, and so on in the statement. The appropriate corrective action is determined by the nature of the error and the specific context in the application program.

Number
Explanation
-10001
Transaction aborted due to conflict with other transaction
-10100
PRIMARY KEY constraint violation, attempt to insert NULL value
-10101
PRIMARY KEY constraint violation, attempt to insert duplicate value
-10102
Domain constraint violation <%>
-10103
Table constraint violation <%>
-10104
View constraint violation <%>
-10105
INSERT or UPDATE operation invalid because the referencing table <%> does not satisfy a referential constraint
-10106
UPDATE or DELETE operation invalid because the referenced table <%> does not satisfy a referential constraint
-10107
The result of a subquery in a basic predicate is more than one value
-10108
Result of SELECT INTO or EXECUTE INTO statement is a table of more than one row
-10109
Type constraint violation
-10110
UNIQUE constraint violation
-10199
Host variable type packed decimal is not supported
-10200
Reserved numeric operand found during data type conversion
-10201
Length error or incorrect value found during data type conversion
-10202
Division by zero attempted
-10203
Negative overflow occurred during data type conversion
-10204
Positive overflow occurred during data type conversion
-10205
Loss of significance occurred during data type conversion
-10207
Undefined value found during data type conversion
-10208
Restricted data type attribute violation
-10210
Error in assignment
-10211
Undefined value found during data type conversion
-10212
Overflow occurred during data type conversion
-10221
The NULL value cannot be assigned to a host variable because no indicator variable is specified
-10222
NULL not allowed for item descriptor area
-10250
Data type not supported
-10301
Loss of significance occurred in arithmetic operation <%>
-10302
Positive overflow occurred in arithmetic operation <%>
-10303
Negative overflow occurred in arithmetic operation <%>
-10304
Division by zero attempted
-10305
Bad parameter encountered in arithmetic operation <%>
-10306
Invalid input for numeric function
-10307
The binary strings are of unequal length
-10310
Invalid character value for CAST
-10311
String data truncated
-10312
Numeric value out of range
-10313
Illegal (negative) substring length
-10314
Like pattern escape character not followed by underscore or percent character
-10315
Length of like pattern escape character is not equal to 1
-10321
Datetime loss of significance
-10322
Datetime positive overflow
-10323
Datetime negative overflow
-10325
Bad parameter encountered in datetime operation
-10326
Datetime illegal operand
-10327
Invalid datetime value
-10328
Datetime subtype mismatch
-10329
Invalid datetime format
-10331
Interval loss of significance
-10332
Interval positive overflow
-10333
Interval negative overflow
-10335
Bad parameter encountered in interval operation
-10336
Interval illegal operand
-10337
Invalid interval value
-10338
Interval subtype mismatch
-10339
Invalid interval format
-10601
Invalid value for field of item descriptor area
-10602
Invalid datetime or interval code

Limits Exceeded

These errors arise when internal limits in the Mimer SQL system are exceeded. Some of the limitations are determined by installation-specific parameters, while others are fixed by Mimer SQL. In general, errors of this nature require either re-installation of the system with extended limitations or modification of the application program to reduce the system demands.

Contact your Mimer representative if you have difficulty avoiding errors of this nature.

Number
Explanation
-11001
Dynamic storage area exhausted in host level interface (DYNDE3)
-11002
Internal DB dynamic storage area (SQLPOOL) exhausted
-11011
Internal storage (SQLPOOL) for like pattern exhausted
-11012
Transaction list exhausted
-11013
Too many databanks referenced in statement (max 30)
-11014
Too many databanks active in transaction
-11047
The maximum number of recursive invocations has been exceeded
-11100
Internal limit exceeded : query stack
-11101
Internal limit exceeded : scan stack
-11102
Internal limit exceeded : generation stack
-11103
Internal limit exceeded : table descriptor list
-11105
Internal limit exceeded : patch table
-11106
Internal limit exceeded : label table
-11107
Internal limit exceeded : traversal stack
-11108
Internal limit exceeded : sco list
-11109
Internal limit exceeded : boolean stack
-11111
Internal limit exceeded : semantic stack
-11113
Internal limit exceeded : statement too complex
-11114
Required temporary table row length is <%>, only <%> is possible
-11115
Internal limit exceeded : restriction group pool
-11118
Internal limit exceeded : scan queue

SQL Statement Errors

These errors arise from syntactic or semantic errors in SQL statements. In general, syntactic errors in embedded SQL programs are detected by the preprocessor, so errors cannot arise at run-time.

Dynamically submitted SQL statements are however parsed at run-time, and the syntax error codes are returned after attempting PREPARE for a syntactically incorrect source statement.

Semantic errors can arise at run-time from both dynamic and static SQL statements.

Number
Explanation
-12001
Too many errors, error collection terminated
-12101
Syntax error, <%> assumed missing
-12102
Syntax error, <%> ignored
-12103
Syntax error, <%> assumed to mean <%>
-12104
Invalid construction
-12106
Internal parser error, analysis aborted
-12107
Syntax analysis resumed here
-12108
Multiple statements not allowed
-12120
Table name too long
-12121
String literal too long
-12122
Numeric literal too long
-12123
Invalid password string
-12124
Invalid hexadecimal literal
-12125
Reserved word may not be used as an identifier
-12126
Invalid name
-12128
Result of concatenation too long
-12129
Table definition does not include any column specification
-12131
Table definition includes more than one PRIMARY KEY specification
-12132
Only one column allowed in column list
-12152
<%> not allowed in EXECUTE mode
-12154
User name too long
-12156
Column name too long
-12157
Synonym name too long
-12158
Correlation name too long
-12159
Cursor name too long
-12160
Databank name too long
-12161
Shadow name too long
-12162
Host Variable or Parameter Marker name too long
-12163
File name too long
-12164
Label name too long
-12165
Index name too long
-12166
Object name too long
-12167
View name too long
-12168
Domain name too long
-12169
Too many identifier names given
-12174
Syntax error in escape clause, expecting comma before PRODUCT or CONFORMANCE specification
-12175
Syntax error in escape clause, invalid CONFORMANCE specification
-12176
Syntax error in escape clause, invalid YEAR specification
-12177
Syntax error in escape clause, invalid PRODUCT specification
-12178
Syntax error in escape clause, invalid VENDOR specification
-12179
Syntax error in escape clause, expecting VENDOR or YEAR after '--(*'
-12180
Syntax error, unexpected token '*)--'
-12181
Syntax error in escape clause, terminating '*)--' missing
-12182
Syntax error in escape clause
-12200
Table <%> not found, table does not exist or no access privilege
-12201
Table reference <%> is ambiguous
-12202
<%> is not a column of an inserted table, updated table or any table identified in a FROM clause
-12203
<%> is neither an object table of an INSERT, UPDATE or DELETE statement, nor specified in a FROM clause
-12204
Column reference <%> ambiguous
-12205
Column <%> not referenced in GROUP BY clause
-12207
DISTINCT specified more than once in a subselect
-12208
SELECT clause of a subquery specifies more than one column
-12209
Column <%> identified in HAVING clause but not included in GROUP BY clause
-12210
Operand of set function includes a set function
-12212
Operand of set function includes a correlated reference specified in an expression
-12213
Set function not specified in a SELECT clause or HAVING clause
-12214
Invalid operand type, expected type is <%>
-12215
Operand not of <%> type
-12216
Operands are not comparable
-12217
Set function containing DISTINCT may not be specified within an expression
-12220
Expression must be a column
-12221
SELECT clause contains both column expressions and set function expressions
-12223
ORDER BY clause invalid because it includes a column name that is not part of the result table
-12224
ORDER BY clause invalid because it includes an integer which does not identify a column of the result table
-12225
The ORDER BY clause is invalid because it includes an ambiguous column reference
-12226
Set function argument not bound in HAVING context
-12227
Duplicate column reference in FOR UPDATE OF clause
-12230
Invalid numeric literal
-12231
Update or insert value is NULL, but the object column <%> cannot contain NULL values
-12232
Insert value must be a constant expression or NULL
-12233
The number of insert values is not the same as the number of object columns
-12234
Update or insert value not compatible with the data type of the object column <%>
-12236
Column name <%> does not identify a unique column of the result table
-12238
Column <%> cannot be updated because it is derived from a set function or expression
-12239
The use of NULL in a SELECT clause is only allowed in a UNION
-12240
Statement contains too many table references
-12242
The corresponding columns of the operands of a UNION do not have compatible column descriptions
-12243
Result table contains a column for which the type cannot be determined
-12244
Operands of a UNION do not have the same number of columns
-12245
FOR UPDATE clause may not be specified because the result table cannot be modified
-12246
Column <%> in the FOR UPDATE clause is not part of the identified table or view
-12250
A host variable or parameter marker is not allowed in a view definition
-12251
CREATE VIEW statement must include a column list because the SELECT clause contains an expression
-12252
CREATE VIEW statement must include a column list because the SELECT clause contains duplicate column names
-12253
The number of columns specified for the view is not the same as specified by the SELECT clause
-12254
WITH CHECK OPTION cannot be used for the specified view because it cannot be modified
-12258
<%> operation not permitted because the view cannot be modified
-12259
<%> operation not permitted because the joined table cannot be modified
-12261
INSERT statement not permitted because the object column <%> is derived from an expression
-12262
The type of the parameter marker cannot be determined
-12263
Parameter markers and host variables not allowed in EXECUTE IMMEDIATE environment
-12264
Parameter markers may not be specified in SELECT clause
-12265
Literal or computed value overflow
-12266
Decimal divide operation invalid because the result would have a negative scale
-12267
Duplicate column reference in INSERT column list
-12268
Duplicate column reference in UPDATE set clauses
-12269
Duplicate column reference in View Parameter
-12270
<%> does not have <%> privilege on object <%>
-12271
Duplicate column reference in GROUP BY clause
-12273
The types of the results of a CASE expression are not type compatible
-12274
The type of the CASE expression result cannot be determined
-12275
At least one result in a CASE expression must be non-null
-12277
Invalid CAST data type specification
-12278
Invalid EXTRACT field specification
-12280
Invalid datetime literal
-12281
Invalid interval literal
-12282
Invalid interval qualifier
-12283
Invalid use of interval qualifier
-12300
Syntax error in escape clause
-12301
Translated native SQL string was truncated
-12302
The function <%> is not supported
-12303
Unrecognized first word, <%> in escape clause expected 'CALL', 'FN','OJ', 'D', 'T' or 'TS'
-12304
Unrecognized scalar function <%>
-12305
Invalid data type <%> in function CONVERT
-12306
Syntax error, incomplete escape clause
-12307
Syntax error, unmatched apostrophe in string literal
-12308
Syntax error, unmatched quote in delimited identifier
-12309
Unknown first parameter <%> in scalar function <%>
-12310
Argument missing in scalar function <%>
-12311
Too many arguments in scalar function <%>
-12500
A databank named <%> already exists (or filename already used)
-12501
Table <%> does not exist
-12502
<%> does not have <%> privilege
-12503
<%> does not have <%> privilege on object <%>
-12504
Statement not allowed within transaction
-12505
<%> is not a USER or PROGRAM ident
-12506
No privilege
-12507
<%> does not have any databank available
-12509
An ident cannot REVOKE a privilege from itself
-12510
An ident cannot GRANT a privilege to itself
-12511
Duplicate column specification
-12512
Invalid type description
-12516
Qualified column name required
-12517
Object <%> does not exist
-12518
Circular grant of membership between groups not permitted
-12520
An ident cannot GRANT a privilege to itself
-12523
Databank <%> does not exist
-12526
Default value for NOT NULL column <%> missing
-12530
Operand not of type <%>
-12531
Operands not comparable
-12533
Literal or computed value overflow
-12534
Invalid numeric literal
-12535
Invalid identifier, keyword VALUE expected
-12536
Name <%> in PRIMARY KEY specification not recognized as a column name of current table definition
-12537
<%> must be unqualified
-12538
Default value not compatible with domain definition
-12539
Host variable construction illegal in this context
-12540
<%> is not a column of the specified table(s)
-12542
Default value is outside the range specified by domain definition
-12544
Too many columns specified in <%> statement
-12545
Primary key column <%> may not be updated because the table is in a NULL databank
-12546
Column <%> is not type compatible with the corresponding column of the referenced table
-12547
Number of columns specified in the foreign key is not the same as the number of columns in the primary key of the referenced table
-12549
Databank option may not be changed to NULL since <%> contains tables with FOREIGN KEY, REFERENCE, UNIQUE or trigger specifications
-12550
Table <%> includes a FOREIGN KEY or UNIQUE constraint and may therefore not be created in a databank with NULL option
-12551
Table <%> is in a databank with NULL option and may therefore not be used as referential constraint
-12553
Explicit grant membership on PUBLIC is not permitted
-12554
PUBLIC cannot be member of another group
-12556
<%> cannot be shadowed because it is a NULL databank
-12557
Shadow named <%> already exists
-12558
Ident named <%> already exists
-12559
Index named <%> already exists
-12560
Table, View or Synonym named <%> already exists
-12561
Domain <%> not found, domain does not exist or no usage privilege
-12563
Shadow <%> does not exist
-12564
Ident <%> does not exist
-12565
Maximum row length exceeded by index or key table
-12566
Maximum row length exceeded by base table
-12568
EXISTS construction illegal in this context
-12569
ALL or ANY construction illegal in this context
-12570
Set function construction illegal in this context
-12571
Subquery construction illegal in this context
-12572
Too many columns given in FOREIGN KEY clause
-12573
Name <%> in CHECK clause not recognized as a column name of current table definition
-12574
Name <%> in column constraint not recognized as current column name
-12577
Default value not compatible with column specification
-12579
No such unique constraint in referenced table
-12581
Too many columns given in UNIQUE constraint
-12582
UNIQUE constraint equivalent to PRIMARY KEY constraint
-12583
UNIQUE constraint equivalent to previously given UNIQUE constraint
-12585
Name <%> in FOREIGN KEY clause not recognized as a column name of current table definition
-12590
Table contains too many columns
-12591
Cannot create unique index
-12592
Dependencies exist, RESTRICT specified
-12593
Column <%> does not exist
-12594
Column <%> cannot be dropped as it is the only column in table
-12595
Column <%> cannot be dropped, dependencies exist
-12596
Default value for column <%> does not exist
-12597
Change of data type is not allowed for a column included in a key or index
-12598
The data type for a column can not be changed to a domain
-12599
The proposed data type change is not supported
-12600
Change of data type is not supported for a column used by a view, routine or trigger
-12601
Statement does not support backup of <%>
-12602
The same file name is given for backup and incremental backup
-12603
Database is already OFFLINE
-12604
Database is already ONLINE
-12605
Cannot RESET LOG, because database is ONLINE
-12606
Databank <%> is already OFFLINE
-12607
Databank <%> is already ONLINE
-12608
Cannot RESET LOG, because databank <%> is ONLINE
-12609
Shadow <%> is already OFFLINE
-12610
Shadow <%> is already ONLINE
-12611
Cannot RESET LOG, because shadow <%> is ONLINE
-12612
Shadow <%> is already specified
-12613
Cannot set more than one shadow OFFLINE for databank having shadow <%>
-12614
Statistics cannot be updated for <%> because it is a view
-12615
Filename already used by databank or shadow
-12616
Cannot SET DATABASE OFFLINE, because another user is connected
-12617
Cannot SET DATABANK <%> OFFLINE, because the databank is in use
-12618
INCREMENTAL backups can only be used in conjunction with EXCLUSIVE
-12620
A domain named <%> already exists
-12621
A schema named <%> already exists
-12622
The schema name for the index table must be the same as the schema name for the table
-12623
A PRIMARY KEY constraint for this table has already been defined
-12624
The UNIQUE constraint cannot be created because the columns contain duplicates
-12625
Referential constraint criteria not fulfilled
-12626
Check constraint criteria not fulfilled
-12627
One or more specified columns does not exist in table
-12628
Referenced table or column not found
-12629
FOREIGN KEY not referencing a compatible UNIQUE or PRIMARY KEY
-12630
Constraint <%> cannot be dropped, dependencies exist
-12631
PRIMARY KEY or UNIQUE column constraint not valid when records exist
-12701
<%> is a reserved word, and cannot be used as the name for a symbol
-12702
<%> is a global variable, and cannot be used as the name for a variable or parameter
-12703
The class <%> is already present in the handler declaration
-12704
The SQLSTATE <%> is already present in the handler declaration
-12705
The condition identifier <%> is already present in the handler declaration
-12706
The condition identifier <%> is already used in another handler in this scope
-12707
A condition identifier for the SQLSTATE <%> has already been defined in this scope
-12708
<%> is not a valid SQLSTATE value
-12709
The SQLSTATE <%> associated with the condition identifier <%> is already present in the handler declaration
-12710
An exception handler for the state (<%>) associated with the condition identifier <%> has already been defined in this scope
-12711
An exception handler for the state <%> has already been defined in this scope
-12712
An exception handler for the class <%> has already been defined in this scope
-12713
The default literal is too large for this data type
-12714
The literal value is too large for this data type
-12715
The type of the default value is not compatible with the type of the variable
-12717
Invalid declaration. The maximum precision for this data type is <%>
-12718
The scale cannot exceed the precision
-12720
The number of correlation names for <%>, does not match number of result types
-12721
The parameter <%> for a result set procedure must be declared as IN
-12722
The parameter <%> is declared as IN, and cannot be assigned
-12723
The parameter <%> is declared as OUT, and cannot be used in expressions
-12724
<%> cannot be assigned a value directly
-12725
Result set procedures can only be used in cursor declarations
-12726
The formal argument of the routine is IN but the actual argument is OUT
-12727
The formal argument of the routine is OUT but the actual argument is IN
-12728
Literals or expressions cannot be used for OUT parameters
-12729
Return statements are only allowed in result set procedures or functions
-12730
Recursive call to <%>, not allowed
-12731
<%> statement not allowed in result procedure
-12732
The procedure <%> does not return a result set and cannot be used in a declare cursor for call
-12733
RESIGNAL statement only allowed in exception
-12734
Wrong number of items in result clause, <%> expected
-12735
Wrong number of parameters, <%> expected
-12736
Invalid type for argument, <%> expected
-12737
Too long name <%>
-12738
Duplicate declaration <%>
-12739
x.y.z names not allowed
-12740
Syntax error, <%> assumed to mean <%>
-12741
The label or routine <%> is not defined
-12742
The label <%> is not defined
-12743
The procedure <%> does not exist, (or no execute privilege)
-12744
The variable <%> is not defined
-12745
The condition identifier <%> is not defined
-12746
The cursor <%> is not defined
-12747
Use of domains in PSM control statements not allowed
-12748
Operands are incompatible
-12749
The SQL module <%> already exists
-12750
The procedure <%> already exists
-12751
Duplicate parameter <%>
-12752
The procedure <%> is declared in an SQL module, and cannot be dropped directly
-12753
Failed to read data dictionary
-12754
The length of a host variable cannot exceed 32
-12755
Host variables cannot be used within a procedure
-12756
The data type for the parameter marker cannot be determined
-12757
The number of items in the into clause is less than the number of items in the select list
-12758
The number of items in the into clause is greater than the number of items in the select list
-12759
The number of items in the fetch into clause is less than the number of items in the cursor declaration
-12760
The number of items in the fetch into clause is greater than the number of items in the cursor declaration
-12761
A fetch direction other than next, can only be defined for a scrollable cursor
-12762
The value in a fetch absolute or relative must be an integer
-12763
The argument to fetch absolute must be larger than 0
-12764
A cursor for call is read only and cannot be used in a update or delete where current statement
-12765
The cursor is declared as read only and cannot be used in a update or delete where current statement
-12766
The table name in the <%> statement is not the same as the name used in the cursor declaration
-12767
The column <%> is not specified in the for update list of the cursor declaration
-12768
The size for a data type must be larger than zero
-12769
It is not allowed to declare exception handlers or condition identifiers for the SQLSTATE successful completion ('00000')
-12770
The formal argument of the procedure is declared as INOUT but the actual argument is <%>
-12771
A handler declaration cannot contain both an exception class and SQLSTATE values or condition identifiers
-12772
The procedure does not return a result set and therefore cannot be used with a scroll cursor
-12773
<%> is not a column and is not declared as a variable or parameter
-12774
The label <%> has already been declared
-12775
The statement requires <%> access
-12776
<%> statement is only allowed if the access indication is MODIFIES SQL DATA or READS SQL DATA
-12777
<%> statements are only allowed if the access indication is MODIFIES SQL DATA
-12778
The access indication for a result set procedure must be READS SQL DATA or CONTAINS SQL
-12779
An UNDO exception handler can only be specified in an atomic compound statement
-12781
Only assignment and comparison operations allowed
-12782
The column name <%> has already occurred in this row declaration
-12783
The field <%> is not defined in the row data type
-12784
The row data types do not have the same number of fields
-12785
A row data type variable may not be used as a parameter or result type nor in a DML statement
-12800
Functionality not supported
-12801
Referencing OLD TABLE is not allowed if trigger event is INSERT
-12802
Referencing NEW TABLE is not allowed if trigger event is DELETE
-12803
The compound statement in a triggered action must be atomic
-12804
Referencing OLD or NEW ROW may only be used if FOR EACH ROW is specified
-12805
A column list can only be specified if trigger event is UPDATE
-12806
Duplicate column name in OF list
-12807
It is not allowed to modify the <%> table
-12808
The trigger time for a view must be INSTEAD OF
-12809
The trigger time for a base table can not be INSTEAD OF
-12810
Only the creator of a table is allowed to create a trigger for the table
-12811
It is not allowed to create triggers for tables, located in databanks with NULL option
-12812
Referencing OLD or NEW table is not allowed in FOR EACH ROW triggers
-12813
A trigger with the name <%> already exists
-12830
A function with the name <%> already exists
-12831
The function <%> does not exist, (or no execute privilege)
-12832
The result of the expression is not deterministic while the routine is declared as deterministic
-12833
All privileges used in a trigger must be held with grant option
-12834
The sequence <%> does not exist
-12835
A sequence with the name <%> already exists
-12836
The keyword NULL cannot be used <%>
-12837
The operands to a overlaps predicate must be of a row data type with two elements
-12838
The two elements in an operand to the overlaps predicate must either be of the same type or otherwise it shall be possible to add the second value to first value
-12839
<%> is not allowed in a before trigger
-12840
The simple value specification for a get diagnostics statement must be of integer type
-12841
<%> is not allowed in a trigger
-12842
The increment for a sequence must be non zero
-12843
Invalid values for sequence attributes
-12844
The schema <%> does not exist, (or no privilege)
-12845
The schema name for routines in a module definition must be the same as the schema name for the module
-12846
The value for diagnostics size must be positive
-12847
The ident name in an authorization clause must be the same as the current user
-12848
Constraint name already exists
-12849
The function <%> MODIFIES SQL DATA and can thus not be used in a DML statement
-12850
A trigger must be located in the same schema as the table
-12851
A constraint must have the same schema name as the object to which it belongs
-12852
The schema name for a routine is not the same as the schema name for the module
-12853
Ident name not allowed as a schema with the same name exists
-12854
A non-deterministic expression is not allowed in a check clause
-12855
Default values with a reference to a sequence combined with a check clause is not allowed in an alter table statement

Program-dependent Errors

These errors arise as a result of incorrect program construction. In general, corrective action requires revision of the program source code.

Number
Explanation
-14001
Invalid sequence of SQL statements
-14002
SQL statement invalid because the user is not connected
-14003
CONNECT statement invalid because the user is already connected
-14004
System already closed down
-14005
Cannot perform DISCONNECT in a transaction
-14006
Login failure
-14011
Transaction already started
-14012
Transaction handling required
-14013
No transaction started
-14014
Cannot perform write operations as transaction status is read-only
-14015
Commit or rollback statements are not allowed in an atomic execution context
-14016
Select for update is not allowed for a read-only cursor
-14017
Mixing DDL and DML statements in a transaction is not allowed
-14018
Incremental backup not allowed in BACKUP transaction
-14019
Operation not allowed in BACKUP transaction
-14020
START BACKUP command required to perform an online backup
-14021
Cannot perform ENTER or LEAVE in a transaction
-14022
Cannot perform ENTER operation because program level is already active
-14023
No program level entered, cannot perform leave operation
-14024
Session statements are not allowed in a trigger
-14031
DESCRIBE statement does not identify a prepared statement
-14032
EXECUTE statement does not identify a prepared statement
-14033
PREPARE statement identifies a SELECT statement of an opened cursor
-14034
The cursor is not in a prepared state
-14035
The cursor identified in a FETCH or CLOSE statement is not open
-14036
The cursor cannot be used because its statement name does not identify a prepared SELECT statement
-14037
The cursor identified in the UPDATE or DELETE statement is not open
-14038
UPDATE or DELETE CURRENT statement not allowed for a cursor of a prepared SELECT statement
-14039
Cursor is not scrollable
-14041
The cursor identified in the UPDATE statement is not positioned on a row
-14042
The cursor identified in the DELETE statement is not positioned on a row
-14043
Routine signaled SQLSTATE
-14044
Routine signaled a condition
-14045
Prepared statement not a cursor specification
-14046
The statement RESIGNAL was used outside a exception handler
-14101
Invalid statement identifier
-14201
Compilation did not yield an executable program
-14202
The cursor identified in an OPEN statement is already open, but not declared as REOPENABLE
-14203
Statement position cannot be saved when temporary tables are used in the query
-14210
Cursor for result set procedure may not be reopenable
-14211
With hold option is not available for result set procedures
-14301
SQLDA contains an invalid data address or indicator variable address
-14302
Invalid address of username or password
-14303
Invalid address
-14311
Illegal statement length given for SQL statement
-14312
Input character string too long
-14313
Like pattern string too long
-14314
Username or password too long
-14315
Illegal byte length of floating point number
-14316
Unterminated C string, null byte not found
-14321
Illegal host variable type
-14322
Illegal host variable type in like pattern string
-14323
Username and password must be fixed length character strings
-14324
Illegal indicator variable type
-14331
The number of provided host variables does not match the number of parameters
-14332
Using clause required for dynamic parameters
-14333
Using clause required for result fields
-14401
Column cannot be updated because it is not identified in the UPDATE clause of the SELECT statement of the cursor
-14402
The table identified in the UPDATE or DELETE statement is not the same as that designated by the cursor
-14403
Cannot describe statement without naming information
-14404
Cannot update table <%> because the declare statement is read-only
-14405
Cannot delete from table <%> because the declare statement is read-only
-14406
Unexpected statement type encountered in an UPDATE or DELETE statement
-14501
Database connection is not open
-14601
Invalid cursor state
-14611
Using clause does not match dynamic parameters
-14612
Using clause or Into clause does not match target specifications
-14621
Cursor not found
-14622
Ambiguous cursor name
-14623
Invalid cursor name
-14624
Cursor already allocated for statement
-14631
Invalid SQL statement name
-14641
Invalid SQL descriptor name
-14642
Invalid descriptor index
-14643
Invalid descriptor count
-14651
Invalid exception number
-14700
No return statement was encountered during the execution of a function
-14701
The statement is not allowed in an atomic execution context
-14702
The same column has been updated to different values when executing a trigger
-14703
An exception occurred during the execution of a trigger
-14720
The maximum_value for the sequence <%> has been reached
-14721
There is no current_value for the sequence <%> because the next_value function has not been invoked
-14722
Sequence <%> locked by another user
-14723
Update of attributes for the sequence <%> failed

Databank and Table Errors

These errors are associated with problems of physical access to databanks and tables. Locking errors should not result from transaction conflicts, but generally indicate either locking at the operating system level or malfunction of the internal Mimer SQL routines.

Many of the errors in this class are corrected by action taken at the operating system level. If errors persist in spite of corrective action, contact your Mimer representative.

Number
Explanation
-16001
Table locked by another user
-16002
Table locked by another cursor
-16003
Table in referential constraint definition locked by another user
-16004
Table in referential constraint definition locked by another cursor
-16005
Log locked by another user
-16006
Backup unit log file locked
-16101
No databank <%> found in dictionary
-16135
Record no longer exists
-16141
Syntax error in filename for databank <%>
-16142
Cannot open databank <%>, file <%> not found
-16143
File protection violation for databank <%>, file <%>
-16144
Cannot open databank <%>, file <%> locked by other user
-16145
Too many databanks open concurrently (direct access I/O limit)
-16146
File create error, disk full
-16147
File create error (quota exceeded) for databank <%>, file <%>
-16148
Device or network connection not ready, databank <%>, file <%>
-16149
Cannot open databank <%> in file <%>
-16150
Tried to access databank <%> on node which is inaccessible because TRANSDB is OFFLINE
-16151
Too many databanks open concurrently
-16152
Tried to open a non-MIMER databank
-16154
Table control area exhausted
-16155
Incompatible version of databank <%>
-16156
Databank <%> belongs to another system databank
-16157
Tried to open a read-only databank with write access
-16159
Old version of the databank <%> cannot be accessed without restoring the databank with the backup and restore utility
-16160
Cannot set TRANSDB shadow OFFLINE on the same node as the master TRANSDB
-16161
Databank <%> disk space exhausted
-16162
Databank LOGDB disk space exhausted
-16163
Databank TRANSDB disk space exhausted
-16164
Databank SQLDB disk space exhausted
-16172
Databank <%> locked by another MIMER/DB user
-16182
Databank <%> corrupt
-16183
Bad parameter
-16184
I/O error
-16185
Internal databank identifier invalid
-16186
Internal table identifier invalid
-16187
Shadow <%> in file <%> has illegal sequence number
-16189
Corrupt bitmap page
-16190
Table root entry not found
-16191
Exclusive access to databank required for attempted operation
-16192
Load not allowed in databank with TRANS or LOG option
-16193
TRANSDB and/or LOGDB not open
-16194
Error occurred in transaction commit phase
-16195
Internal inconsistency detected
-16196
No end of table mark found for tableid
-16197
Shadow <%> is already OFFLINE
-16198
Shadow <%> is already ONLINE
-16199
Result of bitmap page I/O undefined
-16200
Result of index page I/O undefined
-16201
Result of root page I/O undefined
-16202
Result of data page I/O undefined
-16203
Corrupt index page
-16204
Corrupt root page
-16205
Corrupt data page
-16206
Write set corrupt
-16207
Table <%> has invalid record length
-16208
Unable to open databank <%>. SHADOW license required
-16209
Unable to open databank <%>. NETIO license required
-16210
Cleanup control area exhausted
-16211
Not properly closed, dbcheck initiated
-16212
TRANSDB restart directory corrupt
-16213
Error when closing databank file. Please consult multiuser log file
-16214
Blockdata DKBLK1 missing
-16215
Error accessing remote TRANSDB, node will not be accessed further
-16216
Blocksize not supported
-16217
Error when generating internal key
-16218
Operation not allowed. Licensed number of users exceeded
-16219
Too many multi systems started
-16220
Unable to retrieve limit on number of allowed users
-16221
Lost contact with peer
-16222
Record length from update before is invalid
-16224
Transaction state table entries exhausted
-16225
Transaction state identifier invalid
-16226
Invalid function code
-16227
Commit set corrupt
-16228
Restart set corrupt
-16229
Cancel requested
-16230
Transaction cache inconsistent
-16231
Shadow <%> is inaccessible due to incomplete CREATE SHADOW or SET ONLINE operation
-16232
Database upgrade required
-16233
Operation not allowed. Licensed number of users exceeded
-16234
Execution interrupted by scheduler
-16401
Routine cannot be dropped because it is in use
-16402
Routine cannot be used because it is being dropped

Miscellaneous Errors

These errors arise from miscellaneous problems which do not fall into the other classes. If the corrective action is not indicated by the error description, contact your Mimer representative for help.

Number
Explanation
-18001
Blockdata BLKDS2 not included
-18002
Cannot log in, error in SYSDB initialization
-18003
No privilege to open log file
-18004
Databank LOGDB already opened by another MIMER/DB user. Could not be opened exclusively to drop log records
-18005
Unknown language
-18006
Language not properly installed
-18007
Unable to fetch message text
-18008
Restore in wrong sequence attempted
-18009
Mismatching version of Embedded SQL and MIMER/DB
-18010
Invalid log record found during restore operation
-18011
Mismatching version of MIMER/DB and utilities
-18012
The transformation of a TRANSDB shadow to master was interrupted before completion. Please login to UTIL to complete the transformation
-18013
MIMER/DB started from SYSDB shadow. Transform SYSDB shadow to master with UTIL, or restart system from master SYSDB
-18014
Alter shadow not allowed in SQL for system databanks. Use utility program instead.
-18015
Open with hold is not possible when temporary tables are used for evaluation of the query
-18016
Cursor could not be opened with hold as it is not prepared with hold
-18017
With hold functionality not supported
-18018
The network server version does not support scroll
-18019
Bad parameters passed to DBAPI4
-18020
Unknown information code = <%> used
-18021
Only SELECT, INSERT, UPDATE, and DELETE operations (excluding where current forms) may be compiled together in a single statement
-18022
Distributed transactions not supported by server
-18023
Requested DTC function not supported by server
-18024
Failed to enlist transaction in distributed transaction
-18025
Unable to retrieve transaction manager's whereabouts
-18026
Failed to import transaction identifier
-18027
Statement already active in other transaction
-18028
Cannot initiate a new PSM debugger session, because the number of request threads is insufficient
-18029
Execution interrupted by debugger
-18041
Update of primary key columns for a table located in a databank, with NULL option is not allowed
-18042
Primary key columns may not be updated by Level2 applications
-18043
The rowid column may not be updated
-18101
Operation not allowed. SHADOW license required
-18102
Operation not allowed. MIMER/DB license required
-18103
Operation not allowed. MIMER/DB Level2 license required
-18104
Operation not allowed. MIMER/NET Client license required
-18105
Operation not allowed. MIMER/NET Server license required
-18106
Operation not allowed. MIMER/NET PC-Server license required
-18107
Operation not allowed. Beta test version of MIMER requires BETA license.
-18108
Error opening MIMER keyfile
-18121
Operation not allowed. VAR specific MIMER license required
-18122
Authorization failure. Invalid attempt to connect
-18201
SYSDB cannot be backed up using CREATE BACKUP without an ONLINE shadow
-18231
<%> records dropped from LOGDB
-18232
Shadow <%> is OFFLINE
-18233
Unable to access databank <%>, because it is OFFLINE
-18234
Error <%> occurred when trying to access shadow <%>
-18235
Error <%> occurred when trying to access databank <%>
-18236
Statistics updated for <%> tables
-18237
Databank <%> does not have LOG option
-18238
<%> records copied to incremental backup
-18239
Unable to CONNECT, because database is OFFLINE
-18240
Unable to CONNECT, because database is OFFLINE and one connection already exists
-18241
Unable to CONNECT, because SYSDB is OFFLINE
-18242
Unable to CONNECT, because SYSDB is OFFLINE and one connection already exists
-18243
Unable to access databank <%>, because database is OFFLINE
-18244
Could not get exclusive access to the database because one or more connections already exists
-18245
Could not connect to database <%>, a system administrator is executing a statement that requires exclusive access to the database
-18500
Database <%> not found in MIMER_SQLHOSTS
-18501
Database <%> unknown on remote node
-18502
Handshake message invalid, incompatible protocol
-18503
Only remote databases are allowed, specify database which is not local
-18504
The network server version is not compatible
-18505
Local memory pool in network server exhausted (SQLPOOL)
-18506
In the current version only one local (and several remote) databases can be connected at a time
-18507
Unknown connection name <%> specified
-18508
Already connected, connection name <%>
-18509
Database name <%> invalid, too long or contains invalid characters
-18510
Connection name <%> invalid, too long or contains invalid characters
-18512
Illegal reentrant call
-18513
Use another TCP/IP port number
-18514
Too deep address indirection
-18515
Cannot get value of thread-local variable
-18516
The network server version does not support Level2
-18518
Catalog version from beta test. See Release Notes, how to upgrade
-18519
Erroneous contents in MIMER_SQLHOSTS
-18521
Error opening MIMER_SQLHOSTS, filename syntax error
-18522
Error opening MIMER_SQLHOSTS, file not found
-18523
Error opening MIMER_SQLHOSTS, file protection violation
-18524
Error opening MIMER_SQLHOSTS, file locked
-18525
Error opening MIMER_SQLHOSTS, too many opened files
-18526
Error opening MIMER_SQLHOSTS, file create error, disk space exhausted
-18527
Error opening MIMER_SQLHOSTS, other error (-7)
-18528
Error opening MIMER_SQLHOSTS, other error (-8)
-18529
Error opening MIMER_SQLHOSTS, other error (-9)
-18530
Error opening MIMER_SQLHOSTS, illegal access options
-18550
Invalid network package format
-18551
Unknown request code in network package (<%>)
-18552
Network package longer than expected
-18553
Internal data structures corrupt (DSNEE4)
-18554
The UTILITY program does not have client/server support
-18594
Query timeout period expired
-18595
Network partner disconnected
-18601
Could not connect to database <%>, unknown node '<%>'
-18602
Could not connect to database <%>, unknown protocol '<%>'
-18603
Could not connect to database <%>, unknown interface '<%>'
-18604
Could not connect to database <%>, unknown service '<%>'
-18605
Could not connect to database <%>, chosen protocol not supported on ALPHA/VMS '<%>'
-18606
Could not connect to database <%>, network type not supported '<%>'
-18607
Could not connect to database <%>, remote node is unreachable '<%>'
-18608
Bad parameter NETID=<%> passed to network package
-18609
Invalid parameter RECLEN=<%> passed to network package
-18610
Invalid parameter BUFFER=<%> passed to network package
-18611
Too many concurrent network connections
-18612
Connection refused '<%>'
-18613
Unexpected network event '<%>'
-18614
The underlying network protocol does not have enough capabilities '<%>'
-18615
Network service busy '<%>'
-18616
Local or remote system resources are insufficient '<%>'
-18617
Connection timed out '<%>'
-18618
Insufficient privileges for attempted network operation '<%>'
-18619
Unexpected network error '<%>'
-18620
Network operation would block (asynch mode)
-18621
Could not load network library
-18622
Required routines missing from network library
-18901
Multi-user system not started
-18902
MIMER logins are currently disabled, try again later
-18903
Access denied to MIMER multi-user system
-18904
Unable to attach to multi-user system, no response
-18905
Operation not allowed. Licensed number of users exceeded
-18906
Invalid database path
-18920
Machine dependent error-18920
-18921
Machine dependent error-18921
-18922
Machine dependent error-18922
-18923
Machine dependent error-18923
-18924
Machine dependent error-18924
-18925
Machine dependent error-18925
-18926
Machine dependent error-18926
-18927
Machine dependent error-18927
-18928
Machine dependent error-18928
-18929
Machine dependent error-18929

Internal Errors

These errors arise from malfunction in internal Mimer SQL routines. Contact your Mimer representative for help.

Number
Explanation
-19001
Program level list corrupt
-19002
No program level found
-19003
Statement list corrupt
-19004
Output parameter list corrupt
-19005
Table list corrupt
-19006
Unable to find log file, LOGDB corrupt
-19007
Inconsistency detected when trying to update dictionary
-19008
Unable to open SYSTEM base tables
-19009
Dictionary table SYSTEM.USERS corrupt
-19010
Unable to extract correct information from SYSTEM.DATABANKS
-19011
Unable to extract correct information from SYSTEM.TABLE_CONSTRAINTS
-19012
Could not find foreign key tableid (<%>) in SYSTEM.TABLE_CONSTRAINTS
-19015
Sysid record in SYSTEM.OBJECTS not found
-19017
Invalid MAE program
-19018
Invalid operation code <%> at PC=<%>
-19019
Missing IMC instruction
-19020
Invalid function code passed to instruction <%>
-19021
No databank control block found for <%>
-19022
Bad function code passed to DSCDB3
-19023
Invalid pointer to naming structure
-19024
Severity message program corrupt
-19025
Invalid table descriptor
-19026
Invalid table descriptor, log status invalid
-19027
Base table must be opened before index tables
-19028
Table root entry not found
-19029
Unable to change position on write set because no mark is set
-19030
Invalid length for allocation of program space
-19031
Invalid table type
-19032
No table control block found
-19033
Cannot delete databank file outside transaction
-19034
Bad function code passed to DSCRD2
-19035
Invalid index descriptor
-19036
Error detected when closing table, hash chain corrupt
-19037
Invalid internal table type encountered
-19038
Write set inconsistency encountered
-19039
Invalid internal statement identifier
-19040
Invalid internal system identifier
-19041
Invalid internal user identifier
-19042
The static statement cannot be compiled because it is already identified with some other statement
-19043
The statement cannot be prepared because it is already identified with a static statement
-19044
Transaction control block chain corrupt
-19045
Shadow <%> cannot be transformed because it is OFFLINE
-19046
Databank <%> is referenced but not opened
-19047
Table has not been opened with sufficient access to allow current operation
-19048
Databank <%>, no shadow is found in dictionary with sequence number = <%>
-19049
The internal update operation has not been prepared with the old record
-19050
Catalog version not compatible with server
-19051
Compiled LIKE pattern corrupt
-19052
Could not store lookup path, inconsistency detected
-19053
Output descriptor overflow
-19054
Unable to initialize database system
-19055
Unable to generate an internal key
-19056
Inconsistent user identifier (not logged in)
-19057
Scroll program corrupt
-19058
Extended name not supported in static SQL
-19059
Invalid error message descriptor
-19061
Loss of significance for VARCHAR length
-19062
Positive overflow for VARCHAR length
-19063
Negative overflow for VARCHAR length
-19065
Bad parameter for VARCHAR length
-19066
Illegal operand for VARCHAR length
-19067
Bad record number
-19068
No matching record
-19069
Corrupt cancel state
-19071
Unrecognized data types for conversion
-19072
Invalid read set record
-19073
Insufficient internal descriptor area
-19074
Internal inconsistency encountered in TCACHE
-19075
Invalid internal DDU identifier
-19076
Internal inconsistency encountered in table list
-19077
Internal inconsistency encountered in DU1
-19078
Invalid parameter encountered in MOS
-19079
Internal inconsistency encountered in DSETH3
-19080
Thread initialization failure
-19081
Hash table missing in system control block
-19082
Internal inconsistency encountered in DSGSH2
-19083
Internal inconsistency encountered in MCOMEM
-19084
Runtime assertion failed
-19085
Invalid descriptor encountered on server
-19086
Invalid statement status encountered on server
-19087
PSM debugger resources already allocated
-19088
PSM debugger resources already deallocated
-19089
Invalid parameter encountered in DDU
-19091
Invalid function code passed to routine
-19092
Invalid function code 2 passed to routine
-19093
Invalid function code 3 passed to routine
-19201
System error : <%>- Area outside MAE data storage
-19202
System error : <%>- Attempt to qqwsal() in closed area
-19203
System error : <%>- Cost value out of range
-19204
System error : <%>- Error converting into Mimer format
-19205
System error : <%>- Error from MDRCCI call
-19206
System error : <%>- Error when reading databank option
-19207
System error : <%>- Expression switch case not recognized
-19208
System error : <%>- Factor was left unused
-19209
System error : <%>- Failed to get a slave RST
-19210
System error : <%>- Generation stack underflow
-19211
System error : <%>- Group is not allocated
-19212
System error : <%>- Host variable not defined
-19213
System error : <%>- Host variable number mismatch
-19214
System error : <%>- Illegal Set Func. mode switch case
-19215
System error : <%>- Illegal Status switch case <%>
-19216
System error : <%>- Index table not found
-19217
System error : <%>- Invalid base pointer
-19218
System error : <%>- Invalid object type
-19219
System error : <%>- Invalid pointer
-19220
System error : <%>- Main switch case not recognized
-19221
System error : <%>- Multiple offset assignment
-19222
System error : <%>- Multiple restriction groups
-19223
System error : <%>- No area opened
-19224
System error : <%>- Nonexistent member
-19225
System error : <%>- No Tbl_desc for SCO
-19226
System error : <%>- NOT stack overflow
-19227
System error : <%>- NOT stack underflow
-19228
System error : <%>- Offset outside MAE data storage
-19229
System error : <%>- qqcbix() with illegal operator
-19230
System error : <%>- qqcunx() with illegal operator
-19231
System error : <%>- Error from MDRCFC call
-19232
System error : <%>- qqrlst() with NULL list
-19233
System error : <%>- qqwlst() with NULL list
-19234
System error : <%>- Query result stack underflow
-19235
System error : <%>- Query stack underflow
-19236
System error : <%>- Rule matrix index out of range
-19237
System error : <%>- Scan kind not implemented
-19238
System error : <%>- Scan stack underflow
-19239
System error : <%>- Selectivity factor value out of range
-19240
System error : <%>- Semantic stack underflow
-19241
System error : <%>- Set range violation
-19242
System error : <%>- Set size incompatibility
-19243
System error : <%>- Stack underflow
-19244
System error : <%>- Statement switch case not recognized
-19245
System error : <%>- Switch case not recognized
-19246
System error : <%>- Too complicated UNION query
-19247
System error : <%>- Too many nested subqueries
-19248
System error : <%>- Traversal stack underflow
-19249
System error : <%>- Unexpected EXPRESSION in HOST variables
-19250
System error : <%>- Unexpected expression operand
-19251
System error : <%>- Unexpected expression subtype
-19252
System error : <%>- Unexpected node class
-19253
System error : <%>- Unexpected SELECT ITEM
-19254
System error : <%>- Unexpected statement subclass
-19255
System error : <%>- Unexpected DD return code <%>
-19256
System error : <%>- Unknown Host Variable type
-19257
System error : <%>- Unknown statement type
-19258
System error : <%>- WS stack overflow
-19259
System error : <%>- X stack overflow
-19260
System error : <%>- X stack underflow
-19261
System error : <%>- Error logging is not enabled
-19262
System error : <%>- Source position line or column is negative
-19263
System error : <%>- Message insert string too long
-19264
System error : <%>- Error logging is already enabled
-19265
System error : <%>- MAE constant storage overflow
-19266
System error : <%>- Selectivity rule number out of range
-19267
System error : <%>- No entry for index id
-19268
System error : <%>- qqcfnx() with illegal operator
-19269
Unexpected duplicate row found in temporary table
-19270
System error : <%>- Scan queue underflow
-19280
System error : <%>- Error from MDRTDC call
-19290
Out of memory
-19291
Invalid attribute type
-19292
Error when trying to store procedure in dictionary
-19293
Error when trying to share program
-19300
<%> unhandled production
-19301
Internal inconsistency detected in PSM
-19901
Function not yet implemented

Communication Errors

Error codes from the communication kernel layer (network routines):

Number
Explanation
-21001
Already listening on service <%>
-21002
Error trying to ASSIGN channel for TCP/IP communication
-21003
Error when creating socket
-21004
Error when binding socket address for service <%>
-21005
Error when getting port number for service <%>
-21006
Illegal protocol specified: <%>
-21007
Error when looking up host name: <%>
-21008
Error when connecting to database <%> on <%> using <%> to service <%>
-21009
Illegal channel id specified
-21010
Error when reading data from network channel
-21011
Error when writing data to network channel
-21012
Channel is not open
-21013
Channel is not accessible from this process
-21014
Error when creating mailbox
-21015
Error when declaring network object for service <%>
-21016
Unimplemented feature
-21017
Error when accepting new channel
-21018
Error when doing local listen for database <%> on path <%>
-21019
Too many channels used
-21020
Multiple read requests on channel
-21021
Multiple write requests on channel
-21022
Local write when not owning buffer
-21023
Cancel request illegal on channel
-21024
No available channel id number
-21025
Tried to open too many local servers
-21026
Database server for database <%> not running
-21027
Incompatible buffer versions
-21028
Failed to do a LOCAL connection to the server for database <%>
-21029
Illegal reentrant request on channel
-21030
Network request would block caller
-21031
Too large network I/O requested
-21032
Could not find DSINI4 in single-user library
-21033
Could not find DSHND4 in single-user library
-21034
Could not find DSGMD4 in single-user library
-21035
Could not find DSUMP4 in single-user library
-21036
The channel is closed
-21037
The specified network interface is not supported
-21038
Could not lock communication buffers in memory
-21039
Error trying to ASSIGN channel for DECNET communication
-21040
Could not map library for single-user mode
-21041
Could not initialize CK package
-21042
Error when performing initial communication with database server
-21043
Server rejected connection to database <%> on <%> using <%> to service <%>
-21044
Server rejected named pipe connection to database <%>
-21045
The address family for network protocol was unknown
-21046
Error when creating named pipe server objects
-21047
Error when setting up TCP server objects
-21048
Unexpected communication error
-21049
Error when reading/writing data to/from network channel
-21050
Error when closing communication with database server
-21051
All local communication slots are in use
-21052
Database server request failed
-21053
Database or network service not started Error when connecting to database <%> on <%> using <%> to service <%>
-21054
Database server for database <%> not started
-21055
The MIMER network service on <%> for <%> does not currently accept new connections. Try again later
-21056
Local communication has been disabled for database server <%>
-21057
Named pipe communication has not been enabled for database server <%>
-21058
TCP/IP communication has not been enabled for database server <%>
-21100
Command timed out
-21101
Error mapping MCS (MIMER Control Storage)
-21102
Error when doing system communication through the MCS
-21103
MCS communication area is busy. Try again later
-21104
Server for database <%> is already started
-21105
Illegal directory specified for SYSDB82.DBF
-21106
Error in parameter file
-21107
Error when starting database server process
-21108
Error when looking up database name
-21109
Error when creating memory pool in database server
-21110
Could not allocate space from SQLPool
-21111
Error when initiating the ENQ/DEQ package
-21112
Error when attaching a thread to the ENQDEQ area
-21113
Error when initiating server I/O package
-21114
Error when setting default directory for database server I/O package
-21115
Could not start database server thread
-21116
Protocol error- received new request before completion of last request
-21117
Could not create proper execution environment
-21118
Database server not operational
-21119
Notification thread failed. Server can no longer respond to mimcontrol
-21120
Illegal directory path
-21121
Could not create new directory
-21122
Channel closed by administrator
-21123
Invalid channel number specified
-21124
Error when initiating request (rq) queue
-21125
Could not lock the bufferpool in memory
-21126
Database server halted. Failed to generate automatic database dumps
-21127
Database server halted. Dump files from the failed database are placed under <%>
-21128
Error when stopping database server process
-21129
Error when deleting memory pool in database server
-21130
Error getting database server parameters
-21131
Must be superuser to perform this function
-21132
The environment variable MIMER_HOME must point to the MIMER distribution
-21133
An illegal combination of command switches was specified
-21134
The database parameter must be specified
-21135
Permission denied
-21180
Error opening SQLHOSTS file
-21181
Error opening SQLHOSTS file - file name syntax error
-21182
Error opening SQLHOSTS file - file not found
-21183
Error opening SQLHOSTS file - file protection violation
-21184
Error opening SQLHOSTS file - file is locked
-21185
Error opening SQLHOSTS file - too many files are opened
-21186
Error opening SQLHOSTS file - file creation error (diskspace exhausted)
-21187
Error opening SQLHOSTS file - machine dependent code -7
-21188
Error opening SQLHOSTS file - machine dependent code -8
-21189
Error opening SQLHOSTS file - other error
-21190
Error opening SQLHOSTS file - illegal access option
-21191
Could not find a local definition for the specified database name

Error codes used by the server when creating database dumps. These codes are never returned to application programs:

Number
Explanation
-21200
Error when creating dump file
-21201
Error when writing dump file

Error codes reflecting problems in the layer that creates and interprets network packets:

Number
Explanation
-21300
Too large network buffer requested on client side

JDBC Errors

These errors arise when the Mimer JDBC Driver fails for some reason. The error codes are in the range -22000 to -22999. When using Java, the error message is always included in the exception that is thrown.

To get the complete and accurate list of error codes, execute the following command:

 $ java com.mimer.jdbc.Driver -errors


Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Programmer's Manual TOC PREV NEXT INDEX