locked
The specified change tracking operation is not supported RRS feed

  • Question

  • I am using SqlCeChangeTracking class to to track SQLCE changes

                    SqlCeConnection connection = new SqlCeConnection(Utility.ConnectionString);
                    connection.Open();
                    SqlCeChangeTracking changetracking = new SqlCeChangeTracking(connection);     
                    changetracking.EnableTracking("SYNC_SampleTable", TrackingKeyType.PrimaryKey, TrackingOptions.Insert);
                    changetracking.EnableTracking("SYNC_SampleTable2", TrackingKeyType.PrimaryKey, TrackingOptions.All);
                    connection.Close();

    when i do the Synchronization ,I'm getting this error.

    can anyone help me?

     

    The specified change tracking operation is not supported. To carry out this operation on the table, disable the change tracking on the table, and enable the change tracking.
       at System.Data.SqlServerCe.SqlCeChangeTracking.ProcessResults(Int32 hr)
       at System.Data.SqlServerCe.SqlCeChangeTracking.VersionCheck(TrackingVersion& iCurrentVersion, TrackingVersion tSupportedVersion, TrackingVersion tUnsupportedVersion)
       at System.Data.SqlServerCe.SqlCeChangeTracking.GetTrackingType(String tableName)
       at Microsoft.Synchronization.Data.SqlServerCe.SqlCeClientSyncProvider.GetTableRowKey(SqlCeCommand cmdUtil, String tableName, Boolean& fRowGuidFound)
       at Microsoft.Synchronization.Data.SqlServerCe.SqlCeClientSyncProvider.CreateOcsTable(String fmtTableName, Boolean createTable, SyncTable syncTable, SyncSchema syncSchema, SqlCeCommand cmdUtil)
       at Microsoft.Synchronization.Data.SqlServerCe.SqlCeClientSyncProvider.CreateSchema(SyncTable syncTable, SyncSchema syncSchema)
       at Microsoft.Synchronization.SyncAgent.InitClientSchema()
       at Microsoft.Synchronization.SyncAgent.Synchronize()
       at PreCom.Sync.Client.SyncClientAgent.Sync()
       at PreCom.Sync.Client.PreComSyncClient.Synchronize()
       at PreCom.Sync.GuiModule.frmGuiModule.btnSync_Click(Object sender, EventArgs e)
       at System.Windows.Forms.Control.OnClick(EventArgs e)
       at System.Reflection.RuntimeMethodInfo.InternalInvoke(RuntimeMethodInfo rtmi, Object obj, BindingFlags invokeAttr, Binder binder, Object parameters, CultureInfo culture, Boolean isBinderDefault, Assembly caller, Boolean verifyAccess, StackCrawlMark& stackMark)
       at System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean verifyAccess, StackCrawlMark& stackMark)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
       at System.Windows.Forms.Control.TASK.Invoke()
       at System.Windows.Forms.Control._InvokeAll()
       at System.Windows.Forms.Control.WnProc(WM wm, Int32 wParam, Int32 lParam)
       at System.Windows.Forms.Control._InternalWnProc(WM wm, Int32 wParam, Int32 lParam)
       at Microsoft.AGL.Forms.EVL.EnterMainLoop(IntPtr hwnMain)
       at System.Windows.Forms.Application.Run(Form fm)
       at PreCom.Application.Initialize()
       at PreCom.ApplicationMobile.a()

     

     

     

    Wednesday, May 4, 2011 11:16 AM

Answers

All replies