Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
UploadAnd DownLoad Sync Direction Problem using WCF RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I am Syching my server data(MS SQL SERVER 2008 EnterPrise) into my local (MS SQL SERVER 2008 Express).I am successfully DownLoading the server Data using direction Download.But when I am changing directions either DownloadAndUpload or UploadAndDownLoad,it is not able to connect.Say it is givin me request.timeout error.

    Regards,

    Sachin K

     

     

     

     

    Regards,

    Sachin K

     

     

    Tuesday, July 19, 2011 7:01 AM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    please enable Sync Fx tracing and/or WCF tracing so you know what's happening. which providers are you using?

    Tuesday, July 19, 2011 7:31 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Please let me know/any link how to enable Sync Fx tracing.

    Regards,

    Sachin K

     

     

    Tuesday, July 19, 2011 8:16 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    here you go:

    http://msdn.microsoft.com/en-us/library/cc807160.aspx

    theyre actually in the documentation that comes with the installer as well.

    Tuesday, July 19, 2011 8:21 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Sync Related Error..

    Actually in this Scope I am customizing my Sync.

    I have done  followinig activity on Syncronize..

     

       at DBSyncWcfService.IRelationalSyncContract.ApplyChanges(ConflictResolutionPo
    licy resolutionPolicy, ChangeBatch sourceChanges, Object changeData)


       at DBSyncProxy.RelationalProviderProxy.ProcessChangeBatch(ConflictResolutionP
    olicy resolutionPolicy, ChangeBatch sourceChanges, Object changeDataRetriever, S
    yncCallbacks syncCallbacks, SyncSessionStatistics sessionStatistics)


       at Microsoft.Synchronization.KnowledgeProviderProxy.ProcessChangeBatch(CONFLI
    CT_RESOLUTION_POLICY resolutionPolicy, ISyncChangeBatch pSourceChangeManager, Ob
    ject pUnkDataRetriever, ISyncCallback pCallback, _SYNC_SESSION_STATISTICS& pSync
    SessionStatistics)


       at Microsoft.Synchronization.CoreInterop.ISyncSession.Start(CONFLICT_RESOLUTI
    ON_POLICY resolutionPolicy, _SYNC_SESSION_STATISTICS& pSyncSessionStatistics)
       at Microsoft.Synchronization.KnowledgeSyncOrchestrator.DoOneWaySyncHelper(Syn
    cIdFormatGroup sourceIdFormats, SyncIdFormatGroup destinationIdFormats, Knowledg
    eSyncProviderConfiguration destinationConfiguration, SyncCallbacks DestinationCa
    llbacks, ISyncProvider sourceProxy, ISyncProvider destinationProxy, ChangeDataAd
    apter callbackChangeDataAdapter, SyncDataConverter conflictDataConverter, Int32&
     changesApplied, Int32& changesFailed)
       at Microsoft.Synchronization.KnowledgeSyncOrchestrator.DoOneWayKnowledgeSync(
    SyncDataConverter sourceConverter, SyncDataConverter destinationConverter, SyncP
    rovider sourceProvider, SyncProvider destinationProvider, Int32& changesApplied,
     Int32& changesFailed)
       at Microsoft.Synchronization.KnowledgeSyncOrchestrator.Synchronize()
       at Microsoft.Synchronization.SyncOrchestrator.Synchronize()
       at MSSqlDBSync.DBSyncOrchestrator.Synchronize()

    Regards,

    Sachin K

     

     

    Tuesday, July 19, 2011 10:25 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    is that the stack trace? have you enabled tracing?
    Tuesday, July 19, 2011 10:57 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    It is the Stack trace.No.I haven't enabled tracing..
    Tuesday, July 19, 2011 11:04 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Attaching the TraceSample.Txt

    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:31:516, Version of connection detected to be Sql2008
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:31:626, Version of connection detected to be Sql2008
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:31:657, Version of connection detected to be Sql2008
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:31:704, Version of connection detected to be Sql2008
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:31:735, Version of connection detected to be Sql2008
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:31:891,    BeginSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:938, ----- Applying Changes for Scope "lookup_table_scope" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:938,         Source Scope Id: b153cea06b314c969e6c399bb9898905
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:938,    Destination Scope Id: 2eadcc6ea15f495e98430fc864d16b9e
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:938,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:969,    ----- Deletes for Table "CR_RESOLUTION_ACCEPTANCE_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:969,       0 Deletes Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:969,    --- End Deletes for Table "CR_RESOLUTION_ACCEPTANCE_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:969,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:969,    ----- Deletes for Table "CR_RESOLUTION_TYPE_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:969,       0 Deletes Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:969,    --- End Deletes for Table "CR_RESOLUTION_TYPE_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:985,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:985,    ----- Deletes for Table "dbo.CR_SOURCE_OF_REQUEST_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:985,       0 Deletes Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:985,    --- End Deletes for Table "dbo.CR_SOURCE_OF_REQUEST_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:985,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:985,    ----- Deletes for Table "dbo.CMN_TOWN" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:985,       0 Deletes Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:985,    --- End Deletes for Table "dbo.CMN_TOWN" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:985,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:985,    ----- Deletes for Table "dbo.CR_REQ_SUBYPE_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:985,       0 Deletes Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:985,    --- End Deletes for Table "dbo.CR_REQ_SUBYPE_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:985,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:985,    ----- Deletes for Table "dbo.CR_REQ_TYPE_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:32:985,       0 Deletes Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:001,    --- End Deletes for Table "dbo.CR_REQ_TYPE_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:001,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:001,    ----- Deletes for Table "dbo.CR_ESCLATION_STATUS_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:001,       0 Deletes Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:001,    --- End Deletes for Table "dbo.CR_ESCLATION_STATUS_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:001,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:001,    ----- Deletes for Table "dbo.CR_PRIORITY_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:001,       0 Deletes Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:001,    --- End Deletes for Table "dbo.CR_PRIORITY_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:001,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:001,    ----- Inserts for Table "dbo.CR_PRIORITY_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:001,       0 Inserts Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:001,    --- End Inserts for Table "dbo.CR_PRIORITY_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:001,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:001,    ----- Inserts for Table "dbo.CR_ESCLATION_STATUS_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:001,       0 Inserts Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:016,    --- End Inserts for Table "dbo.CR_ESCLATION_STATUS_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:016,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:016,    ----- Inserts for Table "dbo.CR_REQ_TYPE_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:016,       0 Inserts Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:016,    --- End Inserts for Table "dbo.CR_REQ_TYPE_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:016,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:016,    ----- Inserts for Table "dbo.CR_REQ_SUBYPE_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:016,       0 Inserts Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:016,    --- End Inserts for Table "dbo.CR_REQ_SUBYPE_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:016,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:016,    ----- Inserts for Table "dbo.CMN_TOWN" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:016,       0 Inserts Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:016,    --- End Inserts for Table "dbo.CMN_TOWN" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:016,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:016,    ----- Inserts for Table "dbo.CR_SOURCE_OF_REQUEST_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:032,       0 Inserts Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:032,    --- End Inserts for Table "dbo.CR_SOURCE_OF_REQUEST_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:032,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:032,    ----- Inserts for Table "CR_RESOLUTION_TYPE_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:032,       0 Inserts Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:032,    --- End Inserts for Table "CR_RESOLUTION_TYPE_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:032,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:032,    ----- Inserts for Table "CR_RESOLUTION_ACCEPTANCE_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:032,       0 Inserts Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:032,    --- End Inserts for Table "CR_RESOLUTION_ACCEPTANCE_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:032,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:032,    ----- Updates for Table "dbo.CR_PRIORITY_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:032,       0 Updates Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:032,    --- End Updates for Table "dbo.CR_PRIORITY_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:032,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:032,    ----- Updates for Table "dbo.CR_ESCLATION_STATUS_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:048,       0 Updates Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:048,    --- End Updates for Table "dbo.CR_ESCLATION_STATUS_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:048,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:048,    ----- Updates for Table "dbo.CR_REQ_TYPE_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:048,       0 Updates Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:048,    --- End Updates for Table "dbo.CR_REQ_TYPE_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:048,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:048,    ----- Updates for Table "dbo.CR_REQ_SUBYPE_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:048,       0 Updates Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:048,    --- End Updates for Table "dbo.CR_REQ_SUBYPE_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:048,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:048,    ----- Updates for Table "dbo.CMN_TOWN" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:048,       0 Updates Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:048,    --- End Updates for Table "dbo.CMN_TOWN" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:048,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:048,    ----- Updates for Table "dbo.CR_SOURCE_OF_REQUEST_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:063,       0 Updates Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:063,    --- End Updates for Table "dbo.CR_SOURCE_OF_REQUEST_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:063,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:063,    ----- Updates for Table "CR_RESOLUTION_TYPE_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:063,       0 Updates Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:063,    --- End Updates for Table "CR_RESOLUTION_TYPE_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:063,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:063,    ----- Updates for Table "CR_RESOLUTION_ACCEPTANCE_CD" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:063,       0 Updates Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:063,    --- End Updates for Table "CR_RESOLUTION_ACCEPTANCE_CD" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:063,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:063, --- End Applying Changes for Scope "lookup_table_scope" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:063,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:079, Committing transaction
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:094,    EndSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:126,    BeginSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:251, ----- Checking for Outdated Peer -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:251,    Destination is not outdated
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:251, --- End Checking for Outdated Peer ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:251,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:266, ----- Enumerating Changes for Scope "mbc_scope_MHASLA" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:266,          Source Scope Id: 6883d5f1a9e248aeae2c47191be8cf94
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:266,     Destination Scope Id: 9e572d000dd84733984e63dc210ca120
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:266,    Change Tracking Model: Decoupled
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:266,    ----- Table "dbo.MBC_BU_VILLAGE" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:673,       Inserts: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:673,       Deletes: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:673,       Updates: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:673,       Changes Enumerated: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:673,    --- End Table "dbo.MBC_BU_VILLAGE" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:673,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:688,    ----- Table "dbo.MBC_BILLING_UNIT_INTF" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:719,       Inserts: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:719,       Deletes: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:719,       Updates: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:719,       Changes Enumerated: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:719,    --- End Table "dbo.MBC_BILLING_UNIT_INTF" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:719,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:719,    ----- Table "dbo.MBC_CONSUMER_INF" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:735,       Inserts: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:751,       Deletes: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:751,       Updates: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:751,       Changes Enumerated: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:751,    --- End Table "dbo.MBC_CONSUMER_INF" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:751,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:751,    ----- Table "dbo.MBC_CONSUMER_BILL_INTF" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:766,       Inserts: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:766,       Deletes: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:766,       Updates: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:766,       Changes Enumerated: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:766,    --- End Table "dbo.MBC_CONSUMER_BILL_INTF" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:766,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:782,    ----- Table "dbo.MBC_CONSUMER_RECEIPT_INTF" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:798,       Inserts: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:798,       Deletes: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:798,       Updates: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:798,       Changes Enumerated: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:798,    --- End Table "dbo.MBC_CONSUMER_RECEIPT_INTF" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:798,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:798, --- End Enumerating Changes for Scope "mbc_scope_MHASLA" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:798,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:798, Committing transaction
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:938,    EndSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:33:954,    BeginSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:063, ----- Applying Changes for Scope "mbc_scope_MHASLA" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:079,         Source Scope Id: 9e572d000dd84733984e63dc210ca120
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:079,    Destination Scope Id: 6883d5f1a9e248aeae2c47191be8cf94
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:079,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:079,    ----- Deletes for Table "dbo.MBC_CONSUMER_RECEIPT_INTF" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:079,       0 Deletes Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:079,    --- End Deletes for Table "dbo.MBC_CONSUMER_RECEIPT_INTF" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:079,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:079,    ----- Deletes for Table "dbo.MBC_CONSUMER_BILL_INTF" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:079,       0 Deletes Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:079,    --- End Deletes for Table "dbo.MBC_CONSUMER_BILL_INTF" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:079,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:079,    ----- Deletes for Table "dbo.MBC_CONSUMER_INF" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:079,       0 Deletes Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:079,    --- End Deletes for Table "dbo.MBC_CONSUMER_INF" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:079,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:094,    ----- Deletes for Table "dbo.MBC_BILLING_UNIT_INTF" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:094,       0 Deletes Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:094,    --- End Deletes for Table "dbo.MBC_BILLING_UNIT_INTF" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:094,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:094,    ----- Deletes for Table "dbo.MBC_BU_VILLAGE" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:094,       0 Deletes Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:094,    --- End Deletes for Table "dbo.MBC_BU_VILLAGE" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:094,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:094,    ----- Inserts for Table "dbo.MBC_BU_VILLAGE" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:094,       0 Inserts Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:094,    --- End Inserts for Table "dbo.MBC_BU_VILLAGE" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:094,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:094,    ----- Inserts for Table "dbo.MBC_BILLING_UNIT_INTF" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:094,       0 Inserts Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:094,    --- End Inserts for Table "dbo.MBC_BILLING_UNIT_INTF" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:094,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:110,    ----- Inserts for Table "dbo.MBC_CONSUMER_INF" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:110,       0 Inserts Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:110,    --- End Inserts for Table "dbo.MBC_CONSUMER_INF" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:110,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:110,    ----- Inserts for Table "dbo.MBC_CONSUMER_BILL_INTF" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:110,       0 Inserts Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:110,    --- End Inserts for Table "dbo.MBC_CONSUMER_BILL_INTF" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:110,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:110,    ----- Inserts for Table "dbo.MBC_CONSUMER_RECEIPT_INTF" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:110,       0 Inserts Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:110,    --- End Inserts for Table "dbo.MBC_CONSUMER_RECEIPT_INTF" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:110,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:110,    ----- Updates for Table "dbo.MBC_BU_VILLAGE" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:110,       0 Updates Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:110,    --- End Updates for Table "dbo.MBC_BU_VILLAGE" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:110,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:110,    ----- Updates for Table "dbo.MBC_BILLING_UNIT_INTF" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:126,       0 Updates Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:126,    --- End Updates for Table "dbo.MBC_BILLING_UNIT_INTF" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:126,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:126,    ----- Updates for Table "dbo.MBC_CONSUMER_INF" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:126,       0 Updates Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:126,    --- End Updates for Table "dbo.MBC_CONSUMER_INF" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:126,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:126,    ----- Updates for Table "dbo.MBC_CONSUMER_BILL_INTF" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:126,       0 Updates Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:126,    --- End Updates for Table "dbo.MBC_CONSUMER_BILL_INTF" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:126,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:126,    ----- Updates for Table "dbo.MBC_CONSUMER_RECEIPT_INTF" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:126,       0 Updates Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:126,    --- End Updates for Table "dbo.MBC_CONSUMER_RECEIPT_INTF" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:141,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:141, --- End Applying Changes for Scope "mbc_scope_MHASLA" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:141,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:141, Committing transaction
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:141,    EndSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:204,    BeginSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:313, ----- Applying Changes for Scope "request_scope_MHASLA_new" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:313,         Source Scope Id: d4d071b2b2204f03b032605a302b0056
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:313,    Destination Scope Id: 969eecda3ade4dbb91f359575b8df2b4
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:313,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:313,    ----- Deletes for Table "dbo.CR_SERVICE_REQUEST" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:313,       0 Deletes Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:313,    --- End Deletes for Table "dbo.CR_SERVICE_REQUEST" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:313,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:313,    ----- Inserts for Table "dbo.CR_SERVICE_REQUEST" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:313,       0 Inserts Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:313,    --- End Inserts for Table "dbo.CR_SERVICE_REQUEST" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:329,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:329,    ----- Updates for Table "dbo.CR_SERVICE_REQUEST" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:329,       0 Updates Applied
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:329,    --- End Updates for Table "dbo.CR_SERVICE_REQUEST" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:329,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:329, --- End Applying Changes for Scope "request_scope_MHASLA_new" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:329,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:329, Committing transaction
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:329,    EndSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:360,    BeginSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:454, ----- Checking for Outdated Peer -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:469,    Destination is not outdated
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:469, --- End Checking for Outdated Peer ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:469,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:469, ----- Enumerating Changes for Scope "request_scope_MHASLA" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:469,          Source Scope Id: 338696133bbc400984bb78d3a733ca4f
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:469,     Destination Scope Id: f3328d7ef55a409886bbd57a8384fede
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:469,    Change Tracking Model: Decoupled
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:469,    ----- Table "dbo.CR_SERVICE_REQUEST_LOG" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:501,       Inserts: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:501,       Deletes: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:501,       Updates: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:501,       Changes Enumerated: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:501,    --- End Table "dbo.CR_SERVICE_REQUEST_LOG" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:501,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:501,    ----- Table "dbo.CR_SERVICE_REQUEST" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:532,       Inserts: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:532,       Deletes: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:532,       Updates: 9
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:548,       Changes Enumerated: 9
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:548,    --- End Table "dbo.CR_SERVICE_REQUEST" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:548,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:548,    ----- Table "dbo.CR_SERVICE_REQUEST_FEEDBACK" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:563,       Inserts: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:563,       Deletes: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:563,       Updates: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:563,       Changes Enumerated: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:563,    --- End Table "dbo.CR_SERVICE_REQUEST_FEEDBACK" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:563,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:563,    ----- Table "dbo.CR_ESCALATION" -----
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:579,       Inserts: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:579,       Deletes: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:579,       Updates: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:579,       Changes Enumerated: 0
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:579,    --- End Table "dbo.CR_ESCALATION" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:579,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:579, --- End Enumerating Changes for Scope "request_scope_MHASLA" ---
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:579,
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:36:34:594, Committing transaction
    INFO   , MSSqlDBSync.vshost, 10, 07/19/2011 12:37:34:706,    EndSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91

     

    Tuesday, July 19, 2011 12:38 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    am not seeing any error in your trace.

    you might just want to increase your WCF timeout values.

    Tuesday, July 19, 2011 1:54 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi.

    I have verified by using UploadAndDownLoad on different scopes which are perfectly executing.

    Surprisingly the trace file doesnot write any error.I am attaching the config file properties please check out if any thing is missing.

    <system.diagnostics>

    <switches>

    <!-- 0-off, 1-error, 2-warn, 3-info, 4-verbose.

    -->

    <

    add name="SyncTracer" value="3"

    />

    </

    switches>

    <trace autoflush="true">

    <listeners

    >

    <

    add name="TestListener" type="System.Diagnostics.TextWriterTraceListener" initializeData="c:\TraceSample.txt"

    />

    </

    listeners

    >

    </

    trace

    >

    </

    system.diagnostics>

    Please let me know if any further changes are need to be done in config file.

    Also let me know any further details are required ....

    Regards,

    Sachin K

     

    Wednesday, July 20, 2011 4:53 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    so are you getting an error that is not being logged by tracing?

    in the trace you posted, did you get an error there?

    Wednesday, July 20, 2011 4:56 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Yes...

    It is loading all infos in the trace file but not of type error.

    The trace which I posted is the entire file generated.I also tried by making SYnctracer as 1 along with 3,but to no avail.

    Regards,

    Sachin K

    Wednesday, July 20, 2011 7:25 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    am sorry but am not sure what you're looking for exactly. if the trace says theres no error and it completed the sync, then there's no error in the sync.

    when and where are you getting the timeout error? did you get the timeout error for the trace you did above? have you even changed the sync direction to do bidirectional sync when you did the trace? or is that trace for download only?

    Wednesday, July 20, 2011 7:39 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi June,

    The mentioned trace is for bidirectional(UploadAndDownLoad).

    This is for your information.I changed the direction for another scope(as I have 5 scopes) with me .

    The other scope works completely fine with UploadAndDownLoad.This scope which has error is special.

    I have done the customization for this particular scope.I am just giving down what I have done. 

     

    public void localProvider_ApplyingChanges(object sender, DbApplyingChangesEventArgs e)

    {

    string scope = DBSyncApplicationUtil.getScopeName(DBSyncXMLUtil.getDocumnetRoot());

    string table = DBSyncApplicationUtil.getTableName(DBSyncXMLUtil

    .getDocumnetRoot());

    string column = DBSyncApplicationUtil.getColumnName(DBSyncXMLUtil

    .getDocumnetRoot());

     if (_scopeName == scope)

    {

    if (e.Context.DataSet.Tables.Contains(table))

     {

     var dataTable = e.Context.DataSet.Tables[table];

     foreach (DataRow row in dataTable.Rows)

    {

    if (row.RowState == DataRowState.Modified || row.RowState == DataRowState.Added)

    {

    row[column] = DBNull.Value;

    }

    }

    }

    }

    }

    There is a cyclic redundancy on it.http://social.microsoft.com/Forums/en-US/syncdevdiscussions/thread/0660a5af-27c1-40f7-bea1-207862377794/

    The action is to first sync data with the column REQUEST_CURRENT_LOG_ID_N as null.

    Then I sync the table CR_SERVICE_REQUEST_LOG.Then I Sync entire table CR_SERVICE_REQUEST. Please let me know for any issues.

    Regards,

    Sachin K

     

    Wednesday, July 20, 2011 9:24 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    as previously suggested, try tweaking your WCF timeout values to isolate if its WCF that is timing out because the sync  is taking too long. you still havent answered my questions in your other post and i still dont understand what your table relationships are and what you're trying to achieve by setting the column to null.
    Friday, July 22, 2011 1:15 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I have resolved WCF timeout issue.Thanks for that.You have understood the relationships correctly as per previous forums mentioned in the link.In the live application also same process is used to insert the data.

    During insertion in CR_SERVICE_REQUEST,firstly the value for CURRENT_LOG_ID is made to null in CR_SERVICE_REQUEST table.Then  we are inserting a new row in CR_SERVICE_REQUEST_LOG table.This will also generate the log id.Finally there is an updation of Current Log Id generated in CR_SERVICE_REQUEST table.

    Also WCF(hosted at server) also has some role in Sync FrameWork.Should we also add the tracing activity in WCF web.config activity.

    Regards,

    Sachin K


    Monday, August 1, 2011 1:19 PM