Understanding the SQL Server Compact Server Agent Log

The Microsoft SQL Server Compact 3.5 Server Agent log file contains information about each replication synchronization and Push, Pull, or SubmitSQL in remote data access (RDA) operations. The server agent's log file, always called sqlcesa35.log, uses the following abbreviations to represent actions in replication and RDA operations:

• Replication Session Control Block (RSCB)
  An automatically incremented structure that uniquely identifies each client's operation.

  When Sqlcesa35.dll is loaded, the RSCB begins at 1. Sqlcesa35.dll is unloaded only when Microsoft Internet Information Services (IIS) restarts, or the computer running IIS is restarted.

• Command
  The following table describes the commands executed in the operation.

  Command	Description
  OPNW	Open and write to the .in/.out file (without close)
  OPWC	Open, write, and close the .in/.out file
  OPNR	Open and read the .in/.out file
  PUT	Write to the .in/.out file
  FTCH	Read data from the .in/.out file
  CLOS	Close the .in/.out file
  SYNC	Reconcile the data between the Subscriber and the Publisher
  SCHK	Check for the completion of the SYNC command
  PULL	RDA Pull operation
  PUSH	RDA Push operation
  SQL	RDA SubmitSQL operation
  ACK	Acknowledgement of synchronization success or failure

• Thread
  Is the ordinal of the active thread.

• HRESULT (HR)
  Is the error for the particular command.