Database Error Messages

About this chapter

This chapter lists all database error messages reported by Adaptive Server Anywhere. Many of the errors contain the characters %1, %2 and so on. These are replaced by the parameters to the error message.

Each error has a numeric error code, called the SQLCODE. Negative codes are considered errors; positive codes are warnings. The SQLCODE 0 indicates successful completion.

The full listing of the error messages is ordered by SQLCODE value. To find an error message description if you do not have the SQLCODE value, look up the SQLCODE in the alphabetic or SQLSTATE listing.

Error messages indexed by Adaptive Server Anywhere SQLCODE

Error messages indexed by SQLSTATE

Error messages indexed by Sybase error code

Alphabetic list of error messages

(no message)

(no message)

(no message)

(no message)

%1

%1

'%1' is an unknown option

'%1' is not a known file format for loading or unloading tables

'%1' is not a public java class, and cannot be referenced from SQL

'%1' is not a public java reference, and cannot be referenced from SQL

'%1' is not a valid class file

'%1' is not a write file for '%2'

A consolidated user already exists

A dbspace has reached its maximum file size

A thread used internally could not be started

Aggregate functions not allowed on this statement

All threads are blocked

ALTER clause conflict

An attempt to delete database '%1' failed

An internal error occurred in a '%1'

An internal error occurred in a '%1'

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

Attempted two active database requests

Authentication failed

Authentication violation

Backup file format is invalid

Backwards scrolling cursors are not supported for remote objects

Beyond end-of-file

Calling functions outside the database server is not supported

Can only describe a SELECT statement

Cannot access file '%1': %2

Cannot access instance member through a class

Cannot allocate System V resources

Cannot alter a column in an index

Cannot call the '%1' on a JDBC resultset when it is positioned on an inert row

Cannot change column '%1' until index '%2' is dropped

Cannot convert %1 to a %2

Cannot create an index on Java class '%1'

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

Cannot delete a column referenced in a trigger definition

Cannot deserialize Java object

Cannot drop a user that owns messages or data types

Cannot drop a user that owns objects involved in replication

Cannot drop a user that owns procedures in runtime server

Cannot drop a user that owns tables in runtime system

Cannot find index named '%1'

Cannot initialize IQ memory manager: %1

Cannot insert or update computed column '%1'

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

Cannot map a login ID to the sys or public user ID

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

Cannot open transaction log file %1

Cannot remove class '%1': member of Jar

Cannot serialize Java object with class %1

Cannot set a temporary option for user '%1'

Cannot uniquely identify column '%2' of table '%1' in the current jdbc resultset

Cannot uniquely identify rows in cursor

Cannot update an expression

Cannot update member fields qualified with "final" modifier

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

Cannot use dbstop to stop network database server

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

CHECKPOINT statement requires a rollback log

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

Client/database server version mismatch

Client/server communications protocol version mismatch

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

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

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

Column '%1' not found

COMMIT/ROLLBACK not allowed within atomic operation

COMMIT/ROLLBACK not allowed within trigger actions

Communication error

Computed columns are not supported in this database

Connection not found

Connection was terminated

Connections to database have been disabled

Contents of backup files are inconsistent

Correlation name '%1' not found

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

Could not allocate resources to call external function

Could not change an opened prepared statement or callable statement

Could not decompress class '%1' from Jar.

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

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

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

Could not load dynamic library '%1'

Could not load the backup/restore DLL %1

Could not load the store DLL %1

Creating remote tables with computed columns is not supported

Cursor already open

Cursor has not been declared

Cursor is restricted to FETCH NEXT operations

Cursor not open

Cursor operation conflict

Data definition statements not allowed in procedures or triggers

Database %1 needs recovery

Database backup not started

Database creation failed

Database is active

Database name not unique

Database name required to start server

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

Database page size too big

Database server already running

Database server connection limit exceeded

Database server not running

Database server not running in multi-user mode

Database upgrade failed

Database upgrade not possible

Database was initialized with an older version of the software

db_init has not been called or the call to db_init failed

Dbspace '%1' not found

Deadlock detected

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

Disallowed language extension detected in syntax near '%1'

Disk full '%1' -- transaction rolled back

Division by zero

Duplicate insert column

Duplicate referencing column

Dynamic memory exhausted

Error during backup: %1

Error in assignment

Error number %1 for RAISERROR is less than 17000

Error opening cursor

Error parsing connection parameter string

Error writing to transaction log file

Expression has unsupported data type

External login for server %1 could not be found

Feature '%1' not implemented

Feature not available with UltraLite

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

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

Foreign key name '%1' not found

Format string argument number %1 is invalid

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

GRANT of column permission on view not allowed

I/O error %1 -- transaction rolled back

Identifier '%1' too long

Identity attribute mismatch for column '%1'

Illegal cursor operation attempt

Illegal user selectivity estimate specified

Incomplete transactions prevent transaction log renaming

Incorrect store DLL (%1) version.

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

Index name '%1' is ambiguous

Index name '%1' not unique

Index type specification of '%1' is invalid

Input parameter index out of range

INSERT/DELETE on cursor can modify only one table

Integrated login failed

Integrated logins are not permitted

Integrated logins are not supported for this database

Internal database error %1 -- transaction rolled back

Invalid absolute or relative offset in FETCH

Invalid class byte code

Invalid column number

Invalid comparison

Invalid data conversion

Invalid data type for column in WRITETEXT or READTEXT

Invalid database page size

Invalid database server command line

Invalid descriptor index

Invalid escape character '%1'

Invalid escape sequence '%1'

Invalid expression in WHERE clause of Transact-SQL outer join

Invalid expression near '%1'

Invalid host variable

Invalid IQ database command line option or paramater value: %1

Invalid jar file

Invalid JDBC resultset concurrency

Invalid JDBC resultset type

Invalid join type used with Transact-SQL outer join

Invalid local database switch

Invalid operation on a closed '%1'

Invalid operation on a closed '%1'

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

Invalid parameter

Invalid prepared statement type

Invalid REFERENCES clause in trigger definition

Invalid setting for option '%1'

Invalid SQL descriptor name

Invalid SQL identifier

Invalid statement

Invalid TEXTPTR value used with WRITETEXT or READTEXT

Invalid type for field reference

Invalid type on DESCRIBE statement

Invalid user ID or password

Invalid user ID or password

Invalid user ID or password on preprocessed module

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

Item '%1' already exists

Java virtual machine could not be started

Java VM Heap Exhausted at Internal fn: %1

JDBC feature '%1' not supported

JDBC SAStatement batch execute abandoned

Label '%1' not found

Language extension

Language extension detected in syntax

Log file corrupted

Memory error -- transaction rolled back

Method '%1' cannot be called at this time

Mismatch between external function platform specifier and current operating system

Modifications not permitted for read-only database

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

More information required

More than one table is identified as '%1'

Namespace Heap Exhausted at Internal fn: %1

Need a dynamic library name

No current row of cursor

No database file specified

No indicator variable provided for NULL result

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

Not allowed while %1 is using the database

Not connected to a database

Not enough fields allocated in SQLDA

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

Not enough memory to start

Not enough values for host variables

Null attribute mismatch for column '%1'

Null value eliminated in aggregate function

Number in ORDER BY is too large

Number of columns allowing NULLs exceeds limit

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

Only PUBLIC settings are allowed for option '%1'

Only the DBA can set the option %1

Operation would cause a group cycle

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

Parameter name missing in call to procedure '%1'

Parameter not registered as output parameter

Parse error: %1 '%2'

Parse error: %1 near '%2'

Passthrough statement inconsistent with current passthrough

Password must be at least %1 characters

Phantom lock error

Primary key '%1' is used as a foreign key

Primary key column '%1' already defined

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

Primary key for table '%1' is not unique

Procedure '%1' not found

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

Procedure has completed

Procedure in use

Procedure or trigger calls have nested too deeply

Publication '%1' not found

RAISERROR executed: %1

READTEXT or WRITETEXT statement cannot refer to a view

Remote message type '%1' not found

Remote objects %1 does not exist

Remote server %1 could not be found; Add the server using CREATE SERVER

Remote server %1 is currently configured as read only

Remote server does not have the ability to support this statement

Remote statement failed

Request denied -- no active databases

Request to start/stop database denied

Resource governor for %1 exceeded

RESTORE unable to open file '%1'

RESTORE unable to start database '%1'

RESTORE unable to write to file '%1'

Result set not allowed from within an atomic compound statement

Return type of void from procedure '%1' cannot be used in any expression

Return value cannot be set

Right truncation of string data

Rollback occurred due to deadlock during prefetch

ROLLBACK TO SAVEPOINT not allowed

Row has been updated since last time read

Row has changed since last read -- operation cancelled

Row not found

Run time SQL error -- %1

Savepoint '%1' not found

Savepoints require a rollback log

Seek absolute 0 was attempted on a JDBC SAResultSet

SELECT lists in UNION do not match in length

SELECT returns more than one row

Server %1: %2

Server capability name %1 could not be found in the SYSCAPABILITYNAME table.

Server not found and unable to autostart

Server or database cannot be started -- %1

Signature '%1' does not match procedure parameters

Specified database is invalid

Specified database not found

SQL statement error

SQLDA data type invalid

SQLDA fields inconsistent for a multi-row SQLDA

Sqlpp/dblib version mismatch

Standard logons are not permitted

Statement cannot be executed

Statement interrupted by user

Statement is not allowed in passthrough mode

statement's size limit is invalid.

Subquery allowed only one select list item

Subquery cannot return more than one row

Subscription to '%1' for '%2' already exists

Subscription to '%1' for '%2' not found

Syntax error near '%1'

Syntax error, cannot specify IQ specific options without specifying IQ PATH

Table '%1' has a foreign key with a referential action

Table '%1' has no primary key

Table '%1' has publications

Table '%1' is in an outer join cycle

Table '%1' not found

Table '%1' requires a unique correlation name

Table already has a primary key

Table cannot have two primary keys

Table in use

Table must be empty

Terminated by user -- transaction rolled back

The column '%1' does not exist in the remote table

The connection parameters file could not be found

The cursor name '%1' already exists

The data type of column '%1' is not supported

The data type specified for column '%1' is not compatible with the actual data type

The database does not support the Java virtual machine

The integrated login ID guest can only be mapped to the guest database user ID

The JDBC resultset must be positioned on a insert row in order to use the '%1' function

The length specified for column '%1' is different than the actual length

The login ID '%1' has not been mapped to any database user ID

The login ID '%1' is already mapped to user ID '%2'

The optimizer was unable to construct a valid access plan

The option %1 can only be set as a temporary option

The option %1 cannot be set from within a procedure

The pattern is too long

The remote server does not support an auto-incrementing data type

The remote table '%1' could not be found

The selected database is currently inactive

The server attempted to access a page beyond the end of the maximum allowable dbspace file size

The specified foreign key (%1) can not be enforced

The specified transaction isolation is invalid

The streams environment could not be created

The table specification '%1' identifies more than one remote table

There are still active database connections

There is already a variable named '%1'

There is more than one way to join '%1' to '%2'

There is no way to join '%1' to '%2'

Too many columns in table

Too many parameters to this external procedure call

Transact-SQL feature not supported

Transaction log backup page only partially full

Transaction log was truncated

Trigger '%1' not found

Trigger definition conflicts with existing triggers

Triggers and procedures not supported in runtime server

TRUNCATE TABLE statement cannot refer to a view

Unable to connect to server '%1': %2

Unable to delete database file

Unable to find in index '%1' for table '%2'

Unable to start database server

Unable to start specified database

Unknown backup operation

Unknown function '%1'

UNLOAD TABLE cannot be used to unload a view

Unsupported character set '%1'

Unsupported character set '%1' and unsupported language; language used is '%2' instead

Unsupported language; language used is '%1' instead

Unterminated C string

Update operation attempted on a read-only cursor

Update operation attempted on non-updateable query

Update operation attempted on non-updateable remote query

User '%1' already has GRANT permission

User '%1' already has membership in group '%2'

User '%1' has the row in '%2' locked

User '%1' is already the publisher for this database

User '%1' is not a remote user for this database

User '%1' is not a user group

User ID '%1' does not exist

User message %1 already exists

User message %1 not found

User owns procedures in use

User owns tables in use

User-defined exception signaled

User-defined type %1 not found

Using temporary table

VALIDATE TABLE statement must refer to a base table

Value %1 out of range for destination

Value for column '%1' in table '%2' has changed

Value truncated

Variable '%1' not found

Warning

WITH CHECK OPTION violated for insert/update on base table '%1'

Wrong number of parameters to function '%1'

Wrong number of values for INSERT

Wrong number of variables in FETCH

You cannot synchronize with uncommitted transactions

Internal errors (assertion failed)

Error messages indexed by Adaptive Server Anywhere SQLCODE


	Expand Search