Reference Manual
   CHAPTER 10. Database Error Messages     

Error messages index by SQLSTATE

Adaptive Server Anywhere supports the SQLSTATE error code defined by SQL/92. Each SQLSTATE value is a 5- character string containing a 2-character class followed by a 3-character subclass. Each character can be one of the uppercase letters A through Z or the digits 0 through 9. A class that begins with A through H or 0 through 4 has been defined by the ANSI standard; other classes are implementation defined. Similarly, subclasses of standard classes that start with the same characters (A-H, 0-4) are standard. The subclass 000 always means that no subclass code is defined. The most common SQLSTATE value is 00000, which indicates successful completion.

SQLSTATE	Message
00000	(no message)
01000	Warning
01001	Cursor operation conflict
01003	Null value eliminated in aggregate function
01004	Value truncated
01W02	Using temporary table
01W03	Invalid data conversion
01W04	Row has been updated since last time read
01W05	Procedure has completed
01W06	Value for column '%1' in table '%2' has changed
01W07	Language extension detected in syntax
01W08	Statement cannot be executed
01W09	More info required
01W10	Transaction log backup page only partially full
01W11	Database option '%1' for user '%2' has an invalid setting
01W12	Character set translation to '%1' cannot be performed; '%2' is used instead
01W13	Unsupported character set '%1'
01W14	Unsupported language; language used is '%1' instead
01W15	Unsupported character set '%1' and unsupported language; language used is '%2' instead
01W16	Illegal user selectivity estimate specified.
02000	Row not found
02W01	No data
07001	Not enough values for host variables
07002	Not enough fields allocated in SQLDA
07003	Error opening cursor
07005	Can only describe a SELECT statement
07009	Invalid descriptor index
07W01	Invalid type on DESCRIBE statement
07W02	Invalid statement
07W03	Invalid prepared statement type
07W04	SQLDA fields inconsistent for a multi-row SQLDA
08001	Cannot be started -- %1
08003	Not connected to SQL database
08004	Userid '%1' does not exist
08W01	Database engine not running
08W02	Connection not found
08W03	Too many connections to database
08W04	Connections to database have been disabled
08W05	Cannot open log file %1
08W06	There are still active database connections
08W07	Unable to start database engine
08W08	Invalid database engine command line
08W09	Unable to start specified database
08W10	Specified database not found
08W11	Specified database is invalid
08W12	Communication error
08W13	Not enough memory to start
08W14	Database name required to start engine
08W15	Application/engine communications protocol version mismatch
08W16	Database engine not running in multi-user mode
08W17	Error writing to log file
08W18	Sqlpp/dblib version mismatch
08W19	Dblib/database engine version mismatch
08W20	Server/database engine version mismatch
08W21	Authentication violation
08W22	Database's page size too big
08W23	Database engine already running
08W24	Invalid parameter.
08W25	Invalid local database switch
08W26	Dynamic memory exhausted!
08W27	Database name not unique
08W28	Request denied -- no active databases
08W29	Request to start/stop database denied
08W30	The selected database is currently inactive
08W31	Communication buffer underflow
08W32	Invalid database page size
08W33	Database creation failed
08W34	Could not load the store DLL %1
08W35	Could not execute store DLL (%1) entry point.
08W36	Cannot create item (%1) in the specified dbspace.
08W37	The connection parameters file could not be found.
08W38	Error parsing connection parameter string.
08W39	No database file specified
08W40	Database is active
08W41	Database %1 needs recovery
08W42	Database upgrade failed
08W43	Database upgrade not possible
08W44	Could not load the backup/restore DLL %1
08W45	Could not execute backup/restore DLL (%1) entry point.
08W46	Error during backup: %1
08W47	Incorrect store DLL (%1) version.
08W48	Authentication failed
08W49	Parse error: %1 near '%2'.
09W02	Illegal cursor operation attempt
09W04	INSERT/DELETE on cursor can modify only one table
09W05	Cannot uniquely identify rows in cursor
09W06	Cursor is restricted to FETCH NEXT operations
09W07	Statement's size limit is invalid.
09W08	Cannot update or delete an all-NULL row from table '%1'.
0A000	Feature '%1' not implemented
0AW01	Language extension
0AW02	Transact-SQL feature not supported
0AW03	Disallowed language extension detected in syntax near '%1'
0AW04	Triggers and procedures not supported in runtime engine
0AW05	Statement is not allowed in passthrough mode
0AW06	Computed columns are not supported in this database
21000	SELECT returns more than one row
21W01	Subquery cannot return more than one result
22001	Right truncation of string data
22002	No indicator variable provided for NULL result
22003	Value %1 out of range for destination
22005	Error in assignment
22012	Division by zero
22019	Invalid escape character '%1'
22024	Unterminated C string
22025	Invalid escape sequence '%1'
22W02	Row has changed since last read -- operation cancelled
22W03	Invalid TEXTPTR value used with WRITETEXT or READTEXT
23502	Column '%1' in table '%2' cannot be NULL
23503	No primary key value for foreign key '%1' in table '%2'
23504	Number of columns allowing NULLs exceeds limit.
23505	Index '%1' for table '%2' would not be unique
23506	Invalid value for column '%1' in table '%2'
23507	The specified foreign key (%1) can not be enforced.
23W01	Primary key for table '%1' is not unique
23W05	Primary key for row in table '%1' is referenced in another table
24501	Cursor not open
24502	Cursor already open
24503	No current row of cursor
24W01	Cursor has not been declared
26501	SQL statement error
28000	Invalid userid or password
28W01	Invalid userid and password on preprocessed module
28W02	Integrated logons are not permitted
28W03	Standard logons are not permitted
28W04	Integrated logon failed
28W05	Integrated logons are not supported for this database
28W06	The integrated loginid guest can only be mapped to the guest database userid
28W07	Cannot map a loginid to the sys or public userid
28W08	The loginid '%1' is already mapped to userid '%2'
28W09	The loginid '%1' has not been mapped to any database userid
2D501	COMMIT/ROLLBACK not allowed within trigger actions
33000	Invalid SQL descriptor name
37505	Wrong number of parameters to function '%1'
3B001	Savepoint '%1' not found
3B002	ROLLBACK TO SAVEPOINT not allowed
3BW01	Savepoints require a rollback log
3BW02	Result set not allowed from within an atomic compound statement
40000	Run time SQL error -- %1
40001	Deadlock detected
40W01	Internal database error %1 -- transaction rolled back
40W02	Terminated by user -- transaction rolled back
40W03	Disk full '%1' -- transaction rolled back
40W04	I/O error %1 -- transaction rolled back
40W06	All threads are blocked
40W07	Connection was terminated
40W08	Memory error -- transaction rolled back
42501	Do not have permission to %1
42W01	User '%1' already has grant permission
42W02	Operation would cause a group cycle
42W03	User '%1' is not a user group
42W04	Syntax error near '%1'
42W05	Unknown function '%1'
42W06	Aggregate functions not allowed on this statement
42W07	Invalid host variable
42W08	Invalid expression near '%1'
42W13	Invalid column number
42W14	Variable '%1' not found
42W15	There is already a variable named '%1'
42W16	Invalid option '%1' -- no PUBLIC setting exists
42W17	Invalid setting for option '%1'
42W18	User '%1' has the row in '%2' locked
42W19	Not allowed while %1 is using the database
42W20	CHECKPOINT command requires a rollback log
42W21	Table in use
42W22	Attempted two active database requests
42W23	Procedure in use
42W24	Label '%1' not found
42W25	Invalid absolute or relative offset in FETCH
42W26	Wrong number of variables in FETCH
42W27	Database was initialized with an older version of the software
42W28	COMMIT/ROLLBACK not allowed within atomic operation
42W29	Procedure or trigger calls have nested too deeply
42W30	Update operation attempted on a read-only cursor
42W31	Update operation attempted on non-updatable query
42W32	Cannot modify column '%1' in table '%2'
42W33	Table '%1' not found
42W34	User '%1' already has membership in group '%2'
42W35	Update operation attempted on non-updatable remote query
42W40	Duplicate referencing column
42W41	Duplicate insert column
42W42	Parameter name missing in call to procedure '%1'
42W43	Only PUBLIC settings are allowed for option '%1'
42W44	More columns are being dropped from table %1 than are defined
42W45	Cannot set a temporary option for user '%1'
42W46	Only the DBA can set the option %1
42W47	Parameter '%1' not found in procedure '%2'
42W48	Syntax error, cannot specify IQ specific options without specifying IQ PATH
42W49	TRUNCATE TABLE statement cannot refer to a view
42W50	READTEXT or WRITETEXT statement cannot refer to a view
42W51	VALIDATE TABLE statement must refer to a base table
42W52	The option %1 can only be set as a temporary option
42W53	The option %1 cannot be set from within a procedure
42W54	Signature '%1' does not match procedure parameters
44000	WITH CHECK OPTION violated for insert/update on base table '%1'
52002	Column '%1' found in more than one table -- need a correlation name
52003	Column '%1' not found
52004	Derived table '%1' has no name for column %2
52009	Primary key column '%1' already defined
52010	Item '%1' already exists
52012	More than one table is identified as '%1'
52W02	Correlation name '%1' not found
52W03	Cannot find index named '%1'
52W04	Index name '%1' not unique
52W05	Table cannot have two primary keys
52W06	Foreign key '%1' for table '%2' duplicates an existing foreign key
52W07	Foreign key name '%1' not found
52W08	There is more than one way to join '%1' to '%2'
52W09	Procedure '%1' not found
52W10	Trigger '%1' not found
52W11	Trigger definition conflicts with existing triggers
52W12	Invalid REFERENCES clause in trigger definition
52W13	Dbspace '%1' not found
52W14	Table '%1' is in an outer join cycle
52W15	Table '%1' requires a unique correlation name
52W16	User message %1 already exists
52W17	User message %1 not found
52W18	User-defined type %1 not found
52W20	Too many columns in table
52W21	Data definition statements not allowed in procedures or triggers
52W22	GRANT of column permission on view not allowed
52W23	Invalid expression in WHERE clause of Transact-SQL outer join
52W24	Invalid join type used with Transact-SQL outer join
52W25	Invalid comparison
52W40	Index name '%1' is ambiguous
53002	Wrong number of values for INSERT
53003	Function or column reference to '%1' in the select list must also appear in a GROUP BY
53005	Number in ORDER BY is too large
53011	Number of columns defined for the view does not match SELECT statement
53018	Cannot convert %1 to a %2
53019	Return type of void from procedure '%1' cannot be used in any expression
53023	Subquery allowed only one select list item
53026	SELECT lists in UNION do not match in length
53030	Column %1 in foreign key has a different definition than primary key
53W01	ALTER clause conflict
53W02	Cannot update an expression
53W04	There is no way to join '%1' to '%2'
53W05	Cannot alter a column in an index
53W06	Cannot delete a column referenced in a trigger definition
53W07	Error number %1 for RAISERROR is less than 17000
53W08	Format string argument number %1 is invalid
53W09	Invalid datatype for column in WRITETEXT or READTEXT
54003	Identifier '%1' too long
55008	Table '%1' has no primary key
55013	Table already has a primary key
55W02	Table must be empty
55W03	Cannot drop a user that owns tables in runtime engine
55W04	Cannot drop a user that owns procedures in runtime engine
55W05	Cannot drop a user that owns messages or datatypes
55W06	Cannot drop a user that owns objects involved in replication
56001	Table '%1' has a foreign key with a referential action
57014	Statement interrupted by user
5RW01	Publication '%1' not found
5RW02	Table '%1' has publications
5RW03	Subscription to '%1' for '%2' already exists
5RW04	Subscription to '%1' for '%2' not found
5RW05	User '%1' is already the publisher for this database
5RW06	User '%1' is not a remote user for this database
5RW07	Remote message type '%1' not found
5RW08	Passthrough statement inconsistent with current passthrough
5RW09	Remote statement failed
99999	User-defined exception signalled
WB001	Unknown backup operation
WB002	Database backup not started
WB003	Incomplete transactions prevent transaction log renaming
WB004	Unable to delete database file
WB005	Transaction log was truncated
WB006	Contents of backup files are inconsistent
WB007	Backup file format is invalid
WB008	RESTORE unable to open file '%1'
WB009	RESTORE unable to write to file '%1'
WB010	RESTORE unable to start database '%1'
WI005	Unable to find in index '%1' for table '%2'
WI009	Cannot serialize Java object with class %1
WI010	The optimizer was unable to construct a valid access plan.
WJ001	Method '%1' cannot be called at this time
WJ002	Parameter not registered as output parameter
WJ003	The specified transaction isolation is invalid
WJ004	The cursor name '%1' already exists
WJ005	Input parameter index out of range
WJ006	Return value cannot be set
WJ007	JDBC feature '%1' not supported
WJ008	Could not change an opened prepared statement or callable statement
WJ009	An internal error occurred in a '%1'
WJ010	Invalid operation on a closed '%1'
WJ011	Cannot access instance member through a class
WJ012	Cannot update final member fields
WJ013	An internal error occurred in a '%1'
WJ014	Invalid operation on a closed '%1'
WO001	Unable to connect to server '%1': %2
WO002	Remote objects %1 does not exist.
WO003	Remote server %1 is currently configured as read only.
WO004	Remote server %1 could not be found. Add the server using CREATE SERVER.
WO005	Server %1: %2
WO006	Backwards scrolling cursors are not supported for remote objects.
WO007	The remote table '%1' could not be found.
WO008	Could not access column information for the table '%1'.
WO009	Not enough memory is allocated to the Java virtual machine for remote access.
WO010	%1
WO011	The remote server does not support an auto-incrementing datatype.
WO012	Remote server does not have the ability to support this command.
WO013	External login for server %1 could not be found.
WO015	The datatype specified for column '%1' is not compatible with the actual datatype.
WO016	The column '%1' does not exist in the remote table.
WO017	The length specified for column '%1' is different than the actual length.
WO018	Null attribute mismatch for column '%1'.
WO019	Identity attribute mismatch for column '%1'.
WO020	The table specification '%1' identifies more than one remote table.
WO021	Creating remote tables with computed columns is not supported.
WO022	The datatype of column '%1' is not supported.
WP000	Argument %1 of procedure '%2' cannot be null
WP001	Procedure '%1' terminated with unhandled exception '%2'
WP002	'%1' is not a valid class file
WP003	Could not decompress class '%1' from Jar.
WP004	Cannot remove class '%1': member of Jar
WP005	Invalid class byte code
WP006	Java virtual machine could not be started
WP007	Namespace Heap Exhausted at Internal fn: %1
WP008	Java VM Heap Exhausted at Internal fn: %1
WP010	Invalid jar file
WW003	Calling functions outside the database engine is not supported
WW004	Mismatch between external function platform specifier and current operating system
WW005	Need a dynamic library name
WW006	Could not load dynamic library '%1'
WW007	Could not find '%1' in dynamic library '%2'
WW008	Could not allocate resources to call external function
WW009	Expression has unsupported datatype
WW010	Too many parameters to this external procedure call
WW011	A thread used internally could not be started
WW012	RAISERROR executed: %1
WW013	Class '%1' has no public field '%2'
WW014	Invalid type for field reference
WW015	Field '%1' of class '%2' cannot be null
WW016	Index type specification of '%1' is invalid.
WW017	An attempt to delete database '%1' failed.
WW018	Cannot deserialize Java object
WW019	Rollback occurred due to deadlock during prefetch
WW020	Cannot make a static reference to nonstatic variable '%1' in class '%2'
WW022	Cannot create an index on Java class '%1'
WW023	Cannot insert or update computed column '%1'