Reference Manual
   CHAPTER 10. Database Error Messages     

Alphabetic list of error messages

This section provides a full listing of error messages and descriptions.

Errors with an ODBC state marked "handled by ODBC driver" are not returned to ODBC applications, as the ODBC driver carries out the required actions.

  %1

Item	Value
SQLCode	-682
Constant	SQLE_OMNI_DEBUG
SQLState	WO010
ODBC State	(handled by ODBC driver)
Parameter 1	The debug message for the console

Probable cause 

This message is used for displaying component integration services debug mesages on the console.

  '%1' is not a valid class file

Item	Value
SQLCode	-92
Constant	SQLE_BAD_CLASS_FILE
SQLState	WP002
ODBC State	S1000
Parameter 1	The name of the invalid file.

Probable cause 

A file passed to the INSTALL JAVA command was not a valid Java class file.

  (no message)

Item	Value
SQLCode	0
Constant	SQLE_NOERROR
SQLState	00000
ODBC State	00000

Probable cause 

This code indicates that there was no error or warning.

  A thread used internally could not be started

Item	Value
SQLCode	-626
Constant	SQLE_THREAD_START_FAILURE
SQLState	WW011
ODBC State	S1000

Probable cause 

This is a Windows95 specific error. An operating system thread could not be started that is required to execute external functions.

  Aggregate functions not allowed on this statement

Item	Value
SQLCode	-150
Constant	SQLE_AGGREGATES_NOT_ALLOWED
SQLState	42W06
ODBC State	42000

Probable cause 

An UPDATE statement has used an aggregate function (MIN, MAX, SUM, AVG or COUNT).

  All threads are blocked

Item	Value
SQLCode	-307
Constant	SQLE_THREAD_DEADLOCK
SQLState	40W06
ODBC State	40001

Probable cause 

You have attempted to read or write a row and it is locked by another user. Also, all other threads (see database option THREAD_COUNT) are blocked waiting for a lock to be released. This is a deadlock situation and your transaction has been chosen as the one to rollback.

  ALTER clause conflict

Item	Value
SQLCode	-125
Constant	SQLE_ALTER_CLAUSE_CONFLICT
SQLState	53W01
ODBC State	S1000

Probable cause 

A primary key clause, foreign key clause, or a uniqueness clause must be the only clause of an ALTER TABLE command.

  An attempt to delete database '%1' failed.

Item	Value
SQLCode	-651
Constant	SQLE_DROP_DATABASE_FAILED
SQLState	WW017
ODBC State	S1000

Probable cause 

An active database is not allowed to be deleted. If the attempt to delete a database fails for another reason, some parts of the database may have been deleted before failure.

  An internal error occurred in a '%1'

Item	Value
SQLCode	-695
Constant	SQLE_JDBC_OBJ_INTERNAL_ERR
SQLState	WJ009
ODBC State	S1000
Parameter 1	Java class of the object in error

Probable cause 

This is an internal jdbc object error. If it occurs, it should be reported to Adaptive Server Anywhere technical support.

  An internal error occurred in a '%1'

Item	Value
SQLCode	-713
Constant	SQLE_JNAT_OBJ_INTERNAL_ERR
SQLState	WJ013
ODBC State	S1000
Parameter 1	Java class of the object in error

Probable cause 

This is an internal native Java object error. If it occurs, it should be reported to Adaptive Server Anywhere technical support.

  Application/engine communications protocol version mismatch

Item	Value
SQLCode	-88
Constant	SQLE_PROTOCOL_MISMATCH
SQLState	08W15
ODBC State	08S01

Probable cause 

The connection failed because the protocol versions of the application and the running server do not match. Make sure the application and server software are the same version.

  Argument %1 of procedure '%2' cannot be null

Item	Value
SQLCode	-90
Constant	SQLE_ARGUMENT_CANNOT_BE_NULL
SQLState	WP000
ODBC State	S1000
Parameter 1	The argument number which cannot be null.
Parameter 2	The name of the procedure which cannot receive the null parameter.

Probable cause 

A null value was passed to a procedure which was expecting a scalar argument. For example, a Java procedure which has an 'int' argument cannot receive a null value.

  Attempted two active database requests

Item	Value
SQLCode	-298
Constant	SQLE_DOUBLE_REQUEST
SQLState	42W22
ODBC State	S1000

Probable cause 

In Embedded SQL, you have attempted to submit a database request while you have another request in process. This often occurs in Windows when processing the WM_PAINT message causes a database request, and you get a second WM_PAINT before the database request has completed.

  Authentication failed

Item	Value
SQLCode	-218
Constant	SQLE_AUTHENTICATION_FAILED
SQLState	08W48
ODBC State	08001

Probable cause 

You have set the database_authentication or connection_authentication option incorrectly.

  Authentication violation

Item	Value
SQLCode	-98
Constant	SQLE_AUTHENTICATION_VIOLATION
SQLState	08W21
ODBC State	08001

Probable cause 

You have attempted to connect to an engine or server which has been authenticated for exclusive use with a specific application.

  Backup file format is invalid

Item	Value
SQLCode	-716
Constant	SQLE_RESTORE_INVALID_FORMAT
SQLState	WB007
ODBC State	S1000

Probable cause 

The format of an archive file to be used during a RESTORE is invalid.

  Backwards scrolling cursors are not supported for remote objects.

Item	Value
SQLCode	-661
Constant	SQLE_OMNI_BACKWARDS_CURSOR
SQLState	WO006
ODBC State	S1000

Probable cause 

Backwards scrolling cursors are not supported for remote objects. Change the client program to use forward scrolling cursors only.

  Calling functions outside the database engine is not supported

Item	Value
SQLCode	-617
Constant	SQLE_EXTERNAL_CALLS_NOT_SUPPORTED
SQLState	WW003
ODBC State	S1000

Probable cause 

An attempt was made to call a stored procedure that, in turn, calls a function in a dynamically loaded module. The operating system on which this stored procedure was called does not support such an action.

  Can only describe a SELECT statement

Item	Value
SQLCode	-160
Constant	SQLE_DESCRIBE_NONSELECT
SQLState	07005
ODBC State	(handled by ODBC driver)

Probable cause 

In the C language interface, you attempted to describe the select list of a statement other than a SELECT statement.

  Cannot access instance member through a class

Item	Value
SQLCode	-701
Constant	SQLE_CANNOT_ACCESS_INSTANCE_MEMBER
SQLState	WJ011
ODBC State	S1000

Probable cause 

Non-static fields or methods must be accessed through an object instance.

  Cannot alter a column in an index

Item	Value
SQLCode	-127
Constant	SQLE_COLUMN_IN_INDEX
SQLState	53W05
ODBC State	S1000

Probable cause 

This error is reported if you attempt to delete or modify the definition of a column that is part of a primary or foreign key. This error will also be reported if you attempt to delete a column that has an index on it. DROP the index or key, perform the ALTER command, and then add the index or key again.

  Cannot be started -- %1

Item	Value
SQLCode	-105
Constant	SQLE_UNABLE_TO_CONNECT
SQLState	08001
ODBC State	08001
Parameter 1	Name of database.

Probable cause 

The specified database environment cannot be found. If it is a database name, then it does not exist, it is not a database, it is corrupt, or it is an older format. If it is a server name, then the server cannot be found.

  Cannot convert %1 to a %2

Item	Value
SQLCode	-157
Constant	SQLE_CONVERSION_ERROR
SQLState	53018
ODBC State	07006
Parameter 1	The value that could not be converted.
Parameter 2	The name of the type for the conversion.

Probable cause 

An invalid value has been supplied to or fetched from the database. For example, the value 12X might have been supplied where a number was required.

  Cannot create an index on Java class '%1'

Item	Value
SQLCode	-704
Constant	SQLE_CANNOT_INDEX_ON_JAVA_CLASS
SQLState	WW022
ODBC State	S1000
Parameter 1	The name of the class.

Probable cause 

An operation requiring an index was attempted in which at attempt was made to create an index on a Java class type.

  Cannot create item (%1) in the specified dbspace.

Item	Value
SQLCode	-648
Constant	SQLE_INVALID_DBSPACE_FOR_CREATE
SQLState	08W36
ODBC State	S1000

Probable cause 

The dbspace specified is invalid, e.g., an index must be created in a dbspace of the same type as the underlying table.

  Cannot delete a column referenced in a trigger definition

Item	Value
SQLCode	-269
Constant	SQLE_COLUMN_IN_TRIGGER
SQLState	53W06
ODBC State	S1000

Probable cause 

This error is reported if you attempt to delete a column that is referenced in a trigger definition. DROP the trigger before performing the ALTER command.

  Cannot deserialize Java object

Item	Value
SQLCode	-663
Constant	SQLE_JAVA_DESERIALIZATION_ERROR
SQLState	WW018
ODBC State	S1000

Probable cause 

The persisted Java object cannot be read from the database column. Possibly, the class of the object has been removed or modified.

  Cannot drop a user that owns messages or datatypes

Item	Value
SQLCode	-614
Constant	SQLE_USER_OWNS_MESSAGES_OR_DATATYPES
SQLState	55W05
ODBC State	42000

Probable cause 

A user to be dropped is the creator of a message or user-defined datatype. The message or user-defined datatype must be dropped first.

  Cannot drop a user that owns objects involved in replication

Item	Value
SQLCode	-731
Constant	SQLE_USER_OWNS_REPLICATED_OBJECTS
SQLState	55W06
ODBC State	42000

Probable cause 

A user to be dropped is the creator of a database object that is involved in replication (eg. the user owns a table that is part of a publication).

  Cannot drop a user that owns procedures in runtime engine

Item	Value
SQLCode	-270
Constant	SQLE_USER_OWNS_PROCEDURES
SQLState	55W04
ODBC State	42000

Probable cause 

This error is reported by the runtime engine if you attempt to drop a user that owns procedures. Because this operation would result in dropping procedures, and the runtime engine cannot drop procedures, it is not allowed. Use the full engine.

  Cannot drop a user that owns tables in runtime engine

Item	Value
SQLCode	-128
Constant	SQLE_USER_OWNS_TABLES
SQLState	55W03
ODBC State	42000

Probable cause 

This error is reported by the runtime engine if you attempt to drop a user that owns tables. Because this operation would result in dropping tables, and the runtime engine cannot drop tables, it is not allowed. Use the full engine.

  Cannot find index named '%1'

Item	Value
SQLCode	-183
Constant	SQLE_INDEX_NOT_FOUND
SQLState	52W03
ODBC State	42S12
Parameter 1	Name of the index that cannot be found.

Probable cause 

A DROP INDEX command has named an index that does not exist. Check for spelling errors or whether the index name must be qualified by a userid.

  Cannot insert or update computed column '%1'

Item	Value
SQLCode	-703
Constant	SQLE_COMPUTED_COLUMN_WRITE_ATTEMPTED
SQLState	WW023
ODBC State	S1000
Parameter 1	The name of the column.

Probable cause 

Computed column values cannot be modified explicitly. Their value is determined implicitly from the computed expression value.

  Cannot make a static reference to nonstatic variable '%1' in class '%2'

Item	Value
SQLCode	-686
Constant	SQLE_STATIC_REF_TO_NONSTATIC_VAR
SQLState	WW020
ODBC State	S1000
Parameter 1	The name of the nonstatic variable.
Parameter 2	The name of the class.

Probable cause 

A static reference was attempted on nonstatic variable of a class.

  Cannot map a loginid to the sys or public userid

Item	Value
SQLCode	-248
Constant	SQLE_INTEGRATED_LOGON_SYSMAP
SQLState	28W07
ODBC State	28000

Probable cause 

The dba attempted to map a loginID to either sys or public

  Cannot modify column '%1' in table '%2'

Item	Value
SQLCode	-191
Constant	SQLE_CANNOT_MODIFY
SQLState	42W32
ODBC State	42000
Parameter 1	Name of the column that cannot be changed.
Parameter 2	Name of the table containing the column.

Probable cause 

You do not have permission to modify the column, or the table is actually a view and the column in the view is defined as an expression (such as column1+column2) that cannot be modified.

  Cannot open log file %1

Item	Value
SQLCode	-106
Constant	SQLE_CANNOT_OPEN_LOG
SQLState	08W05
ODBC State	08003
Parameter 1	Name of log file.

Probable cause 

The database engine was unable to open the transaction log file. Perhaps the log file name specifies an invalid device or directory. If this is the case, you can use the DBLOG utility to find out where the transaction log should be and perhaps change it.

  Cannot remove class '%1': member of Jar

Item	Value
SQLCode	-653
Constant	SQLE_CLASS_MEMBER_OF_JAR
SQLState	WP004
ODBC State	S1000
Parameter 1	The name of the class file that can't be removed

Probable cause 

An attempt was made to remove a class file which is still part of a Jar. (It must be removed with the Jar)

  Cannot serialize Java object with class %1

Item	Value
SQLCode	-662
Constant	SQLE_JAVA_SERIALIZATION_ERROR
SQLState	WI009
ODBC State	S1000
Parameter 1	The class of the value that cannot be serialized.

Probable cause 

The Java object cannot be serialized as a persistent database column.

  Cannot set a temporary option for user '%1'

Item	Value
SQLCode	-203
Constant	SQLE_TEMPORARY_NOT_ALLOWED
SQLState	42W45
ODBC State	42000
Parameter 1	Userid whose option was to be changed.

Probable cause 

TEMPORARY options are set on a connection basis. To change an option for another user, do not specify TEMPORARY in the SET OPTION statement.

  Cannot uniquely identify rows in cursor

Item	Value
SQLCode	-295
Constant	SQLE_CANNOT_UNIQUELY_IDENTIFY_ROWS
SQLState	09W05
ODBC State	42000

Probable cause 

A UNIQUE cursor has been opened on a SELECT statement for which a set of columns uniquely identifying each row cannot be generated. One of the tables may not be defined with a primary key or uniqueness constraint, or the SELECT statement may involve a UNION or GROUP BY.

  Cannot update an expression

Item	Value
SQLCode	-190
Constant	SQLE_NON_UPDATEABLE_COLUMN
SQLState	53W02
ODBC State	42000

Probable cause 

You have tried to update a column in a query that is a database expression rather than a column in a table.

  Cannot update final member fields

Item	Value
SQLCode	-699
Constant	SQLE_CANNOT_UPDATE_FINAL_FIELD
SQLState	WJ012
ODBC State	S1000

Probable cause 

Final fields are read only.

  Cannot update or delete an all-NULL row from table '%1'.

Item	Value
SQLCode	-734
Constant	SQLE_CANNOT_UPDATE_NULL_ROW
SQLState	09W08
ODBC State	42000
Parameter 1	The name of the table which cannot be modifed.

Probable cause 

An attempt has been made to modify or delete a row in the specified table, which is part of the null-supplying side of an outer join. However, the cursor is currently positioned on a derived row that contains an all-NULL row for this table, which is the result of the failure of one or more ON conditions to evaluate to TRUE. Verify that the UPDATE or DELETE statement is correct.

  Character set translation to '%1' cannot be performed; '%2' is used instead

Item	Value
SQLCode	114
Constant	SQLE_CANNOT_PERFORM_CHAR_TRANSLATION
SQLState	01W12
ODBC State	(handled by ODBC driver)
Parameter 1	Name of character set the application requested.
Parameter 2	Name of character set the database will be using.

Probable cause 

The engine is unable to do a character translation from the character set the database is using to the character set the application requested.

  CHECKPOINT command requires a rollback log

Item	Value
SQLCode	-212
Constant	SQLE_CHECKPOINT_REQUIRES_UNDO
SQLState	42W20
ODBC State	40001

Probable cause 

You cannot use a CHECKPOINT command when the database engine is running in bulk mode without a rollback log.

  Class '%1' has no public field '%2'

Item	Value
SQLCode	-93
Constant	SQLE_FIELD_NOT_FOUND
SQLState	WW013
ODBC State	S1000
Parameter 1	The name of the class in which the named field could not be found.
Parameter 2	The name of the field which could not be found.

Probable cause 

An expression referenced a field which either does not exist or is not public.

  Column %1 in foreign key has a different definition than primary key

Item	Value
SQLCode	-113
Constant	SQLE_INVALID_FOREIGN_KEY_DEF
SQLState	53030
ODBC State	42000
Parameter 1	Name of the problem column.

Probable cause 

The data type of the column in the foreign key is not the same as the data type of the column in the primary key. Change the definition of one of the columns using ALTER TABLE.

  Column '%1' found in more than one table -- need a correlation name

Item	Value
SQLCode	-144
Constant	SQLE_COLUMN_AMBIGUOUS
SQLState	52002
ODBC State	42000
Parameter 1	Name of the ambiguous column.

Probable cause 

You have not put a correlation name on a column that is found in more than one of the tables referenced in a query. You need to add a correlation name to the reference.

  Column '%1' in table '%2' cannot be NULL

Item	Value
SQLCode	-195
Constant	SQLE_COLUMN_CANNOT_BE_NULL
SQLState	23502
ODBC State	23000
Parameter 1	Name of the column that cannot be NULL.
Parameter 2	Name of the table containing the column.

Probable cause 

You have not supplied a value where a value is required. The column definition prohibits NULL values or the column is part of a NOT NULL foreign key.

  Column '%1' not found

Item	Value
SQLCode	-143
Constant	SQLE_COLUMN_NOT_FOUND
SQLState	52003
ODBC State	42S22
Parameter 1	Name of the column that could not be found.

Probable cause 

You have misspelled the name of a column, or the column you are looking for is in a different table.

  COMMIT/ROLLBACK not allowed within atomic operation

Item	Value
SQLCode	-267
Constant	SQLE_ATOMIC_OPERATION
SQLState	42W28
ODBC State	42000

Probable cause 

A COMMIT or ROLLBACK statement was encountered while executing within an atomic operation.

  COMMIT/ROLLBACK not allowed within trigger actions

Item	Value
SQLCode	-273
Constant	SQLE_INVALID_TRIGGER_STATEMENT
SQLState	2D501
ODBC State	42000

Probable cause 

An attempt was made to execute a statement that is not allowed while performing a trigger action. COMMIT and ROLLBACK statements cannot be executed from a trigger.

  Communication buffer underflow

Item	Value
SQLCode	-73
Constant	SQLE_COMMUNICATIONS_UNDERFLOW
SQLState	08W31
ODBC State	08S01

Probable cause 

The multi-user client or server has received a network buffer containing insufficient data. If this error occurs, it should be reported to Watcom.

  Communication error

Item	Value
SQLCode	-85
Constant	SQLE_COMMUNICATIONS_ERROR
SQLState	08W12
ODBC State	08S01

Probable cause 

There is a communication problem between the multi-user client and server. This happens most frequently when the multi-user client was unable to start because a communication error occurred while trying to locate the server.

  Computed columns are not supported in this database

Item	Value
SQLCode	-709
Constant	SQLE_COMPUTED_COLUMNS_NOT_SUPPORTED
SQLState	0AW06
ODBC State	42000

Probable cause 

The current database is an older database and does not have catalog support for computed (materialized) columns. The database should be unloaded and reloaded into a database that has been initialized with a newer version of Adaptive Server Anywhere or use DBUPGRADE to upgrade the database to the most recent version.

  Connection not found

Item	Value
SQLCode	-108
Constant	SQLE_CONNECTION_NOT_FOUND
SQLState	08W02
ODBC State	08003

Probable cause 

The specified connection name on a DISCONNECT or SET CONNECTION statement is invalid.

  Connection was terminated

Item	Value
SQLCode	-308
Constant	SQLE_CONNECTION_TERMINATED
SQLState	40W07
ODBC State	S1000

Probable cause 

Your database connection has been terminated by a DBA executing a DROP CONNECTION command. Your transaction was rolled back.

  Connections to database have been disabled

Item	Value
SQLCode	-99
Constant	SQLE_CONNECTIONS_DISABLED
SQLState	08W04
ODBC State	08005

Probable cause 

Connections to the multi-user server have been disabled on the server console. You will receive this error until they have been reenabled on the server console.

  Contents of backup files are inconsistent

Item	Value
SQLCode	-715
Constant	SQLE_RESTORE_INCONSISTENT
SQLState	WB006
ODBC State	S1000
Parameter 1	The name of server capability.

Probable cause 

An alter server was attempted on a capability that was not defined. During a RESTORE, the contents of a backup that was done to two or more disk or tape devices were found to be inconsistent.

  Correlation name '%1' not found

Item	Value
SQLCode	-142
Constant	SQLE_CORRELATION_NAME_NOT_FOUND
SQLState	52W02
ODBC State	42S02
Parameter 1	Name of the invalid correlation name.

Probable cause 

You have misspelled a correlation name, or you have used a table name instead of the correlation name.

  Could not access column information for the table '%1'.

Item	Value
SQLCode	-667
Constant	SQLE_OMNI_RMT_COLUMNS_NOTFOUND
SQLState	WO008
ODBC State	S1000
Parameter 1	The complete name of the remote table

Probable cause 

Column information for the table could not be accessed. Check privileges for the table.

  Could not allocate resources to call external function

Item	Value
SQLCode	-622
Constant	SQLE_ERROR_CALLING_FUNCTION
SQLState	WW008
ODBC State	S1000

Probable cause 

The external function could not be called due to a shortage of operating system resources. If the operating system supports threads, the maximum thread count should be increased.

  Could not change an opened prepared statement or callable statement

Item	Value
SQLCode	-694
Constant	SQLE_CANNOT_CHANGE_OPENED_STATEMENT
SQLState	WJ008
ODBC State	S1000

Probable cause 

An attempt was made to change the sql statement of an opened prepared statement or callable statement. Prepared statement and callable statement must be closed before attempting such changes.

  Could not decompress class '%1' from Jar.

Item	Value
SQLCode	-652
Constant	SQLE_CANNOT_DECOMPRESS_CLASS
SQLState	WP003
ODBC State	S1000
Parameter 1	The name of the class file in the Jar

Probable cause 

The Java runtime library must be installed to extract class files from .ZIPs or .JARs

  Could not execute backup/restore DLL (%1) entry point.

Item	Value
SQLCode	-692
Constant	SQLE_BACKUP_ENTRY_NOT_FOUND
SQLState	08W45
ODBC State	S1000

Probable cause 

An attempt to locate or execute the backup/restore DLL entry point failed.

  Could not execute store DLL (%1) entry point.

Item	Value
SQLCode	-647
Constant	SQLE_STORE_ENTRY_NOT_FOUND
SQLState	08W35
ODBC State	S1000

Probable cause 

An attempt to locate or execute the store DLL entry point failed.

  Could not find '%1' in dynamic library '%2'

Item	Value
SQLCode	-621
Constant	SQLE_COULD_NOT_FIND_FUNCTION
SQLState	WW007
ODBC State	S1000
Parameter 1	Name of the function which could not be found.
Parameter 2	Name of the dynamic library in which the function could not be found.

Probable cause 

The external function could not be found in the dynamic library.

  Could not load dynamic library '%1'

Item	Value
SQLCode	-620
Constant	SQLE_COULD_NOT_LOAD_LIBRARY
SQLState	WW006
ODBC State	S1000
Parameter 1	Name of the dynamic library which could not be loaded.

Probable cause 

This error is usually caused by a failure to load a dynamic library named in an external function call. This error can also occur if other libraries such as the Java virtual machine library are missing.

  Could not load the backup/restore DLL %1

Item	Value
SQLCode	-691
Constant	SQLE_BACKUP_NOT_LOADED
SQLState	08W44
ODBC State	S1000

Probable cause 

An attempt to load the backup/restore DLL failed.

  Could not load the store DLL %1

Item	Value
SQLCode	-646
Constant	SQLE_STORE_NOT_LOADED
SQLState	08W34
ODBC State	S1000

Probable cause 

An attempt to load the store DLL failed.

  Creating remote tables with computed columns is not supported.

Item	Value
SQLCode	-732
Constant	SQLE_OMNI_COMPUTED_NOT_SUPPORTED
SQLState	WO021
ODBC State	S1000

Probable cause 

Computed columns are not supported in 'CREATE TABLE' statements which specify a remote location.

  Cursor already open

Item	Value
SQLCode	-172
Constant	SQLE_CURSOR_ALREADY_OPEN
SQLState	24502
ODBC State	24000

Probable cause 

You attempted to OPEN a cursor that is already open.

  Cursor has not been declared

Item	Value
SQLCode	-170
Constant	SQLE_CURSOR_NOT_DECLARED
SQLState	24W01
ODBC State	24000

Probable cause 

You attempted to OPEN a cursor that has not been declared.

  Cursor is restricted to FETCH NEXT operations

Item	Value
SQLCode	-668
Constant	SQLE_NO_SCROLL_CURSOR
SQLState	09W06
ODBC State	HY106

Probable cause 

An illegal FETCH operation has been detected for a NO SCROLL cursor. For a forward-only cursor the only permitted FETCH operations are FETCH RELATIVE 0 and FETCH NEXT (FETCH RELATIVE 1).

  Cursor not open

Item	Value
SQLCode	-180
Constant	SQLE_CURSOR_NOT_OPEN
SQLState	24501
ODBC State	34000

Probable cause 

You attempted to OPEN a cursor that has not been declared.

  Cursor operation conflict

Item	Value
SQLCode	108
Constant	SQLE_CURSOR_OPERATION_CONFLICT
SQLState	01001
ODBC State	(handled by ODBC driver)

Probable cause 

You have attempted to perform an operation on the current row of a cursor, but the row has been modified by a searched UPDATE or DELETE or by a positioned UPDATE or DELETE.

  Data definition statements not allowed in procedures or triggers

Item	Value
SQLCode	-623
Constant	SQLE_DDL_NOT_ALLOWED_IN_PROCEDURES
SQLState	52W21
ODBC State	S1000

Probable cause 

The procedure or trigger definition contains a data definition statement (such as CREATE, DROP, GRANT, REVOKE, ALTER). These statements are not allowed within procedures or triggers.

  Database %1 needs recovery

Item	Value
SQLCode	-665
Constant	SQLE_DATABASE_NEEDS_RECOVERY
SQLState	08W41
ODBC State	S1000
Parameter 1	The filename of the database that needs recovery.

Probable cause 

The database quit abnormally the last time it was used. Database recovery must be performed before proceeding.

  Database backup not started

Item	Value
SQLCode	-241
Constant	SQLE_BACKUP_NOT_STARTED
SQLState	WB002
ODBC State	S1000

Probable cause 

A database backup could not be started. Either you do not have DBA authority, or another backup has started and not completed.

  Database creation failed

Item	Value
SQLCode	-645
Constant	SQLE_DATABASE_NOT_CREATED
SQLState	08W33
ODBC State	08004

Probable cause 

An attempt to initialize a file for database or write file creation failed.

  Database engine already running

Item	Value
SQLCode	-96
Constant	SQLE_ENGINE_ALREADY_RUNNING
SQLState	08W23
ODBC State	HY000

Probable cause 

The database engine was not able to start on a db_start_engine call because it was already running.

  Database engine not running

Item	Value
SQLCode	-100
Constant	SQLE_ENGINE_NOT_RUNNING
SQLState	08W01
ODBC State	08001

Probable cause 

You have not run the database engine or network requestor or the interface library is unable to find it.

  Database engine not running in multi-user mode

Item	Value
SQLCode	-89
Constant	SQLE_ENGINE_NOT_MULTIUSER
SQLState	08W16
ODBC State	08001

Probable cause 

The database was started for bulk loading (the -b switch) and cannot be used as a multi-user engine. Stop the database, and start again without -b. In the DOS version of Watcom SQL 3.0, the database engine was not started in multi-user mode.

  Database is active

Item	Value
SQLCode	-664
Constant	SQLE_DATABASE_ACTIVE
SQLState	08W40
ODBC State	S1000

Probable cause 

An attempt was made to create a writefile for a database that is currently active.

  Database name not unique

Item	Value
SQLCode	-77
Constant	SQLE_ALIAS_CLASH
SQLState	08W27
ODBC State	08001

Probable cause 

The database cannot be loaded as its name is conflicting with a previously loaded database.

  Database name required to start engine

Item	Value
SQLCode	-87
Constant	SQLE_DATABASE_NAME_REQUIRED
SQLState	08W14
ODBC State	08001

Probable cause 

A database name is required to start the database engine or the multi-user client, but it was not specified.

  Database option '%1' for user '%2' has an invalid setting

Item	Value
SQLCode	113
Constant	SQLE_INVALID_OPTION_ON_CONNECT
SQLState	01W11
ODBC State	(handled by ODBC driver)
Parameter 1	Name of the database option that has the invalid value.
Parameter 2	Name of the user attempting to connect.

Probable cause 

Upon processing a connection request for a specific user, the engine processed a database option from the SYSOPTIONS table which had an invalid setting. The erroneous option setting is ignored; in its place, the engine will use the default option value for the current database.

  Database upgrade failed

Item	Value
SQLCode	-672
Constant	SQLE_DATABASE_UPGRADE_FAILED
SQLState	08W42
ODBC State	08004

Probable cause 

An attempt to upgrade a database failed. This could be caused by a failure to read or write one of the SQL script files used to define the system table changes.

  Database upgrade not possible

Item	Value
SQLCode	-673
Constant	SQLE_DATABASE_UPGRADE_NOT_POSSIBLE
SQLState	08W43
ODBC State	08004

Probable cause 

An attempt to upgrade a database failed. The database is too old to be upgraded.

  Database was initialized with an older version of the software

Item	Value
SQLCode	-266
Constant	SQLE_OLD_DBINIT
SQLState	42W27
ODBC State	S1000

Probable cause 

The database is missing some system table definitions required for this statement. These system table definitions are normally created when a database is initialized. The database should be unloaded and reloaded into a database that has been initialized with a newer version of Adaptive Server Anywhere or use DBUPGRADE to upgrade the database to the most recent version.

  Database's page size too big

Item	Value
SQLCode	-97
Constant	SQLE_PAGE_SIZE_TOO_BIG
SQLState	08W22
ODBC State	08004

Probable cause 

You have attempted to start a database or create a write file for a database with a page size that exceeds the maximum page size of the running engine. Either restart the engine with this database named on the command line, or restart the engine with a larger page size.

  Dblib/database engine version mismatch

Item	Value
SQLCode	-231
Constant	SQLE_DBLIB_ENGINE_MISMATCH
SQLState	08W19
ODBC State	08001

Probable cause 

Your executable uses a database interface library that does not match the version number of the database engine.

  Dbspace '%1' not found

Item	Value
SQLCode	-138
Constant	SQLE_DBSPACE_NOT_FOUND
SQLState	52W13
ODBC State	42S02
Parameter 1	Name of the dbspace that could not be found.

Probable cause 

The named dbspace was not found.

  Deadlock detected

Item	Value
SQLCode	-306
Constant	SQLE_DEADLOCK
SQLState	40001
ODBC State	40001

Probable cause 

You have attempted to read or write a row and it is locked by another user. Also, the other user is blocked directly or indirectly on your own transaction. This is a deadlock situation and your transaction has been chosen as the one to rollback.

  Derived table '%1' has no name for column %2

Item	Value
SQLCode	-163
Constant	SQLE_NO_COLUMN_NAME
SQLState	52004
ODBC State	42000
Parameter 1	Name of the derived table.
Parameter 2	Number of the column for which there is no name.

Probable cause 

The specified column of the derived table has no column name. Use a select list alias in the query specification or use a derived columns specifier.

  Disallowed language extension detected in syntax near '%1'

Item	Value
SQLCode	-627
Constant	SQLE_INVALID_SYNTAX_EXTENSION
SQLState	0AW03
ODBC State	S1000
Parameter 1	The word or symbol where the syntax has been detected.

Probable cause 

The command you are trying to execute contains extensions to ANSI 1992 Entry SQL that are not allowed by the current settings.

  Disk full '%1' -- transaction rolled back

Item	Value
SQLCode	-304
Constant	SQLE_DEVICE_FULL
SQLState	40W03
ODBC State	S1000

Probable cause 

Your hard disk is out of free space. A ROLLBACK WORK command has been automatically executed.

  Division by zero

Item	Value
SQLCode	-628
Constant	SQLE_DIV_ZERO_ERROR
SQLState	22012
ODBC State	22012

Probable cause 

A division by zero operation was detected.

  Do not have permission to %1

Item	Value
SQLCode	-121
Constant	SQLE_PERMISSION_DENIED
SQLState	42501
ODBC State	42000
Parameter 1	Description of the type of permission lacking.

Probable cause 

You do not have the required permission to do the specified action. You have not been granted permission to use a table belonging to another userid.

  Duplicate insert column

Item	Value
SQLCode	-637
Constant	SQLE_DUPLICATE_INSERT_COLUMN
SQLState	42W41
ODBC State	42000

Probable cause 

A duplicate column name was used in the list of insert columns.

  Duplicate referencing column

Item	Value
SQLCode	-636
Constant	SQLE_DUPLICATE_REFERENCING_COLUMN
SQLState	42W40
ODBC State	42000

Probable cause 

A duplicate column name was used in the list of referencing columns.

  Dynamic memory exhausted!

Item	Value
SQLCode	-78
Constant	SQLE_DYNAMIC_MEMORY_EXHAUSTED
SQLState	08W26
ODBC State	HY001

Probable cause 

A failure occurred when trying to allocate dynamic memory.

  Error during backup: %1

Item	Value
SQLCode	-697
Constant	SQLE_BACKUP_ERROR
SQLState	08W46
ODBC State	S1000

Probable cause 

An error occurred during a BACKUP statement.

  Error in assignment

Item	Value
SQLCode	-641
Constant	SQLE_ERROR_IN_ASSIGNMENT
SQLState	22005
ODBC State	22018

Probable cause 

In a GET DESCRIPTOR statement, the data type of the host variable must correspond to the data type of the descriptor item.

  Error number %1 for RAISERROR is less than 17000

Item	Value
SQLCode	-296
Constant	SQLE_ERROR_NUMBER_OUT_OF_RANGE
SQLState	53W07
ODBC State	42000
Parameter 1	Error number.

Probable cause 

The error number used in a RAISERROR statement is invalid. The number must be greater than or equal to 17000.

  Error opening cursor

Item	Value
SQLCode	-171
Constant	SQLE_OPEN_CURSOR_ERROR
SQLState	07003
ODBC State	24000

Probable cause 

You have attempted to open a cursor on a statement that is not a SELECT statement or a CALL statement.

  Error parsing connection parameter string.

Item	Value
SQLCode	-655
Constant	SQLE_GEN_PARSE_ERROR
SQLState	08W38
ODBC State	08001

Probable cause 

The connection string could not be parsed. The string or connection parameter file contains a syntax error.

  Error writing to log file

Item	Value
SQLCode	-107
Constant	SQLE_ERROR_WRITING_LOG
SQLState	08W17
ODBC State	S1000

Probable cause 

The database engine got an I/O error writing the log file. Perhaps the disk is full or the log file name is invalid.

  Expression has unsupported datatype

Item	Value
SQLCode	-624
Constant	SQLE_DATATYPE_NOT_ALLOWED
SQLState	WW009
ODBC State	S1000

Probable cause 

Either an external function or Java method is declared to have a parameter or result datatype which is not supported, or a Java field reference with unsupported result type was attempted.

  External login for server %1 could not be found.

Item	Value
SQLCode	-712
Constant	SQLE_OMNI_EXTLOGIN_NOT_FOUND
SQLState	WO013
ODBC State	S1000
Parameter 1	The name of the remote server.

Probable cause 

An external login for the server and user does not exist.

  Feature '%1' not implemented

Item	Value
SQLCode	-134
Constant	SQLE_NOT_IMPLEMENTED
SQLState	0A000
ODBC State	S1000
Parameter 1	The unimplemented feature.

Probable cause 

The requested operation or feature is not implemented in Adaptive Server Anywhere.

  Field '%1' of class '%2' cannot be null

Item	Value
SQLCode	-649
Constant	SQLE_FIELD_CANNOT_BE_NULL
SQLState	WW015
ODBC State	S1000
Parameter 1	The name of the field which cannot be null.
Parameter 2	The name of the class which has the field.

Probable cause 

An attempt was made to store a SQL null value in a Java object field which has a Java type that cannot be null. For example, the Java 'int' type cannot be null.

  Foreign key '%1' for table '%2' duplicates an existing foreign key

Item	Value
SQLCode	-251
Constant	SQLE_DUPLICATE_FOREIGN_KEY
SQLState	52W06
ODBC State	42000
Parameter 1	The role name of the new foreign key.
Parameter 2	The table containing the foreign key.

Probable cause 

You have attempted to define a foreign key that already exists.

  Foreign key name '%1' not found

Item	Value
SQLCode	-145
Constant	SQLE_FOREIGN_KEY_NAME_NOT_FOUND
SQLState	52W07
ODBC State	42000
Parameter 1	Name of the non-existing foreign key.

Probable cause 

You have misspelled the name of a foreign key or the foreign key does not exist.

  Format string argument number %1 is invalid

Item	Value
SQLCode	-294
Constant	SQLE_INVALID_FORMAT_STRING_ARG_NUM
SQLState	53W08
ODBC State	42000
Parameter 1	Argument number.

Probable cause 

An argument number in the format string for a PRINT or RAISERROR statement is invalid. The number must be between 1 and 20 and must not exceed the number of arguments provided.

  Function or column reference to '%1' in the select list must also appear in a GROUP BY

Item	Value
SQLCode	-149
Constant	SQLE_INVALID_GROUP_SELECT
SQLState	53003
ODBC State	42000
Parameter 1	Name of the column referenced directly, or in an expression, that must be in the GROUP BY clause.

Probable cause 

In a query using GROUP BY, select list items that are not aggregate functions must also appear in the GROUP BY clause. If the select list item is a column reference or an alias, simply add the column name or alias to the GROUP BY clause. If the select list item is a scalar function, ensure that the function's arguments in the GROUP BY clause match exactly with those in the select list. In some cases, you may want to use the MAX function on the column name (or another aggregate function) instead of adding the column to the GROUP BY clause.

  GRANT of column permission on view not allowed

Item	Value
SQLCode	-635
Constant	SQLE_NO_COLUMN_PERMS_FOR_VIEWS
SQLState	52W22
ODBC State	S1000

Probable cause 

Permissions on columns cannot be granted for views.

  I/O error %1 -- transaction rolled back

Item	Value
SQLCode	-305
Constant	SQLE_DEVICE_ERROR
SQLState	40W04
ODBC State	S1000

Probable cause 

Adaptive Server Anywhere has detected a problem with your hard disk. If you cannot find a hardware error using the operating system disk check utility (eg. in DOS, chkdsk, and in QNX, chkfsys), report the problem to Adaptive Server Anywhere technical support. A ROLLBACK WORK command has been automatically executed.

  Identifier '%1' too long

Item	Value
SQLCode	-250
Constant	SQLE_IDENTIFIER_TOO_LONG
SQLState	54003
ODBC State	42000
Parameter 1	The identifier in error.

Probable cause 

An identifier is longer than 128 characters.

  Identity attribute mismatch for column '%1'.

Item	Value
SQLCode	-725
Constant	SQLE_OMNI_IDENTITY_MISMATCH
SQLState	WO019
ODBC State	(handled by ODBC driver)
Parameter 1	The name of the column.

Probable cause 

The identity attribute of the column specified in the 'CREATE EXISTING' command differs from the identity attribute of the actual column.

  Illegal cursor operation attempt

Item	Value
SQLCode	-187
Constant	SQLE_CURSOROP_NOT_ALLOWED
SQLState	09W02
ODBC State	07005

Probable cause 

An illegal cursor operation was attempted. For example, you may be attempting to OPEN a cursor for a statement that is neither a SELECT nor a BATCH.

  Illegal user selectivity estimate specified.

Item	Value
SQLCode	118
Constant	SQLE_INVALID_USER_ESTIMATE
SQLState	01W16
ODBC State	(handled by ODBC driver)

Probable cause 

You have specified a user selectivity estimate that is either not a literal constant or is outside the range 0.0 to 100.0 (estimates are specified as percentages). The estimate has been ignored.

  Incomplete transactions prevent transaction log renaming

Item	Value
SQLCode	-242
Constant	SQLE_BACKUP_CANNOT_RENAME_LOG_YET
SQLState	WB003
ODBC State	S1000

Probable cause 

The last page in the transaction log was read by a call to db_backup. One or more currently active connections have partially completed transactions, preventing the transaction log file from being renamed. The db_backup call should be reissued.

  Incorrect store DLL (%1) version.

Item	Value
SQLCode	-711
Constant	SQLE_STORE_VERSION_MISMATCH
SQLState	08W47
ODBC State	S1000

Probable cause 

The store and server dll versions do not match.

  Index '%1' for table '%2' would not be unique

Item	Value
SQLCode	-196
Constant	SQLE_INDEX_NOT_UNIQUE
SQLState	23505
ODBC State	23000
Parameter 1	Name of the index that would not be unique.
Parameter 2	Name of the table that contains the index.

Probable cause 

You have inserted or updated a row that has the same value as another row in some column, and there is a constraint that does not allow two rows to have the same value in that column.

  Index name '%1' is ambiguous

Item	Value
SQLCode	-678
Constant	SQLE_AMBIGUOUS_INDEX_NAME
SQLState	52W40
ODBC State	42S11
Parameter 1	Name of the ambiguous index.

Probable cause 

A statement has referred to an index name which is not unique. The index name should be prefixed by an owner name.

  Index name '%1' not unique

Item	Value
SQLCode	-111
Constant	SQLE_INDEX_NAME_NOT_UNIQUE
SQLState	52W04
ODBC State	42S11
Parameter 1	Name of the invalid index.

Probable cause 

You have attempted to create an index with a name of an existing index.

  Index type specification of '%1' is invalid.

Item	Value
SQLCode	-650
Constant	SQLE_INVALID_INDEX_TYPE
SQLState	WW016
ODBC State	S1000

Probable cause 

IQ index types can be specified for IQ indexes only.

  Input parameter index out of range

Item	Value
SQLCode	-689
Constant	SQLE_BAD_PARAM_INDEX
SQLState	WJ005
ODBC State	S1000

Probable cause 

Valid indices for parameters starts from 1 up to the number of host variables specified in the prepared/callable statement.

  INSERT/DELETE on cursor can modify only one table

Item	Value
SQLCode	-199
Constant	SQLE_ONLY_ONE_TABLE
SQLState	09W04
ODBC State	42000

Probable cause 

You have attempted to INSERT into a cursor and have specified values for more than one table; or you have tried to DELETE from a cursor that involves a join. INSERT into one table at a time. For DELETE, use the FROM clause to specify which table you wish to delete from.

  Integrated logon failed

Item	Value
SQLCode	-245
Constant	SQLE_INTEGRATED_LOGON_FAILED
SQLState	28W04
ODBC State	28000

Probable cause 

The integrated logon failed, possibly because if the user doesn't have a system account on the server machine, or for other reasons.

  Integrated logons are not permitted

Item	Value
SQLCode	-205
Constant	SQLE_INVALID_STANDARD_LOGON
SQLState	28W02
ODBC State	28000

Probable cause 

The engine logon type switch (gl) is set to STANDARD logon type, and the user has attempted an integrated logon.

  Integrated logons are not supported for this database

Item	Value
SQLCode	-246
Constant	SQLE_INTEGRATED_LOGON_UNSUPPORTED
SQLState	28W05
ODBC State	28000

Probable cause 

The current database is an older database and does not have a sys.syslogin table to map integrated loginIDs to database userIDs.

  Internal database error %1 -- transaction rolled back

Item	Value
SQLCode	-301
Constant	SQLE_DATABASE_ERROR
SQLState	40W01
ODBC State	S1000
Parameter 1	Identification of the error.

Probable cause 

This error indicates an internal database error, and should be reported to Adaptive Server Anywhere technical support. A ROLLBACK WORK command has been automatically executed.

  Invalid absolute or relative offset in FETCH

Item	Value
SQLCode	-263
Constant	SQLE_INVALID_FETCH_POSITION
SQLState	42W25
ODBC State	42000

Probable cause 

The offset specified in a FETCH was invalid or NULL.

  Invalid class byte code

Item	Value
SQLCode	-670
Constant	SQLE_BAD_CLASS_BYTE_CODE
SQLState	WP005
ODBC State	S1000

Probable cause 

A binary expression passed to the INSTALL JAVA command was not a valid Java class.

  Invalid column number

Item	Value
SQLCode	-159
Constant	SQLE_INVALID_COLUMN_NUMBER
SQLState	42W13
ODBC State	42000

Probable cause 

You have given an invalid column number, or the column you are looking for is in a different table.

  Invalid comparison

Item	Value
SQLCode	-710
Constant	SQLE_INVALID_COMPARISON
SQLState	52W25
ODBC State	42000

Probable cause 

An attempt was made to compare two arguments that do not support comparison. For example, it is not valid to compare a Java object with another Java object, unless the class of the object supports a valid compareTo() method.

  Invalid data conversion

Item	Value
SQLCode	103
Constant	SQLE_CANNOT_CONVERT
SQLState	01W03
ODBC State	07006

Probable cause 

The database could not convert a value to the required type. This is either a value supplied to the database on an insert, update or as a host bind variable, or a value retrieved from the database into a host variable or SQLDA.

  Invalid database engine command line

Item	Value
SQLCode	-81
Constant	SQLE_INVALID_COMMAND_LINE
SQLState	08W08
ODBC State	08001

Probable cause 

It was not possible to start the database engine or multi-user client because the command line was invalid. of how the engine is started.

  Invalid database page size

Item	Value
SQLCode	-644
Constant	SQLE_PAGE_SIZE_INVALID
SQLState	08W32
ODBC State	42000

Probable cause 

You have attempted to create a database with an invalid page size. The page size for an Adaptive Server Anywhere database must be either 1K, 2K, or 4K.

  Invalid datatype for column in WRITETEXT or READTEXT

Item	Value
SQLCode	-609
Constant	SQLE_INVALID_TEXT_IMAGE_DATATYPE
SQLState	53W09
ODBC State	S1000

Probable cause 

The column referenced in a WRITETEXT or READTEXT statement is not defined for storing text or image data.

  Invalid descriptor index

Item	Value
SQLCode	-640
Constant	SQLE_INVALID_DESCRIPTOR_INDEX
SQLState	07009
ODBC State	07009

Probable cause 

The index number used with respect to a descriptor area is out of range.

  Invalid escape character '%1'

Item	Value
SQLCode	-629
Constant	SQLE_INVALID_ESCAPE_CHAR
SQLState	22019
ODBC State	22019

Probable cause 

Escape character string length must be exactly one.

  Invalid escape sequence '%1'

Item	Value
SQLCode	-630
Constant	SQLE_INVALID_ESCAPE_SEQ
SQLState	22025
ODBC State	22025

Probable cause 

LIKE pattern contains an invalid use of the escape character. The escape character may only precede the special characters '%', '_', '[', and the escape character itself.

  Invalid expression in WHERE clause of Transact-SQL outer join

Item	Value
SQLCode	-680
Constant	SQLE_INVALID_TSQL_OJ_EXPRESSION
SQLState	52W23
ODBC State	42000

Probable cause 

An expression in the WHERE clause of a query which uses Transact-SQL syntax contains a comparison of a column from the null-supplying table with a subquery or an expression which references a column from another table.

  Invalid expression near '%1'

Item	Value
SQLCode	-156
Constant	SQLE_EXPRESSION_ERROR
SQLState	42W08
ODBC State	42000
Parameter 1	The invalid expression.

Probable cause 

You have an expression which the database engine cannot understand. For example, you might have tried to add two dates.

  Invalid host variable

Item	Value
SQLCode	-155
Constant	SQLE_VARIABLE_INVALID
SQLState	42W07
ODBC State	42000

Probable cause 

A host variable supplied to the database using the C language interface as either a host variable or through an SQLDA is invalid.

  Invalid jar file

Item	Value
SQLCode	-730
Constant	SQLE_BAD_JAR_FILE
SQLState	WP010
ODBC State	S1000

Probable cause 

A file passed to the INSTALL JAVA command was not a valid jar file.

  Invalid join type used with Transact-SQL outer join

Item	Value
SQLCode	-681
Constant	SQLE_INVALID_TSQL_JOIN_TYPE
SQLState	52W24
ODBC State	42000

Probable cause 

An invalid join type was used with a query that contains Transact-SQL outer join comparison operators.

  Invalid local database switch

Item	Value
SQLCode	-79
Constant	SQLE_INVALID_LOCAL_OPTION
SQLState	08W25
ODBC State	08001

Probable cause 

An invalid local database switch was found in the DBS option.

  Invalid operation on a closed '%1'

Item	Value
SQLCode	-696
Constant	SQLE_JDBC_OBJ_CLOSED
SQLState	WJ010
ODBC State	S1000
Parameter 1	Java class of the closed object

Probable cause 

An illegal attempt was made to access a closed JDBC object.

  Invalid operation on a closed '%1'

Item	Value
SQLCode	-714
Constant	SQLE_JNAT_OBJ_CLOSED
SQLState	WJ014
ODBC State	S1000
Parameter 1	Java class of the closed object

Probable cause 

An illegal attempt was made to access a closed native Java object.

  Invalid option '%1' -- no PUBLIC setting exists

Item	Value
SQLCode	-200
Constant	SQLE_INVALID_OPTION
SQLState	42W16
ODBC State	42000
Parameter 1	Name of the invalid option.

Probable cause 

You have probably misspelled the name of an option in the SET OPTION command. You can only define an option for a user if the database administrator has supplied a PUBLIC value for that option.

  Invalid parameter.

Item	Value
SQLCode	-735
Constant	SQLE_INVALID_PARAMETER
SQLState	08W24
ODBC State	08004

Probable cause 

An error occurred while evaluating a parameter.

  Invalid prepared statement type

Item	Value
SQLCode	-133
Constant	SQLE_INVALID_STATEMENT_TYPE
SQLState	07W03
ODBC State	S1000

Probable cause 

This is an internal C language interface error. If it occurs, it should be reported to Adaptive Server Anywhere technical support.

  Invalid REFERENCES clause in trigger definition

Item	Value
SQLCode	-272
Constant	SQLE_INVALID_TRIGGER_COL_REFS
SQLState	52W12
ODBC State	42000

Probable cause 

The REFERENCES clause in a trigger definition is invalid. An OLD correlation name may have been specified in a BEFORE INSERT trigger, or a NEW correlation name may have been specified in an AFTER DELETE trigger. In both cases, the values do not exist and cannot be referenced.

  Invalid setting for option '%1'

Item	Value
SQLCode	-201
Constant	SQLE_INVALID_OPTION_SETTING
SQLState	42W17
ODBC State	42000
Parameter 1	Name of the invalid option.

Probable cause 

You have supplied an invalid value for an option in the SET command. Some options only allow numeric values, while other options only allow the values "on" and "off".

  Invalid SQL descriptor name

Item	Value
SQLCode	-642
Constant	SQLE_INVALID_DESCRIPTOR_NAME
SQLState	33000
ODBC State	33000

Probable cause 

You have attempted to deallocate a descriptor which has not been allocated.

  Invalid statement

Item	Value
SQLCode	-130
Constant	SQLE_INVALID_STATEMENT
SQLState	07W02
ODBC State	S1000

Probable cause 

The statement identifier (generated by PREPARE) passed to the database for a further operation is invalid.

  Invalid TEXTPTR value used with WRITETEXT or READTEXT

Item	Value
SQLCode	-608
Constant	SQLE_INVALID_TEXTPTR_VALUE
SQLState	22W03
ODBC State	S1000

Probable cause 

The value supplied as the TEXTPTR for a WRITETEXT or READTEXT statement is invalid.

  Invalid type for field reference

Item	Value
SQLCode	-94
Constant	SQLE_INVALID_FIELD_REFERENCE
SQLState	WW014
ODBC State	S1000

Probable cause 

An expression attempted to reference a field or a method of a non-Java value. Field references via '.' and '>>' are only valid when applied to Java objects.

  Invalid type on DESCRIBE statement

Item	Value
SQLCode	-161
Constant	SQLE_INVALID_DESCRIBE_TYPE
SQLState	07W01
ODBC State	(handled by ODBC driver)

Probable cause 

This is an internal C language interface error. If it occurs, it should be reported to Adaptive Server Anywhere technical support.

  Invalid userid and password on preprocessed module

Item	Value
SQLCode	-104
Constant	SQLE_INVALID_MODULE_LOGON
SQLState	28W01
ODBC State	28000

Probable cause 

A userid and password were specified when a module was preprocessed but the userid or password is invalid.

  Invalid userid or password

Item	Value
SQLCode	-103
Constant	SQLE_INVALID_LOGON
SQLState	28000
ODBC State	28000

Probable cause 

The user has supplied an invalid userid or an incorrect password. ISQL will handle this error by presenting a connection dialog to the user.

  Invalid value for column '%1' in table '%2'

Item	Value
SQLCode	-209
Constant	SQLE_INVALID_COLUMN_VALUE
SQLState	23506
ODBC State	23000
Parameter 1	Name of the column that was assigned an invalid value.
Parameter 2	Name of the table containing the column.

Probable cause 

An INSERT or UPDATE has specified a value for a column that violates a CHECK constraint, and the INSERT or UPDATE were not done because of the error. Note that a CHECK constraint is violated if it evaluates to FALSE; it is deemed to hold if the condition evaluates to TRUE or UNKNOWN.

  Item '%1' already exists

Item	Value
SQLCode	-110
Constant	SQLE_NAME_NOT_UNIQUE
SQLState	52010
ODBC State	42S01
Parameter 1	Name of the item that already exists.

Probable cause 

You have tried to create a file, table, view, column, foreign key, or publication with the same name as an existing one.

  Java virtual machine could not be started

Item	Value
SQLCode	-675
Constant	SQLE_JAVA_VM_NOT_STARTED
SQLState	WP006
ODBC State	S1000

Probable cause 

A problem was encountered starting the Java virtual machine. Possible problems include not enough memory, or incomplete installation of the Java runtime support classes.

  Java VM Heap Exhausted at Internal fn: %1

Item	Value
SQLCode	-165
Constant	SQLE_JAVA_VM_HEAP_EXHAUSTED
SQLState	WP008
ODBC State	S1000
Parameter 1	The internal function is for debugging purposes.

Probable cause 

The amount of space the user has allocated for the Java VM is insufficient to continue allocating new objects. Increase the size by using: set option public.java_heap_size = nnnnnnnn

  JDBC feature '%1' not supported

Item	Value
SQLCode	-693
Constant	SQLE_UNSUPPORTED_JDBC_FEATURE
SQLState	WJ007
ODBC State	S1000
Parameter 1	Name of the attempted feature

Probable cause 

An attempt was made to use a feature of JDBC that is not supported.

  Label '%1' not found

Item	Value
SQLCode	-262
Constant	SQLE_LABEL_NOT_FOUND
SQLState	42W24
ODBC State	42000
Parameter 1	Name of the label that could not be found.

Probable cause 

The label referenced in a LEAVE statement was not found.

  Language extension

Item	Value
SQLCode	-135
Constant	SQLE_LANGUAGE_EXTENSION
SQLState	0AW01
ODBC State	S1000

Probable cause 

The requested operation is valid in some versions of SQL, but not in Adaptive Server Anywhere.

  Language extension detected in syntax

Item	Value
SQLCode	107
Constant	SQLE_SYNTAX_EXTENSION_WARNING
SQLState	01W07
ODBC State	(handled by ODBC driver)

Probable cause 

The command you are executing contains extensions to ANSI 1992 Entry SQL.

  Memory error -- transaction rolled back

Item	Value
SQLCode	-309
Constant	SQLE_MEMORY_ERROR
SQLState	40W08
ODBC State	S1000

Probable cause 

The UltraLite runtime has received an unexpected error from the system calls being used to store the UltraLite database. For example, a write to persistent memory failed. This is an internal error and indicates faulty or corrupt persistent storage on the device. A ROLLBACK WORK command has been automatically executed.

  Method '%1' cannot be called at this time

Item	Value
SQLCode	-669
Constant	SQLE_METHOD_CANNOT_BE_CALLED
SQLState	WJ001
ODBC State	S1000
Parameter 1	The name of the method

Probable cause 

The method cannot be called at this time. Check that the method is not being called out of order.

  Mismatch between external function platform specifier and current operating system

Item	Value
SQLCode	-618
Constant	SQLE_EXTERNAL_PLATFORM_FAILURE
SQLState	WW004
ODBC State	S1000

Probable cause 

A call to an external entry point in a dynamically loaded module was qualified by an operating system which was not the operating system on which the engine/server is currently executing.

  More columns are being dropped from table %1 than are defined

Item	Value
SQLCode	-124
Constant	SQLE_TOO_MANY_COLUMNS_DELETED
SQLState	42W44
ODBC State	42000

Probable cause 

The number of columns in a table can never fall below one. Your ALTER TABLE has more drop/delete column clauses than the current number of columns in the table.

  More info required

Item	Value
SQLCode	112
Constant	SQLE_MORE_INFO
SQLState	01W09
ODBC State	(handled by ODBC driver)

Probable cause 

More information is required to complete the request. This is used internally in the database interface library to process a unified logon. It should not be returned to an application.

  More than one table is identified as '%1'

Item	Value
SQLCode	-139
Constant	SQLE_CORRELATION_NAME_AMBIGUOUS
SQLState	52012
ODBC State	42000
Parameter 1	Ambiguous correlation name.

Probable cause 

You have identified two tables in the same FROM clause with the same correlation name.

  Namespace Heap Exhausted at Internal fn: %1

Item	Value
SQLCode	-164
Constant	SQLE_NAMESPACE_HEAP_EXHAUSTED
SQLState	WP007
ODBC State	S1000
Parameter 1	The internal function is for debugging purposes.

Probable cause 

The amount of space the user has allocated for the Java Namespace is insufficient to continue loading Java classes etc. Increase the size by using: set option public.java_namespace_size = nnnnnnnn

  Need a dynamic library name

Item	Value
SQLCode	-619
Constant	SQLE_REQUIRE_DLL_NAME
SQLState	WW005
ODBC State	S1000

Probable cause 

The name of the external function to call did not contain a library name specifier.

  No current row of cursor

Item	Value
SQLCode	-197
Constant	SQLE_NO_CURRENT_ROW
SQLState	24503
ODBC State	24000

Probable cause 

You have attempted to perform an operation on the current row of a cursor, but the cursor is not positioned on a row. The cursor is before the first row of the cursor, after the last row, or is on a row that has since been deleted.

  No data

Item	Value
SQLCode	100
Constant	SQLE_NO_DESCRIPTOR_DATA
SQLState	02W01
ODBC State	42000

Probable cause 

You have positioned a cursor beyond the beginning or past the end of the query. There is no row at that position. You have attemped to access a descriptor area using an index value larger than the number of variables in the descriptor.

  No database file specified

Item	Value
SQLCode	-72
Constant	SQLE_NO_DATABASE_FILE
SQLState	08W39
ODBC State	08001

Probable cause 

The database engine was started but there was no specified database file. The engine is stopped.

  No indicator variable provided for NULL result

Item	Value
SQLCode	-181
Constant	SQLE_NO_INDICATOR
SQLState	22002
ODBC State	S1000

Probable cause 

You tried to retrieve a value from the database that was the NULL value but you did not provide an indicator variable for that value.

  No primary key value for foreign key '%1' in table '%2'

Item	Value
SQLCode	-194
Constant	SQLE_INVALID_FOREIGN_KEY
SQLState	23503
ODBC State	23000
Parameter 1	Name of the foreign key.
Parameter 2	Name of the table with the foreign key.

Probable cause 

You have tried to insert or update a row that has a foreign key for another table, and the value for the foreign key is not NULL and there is not a corresponding value in the primary key

  Not allowed while %1 is using the database

Item	Value
SQLCode	-211
Constant	SQLE_MUST_BE_ONLY_CONNECTION
SQLState	42W19
ODBC State	40001

Probable cause 

You have attempted a data definition language operation that cannot be completed while another user is connected.

  Not connected to SQL database

Item	Value
SQLCode	-101
Constant	SQLE_NOT_CONNECTED
SQLState	08003
ODBC State	08003

Probable cause 

You have not connected to the database, or you have executed the DISCONNECT command and have not connected to the database again.

  Not enough fields allocated in SQLDA

Item	Value
SQLCode	-182
Constant	SQLE_SQLDA_TOO_SMALL
SQLState	07002
ODBC State	07002

Probable cause 

There are not enough fields in the SQLDA to retrieve all of the values requested.

  Not enough memory is allocated to the Java virtual machine for remote access.

Item	Value
SQLCode	-679
Constant	SQLE_OMNI_MEMORY_CONFIG
SQLState	WO009
ODBC State	S1000

Probable cause 

The Java heap size and Java name space configuration values in sysoptions must be increased to allow the loading of the Java classes used for remote access.

  Not enough memory to start

Item	Value
SQLCode	-86
Constant	SQLE_NO_MEMORY
SQLState	08W13
ODBC State	HY001

Probable cause 

The database engine or multi-user client executable was loaded but was unable to start because there is not enough memory to run properly.

  Not enough values for host variables

Item	Value
SQLCode	-188
Constant	SQLE_NOT_ENOUGH_HOST_VARS
SQLState	07001
ODBC State	07002

Probable cause 

You have not provided enough host variables for either the number of bind variables, or the command, or the number of select list items.

  Null attribute mismatch for column '%1'.

Item	Value
SQLCode	-724
Constant	SQLE_OMNI_NULL_MISMATCH
SQLState	WO018
ODBC State	(handled by ODBC driver)
Parameter 1	The name of the column.

Probable cause 

The null attribute of the column specified in the 'CREATE EXISTING' command differs from the null attribute of the actual column.

  Null value eliminated in aggregate function

Item	Value
SQLCode	109
Constant	SQLE_NULL_VALUE_ELIMINATED
SQLState	01003
ODBC State	(handled by ODBC driver)

Probable cause 

Value of the expression argument of the aggregate function evaluated to NULL for one or more rows.

  Number in ORDER BY is too large

Item	Value
SQLCode	-152
Constant	SQLE_INVALID_ORDER
SQLState	53005
ODBC State	42000

Probable cause 

You have used an integer in an ORDER BY list and the integer is larger than the number of columns in the select list.

  Number of columns allowing NULLs exceeds limit.

Item	Value
SQLCode	-733
Constant	SQLE_TOO_MANY_NULL_COLUMNS
SQLState	23504
ODBC State	23000

Probable cause 

You have attempted to create or modify a table definition such that the number of columns that allow nulls is now more than the limit on such columns. The limit is a function of database page size and is approximately 8*(page_size - 30).

  Number of columns defined for the view does not match SELECT statement

Item	Value
SQLCode	-114
Constant	SQLE_VIEW_DEFINITION_ERROR
SQLState	53011
ODBC State	21S02

Probable cause 

The column list specified as part of the CREATE VIEW statement does not correspond to the list of items in the view's SELECT statement.

  Only PUBLIC settings are allowed for option '%1'

Item	Value
SQLCode	-202
Constant	SQLE_NOT_PUBLIC_ID
SQLState	42W43
ODBC State	42000
Parameter 1	Name of the option.

Probable cause 

The option specified in the SET OPTION command is PUBLIC only. You cannot define this option for any other user.

  Only the DBA can set the option %1

Item	Value
SQLCode	-204
Constant	SQLE_OPTION_REQUIRES_DBA
SQLState	42W46
ODBC State	42000

Probable cause 

The option specified in the SET OPTION command can only be set by a user having DBA authority.

  Operation would cause a group cycle

Item	Value
SQLCode	-122
Constant	SQLE_GROUP_CYCLE
SQLState	42W02
ODBC State	42000

Probable cause 

You have tried to add a member to group that would result in a member belonging to itself (perhaps indirectly).

  Parameter '%1' not found in procedure '%2'

Item	Value
SQLCode	-615
Constant	SQLE_INVALID_PARAMETER_NAME
SQLState	42W47
ODBC State	42000

Probable cause 

The procedure parameter name does not match a parameter for this procedure. Check the spelling of the parameter name.

  Parameter name missing in call to procedure '%1'

Item	Value
SQLCode	-639
Constant	SQLE_PARAMETER_NAME_MISSING
SQLState	42W42
ODBC State	42000
Parameter 1	The name of the procedure

Probable cause 

Positional arguments were specified after keyword arguments in a call to this procedure.

  Parameter not registered as output parameter

Item	Value
SQLCode	-671
Constant	SQLE_PARAM_NOT_REGISTERED
SQLState	WJ002
ODBC State	S1000

Probable cause 

The parameter must be registered as an output parameter before the value of the parameter can be obtained.

  Parse error: %1 near '%2'.

Item	Value
SQLCode	-95
Constant	SQLE_INVALID_PARSE_PARAMETER
SQLState	08W49
ODBC State	08004

Probable cause 

An error occurred while parsing a connection string.

  Passthrough statement inconsistent with current passthrough

Item	Value
SQLCode	-287
Constant	SQLE_PASSTHROUGH_INCONSISTENT
SQLState	5RW08
ODBC State	42S02

Probable cause 

Passthrough is additive, in that subsequent passthrough statements add to the list of users receiving passthrough. The passthrough statements must all be PASSTHROUGH ONLY or none should be PASSTHROUGH ONLY.

  Primary key column '%1' already defined

Item	Value
SQLCode	-119
Constant	SQLE_PRIMARY_KEY_COLUMN_DEFINED
SQLState	52009
ODBC State	42000
Parameter 1	Name of the column that is already in the primary key.

Probable cause 

You have listed the same column name twice in the definition of a primary key.

  Primary key for row in table '%1' is referenced in another table

Item	Value
SQLCode	-198
Constant	SQLE_PRIMARY_KEY_VALUE_REF
SQLState	23W05
ODBC State	23000
Parameter 1	The name of the table containing the row being modified.

Probable cause 

You have attempted to delete or modify a row whose primary key value is referenced elsewhere in the database.

  Primary key for table '%1' is not unique

Item	Value
SQLCode	-193
Constant	SQLE_PRIMARY_KEY_NOT_UNIQUE
SQLState	23W01
ODBC State	23000
Parameter 1	Name of the table where the problem was detected.

Probable cause 

You have tried to add a new row to a table where the new row has the same primary key as an existing row. The database has not added the incorrect row to the database. For example, you might have added a student with student number 86004 and there is already a row for a student with that number.

  Procedure '%1' not found

Item	Value
SQLCode	-265
Constant	SQLE_PROCEDURE_NOT_FOUND
SQLState	52W09
ODBC State	42S02
Parameter 1	Name of the procedure that could not be found.

Probable cause 

You have misspelled the name of a procedure, or you have connected with a different userid and forgotten to qualify a procedure name with a user name.

  Procedure '%1' terminated with unhandled exception '%2'

Item	Value
SQLCode	-91
Constant	SQLE_UNHANDLED_JAVA_EXCEPTION
SQLState	WP001
ODBC State	S1000
Parameter 1	The name of the procedure which returned the unhandled exception.
Parameter 2	The fully qualified Java class name of the unhandled exception.

Probable cause 

A Java procedure terminated with an active exception, and this exception is reflected in SQL as an error status.

  Procedure has completed

Item	Value
SQLCode	105
Constant	SQLE_PROCEDURE_COMPLETE
SQLState	01W05
ODBC State	(handled by ODBC driver)

Probable cause 

An OPEN or a RESUME has caused a procedure to execute to completion. There are no more result sets available from this procedure. This warning will also be returned if you attempt to RESUME a cursor on a SELECT statement.

  Procedure in use

Item	Value
SQLCode	-215
Constant	SQLE_PROCEDURE_IN_USE
SQLState	42W23
ODBC State	40001

Probable cause 

You have attempted to DROP a procedure that is being used by other active users of the database.

  Procedure or trigger calls have nested too deeply

Item	Value
SQLCode	-274
Constant	SQLE_NESTING_TOO_DEEP
SQLState	42W29
ODBC State	S1000

Probable cause 

You have probably defined a procedure or trigger that causes unlimited recursion.

  Publication '%1' not found

Item	Value
SQLCode	-280
Constant	SQLE_PUBLICATION_NOT_FOUND
SQLState	5RW01
ODBC State	42S02
Parameter 1	Name of the publication that could not be found.

Probable cause 

You have misspelled the name of a publication, or you have connected with a different userid and forgotten to qualify a publication name with a user name.

  RAISERROR executed: %1