Engine Errors
The following table lists the storage engine errors that you might experience when you use SQL Server Compact 4.0.
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:
PropertyBitmask value
MAXBUFFERSIZE1
AUTO_SHRINK_THRESHOLD4
FLUSH_INTERVAL8
MAX_LOCKS10
MAX_DATABASE_SIZE20
TEMPFILE_DIRECTORY40
|
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 |