locked
Sync Sql Server 2008 to SqlServer 2008 System Error RRS feed

  • Question

  • Hi ,

    I have three different Computer and running SqlServer 2008 on all of them. I have programmed so that i can only Sync 9 tables among the database. I am unable to sync, the only way i can sync is if the Tables are Empty, otherwise i am getting this error, I have looked everywhere to find the solution.

    Source ConnStr: Data Source=BPOS-LAVC-BO1;Initial Catalog=BPOSDB;User ID=bposuser1; Application Name = BPOS.

    Dest ConnStr: Data Source=T2\AQUAT2;Initial Catalog=AQUAT2;User ID=devuser1;Password=devuser1;
       System error.
          at Microsoft.Synchronization.CoreInterop.ISyncSession.Start(CONFLICT_RESOLUTION_POLICY resolutionPolicy, _SYNC_SESSION_STATISTICS& pSyncSessionStatistics)
          at Microsoft.Synchronization.KnowledgeSyncOrchestrator.DoOneWaySyncHelper(SyncIdFormatGroup sourceIdFormats, SyncIdFormatGroup destinationIdFormats, KnowledgeSyncProviderConfiguration destinationConfiguration, SyncCallbacks DestinationCallbacks, ISyncProvider sourceProxy, ISyncProvider destinationProxy, ChangeDataAdapter callbackChangeDataAdapter, SyncDataConverter conflictDataConverter, Int32& changesApplied, Int32& changesFailed)
          at Microsoft.Synchronization.KnowledgeSyncOrchestrator.DoOneWayKnowledgeSync(SyncDataConverter sourceConverter, SyncDataConverter destinationConverter, SyncProvider sourceProvider, SyncProvider destinationProvider, Int32& changesApplied, Int32& changesFailed)
          at Microsoft.Synchronization.KnowledgeSyncOrchestrator.Synchronize()
          at Microsoft.Synchronization.SyncOrchestrator.Synchronize()
          at Brownstone.AquaSync.SyncApplication.SynchronizationHelper.SynchronizeProviders(KnowledgeSyncProvider localProvider, KnowledgeSyncProvider remoteProvider)
          at Brownstone.AquaSync.SyncApplication.SqlSharingForm.tempoSync_Tick(Object sender, EventArgs e)

     

     


    Devloper
    Friday, October 1, 2010 6:59 PM

All replies

  • Hey,

    Which providers do you use? What's the error message you have?

     

    Thanks,


    Ann Tang
    Friday, October 1, 2010 8:14 PM
  • I am Using ADO.net  and the error message is highlighted on the TOP.
    Devloper
    Friday, October 1, 2010 10:39 PM
  • Hello,

    Does this exception have an internal exception that can be printed?

    Friday, October 8, 2010 5:45 PM
    Answerer