Collection Contents Index CHAPTER 10.  Database Error Messages Error messages index by SQLSTATE pdf/chap10.pdf

Reference Manual
   CHAPTER 10. Database Error Messages     

Error message index by SQLCODE


SQLCODE

Message

-737

Signature '%1' does not match procedure parameters

-736

The datatype of column '%1' is not supported.

-735

Invalid parameter.

-734

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

-733

Number of columns allowing NULLs exceeds limit.

-732

Creating remote tables with computed columns is not supported.

-731

Cannot drop a user that owns objects involved in replication

-730

Invalid jar file

-729

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

-728

Update operation attempted on non-updatable remote query

-727

The optimizer was unable to construct a valid access plan.

-726

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

-725

Identity attribute mismatch for column '%1'.

-724

Null attribute mismatch for column '%1'.

-723

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

-722

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

-721

The datatype specified for column '%1' is not compatible with the actual datatype.

-720

VALIDATE TABLE statement must refer to a base table

-719

RESTORE unable to start database '%1'

-718

RESTORE unable to write to file '%1'

-717

RESTORE unable to open file '%1'

-716

Backup file format is invalid

-715

Contents of backup files are inconsistent

-714

Invalid operation on a closed '%1'

-713

An internal error occurred in a '%1'

-712

External login for server %1 could not be found.

-711

Incorrect store DLL (%1) version.

-710

Invalid comparison

-709

Computed columns are not supported in this database

-708

READTEXT or WRITETEXT statement cannot refer to a view

-707

Statement is not allowed in passthrough mode

-706

Remote server does not have the ability to support this command.

-705

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

-704

Cannot create an index on Java class '%1'

-703

Cannot insert or update computed column '%1'

-702

TRUNCATE TABLE statement cannot refer to a view

-701

Cannot access instance member through a class

-700

SQLDA fields inconsistent for a multi-row SQLDA

-699

Cannot update final member fields

-698

The remote server does not support an auto-incrementing datatype.

-697

Error during backup: %1

-696

Invalid operation on a closed '%1'

-695

An internal error occurred in a '%1'

-694

Could not change an opened prepared statement or callable statement

-693

JDBC feature '%1' not supported

-692

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

-691

Could not load the backup/restore DLL %1

-690

Return value cannot be set

-689

Input parameter index out of range

-687

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

-686

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

-684

Rollback occurred due to deadlock during prefetch

-683

The cursor name '%1' already exists

-682

%1

-681

Invalid join type used with Transact-SQL outer join

-680

Invalid expression in WHERE clause of Transact-SQL outer join

-679

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

-678

Index name '%1' is ambiguous

-677

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

-676

The specified transaction isolation is invalid

-675

Java virtual machine could not be started

-674

Statement's size limit is invalid.

-673

Database upgrade not possible

-672

Database upgrade failed

-671

Parameter not registered as output parameter

-670

Invalid class byte code

-669

Method '%1' cannot be called at this time

-668

Cursor is restricted to FETCH NEXT operations

-667

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

-666

The remote table '%1' could not be found.

-665

Database %1 needs recovery

-664

Database is active

-663

Cannot deserialize Java object

-662

Cannot serialize Java object with class %1

-661

Backwards scrolling cursors are not supported for remote objects.

-660

Server %1: %2

-659

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

-658

Remote server %1 is currently configured as read only.

-657

Remote objects %1 does not exist.

-656

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

-655

Error parsing connection parameter string.

-654

The connection parameters file could not be found.

-653

Cannot remove class '%1': member of Jar

-652

Could not decompress class '%1' from Jar.

-651

An attempt to delete database '%1' failed.

-650

Index type specification of '%1' is invalid.

-649

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

-648

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

-647

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

-646

Could not load the store DLL %1

-645

Database creation failed

-644

Invalid database page size

-642

Invalid SQL descriptor name

-641

Error in assignment

-640

Invalid descriptor index

-639

Parameter name missing in call to procedure '%1'

-638

Right truncation of string data

-637

Duplicate insert column

-636

Duplicate referencing column

-635

GRANT of column permission on view not allowed

-634

Unterminated C string

-633

Update operation attempted on a read-only cursor

-632

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

-631

RAISERROR executed: %1

-630

Invalid escape sequence '%1'

-629

Invalid escape character '%1'

-628

Division by zero

-627

Disallowed language extension detected in syntax near '%1'

-626

A thread used internally could not be started

-625

Too many parameters to this external procedure call

-624

Expression has unsupported datatype

-623

Data definition statements not allowed in procedures or triggers

-622

Could not allocate resources to call external function

-621

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

-620

Could not load dynamic library '%1'

-619

Need a dynamic library name

-618

Mismatch between external function platform specifier and current operating system

-617

Calling functions outside the database engine is not supported

-616

Too many columns in table

-615

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

-614

Cannot drop a user that owns messages or datatypes

-613

User-defined type %1 not found

-612

User message %1 not found

-611

Transact-SQL feature not supported

-610

User message %1 already exists

-609

Invalid datatype for column in WRITETEXT or READTEXT

-608

Invalid TEXTPTR value used with WRITETEXT or READTEXT

-313

The loginid '%1' has not been mapped to any database userid

-312

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

-309

Memory error -- transaction rolled back

-308

Connection was terminated

-307

All threads are blocked

-306

Deadlock detected

-305

I/O error %1 -- transaction rolled back

-304

Disk full '%1' -- transaction rolled back

-302

Terminated by user -- transaction rolled back

-301

Internal database error %1 -- transaction rolled back

-300

Run time SQL error -- %1

-299

Statement interrupted by user

-298

Attempted two active database requests

-297

User-defined exception signalled

-296

Error number %1 for RAISERROR is less than 17000

-295

Cannot uniquely identify rows in cursor

-294

Format string argument number %1 is invalid

-288

Remote statement failed

-287

Passthrough statement inconsistent with current passthrough

-286

Remote message type '%1' not found

-285

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

-284

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

-283

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

-282

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

-281

Table '%1' has publications

-280

Publication '%1' not found

-275

Triggers and procedures not supported in runtime engine

-274

Procedure or trigger calls have nested too deeply

-273

COMMIT/ROLLBACK not allowed within trigger actions

-272

Invalid REFERENCES clause in trigger definition

-271

Trigger definition conflicts with existing triggers

-270

Cannot drop a user that owns procedures in runtime engine

-269

Cannot delete a column referenced in a trigger definition

-268

Trigger '%1' not found

-267

COMMIT/ROLLBACK not allowed within atomic operation

-266

Database was initialized with an older version of the software

-265

Procedure '%1' not found

-264

Wrong number of variables in FETCH

-263

Invalid absolute or relative offset in FETCH

-262

Label '%1' not found

-261

There is already a variable named '%1'

-260

Variable '%1' not found

-251

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

-250

Identifier '%1' too long

-249

The loginid '%1' is already mapped to userid '%2'

-248

Cannot map a loginid to the sys or public userid

-247

The integrated loginid guest can only be mapped to the guest database userid

-246

Integrated logons are not supported for this database

-245

Integrated logon failed

-244

Transaction log was truncated

-243

Unable to delete database file

-242

Incomplete transactions prevent transaction log renaming

-241

Database backup not started

-240

Unknown backup operation

-232

Server/database engine version mismatch

-231

Dblib/database engine version mismatch

-230

Sqlpp/dblib version mismatch

-222

Result set not allowed from within an atomic compound statement

-221

ROLLBACK TO SAVEPOINT not allowed

-220

Savepoint '%1' not found

-218

Authentication failed

-217

The option %1 cannot be set from within a procedure

-216

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

-215

Procedure in use

-214

Table in use

-213

Savepoints require a rollback log

-212

CHECKPOINT command requires a rollback log

-211

Not allowed while %1 is using the database

-210

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

-209

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

-208

Row has changed since last read -- operation cancelled

-207

Wrong number of values for INSERT

-206

Standard logons are not permitted

-205

Integrated logons are not permitted

-204

Only the DBA can set the option %1

-203

Cannot set a temporary option for user '%1'

-202

Only PUBLIC settings are allowed for option '%1'

-201

Invalid setting for option '%1'

-200

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

-199

INSERT/DELETE on cursor can modify only one table

-198

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

-197

No current row of cursor

-196

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

-195

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

-194

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

-193

Primary key for table '%1' is not unique

-192

Update operation attempted on non-updatable query

-191

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

-190

Cannot update an expression

-189

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

-188

Not enough values for host variables

-187

Illegal cursor operation attempt

-186

Subquery cannot return more than one result

-185

SELECT returns more than one row

-183

Cannot find index named '%1'

-182

Not enough fields allocated in SQLDA

-181

No indicator variable provided for NULL result

-180

Cursor not open

-172

Cursor already open

-171

Error opening cursor

-170

Cursor has not been declared

-165

Java VM Heap Exhausted at Internal fn: %1

-164

Namespace Heap Exhausted at Internal fn: %1

-163

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

-161

Invalid type on DESCRIBE statement

-160

Can only describe a SELECT statement

-159

Invalid column number

-158

Value %1 out of range for destination

-157

Cannot convert %1 to a %2

-156

Invalid expression near '%1'

-155

Invalid host variable

-154

Wrong number of parameters to function '%1'

-153

SELECT lists in UNION do not match in length

-152

Number in ORDER BY is too large

-151

Subquery allowed only one select list item

-150

Aggregate functions not allowed on this statement

-149

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

-148

Unknown function '%1'

-147

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

-146

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

-145

Foreign key name '%1' not found

-144

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

-143

Column '%1' not found

-142

Correlation name '%1' not found

-141

Table '%1' not found

-140

Userid '%1' does not exist

-139

More than one table is identified as '%1'

-138

Dbspace '%1' not found

-137

Table '%1' requires a unique correlation name

-136

Table '%1' is in an outer join cycle

-135

Language extension

-134

Feature '%1' not implemented

-133

Invalid prepared statement type

-132

SQL statement error

-131

Syntax error near '%1'

-130

Invalid statement

-128

Cannot drop a user that owns tables in runtime engine

-127

Cannot alter a column in an index

-126

Table cannot have two primary keys

-125

ALTER clause conflict

-124

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

-123

User '%1' is not a user group

-122

Operation would cause a group cycle

-121

Do not have permission to %1

-120

User '%1' already has grant permission

-119

Primary key column '%1' already defined

-118

Table '%1' has no primary key

-116

Table must be empty

-114

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

-113

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

-112

Table already has a primary key

-111

Index name '%1' not unique

-110

Item '%1' already exists

-109

There are still active database connections

-108

Connection not found

-107

Error writing to log file

-106

Cannot open log file %1

-105

Cannot be started -- %1

-104

Invalid userid and password on preprocessed module

-103

Invalid userid or password

-102

Too many connections to database

-101

Not connected to SQL database

-100

Database engine not running

-99

Connections to database have been disabled

-98

Authentication violation

-97

Database's page size too big

-96

Database engine already running

-95

Parse error: %1 near '%2'.

-94

Invalid type for field reference

-93

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

-92

'%1' is not a valid class file

-91

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

-90

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

-89

Database engine not running in multi-user mode

-88

Application/engine communications protocol version mismatch

-87

Database name required to start engine

-86

Not enough memory to start

-85

Communication error

-84

Specified database is invalid

-83

Specified database not found

-82

Unable to start specified database

-81

Invalid database engine command line

-80

Unable to start database engine

-79

Invalid local database switch

-78

Dynamic memory exhausted!

-77

Database name not unique

-76

Request denied -- no active databases

-75

Request to start/stop database denied

-74

The selected database is currently inactive

-73

Communication buffer underflow

-72

No database file specified

0

(no message)

100

Row not found

100

No data

101

Value truncated

102

Using temporary table

103

Invalid data conversion

104

Row has been updated since last time read

105

Procedure has completed

106

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

107

Language extension detected in syntax

108

Cursor operation conflict

109

Null value eliminated in aggregate function

110

Transaction log backup page only partially full

111

Statement cannot be executed

112

More info required

113

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

114

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

115

Unsupported character set '%1'

116

Unsupported language; language used is '%1' instead

117

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

118

Illegal user selectivity estimate specified.

200

Warning


Collection Contents Index CHAPTER 10.  Database Error Messages Error messages index by SQLSTATE pdf/chap10.pdf