Databases
StackOverflow2013
Postsdbo
POChange Tracking has cleaned up tracking information although Auto Clean up is set to false
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POChange Tracking has cleaned up tracking information although Auto Clean up is set to false
    primarykey
    data
    text
    <p>On my SQL Server I have change tracking enabled, auto cleanup set to false or to true with a very high retention period like 364 days.</p> <p>Using Microsoft Sync Framework I sync the first time successfully, the second time I try to sync I get the error</p> <blockquote> <p>"System.Data.SqlClient.SqlException (0x80131904): SQL Server Change Tracking has cleaned up tracking information for table 'TableName'. To recover from this error, the client must reinitialize its local database and try again".</p> </blockquote> <p>Why is the tracking information being cleaned although the auto clean up is set to false?</p> <p>I tried the solution posted by this <a href="http://social.microsoft.com/Forums/en/uklaunch2007ado.net/thread/0e2dd016-5d14-4cf9-aebc-93b762b42ec7" rel="nofollow" title="articlequot;">article</a>, but it did not work for me, when I run the reinitialize code it takes forever and the RAM usage keeps building until I get out of memory exception.</p> <p>Please note that my database is big, over 400 MB, the total number of records synced is over 163,000 record, the first sync takes a long time so resorting to deleting the local CE database when this error happens is not an option.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USAhmad Abu Raddad
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COhave you done anything on the server database? ie., truncate table? etc...
      singulars
      1. POChange Tracking has cleaned up tracking information although Auto Clean up is set to false
      1. USJuneT
    2. CONothing changed on the server, not even Data.
      singulars
      1. POChange Tracking has cleaned up tracking information although Auto Clean up is set to false
      1. USAhmad Abu Raddad
    3. COare you copying over SQL Ce databases from different locations? the error can also appear if the sync anchors on the SQL Ce database got reset.
      singulars
      1. POChange Tracking has cleaned up tracking information although Auto Clean up is set to false
      1. USJuneT
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload