The following table lists the SQL Server Compact 3.5 Server Agent (sqlcesa35.dll) errors that you might experience when you use SQL Server Compact 3.5.

If you experience any errors with the prefix 'Internal error' while you use SQL Server Compact 3.5, 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

29001

SSCE_M_EXPECTEDINSERTUPDATESONLY

Internal error: An unexpected state was encountered when processing inserts or updates.

Not applicable

Not applicable

29004

SSCE_M_CANTCOCREATEMSDAINITIALIZE

The OLE DB provider for SQL Server cannot be initialized. Check if SQLOLEDB.dll is installed correctly.

Not applicable

Not applicable

29005

SSCE_M_RSCBWITHSAMEEXCHANGEID

A replication session control block already exists. The IIS server was probably shut down during a synchronization process. Try synchronizing again.

Not applicable

Not applicable

29006

SSCE_M_SQLRECONCILERFAILED

A call to SQL Server Reconciler failed. Try to resynchronize.

Not applicable

Not applicable

29007

SSCE_M_QUERYCANNOTBETRACKED

The query cannot be tracked. There might not be a primary key, or the query might involve multiple tables.

Not applicable

Query string

29009

SSCE_M_EXPRESSIONWITHOUTALIAS

Internal error: The expression or literal cannot be processed without an alias. RDA error.

Not applicable

Not applicable

29010

SSCE_M_NOPRIMARYKEY

The table does not have a primary key.

Not applicable

Table name

29011

SSCE_M_ROWVERCOLUMN

The table contains a timestamp or another row versioning column.

Not applicable

Table name

29012

SSCE_M_INVALIDPUSHSEQUENCE

Internal error: An error occurred during the push operation in the SQL Server Compact Server Agent.

Not applicable

Not applicable

29015

SSCE_M_PUSHPKCOLCOUNTMISMATCH

The expected number of columns in the primary key on SQL Server does not match the count in SQL Server Compact. The schema on SQL Server has changed since the last RDA Pull. The table will have to be PULLED again to match the primary key schema defined on SQL Server.

Supplied count, Expected count

Not applicable

29016

SSCE_M_VF_MISSINGSERVERCOLUMN

Client-side and server-side columns for the RDA table do not match.

Not applicable

Table name

29017

SSCE_M_VF_MISMATCHEDTYPES

The OLE DB data type information in the SQL Server Compact columns does not match the information in the SQL Server columns for the RDA table.

Client type, Server type

Table name

29018

SSCE_M_VF_MISSINGTABLE

No columns were found. Either the table name is missing or the permissions are not valid.

Not applicable

Table name

29020

SSCE_M_NOROWSAFFECTED

A row cannot be updated or deleted in the SQL Server by using RDA.

Not applicable

Not applicable

29021

SSCE_M_TOOMANYROWSAFFECTED

More than one row was affected by an RDA update or delete operation in the SQL Server database.

Not applicable

Not applicable

29022

SSCE_M_INCORRECTPROVIDERVERSION

The version of the Microsoft OLE DB Provider for SQL Server is not correct. Install MDAC 2.8 or later.

Not applicable

Version

29023

SSCE_M_INCORRECTPROVIDER

The OLE DB Provider for SQL Server on the computer running IIS is not compatible with SQL Server Compact. Install MDAC 2.8 or later.

Not applicable

Provider

29024

SSCE_M_VF_PRIMARYKEYCHANGE

The push operation cannot match the order of the primary key columns on the client side and server side. Repull the table or reset the primary key column.

Not applicable

Not applicable

29025

SSCE_M_VF_MISSINGSERVERPKCOLUMN

The push operation cannot find a primary key column on the SQL Server table.

Not applicable

Not applicable

29026

SSCE_M_VF_EXTRASERVERPKCOLUMN

The push operation has found an extra primary key column on the SQL Server table.

Not applicable

Not applicable

29028

SSCE_M_UNSUPPORTEDOLEDBTYPE

The OLE DB data type is not supported by the Microsoft OLE DB Provider for SQL Server. Install MDAC 2.8 or later.

Data type

Not applicable

29029

SSCE_M_VF_NONLOBIUNKNOWN

Internal error: The SQL Server Compact column metadata information does not match with the OLEDB provider (non-SQL Server).

Not applicable

Not applicable

29030

SSCE_M_NOTRACKPKCOLMISSING

The query cannot be tracked because one or more columns of the primary key are missing.

Not applicable

Not applicable

29031

SSCE_M_NOTRACKCOMPUTEDCOLUMN

The query cannot be tracked because the table includes a computed column that cannot be pulled.

Not applicable

Not applicable

29032

SSCE_M_NOTRACKMULTITABLE

The query cannot be tracked because it is a multitable query.

Not applicable

Not applicable

29033

SSCE_M_INVALIDCODEPAGE

The server code page, or the override code page, is either not valid or not installed on the computer running IIS.

Code page

Not applicable

29034

SSCE_M_MISMATCHEDCOMPONENTS

The Client Agent and Server Agent component versions are incompatible. The compatible versions are: Client Agent versions 3.0 and 3.5 with Server Agent versions 3.5 and Client Agent version 3.5 with Server Agent version 3.5. Re-install the replication components with the matching versions for client and server agents.

Not applicable

Client Agent version, Server Agent version

29042

SSCE_M_RSCBTIMEDOUT

The replication session was inactive for longer than the cleanup interval and the synchronization was cancelled. This typically occurs when the server has an extremely high CPU utilization. The default of 2 hrs was exceeded. Try the operation again.

Not applicable

Not applicable

29044

SSCE_M_FILERENAMEFAILED

SQL Server Compact failed to rename an .IN file to .OUT on the IIS server. This typically occurs when there are large amounts of referential integrity retry situations on SQL Server Compact while using merge replication because of which SQL Server Compact is unable to modify the file name extensions. Try again.

Not applicable

Not applicable

29045

SSCE_M_INITIALIZERECONCILERFAILED

Initializing SQL Server Reconciler has failed. Try again.

Not applicable

Not applicable

29046

SSCE_M_READONLY

While performing an RDA Push, SQL Server Compact was only able to obtain a read-only cursor on the table(s) being pushed to SQL Server. There could be locking conflicts on SQL Server while trying to do the push. Verify that the table on SQL Server is updatable and try again.

Not applicable

Not applicable

29048

SSCE_M_IMPERSONATIONFAILED

The Windows user account could not be impersonated at the computer running IIS.

Not applicable

Not applicable

29049

SSCE_M_CANTCONNECTTOPUBLISHER

The server agent could not connect to the publisher.

Not applicable

Not applicable

29050

SSCE_M_GETROWSET

Internal error: Failure getting a rowset.

Not applicable

Not applicable

29051

SSCE_M_GETCOLUMNS

Internal error: Failure getting columns.

Not applicable

Not applicable

29052

SSCE_M_CREATEINDEXSQL

Internal error: Failure generating RDA create index SQL statement.

Not applicable

Not applicable

29053

SSCE_M_CREATETABLESQL

Internal error: Failure generating RDA create table SQL statement.

Not applicable

Not applicable

29054

SSCE_M_GETPRIMARYKEYCOLUMNS

Internal error: Failure getting RDA primary key columns. .

Not applicable

Not applicable

29055

SSCE_M_CREATEPRIMARYKEY

Internal error: Failure generating create RDA primary key SQL statement.

Not applicable

Not applicable

29056

SSCE_M_VERIFYSCHEMA

Internal error: Failure while verifying RDA schema.

Not applicable

Not applicable

29057

SSCE_M_PREPAREINSERT

Internal error: Failure while preparing an RDA insert.

Not applicable

Not applicable

29058

SSCE_M_PREPAREUPDATE

Internal error: Failure while preparing an RDA update.

Not applicable

Not applicable

29059

SSCE_M_PREPAREDELETE

Internal error: Failure while preparing an RDA delete.

Not applicable

Not applicable

29060

SSCE_M_CONNECTFAILURESQL

Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the SQL user is not a valid user on the SQL Server, or the password is incorrect.

Not applicable

Not applicable

29061

SSCE_M_CONNECTFAILUREIIS

Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the computer running SQL Server, or the password is incorrect.

Not applicable

Not applicable

29062

SSCE_M_SELECTSTRINGMISSING

The SQLSelectString parameter is not specified.

Not applicable

Not applicable