Export (0) Print
Expand All

Engine Errors

The following table lists the storage engine errors that you might experience when you use SQL Server Compact 4.0.

Important note Important

If you experience any errors with the prefix "Internal error" while you use SQL Server Compact, try the operation again as the error might not reproduce. If the error appears again, you should immediately contact Microsoft Product Support Services. The internal errors cannot be resolved by common troubleshooting techniques.

Value

Error Token

Description

Numeric Parameters

String Parameters

25001

SSCE_M_NOCURRENTRECORD

Either the cursor is not on a row, or there are no rows left.

Not applicable

Not applicable

25002

SSCE_M_INVALIDBUFFERSIZE

The specified buffer size is not valid.

Buffer size specified

Not applicable

25003

SSCE_M_COLUMNLENGTHTOOBIG

The specified length is too long for the column type.

Specified length, Column data type

Not applicable

25004

SSCE_M_COLUMNNOTUPDATEABLE

The column cannot be modified.

Not applicable

Column name

25005

SSCE_M_NULLINVALID

The column cannot contain null values.

Not applicable

Column name, Table name

25008

SSCE_M_INVALIDPARAMETER

The parameter is not valid.

Not applicable

Not applicable

25009

SSCE_M_INVALIDPATH

The path is not valid. Check the directory for the database.

Not applicable

Path

25010

SSCE_M_INVALIDFILENAME

The file name is not valid. Check the file name for the database.

Not applicable

File name

25011

SSCE_M_INVALIDDATABASE

The file that is being referenced is not a SQL Server Compact database file format.

Not applicable

Database name

25012

SSCE_M_UPDATENOTPREPARED

The record was not prepared for update.

Not applicable

Not applicable

25014

SSCE_M_SYSCOLACCESSDENIED

Access to the system column is denied.

Not applicable

Not applicable

25016

SSCE_M_KEYDUPLICATE

A duplicate value cannot be inserted into a unique index.

Not applicable

Table name, Constraint name

25017

SSCE_M_DATABASECORRUPTED

The database file may be corrupted. Run the repair utility to check the database file.

Not applicable

Database name

25018

SSCE_M_WRITECONFLICT

Failed to obtain a lock for a write operation.

Not applicable

Not applicable

25020

SSCE_M_COMMITCONFLICT

Failed to obtain a lock for a commit.

Not applicable

Not applicable

25022

SSCE_M_NULLKEYDISALLOWED

Null values are not allowed in indexes.

Not applicable

Not applicable

25025

SSCE_M_INTEGRITYVIOLATION_MSTR

The primary key value cannot be deleted because references to this key still exist.

Not applicable

Foreign key constraint name

25026

SSCE_M_INTEGRITYVIOLATION_SLV

A foreign key value cannot be inserted because a corresponding primary key value does not exist.

Not applicable

Primary key constraint name

25027

SSCE_M_RECORDTOOBIG

The table definition or the row size exceeds the maximum row size of 8060 bytes.

Not applicable

Not applicable

25028

SSCE_M_INVALIDPASSWORD

The specified password does not match the database password.

Not applicable

Not applicable

25030

SSCE_M_RI_DUPLICATEKEY

A duplicate key value was found as a result of referential integrity action.

Not applicable

Foreign table name

25033

SSCE_M_ILLEGALCOLLATINGSEQ

The specified locale is not supported on this operating system.

Not applicable

Not applicable

25034

SSCE_M_FILELOCKVIOLATION

There is a file locking violation. Close any external application that uses the database file.

Not applicable

Not applicable

25035

SSCE_M_FILESHAREVIOLATION

There is a file-sharing violation. A different process might be using the file.

Not applicable

Not applicable

25037

SSCE_M_DISKFULL

There is not enough disk space left for the database.

Not applicable

Not applicable

25038

SSCE_M_TEMPDISKFULL

There is not enough disk space left for the temporary database.

Not applicable

Not applicable

25039

SSCE_M_FILEACCESSDENIED

Access to the database file is not allowed.

Not applicable

File name

25044

SSCE_M_TOOMANYOPENFILES

OS Error: The OS limit of open files has been exceeded. Other applications will need to be shut down to free up available open files.

Not applicable

Not applicable

25046

SSCE_M_FILENOTFOUND

The database file cannot be found. Check the path to the database.

Not applicable

File name

25047

SSCE_M_READVERIFYERROR

OS Error: SQL Server Compact encountered a premature EOF for the database file. Running the repair utility might help recover some data.

Not applicable

Not applicable

25048

SSCE_M_NOMOREFILEHANDLES

OS Error: The OS is reporting that no more file handles can be created. In order to proceed try closing other applications.

Not applicable

Not applicable

25049

SSCE_M_DISKNOTREADY

OS Error: The OS storage system (RAM, CF, SD, or IPSM) is not responding. Retry the operation.

Not applicable

Not applicable

25050

SSCE_M_SHARINGBUFFEREXCEEDED

OS Error: The OS will not allow sharing of any more files. In order to proceed try closing other applications.

Not applicable

Not applicable

25051

SSCE_M_DISKIO

Internal error: Unable to successfully execute disk I/O on the file system.

Not applicable

Not applicable

25053

SSCE_M_KEYNOTMADE

Internal error: A serious error has occurred when trying to create a key.

Not applicable

Not applicable

25054

SSCE_M_TOOMANYKEYS

The limit of 16 columns for the multi-column index was exceeded.

Not applicable

Not applicable

25056

SSCE_M_COLUMNWIDTHNOTEVEN

The size of the Unicode text column is not even.

Column size

Column name

25058

SSCE_M_NOCURRENTINDEX

Internal error: Invalid operation without a current index.

Not applicable

Not applicable

25059

SSCE_M_ILLEGALINDEXCOLUMN

Long value data type cannot be indexed.

Not applicable

Not applicable

25060

SSCE_M_REFERENCENOTFOUND

The foreign key constraint does not exist.

Not applicable

Not applicable

25064

SSCE_M_ONLYONESPECIALCOLUMN

Only one ROWGUID, autoincrement, and version are allowed for each column in a table.

Not applicable

Object name

25065

SSCE_M_TOOMANYINDEXES

The limit of 249 indexes per tables has been exceeded.

Not applicable

Table name

25066

SSCE_M_TOOMANYCOLUMNS

The limit of 1024 columns for a table has been exceeded.

Column count

Column name

25067

SSCE_M_TRANSTOODEEP

Internal error: The internal transactions for SQL Server Compact have exceeded the nesting limit.

Not applicable

Not applicable

25070

SSCE_M_DIFFNUMRELCOLUMNS

The definition of referring columns (such as number of columns or data types) in referential relationships must match the referred columns.

Not applicable

Constraint name (if known)

25072

SSCE_M_PRIMARYKEYNULLCONFLICT

Primary keys cannot be created on columns that support null values.

Not applicable

Column name

25073

SSCE_M_TABLEMUSTHAVECOLUMNS

Tables must contain at least one column.

Not applicable

Not applicable

25074

SSCE_M_DEFAULTEXPRTOOLONG

The expression string for the default value cannot be longer than 4000 characters.

Length of expression string

Not applicable

25075

SSCE_M_DISALLOWIDENTITYNULL

Nullable columns cannot be identity columns.

Not applicable

Not applicable

25077

SSCE_M_CONSTRAINTINUSE

The constraint cannot be removed because it is referenced by another constraint.

Not applicable

Constraint name

25078

SSCE_M_INDEXINUSE

The index cannot be removed because it is being used to enforce a constraint.

Not applicable

Index name

25079

SSCE_M_ENCRYPTEDDBMUSTHAVEPWD

A password must be specified when a database is created by using encryption.

Not applicable

Not applicable

25080

SSCE_M_NOOSENCRYPTIONSUPPORT

The operating system does not support encryption.

Not applicable

Not applicable

25081

SSCE_M_VIOLATEDAUTOINCRANGE

The new value generated for the inserted row does not fall within the allowable range.

Generated value

Not applicable

25083

SSCE_M_CYCLEDETECTED

The referential relationship will result in a cyclical reference that is not allowed.

Not applicable

Constraint name

25084

SSCE_M_RELCOLUMNSTYPEMISMATCH

The data types of the columns in the relationship do not match.

Not applicable

Not applicable

25085

SSCE_M_PKDUPLICATE

The table already has a primary key.

Not applicable

Not applicable

25086

SSCE_M_INVALIDINCREMENT

The identity column contains an increment value that is not valid.

Not applicable

Column name

25087

SSCE_M_GENERATEGUIDFAILED

Internal error: A new GUID cannot be generated for the new row.

Not applicable

Not applicable

25090

SSCE_M_LOCKTIMEOUT

SQL Server Compact timed out waiting for a lock. The default lock time is 2000ms for devices and 5000ms for desktops. The default lock timeout can be increased in the connection string using the ssce: default lock timeout property.

Session id, Thread id, Process id

Table name, Conflict type, Resource

25091

SSCE_M_OUTOFLOCKS

The lock manager has run out of space for additional locks. This can be caused by large transactions, by large sort operations, or by operations where SQL Server Compact creates temporary tables. You cannot increase the lock space.

Not applicable

Not applicable

25092

SSCE_M_INVALIDTEMPPATH

The path specified for the temporary database is not valid.

Not applicable

Not applicable

25100

SSCE_M_NOQUERYPROCESSOR

Unable to create Command object because Query Processor module is not present on the device or not located in the same directory as the Storage Engine module.

Not applicable

Not applicable

25101

SSCE_M_OUTOFBUFFERPOOLSPACE

SQL Server Compact has exceeded the buffer size. The default size can be increased on initialization by modifying the ssce: max buffer size property.

Not applicable

Not applicable

25102

SSCE_M_INITPROPCONFLICT

Another user has opened the database with different instance-level initialization properties. The Error Number field of the Error object specifies which property or properties caused the failure. The following table shows the bitmask values that are used for the Error Number:

Property Bitmask value
MAXBUFFERSIZE 1
AUTO_SHRINK_THRESHOLD 4
FLUSH_INTERVAL 8
MAX_LOCKS 10
MAX_DATABASE_SIZE 20
TEMPFILE_DIRECTORY 40

Not applicable

Not applicable

25103

SSCE_M_CANTLOADSQLSEDLL

Storage Engine module could not be loaded. Reinstall SQL Server Compact Edition.

Not applicable

Not applicable

25104

SSCE_M_DATABASETOOBIG

The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only.

Required Max Database Size (in MB; 0 if unknown)

Not applicable

25105

SSCE_M_INVALIDSECURITYDESCRIPTOR

Internal error: Invalid Security Descriptor was specified.

Not applicable

Not applicable

25106

SSCE_M_TOOMANYCONSTRAINTS

The limit of 249 constraints per table has been exceeded.

Not applicable

Table Name

25107

SSCE_M_BADKEYTYPE

Internal error: The specified constraint does not define the requested type of key.

Not applicable

Not applicable

25108

SSCE_M_OUTSTANDINGPREPARE

Another cursor on the same table has a pending operation on the same row.

Not applicable

Not applicable

25109

SSCE_M_PASSWORDTOOLONG

The database password cannot exceed 40 characters.

Not applicable

Not applicable

25110

SSCE_M_SYSTEMNAME

The table and column name is part of a reserved name. Table and column names cannot begin with "__Sys".

Not applicable

Name

25111

SSCE_M_COMPRESSEDNOSTREAM

Internal error: Compressed columns do not support the stream interface(s).

Not applicable

Column Name

25112

SSCE_M_COMPRESSEDNONLV

Invalid use of compressed flag for non-long value column.

Not applicable

Column Name, Table Name

25113

SSCE_M_CHANGECOMPRESSED

Cannot change compression status for a database.

Not applicable

Db name

25114

SSCE_M_FILEALREADYEXISTS

File already exists. Try using a different database name.

Not applicable

File name

25115

SSCE_M_WRONGPAGE

Wrong page (potential database corruption). Try running the repair tool.

Not applicable

Not applicable

25116

SSCE_M_SYSTABACCESSDENIED

Internal error: Access to the system table is denied.

Not applicable

Not applicable

25117

SSCE_M_ALREADYOPENED

Database already opened by a different user.

Not applicable

Db name

25118

SSCE_M_CANTOPENSHAREDMEMORY

Internal error: Cannot open the shared memory region.

Not applicable

Not applicable

25119

SSCE_M_CANTCHANGEKEYCOLUMN

Cannot alter a column that is part of a key or an index.

Not applicable

Index Name, Column

25120

SSCE_M_RODATABASEREQUIRESTEMPPATH

Opening a database as read-only requires a temporary path to be specified.

Not applicable

Db name

25122

SSCE_M_FATALLOCKFAILURE

Internal error: Fatal failure of the lock susbsytem for this database.

Not applicable

Db name

25123

SSCE_M_LIBRARYLOADFAILURE

A SQL Server Compact DLL could not be loaded. Reinstall SQL Server Compact Edition.

Not applicable

DLL name, Dir name

25124

SSCE_M_INCONSISTENTLVVERSION

The long value was changed by another transaction.

Not applicable

Not applicable

25125

SSCE_M_INVALIDSTATSOPTIONS

Internal error: Invalid statistics creation options.

Options

Not applicable

25127

SSCE_M_INVALIDPROVIDERTYPE

Invalid provider type.

Db version, Requested version

File name

25128

SSCE_M_INVALIDSHAREDMEMORYFORMAT

SQL Server Compact has encountered two different versions of the product accessing the same database file. Ensure that each application accessing the same database file is using the same version of SQL Server Compact Edition.

Not applicable

Not applicable

25129

SSCE_M_PREFIXTOOLARGE

The string value that has been assigned to the LIKE clause in the SELECT statement exceeds the limit for SQL Server Compact Edition. The limit for single byte character set is 256 characters but can be smaller for double byte character set.

Not applicable

Not applicable

25130

SSCE_M_UNINSTALLEDCOLLATINGSEQ

The specified locale is not installed on this machine. Install the appropriate language pack.

Not applicable

Not applicable

25131

SSCE_M_CANTLOADSQLQPDLL

Query Processor module could not be loaded. Reinstall SQL Server Compact Edition.

Not applicable

Not applicable

25133

SSCE_M_NOTSUPPORTED

Internal error: SQL Server Compact made an unsupported request to the host operating system.

Not applicable

Not applicable

25134

define SSCE_M_READREQUIREDRECORDS

The required number of records has already been read.

Not applicable

Not applicable

25135

define SSCE_M_IDENTITYINSERT_ON

IDENTITY_INSERT is already ON for another table. Cannot perform SET operation for this table.

Not applicable

This table name, Other table name

25136

define SSCE_M_NO_IDENTITY

Table does not have a IDENTITY column.

Not applicable

Not applicable

25137

define SSCE_M_INVALIDENCRYPTIONMODE

The database encryption mode is invalid.

Input encryption mode

Not applicable

25138

define SSCE_M_DBUPGRADENEEDED

The database file has been created by an earlier version of SQL Server Compact. Please upgrade using SqlCeEngine.Upgrade() method.

Not applicable

Not applicable

25139

define SSCE_M_INVALID3XDATABASE

The file that is being referenced is not a valid SQL Server 2005 Compact Edition (version 3.1) or SQL Server 2005 Mobile Edition (version 3.0) database file to perform upgrade.

Not applicable

Database file fame

25140

define SSCE_M_INVALIDSRCPASSWORD

The password specified for the source database is incorrect.

Not applicable

Data source

25141

define SSCE_M_ILLEGALSRCCOLLATINGSEQ

The source database locale is not supported on this operating system.

LCID

Not applicable

25200

SSCE_WRN_COLUMNNULL

The column cannot have NULL values.

Not applicable

Not applicable

25201

SSCE_WRN_BUFFERTRUNCATED

The data was truncated. Try to pass down a larger buffer.

Not applicable

Not applicable

25206

SSCE_WRN_RI_RECORDSUPDATED

Additional records were updated as a result of referential integrity actions.

Not applicable

Not applicable

25207

SSCE_WRN_RI_RECORDSDELETED

Additional records were deleted as a result of referential integrity actions.

Not applicable

Not applicable

25210

SSCE_WRN_DEFAULTALREADYPRESENT

This column already had a default.

Not applicable

Not applicable

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft