Synchronizing contacts

When you enable contact synchronization in Exchange Integration, the contacts are added to the EcngSyncResource table. They are then moved to the EWSSyncResource table and the number of contacts decreases as they're processed.

However, running the following SQL statement shows that x number of records have been added to the EcngSyncResource table but they have not been successfully moved to the EWSSyncResource table.

SELECT * FROM EcngSyncResource WITH (NOLOCK) WHERE exsr_UUID NOT IN (SELECT EWRS_UUID FROM EWSSyncResource WITH (NOLOCK)) AND exsr_Deleted IS null AND exsr_processed = 0 AND exsr_EndpointID IN (6009,6014)

To troubleshoot this issue, update one of the contacts before performing a synchronization to check if it processed. Also check the log files for any errors or conflicts when processing the records.