Jaa

Understanding the SQL Server Compact Edition Server Agent Log

  • Artikkeli

The Microsoft SQL Server Compact Edition Server Agent log file contains information about each replication synchronization and Push, Pull, or SubmitSQL in remote data access (RDA) operations. The log file, always called sqlcesa30.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 Sqlcesa30.dll is loaded, the RSCB begins at 1. Sqlcesa30.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.