Previous Page TOC Index Next Page

APPENDIX A ERROR MESSAGES


SQL Errors

These errors are caused by erroneous SQL statements and are detected by the SOLID SQL Parser. Administrative actions are not needed.

Database Errors

These errors are detected by the SOLID Database Engine and may demand administrative actions.

System Errors

These errors are detected by the operating system and demand administrative actions.

Table Errors

These errors are caused by erroneous SQL statements and detected by the SOLID Database Engine. Administrative actions are not needed.

Server Errors

These errors are caused by erroneous administrative actions or client requests. They may demand administrative actions.

Communication Errors

These errors are caused by network errors or faulty configuration of the SOLID Server software. These errors demand administrative actions.

Procedure Errors

These errors are caused by errors in the definition or execution of a stored procedure. Administrative actions are not needed.

See also:

See Appendix D SOLID Server SQL Syntax and Appendix C SOLID Server Data Types for more information.

SOLID SQL Errors

Error code

Description

SQL Error 1

Parsing error ‘syntax error’


The SQL parser could not parse the SQL string. Check the syntax of the SQL statement and try again.

SQL Error 2

Table <table> can not be opened


You may not have privileges to access the table and its data.

SQL Error 3

Table <table> can not be created


Table can not be created. You may not have privileges for this operation.

SQL Error 4

Illegal column definition <column>


A column type in your CREATE TABLE statement is illegal. Use a legal type for the column.

SQL Error 5

Table <table> can not be dropped


Table can not be dropped. Only the owner (i.e. the creator) can drop it.

SQL Error 6

Illegal value specified for column <column>


The value specified for column is invalid. Check the value for the column.

SQL Error 7

Insert failed


The server failed to do the insertion. You may not have INSERT privilege on the table or it may be locked.

SQL Error 8

Delete failed


The server failed to do the deletion. You may not have DELETE privilege on the table or the row may be locked.

SQL Error 9

Row fetch failed


The server failed to fetch a row. You may not have SELECT privilege on the table or there may be an exclusive lock on the row.

SQL Error 10

View <view> can not be created


You can not create this view. You may not have SELECT privilege on one or more tables in the query-specification of your CREATE VIEW statement.

SQL Error 11

View <view> can not be dropped


You can not drop this view. Only the owner (i.e. the creator) of the view can drop it.

SQL Error 12

Illegal view definition <view>


The view definition is illegal. Check the syntax of the definition.

SQL Error 13

Illegal column name <column>


Column name is illegal. Check that the name is not a reserved name.

SQL Error 14

Call to function <function> failed


Function call to function failed. Check the arguments and their types.

SQL Error 15

Arithmetics error


An arithmetics error occurred. Check the operators, values and types.

SQL Error 16

Update failed


The server failed to update a row. There may a lock on a row.

SQL Error 17

View is not updatable


This view is not updatable. UPDATE, INSERT and DELETE operations are not allowed.

SQL Error 18

Inserted row does not meet check option condition


You tried to insert a row, but one or more of the column values do not meet column constraint definition.

SQL Error 19

Updated row does not meet check option condition


You tried to update a row, but one or more of the column values do not meet column constraint definition.

SQL Error 20

Illegal CHECK constraint


A check constraint given to the table is illegal. Check the types of the check constraint of this table.

SQL Error 21

Insert failed because of CHECK constraint


You tried to insert a row, but the values do not meet the check option conditions.

SQL Error 22

Update failed because of CHECK constraint


You tried to update a row, but the values do not meet the check option conditions.

SQL Error 23

Illegal DEFAULT value


The DEFAULT value for the column given is illegal.

SQL Error 24

Incorrect number of items in VALUES list


The number of items given in VALUES list is different from the number of columns in the table. Check the number of items.

SQL Error 25

Duplicate columns in INSERT column list


You have included a column in column list twice. Remove duplicate columns.

SQL Error 26

At least one column definition required in CREATE TABLE


You need to specify at least one column definition in a CREATE TABLE statement.

SQL Error 27

Illegal REFERENCES column list


There are wrong number of columns in your REFERENCES list.

SQL Error 28

Only one PRIMARY KEY allowed in CREATE TABLE


You can use only one PRIMARY KEY in CREATE TABLE.

SQL Error 29

GRANT failed


Granting privileges failed. You may not have privileges for this operation.

SQL Error 30

REVOKE failed


Revoking privileges failed. You may not have privileges for this operation.

SQL Error 31

Multiple instances of a privilege type


You tried to grant privileges to a role or a user. You have included multiple instances of a privilege type in the list of privileges.

SQL Error 32

Illegal constant <constant>


Illegal constant was found. Check the syntax of the statement.

SQL Error 33

Column name list of illegal length


You have entered different number of columns in CREATE VIEW statement to the view and to the table.

SQL Error 34

UPDATE expression of illegal type


An expression in UPDATE statement has illegal type for a column.

SQL Error 35

Column names not allowed in ORDER BY for UNION


You can not use column name in an ORDER BY for UNION statement.

SQL Error 36

Nested aggregate functions


Nested aggregate functions can not be used. For example: SUM(AVG(<column>)).

SQL Error 37

Aggregate function with no arguments


An aggregate function was entered with no arguments. For example: SUM().

SQL Error 38

Set operation between different row types


You have tried to execute a set operation of tables with incompatible row types. The row types in a set operation must be compatible.

SQL Error 39

COMMIT WORK failed


Committing a transaction failed.

SQL Error 40

ROLLBACK WORK failed


Rolling back a transaction failed.

SQL Error 41

Savepoint could not be created


A savepoint could not be created.

SQL Error 42

Could not create index <index>


An index could not be created. You may not have privileges for this operation. You need to be an owner of the table or have SYS_ADMIN_ROLE to have privileges to create index for the table.

SQL Error 43

Could not drop index <index>


An index could not be dropped. You may not have privileges for this operation. You need to be an owner of the table or have SYS_ADMIN_ROLE to have privileges to drop index from the table.

SQL Error 44

Could not create schema <schema>


A schema could not be created.

SQL Error 45

Could not drop schema <schema>


A schema could not be dropped.

SQL Error 46

Illegal ORDER BY specification


You tried to use an ORDER BY column that does not exist. Refer to an existing column in the ORDER BY specification.

SQL Error 47

Maximum length of identifier is 31


You have exceeded the maximum length for the identifier.

SQL Error 48

Subquery returns more than one row


You have used a subquery that returns more than one row. Only subqueries returning one row may be used in this situation.

SQL Error 49

Illegal expression <expression>


You tried to insert or update a table using an aggregate function (SUM, MAX, MIN or AVG) as a value. This is not allowed.

SQL Error 50

Ambiguous column name <column>


You have referenced a column which is exists in more than one table. Use syntax <table>.<column> to indicate which table you want to use.

SQL Error 51

Non-existent function <function>


You tried to use a function which does not exist.

SQL Error 52

Non-existent cursor <cursor>


You tried to use a cursor which is not created.

SQL Error 53

Function call sequence error


A function was called in wrong order. Check the sequence and success of the function calls.

SQL Error 54

Illegal use of a parameter


A parameter was used illegally. For example: SELECT * FROM TEST WHERE ? < ?;

SQL Error 55

Illegal parameter value


A parameter has an illegal value. Check the type and value of the parameter.

SQL Error 56

Only ANDs and simple condition predicates allowed in UPDATE CHECK


All search condition predicates are not supported.

SQL Error 57

Opening the cursor did not succeed


Server failed to open a cursor. You may not have cursor open at this moment.

SQL Error 58

Column <column> is not referenced in group-by-clause


You tried to group rows using <column>. All columns in group-by-clause must be listed in your select-list. A star (‘*’) notation is not allowed with GROUP BY.

SQL Error 59

Comparison between incompatible types


You tried to compare values which have incompatible types. Incompatible types are for example an integer and a date value.

SQL Error 60

Reference to the insert table not allowed in the source query


You have referenced in subquery a table where you are inserting values. This is not allowed.

SQL Error 61

Reference to the update table not allowed in subquery


You have referenced in subquery a table where you are updating values. This is not allowed.

SQL Error 62

Reference to the delete table not allowed in subquery


You have referenced in subquery a table where you are deleting values. This is not allowed.

SQL Error 63

Subquery returns more than one column


You have used a subquery that returns more than one column. Only subqueries returning one column may be used.

SQL Error 64

Cursor <cursor> not updatable


The cursor opened is not updatable.

SQL Error 65

Insert or update tried on pseudo column


You tried to update a pseudo column (ROWID, ROWVER). Pseudo columns are not updatable.

SQL Error 66

Could not create user <user>


A user could not be created. You may not have privileges for this operation.

SQL Error 67

Could not alter user <user >


A user could not be altered. You may not have privileges for this operation.

SQL Error 68

Could not drop user <user >


A user could not be dropped. You may not have privileges for this operation.

SQL Error 69

Could not create role <role>


A role could not be created. You may not have privileges for this operation.

SQL Error 70

Could not drop role <role>


A role could not be dropped. You may not have privileges for this operation.

SQL Error 71

Grant <role> failed


Granting role failed. You may not have privileges for this operation.

SQL Error 72

Revoke <role> failed


Revoking role failed. You may not have privileges for this operation.

SQL Error 73

Comparison of vectors of different length


You have tried to compare row value constructors that have different number of dimensions. For example you have compared (a,b,c) to (1,1).

SQL Error 74

Expression * not compatible with aggregate expression


The aggregate expression can not be used with * columns. Specify columns using their names when used with this aggregate expression. This usually happens when GROUP BY expression is used with the * columns.

SQL Error 75

Illegal reference to table <table>


You have tried to reference a table which is not in the FROM list. For example: SELECT T1.* FROM T2.

SQL Error 76

Ambiguous table name <table>


You have used the syntax <table>.<column name>ambiguously. For example: SELECT T1.* FROM T1 A,T1 B WHERE A.F1=0;

SQL Error 77

Illegal use of aggregate expression


You tried to use aggregate expression illegally. For example: SELECT ID FROM TEST WHERE SUM(ID) = 3;

SQL Error 78

Row fetch failed


The server failed to fetch a row. You may not have SELECT privilege on the table or there may be an exclusive lock on the row.

SQL Error 79

Subqueries not allowed in CHECK constraint


You tried to use subquery in a check constraint.

SQL Error 80

Sorting failed


External sorter is out of disk space or cache memory. Modify parameters in configuration file solid.ini.

SQL Error 81

SET syntax results in error



SQL Error 82

Improper type used with LIKE



SQL Error 83

Syntax error



SQL Error 84

Parser error <statement>



SQL Error 85

Incorrect number of columns in subquery for INSERT



SQL Error 86

Illegal ROWNUM constraint



SOLID SQL Warnings

Warning code

Description

SQL Warning 1

ANSI X3.135-1989 compatibility: DEFAULT should be before constraints



SQL Warning 2

ANSI X3.135-1989 compatibility: illegal identifier '<identifier>'


The length of the identifier exceeds 18 characters.

SQL Warning 3

Rdb compatibility: illegal identifier '<identifier>'


The last character of the identifier is underscore (‘_’).

SQL Warning 4

ANSI X3.135-1989 compatibility: illegal literal '<literal>'


You have used character ‘e’ instead of character ‘E’. For example 1.234e-54

SQL Warning 5

Oracle compatibility: use ANY instead of SOME



SQL Warning 6

ANSI X3.135-1989 compatibility: token '!=' illegal, use '<>'



SQL Warning 7

ANSI X3.135-1989 compatibility: use DISTINCT instead of UNIQUE



SQL Warning 8

ANSI X3.135-1989 compatibility: syntax '+=' not allowed



SQL Warning 9

ANSI X3.135-1989 compatibility: CHECK in UPDATE not allowed



SQL Warning 10

ANSI X3.135-1989 compatibility: "identifier" syntax not allowed


You have surrounded identifier with double quote characters.

SQL Warning 11

ANSI X3.135-1989 compatibility: multiple DISTINCTs not allowed



SQL Warning 12

ANSI X3.135-1989 compatibility: vector predicates not allowed


You have used a row value constructor.

SQL Warning 13

ANSI X3.135-1989 compatibility: LEFT OUTER JOIN not allowed



SQL Warning 14

ANSI X3.135-1989 compatibility: AS <column id> not allowed



SQL Warning 15

ANSI X3.135-1989 compatibility: FOR READ ONLY/UPDATE not allowed



SQL Warning 16

ANSI X3.135-1989 compatibility: identifiers beginning with _ not allowed


You have used identifier beginning with underscore (‘_’) character.

SQL Warning 17

ANSI X3.135-1989 compatibility: syntax <table>.* not allowed



SQL Warning 18

ANSI X3.135-1989 compatibility: syntax DATE '...' not allowed



SQL Warning 19

Reserved word '<reserved word>'



SQL Warning 20

ANSI X3.135-1989 compatibility: NULL not allowed in SELECT list



SQL Warning 21

Use '+' instead of '||'



SQL Warning 22

ANSI X3.135-1989 compatibility: UNIONs in VIEWs not allowed



SOLID Database Errors

Error code

Description

Database Error 10001

Key value is not found


Internal error: a key value can not be found from the database index.

Database Error 10002

Operation failed


This is an internal error indicating that the index of the table accessed is in inconsistent state. Try to drop and create the index again to recover the error.

Database Error 10004

Redefinition


Unexpected failure occurred in the database engine.


This error may also occur during recovery: either an index or a view has been redefined during recovery. The server is not able to do the recovery. Delete log files and start the server again.

Database Error 10005

Unique constraint violation


You have violated a unique constraint. This happens when you have tried to insert or update a column which has a unique constraint and the value inserted or updated is not unique.


This may also occur when you create users, tables or roles having same names in separate transactions.

Database Error 10006

Concurrency conflict, two transactions updated or deleted the same row


Two separate transactions have modified a same row in the database simultaneously. This has resulted in a concurrency conflict.

Database Error 10007

Transaction is not serializable


The transaction committed is not serialisable.

Database Error 10010

No checkpoint in database


This error occurs when the server has crashed in the middle of creating a new database. Delete the database and log files and try to create the database again.

Database Error 10011

Database headers are corrupted


The headers in the database are corrupted. This may be caused by a disk error or other system failure. Restore the database from the backup.

Database Error 10012

Node split failed


This is an internal error.

Database Error 10013

Transaction is read-only

You have tried to write inside a transaction that is set read-only. Remove the write operation or unset the read-only mode in the transaction.

Database Error 10014

Resource is locked


This error occurs when you are trying to use a key value in an index which has been concurrently dropped.

Database Error 10016

Log file is corrupted


One of the log files of the database is corrupted. You can not use these log files. Delete them and start the server again.

Database Error 10017

Too long key value


The maximum length of the key value has been exceeded. The maximum value is one third of the size of the index leaf.

Database Error 10019

Backup is active


You have tried to start a backup when a backup process is already in progress.

Database Error 10020

Checkpoint creation is active


You have tried to start a checkpoint when a checkpoint creation is already in progress.

Database Error 10021

Failed to delete log file


The deletion of a log file in making a backup has failed. Reasons for the failure can be:


The log file has already been deleted from the operating system.


The log file has a read-only attribute.

Database Error 10023

Wrong log file, maybe the log file is from another database


The log file in the database directory is from another SOLID Server database. Copy the correct log files to the database directory.

Database Error 10024

Illegal backup directory


The backup directory is either an empty string or a dot indicating that the backup will be created in the current directory.

Database Error 10026

Transaction is timed out

An idle transaction has exceeded the maximum idle transaction time. The transaction has been aborted.


The maximum value is set in parameter AbortTimeOut in SRV section. The default value is 120 minutes.

Database Error 10027

No active search


Internal error.

Database Error 10028

Referential integrity violation, foreign key values exist


You tried to delete a row that is referenced from a foreign key.

Database Error 10029

Referential integrity violation, referenced column values do not exist


The definition of a foreign key does not uniquely identify a row in the referenced table.

Database Error 10030

Backup directory 'directory name' does not exist


Backup directory is not found. Check the name of the backup directory.

Database Error 10031

Transaction detected a deadlock, transaction is rolled back


Deadlock detected. If necessary, begin transaction again.

Database Error 10032

Wrong database block size specified


The block size of the database file differs from the blocksize given in the configuration file solid.ini.

Database Error 10033

Primary key unique constraint violation


Your primary key definition is not unique.

Database Error 10034

Sequence name <sequence> conflicts with an existing entity


Choose a unique name for a sequence. The specified name is already used.

Database Error 10035

Sequence does not exist


Check the name of the sequence.

Database Error 10036

Data dictionary operation is active for accessed sequence


Create or drop operation is active for the accessed sequence. Try again.

Database Error 10037

Can not store sequence value, the target data type is illegal


The valid target data types are INTEGER and BINARY.

Database Error 10038

Illegal column value for descending index


Corrupted data found in descending index. Drop the index and create it again.

Database Error 10040

Log file write failure, probably the disk containing the log files is full


Shut down the server and reserve more disk space for log files.

Database Error 10041

Database is read-only



Database Error 10042

Database index check failed, the database file is corrupted



Database Error 10043

Database free block list corrupted, same block twice in free list



Database Error 10044

Primary key can not contain blob attributes



Database Error 10045

This database is a hot standby slave, the database is read only



Database Error 10046

Operation failed, data dictionary operation is active



Database Error 10047

Replicated transaction is aborted



Database Error 10048

Replicated transaction contains schema changes, operation failed



Database Error 10049

Slave server not available any more, transaction aborted



Database Error 10050

Replicated row contains BLOb columns that cannot be replicated



SOLID System Errors

Error code

Description

System Error 11000

File open failure


The server is unable to open the database file. Reason for the failure can be:


The database file has been set read-only.


You do not have rights to open the database file in write mode.


Another SOLID Server is using the database file.


Correct the error and try again.

System Error 11001

File write failure


Server is unable to write to the disk. The database files may have a read-only attribute set or you may not have rights to write to the disk. Add rights or unset read-only attribute and try again.

System Error 11002

File write failed, disk full


Server failed to write to the disk, because the disk is full. Free disk space or move the database file to another disk. You can also split the database file to several disks using the FileSpec_[1-N] parameter in IndexFile section.

System Error 11003

File write failed, configuration exceeded


Writing to the database file failed, because the maximum database file size set in FileSpec_[1-N] parameter is exceeded.

System Error 11004

File read failure


An error occurred reading a file. This may indicate a disk error in your system.

System Error 11005

File read beyond end of file


Internal error.

System Error 11006

File read failed, illegal file address


An error occurred reading a file. This may indicate a disk error in your system.

System Error 11007

File lock failure


The server failed to lock the database file. This error occurs in the Windows version, if you do not have SHARE.EXE loaded. To correct the failure:


1. Exit Windows


2. Load SHARE.EXE


3. Delete the database file SOLID.DB and log files.


4. Start Windows and launch SOLID Server.

System Error 11008

File unlock failure


Server failed to unlock a file.

System Error 11009

File free block list corrupted


Internal error.

System Error 11010

Too long file name


Filename specified in parameter FileSpec_[1-N] is too long. Change the name to a proper file name.

System Error 11011

Duplicate file name specification


Filename specified in parameter FileSpec_[1-N] is not unique. Change the name to a proper file name.

System Error 11012

License information not found, exiting from SOLID Server


Check the existence of your solid.lic file.

System Error 11013

License information is corrupted


Your solid.lic file has been corrupted.

System Error 11014

Database age limit of evaluation license expired



System Error 11015

Evaluation license expired



System Error 11016

License is for different CPU architecture



System Error 11017

License is for different OS environment



System Error 11018

License is for different version of this OS



System Error 11019

License is not valid for this server version



System Error 11020

License information is corrupted



System Error 11021

Problem with Your license, please contact SOLID Information Technology Ltd. immediately



System Error 11022

Desktop license is only for local <protocol> communication, cannot use protocol <protocol> for listening



SOLID Table Errors

Error code

Description

Table Error 13001

Illegal character constant <constant>


An illegal character constant was found in the SQL statement.

Table Error 13002

Type CHAR not allowed for arithmetics


You have entered a calculation having a character type constant. Character constants are not supported in arithmetics.

Table Error 13003

Aggregate function <function> not available for ordinary call


Aggregate functions can not be used for ordinary function calls.

Table Error 13004

Illegal aggregate function <parameter> parameter


An illegal parameter has been given to an aggregate function. Aggregate function parameters can only be column names or numbers.

Table Error 13005

SUM and AVG not supported for CHAR type


Aggregate functions SUM and AVG are not supported for character type parameters.

Table Error 13006

SUM or AVG not supported for DATE type


Aggregate functions SUM and AVG are not supported for date type parameters.

Table Error 13007

Function <function> is not defined


The function you tried to use is not defined.

Table Error 13009

Division by zero


A division by zero has occurred.

Table Error 13011

Table <table> does not exist


You have referenced a table which does not exist or you do not have REFERENCES privilege on the table.

Table Error 13013

Table name <table> conflicts with an existing entity


Choose a unique name for a table. The specified name is already used.

Table Error 13014

Index <index> does not exist


You have referenced an index which does not exist.

Table Error 13015

Column <column> does not exist on table <table>


You have referenced a column in a table which does not exist.

Table Error 13016

User does not exist


You have referenced a user which does not exist.

Table Error 13018

Join table is not supported


Joined tables are not supported in this version of SOLID Server.

Table Error 13019

Transaction savepoints are not supported


Transaction savepoints are not supported in this version of SOLID Server.

Table Error 13020

Default values are not supported


Default column values are not supported in this version of SOLID Server.

Table Error 13021

Foreign keys are not supported


Foreign keys are not supported in this version of SOLID Server.

Table Error 13022

Descending keys are not supported


Descending keys are not supported in this version of SOLID Server.

Table Error 13023

Schema is not supported


Schema is not supported in this version of SOLID Server.

Table Error 13025

Update through a cursor with no current row


You have tried to update using cursor, but you do not have current row in the cursor.

Table Error 13026

Delete through a cursor with no current row


You have tried to delete using cursor, but you do not have current row in the cursor.

Table Error 13028

View <view> does not exist


You have referenced a view which does not exist.

Table Error 13029

View name <view> conflicts with an existing entity


Choose a unique name for a view. The specified name is already used.

Table Error 13030

No value specified for NOT NULL column <column>


You have not specified a value for a column which is defined NOT NULL.

Table Error 13031

Data dictionary operation is active for accessed table or key


You can not access the table or key, because a data dictionary operation is currently active. Try again after the data dictionary operation has completed.

Table Error 13032

Illegal type <type>


You have tried to create a table with a column having an illegal type.

Table Error 13033

Illegal parameter <parameter> for type <type>


The type of the parameter you entered is illegal in this column.

Table Error 13034

Illegal constant <constant>


You have entered an illegal constant.

Table Error 13035

Illegal INTEGER constant <constant>


You have entered an illegal integer type constant. Check the syntax of the statement and try again.

Table Error 13036

Illegal DECIMAL constant <constant>


You have entered an illegal decimal type constant. Check the decimal number and try again.

Table Error 13037

Illegal DOUBLE PREC constant <constant>


You have entered an illegal double precision type constant. Check the number and try again.

Table Error 13038

Illegal REAL constant <constant>


You have entered an illegal real type constant. Check the real number and try again.

Table Error 13039

Illegal assignment


You have tried to assign an illegal value for a column.

Table Error 13040

Aggregate <function> function is not defined


The aggregate function you tried to use is not supported.

Table Error 13041

Type DATE not allowed for arithmetics


DATE type columns or constants are not allowed in arithmetics.

Table Error 13042

Power arithmetic not allowed for NUMERIC and DECIMAL data type


Decimal and numeric data types do not support power arithmetics.

Table Error 13043

Illegal date constant <constant>


A date constant is illegal. The correct form for date constants is: YYYY-MM-DD.

Table Error 13045

Reference privileges are not supported


Reference privileges are not supported in this version of SOLID Server.

Table Error 13046

Illegal user name <user>


User name entered is not legal. A legal user name is at least 2 and at most 31 characters in length. A user name may contain characters from A to Z, numbers from 0 to 9 and underscore character ‘_’.

Table Error 13047

No privileges for operation


You have no privileges for the attempted operation.

Table Error 13048

No privileges to grant privileges for table <table>


You have no privileges to grant privileges for the table.

Table Error 13049

Column privileges cannot be granted WITH GRANT OPTION


Granting column privileges WITH GRANT OPTION is not supported in this version of SOLID Server.

Table Error 13050

Too long constraint value


Maximum constraint length has been exceeded. Maximum constraint length is 255 characters.

Table Error 13051

Illegal column name <column>


You have tried to create a table with an illegal column name.

Table Error 13052

Illegal comparison operator <operator> for a pseudo column <column>


You have tried to use an illegal comparison operator for a pseudo column. Legal comparison operators for pseudo columns are: equality ‘=‘ and non-equality ‘<>‘.

Table Error 13053

Illegal data type for a pseudo column


You have tried to use an illegal data type for a pseudo column. Data type of pseudo columns is BINARY.

Table Error 13054

Illegal pseudo column data, maybe data is not received using pseudo column


You have tried to compare pseudo column data with non-pseudo column data. Pseudo column data can only be compared with data received from a pseudo column.

Table Error 13055

Update not allowed on pseudo column


Updates are not allowed on pseudo columns.

Table Error 13056

Insert not allowed on pseudo column


Inserts are not allowed on pseudo columns.

Table Error 13057

Index name <index> already exists


You have tried to create an index, but an index with the same name already exists. Use another name for the index.

Table Error 13058

Constraint checks were not satisfied on column <column>


Column has constraint checks which were not satisfied during an insert or update.

Table Error 13059

Reserved system name <name>


You tried to use a name which is a reserved system name such as PUBLIC and SYS_ADMIN_ROLE.

Table Error 13060

User name <user> not found


You tried to reference a user name which is not created.

Table Error 13061

Role name <role> not found


You tried to reference a role name which is not created.

Table Error 13062

Admin option is not supported


Admin option is not supported in this version of SOLID Server.

Table Error 13063

Name <name> already exists


You tried to use a role or user which already exists. User names and role names must all be different i.e. you can not have a user named HOBBES and a role named HOBBES.

Table Error 13064

Not a valid user name <user>


You tried to create an invalid user name. A valid user name has at least 2 characters and at most 31 characters.

Table Error 13065

Not a valid role name <role>


You tried to create an invalid role name. A valid user name has at least 2 characters and at most 31 characters.

Table Error 13066

User <user> not found in role <role>


You tried to revoke a role from a user and the user did not have that role.

Table Error 13067

Too short password


You have entered a too short password. Password length must be at least 3 characters.

Table Error 13068

Shutdown is in progress


You are unable to complete this operation, because server shutdown is in progress.

Table Error 13070

Numerical overflow


A numerical overflow has occurred. Check the values and types of numerical variables.

Table Error 13071

Numerical underflow


A numerical underflow has occurred. Check the values and types of numerical variables.

Table Error 13072

Numerical value out of range


A numerical value is out of range. Check the values and types of numerical variables.

Table Error 13073

Math error


A mathematical error has occurred. Check the mathematics in the statement and try again.

Table Error 13074

Illegal password


You have tried to enter an illegal password.

Table Error 13075

Illegal role name <role>


You have tried to enter an illegal role name. A legal role name is at least 2 and at most 31 characters in length. A user role may contain characters from A to Z, numbers from 0 to 9 and underscore character ‘_’.

Table Error 13076

NOT NULL must not be specified for added column <column>


You have tried to add a column to a table using ALTER TABLE statement. NOT NULL constraint is not allowed in ALTER TABLE statement when the table already includes data.

Table Error 13077

Last column can not be dropped


You have tried to drop the final column in a table. This is not allowed; at least one column must remain in the table.

Table Error 13078

Column already exist on table


You have tried to create a column which already exists in a table.

Table Error 13079

Illegal search constraint


Check the search condition. There may be mismatch between data types.

Table Error 13080

Incompatible types, can not modify column <column> from type <type> to type <type>


You have tried to modify column to a data type that is incompatible with the original definition, such as VARCHAR and INTEGER.

Table Error 13081

Descending keys are not supported for binary columns


You can not define descending key for a binary column.

Table Error 13082

Function <function>: parameter * not supported


You can not use parameter star (*) with ODBC Scalar Functions.

Table Error 13083

Function <function>: Too few parameters


The function expects more parameters. Check the function call.

Table Error 13084

Function <function>: Too many parameters


The function expects fewer parameters. Check the function call.

Table Error 13085

Function <function>: Run-time failure


An error was detected during the execution of the function. Check the parameters.

Table Error 13086

Function <function>: type mismatch in parameter <parameter number>


A erroneous type of parameter detected in the given position of the function call. Check the function call.

Table Error 13087

Function <function>: illegal value in parameter <parameter number>


An illegal value for a parameter detected in the given position of the function call. Check the function call.

Table Error 13090

Foreign key column <column> data type not compatible with referenced column data type


References specification error. Check that the column data type are compatible between referencing and referenced tables.

Table Error 13091

Foreign key does not match to the primary key or unique constraint of the referenced table


References specification error. Check that the column data type are compatible between referencing and referenced tables and that the foreign key is unique for the referenced table.

Table Error 13092

Event name <event> conflicts with an existing entity


Choose a unique name for an event. The specified name is already used.

Table Error 13093

Event <event>does not exist


You referenced to a nonexistent event. Check the name of event.

Table Error 13094

Duplicate column <column> in primary key definition


Duplicate columns are not allowed in a table-constraint-definition. Remove duplicate columns from the definition.

Table Error 13095

Duplicate column <column> in unique constraint definition


Duplicate columns are not allowed in a table-constraint-definition. Remove duplicate columns from the definition.

Table Error 13096

Duplicate column <column> in index definition


Duplicate columns are not allowed in CREATE INDEX statement. Remove duplicate columns.

Table Error 13097

Primary key columns must be NOT NULL


Error in a column-constraint-definition. Define primary key columns NOT NULL. For example: CREATE TABLE DEPT (DEPTNO INTEGER NOT NULL, DNAME VARCHAR, PRIMARY KEY(DEPTNO));

Table Error 13098

Unique constraint columns must be NOT NULL


Error in a column-constraint-definition. Define unique columns NOT NULL. For example: CREATE TABLE DEPT4 (DEPTNO INTEGER NOT NULL, DNAME VARCHAR, UNIQUE(DEPTNO) );

Table Error 13099

No REFERENCES privileges to referenced columns in table <table>


You do not have privileges to reference to the table.

Table Error 13100

Illegal table mode combination


You have defined illegal combination of locking. Check locking type of tables.

Table Error 13101

Only execute privileges can be used with procedures



Table Error 13102

Execute privileges can be used only with procedures



Table Error 13103

Illegal grant or revoke operation



Table Error 13104

Sequence name <sequence> conflicts with an existing entity


Choose a unique name for a sequence. The specified name is already used.

Table Error 13105

Sequence <sequence>does not exist


You referenced to a nonexistent sequence. Check the name of sequence.

Table Error 13106

Foreign key reference exists to table <table>



Table Error 13107

Illegal set operation


You tried to execute a non-existent set operation.

Table Error 13108

Comparison between incompatible types <datatype> and <datatype>



Table Error 13109

There are schema objects for this user, drop failed



Table Error 13110

NULL values given for NOT NULL column <column>



Table Error 13111

Ambiguous entity name <name>



Table Error 13112

Foreign keys are not supported with main memory tables



Table Error 13113

Illegal arithmetics between types <datatype> and <datatype>



Table Error 13114

String operations are not allowed on values stored as BLObs or CLObs



SOLID Server Errors

Error code

Description

Server Error 14501

Operation failed


This error occurs when a timed command fails. Check the arguments of timed commands.

Server Error 14502

RPC parameter is invalid


A network error has occurred.

Server Error 14503

Communication error


A communication error has occurred.

Server Error 14504

Duplicate cursor name <cursor>


You have tried to declare a cursor with a cursor name which is already in use. Use another name.

Server Error 14505

Connect failed, illegal user name or password


You have entered either a user name or a password that is not valid.

Server Error 14506

Server is closed, no new connections allowed


You have tried to connect to a closed server. Connecting was aborted.

Server Error 14507

Maximum number of licensed user connections exceeded


You have tried to connect to a server which has all licenses currently in use. Connecting was aborted.

Server Error 14508

The operation has timed out


You have launched an operation that has been aborted.

Server Error 14509

Version mismatch


A version mismatch has occurred. The client and server are different versions. Use same versions in the client and the server.

Server Error 14510

Communication write operation failed


A write operation failed. This indicates a network problem. Check your network settings.

Server Error 14511

Communication read operation failed


A read operation failed. This indicates a network problem. Check your network settings.

Server Error 14512

There are users logged to the server


You can not shutdown the server now. There are users connected to the server.

Server Error 14513

Backup process is active


You can not shutdown the server now. The backup process is active

Server Error 14514

Checkpoint creation is active


You can not shutdown the server now. The checkpoint creation is active.

Server Error 14515

Invalid user id


You tried to drop a user, but the user id is not logged in to the server.

Server Error 14516

Invalid user name


You tried to drop a user, but the user name is not logged in to the server.

Server Error 14517

Someone has updated the at commands at the same time, changes not saved


You tried to update timed commands at the same time another user was doing the same. Your changes will not be saved.

Server Error 14518

Connection to the server is broken, connection lost


Possible network error. Reconnect to the server.

Server Error 14519

The user was thrown out from the server, connection lost


Possible network error.

Server Error 14520

Server is hotstandby slave, no connections are allowed



Server Error 14521

Failed to create a new thread for the client



Server Error 14522

HotStandby sync directory not specified



Server Error 14523

HotStandby switch is already active



Server Error 14524

HotStandby database has a different time stamp



Server Error 14525

HotStandby databases are not properly synchronized



Server Error 14526

HotStandby databases are not properly synchronized



Server Error 14527

HotStandby standalone database



Server Error 14528

Both HotStandby databases are masters



Server Error 14529

The operation timed out



SOLID Communication Errors

Error code

Description

Communication Error 21300

Protocol <protocol> is not supported


Protocol is not supported.

Communication Error 21301

Cannot load the dynamic link library <library> or one of its components


The server was unable to load the dynamic link library or a component needed by this library. Check the existence of necessary libraries and components.

Communication Error 21302

Wrong version of dynamic link library <library>


The version of this library is wrong. Update this library to a newer version.

Communication Error 21303

Network adapter card is missing or needed <protocol> software is not running


The network adapter card is missing or not functioning.

Communication Error 21304

Out of <protocol> resources


The network protocol is out of resources. Increase the protocols resources in the operating system.

Communication Error 21305

An empty or incomplete network name was specified


The network name specified is not legal. Check the network name.

Communication Error 21306

Server <network name> not found, connection failed


The server was not found. 1) Check that the server is running. 2) Check that the network name is valid. 3) Check that the server is listening given network name.

Communication Error 21307

Invalid connect info <network name>


The network name given as the connect info is not legal. Check the network name.

Communication Error 21308

Connection is broken (<protocol> <read/write> operation failed with code <internal code>)


The connection using the protocol is broken. Either a read or a write operation has failed with and internal error code <internal code>.

Communication Error 21309

Failed to accept a new client connection, out of <protocol> resources


The server was not able to establish a new client connection. The protocol is out of resources. Increase the protocol’s resources in the operating system.

Communication Error 21310

Failed to accept a new client connection, listening of <network name> interrupted


The server was not able to establish a new client connection. The listening has been interrupted.

Communication Error 21311

Failed to start a selecting thread for <network name>


A thread selection has failed for <network name>.

Communication Error 21312

Listening info <network name> already specified for this server


A network name has already been specified for this server. A server can not use a same network name more than once.

Communication Error 21313

Already listening with the network name <network name>


You have tried to add a network name to a server when it is already listening with that network name. A server can not use a same network name more than once.

Communication Error 21314

Cannot start listening, network name <network name> is used by another process


The server can not start listening with the given network name. Another process in this computer is using the same network name.

Communication Error 21315

Cannot start listening, invalid listening info <network name>


The server can not start listening with the given listening info. The given network name is invalid. Check the syntax of the network name.

Communication Error 21316

Cannot stop the listening of <network name>. There are clients connected


You can not stop listening of this network name. There are clients connected to this server using this network name.

Communication Error 21317

Failed to save the listen information into the configuration file


The server failed to save this listening information to the configuration file. Check the file access rights and format of the configuration file.

Communication Error 21318

Operation failed because of an unusual <protocol> return code <code>


Possible network error. Create connection again.

Communication Error 21319

RPC request contained an illegal version number


Either the message was corrupted or there may be a mismatch between server and client versions.

Communication Error 21320

Called RPC service is not supported in the server


There maybe a mismatch between server and client versions.

Communication Error 21321

Protocol %s is not valid, try using switch '-a' for specifying another adapter id instead of %d


This is returned if the NetBIOS LAN adapter id given in listen/connect string is not valid.

Communication Error 21322

The host machine given in connect info '%s' was not found


This is returned in clients if the host machine name given in connect info is not valid.

Communication Error 21323

Protocol <protocol> can not be used for listening in this environment.


This message is displayed if the server end communication using specified protocol is not supported.

Communication Error 21324

The process does not have the privilege to create a mailbox



SOLID Communication Warnings

Error code

Description

Warning Code 21100

Illegal value <value> for configuration parameter <parameter>, using default


An illegal value was given to the parameter <parameter>. The server will use a default value for this parameter.

Warning Code 21101

Invalid protocol definition <protocol> in configuration file


The protocol is defined illegally in the configuration file. Check the syntax of the definition.

SOLID Procedure Errors

Error code

Description

Procedure Error 23001

Undefined symbol <symbol>


You have used a symbol that has not been defined in a procedure definition.

Procedure Error 23002

Undefined cursor <cursor>


You have used a cursor that has not been defined in a procedure definition.

Procedure Error 23003

Illegal SQL operation <operation>



Procedure Error 23004

Syntax error: parse error, line <line number>


Check the syntax of your procedure.

Procedure Error 23005

Procedure <procedure> not found



Procedure Error 23006

Wrong number of parameters for procedure <procedure>



Procedure Error 23007

Procedure name <value> conflicts with an existing entity.


Choose a unique name for a procedure. The specified name is already used.

Procedure Error 23009

Event <event> does not exist, line <line number>



Procedure Error 23010

Incompatible event <event> parameter type, line <line number>



Procedure Error 23011

Wrong number of parameter for event <event>, line <line number>



Procedure Error 23012

Duplicate wait for event <event>, line <line number>



Procedure Error 23013

Undefined sequence <sequence>



Procedure Error 23014

Duplicate sequence name <sequence>



Procedure Error 23015

Sequence <sequence> not found



Procedure Error 23016

Incompatible variable type in call to sequence <sequence>, line <line number>



Procedure Error 23017

Duplicate symbol <symbol>


You have duplicate definitions for a symbol.

Procedure Error 23018

Procedure owner <owner>not found



Procedure Error 23019

Duplicate cursor name '<cursor>'



Procedure Error 23020

Illegal option <option> for WHENEVER SQLERROR … statement



Procedure Error 23021

RETURN ROW not allowed in procedure with no return type, line <line number>



Procedure Error 23022

SQL String variable <variable> must be of character data type, line <line number>



Procedure Error 23023

Call syntax error: <syntax>, line <line number>



Procedure Error 23501

Cursor <cursor> is not open



Procedure Error 23502

Illegal number of columns in EXECUTE ... <procedure> in cursor <cursor>



Procedure Error 23503

Previous SQL operation before <operation> failed in cursor <cursor>



Procedure Error 23504

Cursor <cursor> is not executed



Procedure Error 23505

Cursor <cursor> is not a SELECT statement



Procedure Error 23506

End of table in cursor <cursor>



Procedure Error 23507

Illegal type conversion in cursor <cursor> from type <data type> to type <data type>



Procedure Error 23508

Illegal assignment, line <line number>



Procedure Error 23509

In <procedure> line <line number> Stmt <statement> was not in error state in RETURN SQLERROR OF ...



Procedure Error 23510

In <procedure> line <line number> Transaction cannot be set read only, because it has written already



Procedure Error 23511

In <procedure> line <line number> USING part is missing for dynamic parameters for <procedure>



Procedure Error 23512

In <procedure> line <line number> USING list is too short for <procedure>'



Procedure Error 23513

In <procedure> line<line number> Comparison between incompatible types <data type> and <data type>



Procedure Error 23514

In <procedure> line <line number> type <data type> is illegal for logical expression



Procedure Error 23515

In <procedure> line <line number> assignment of parameter <parameter> in <list> list failed



Procedure Error 23516

In CALL <procedure> assignment of parameter <parameter> failed



SOLID Sorter Errors

Error code

Description

Sorter Error 24001

Sort failed due to insufficient configured TmpDir space



Sorter Error 24002

Sort failed due to insufficient physical TmpDir space



Sorter Error 24003

Sort failed due to insufficient sort buffer space



Sorter Error 24004

Sort failed due to too long row (internal failure)



Sorter Error 24005

Sort failed due to I/O error



Previous Page TOC Index Next Page

Copyright © 1992-1997 Solid Information Technology Ltd All rights reserved.