Answered by:
UploadAnd DownLoad Sync Direction Problem using WCF

Question
-
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
-
am not seeing any error in your trace.
you might just want to increase your WCF timeout values.
- Marked as answer by Sid Singh [MSFT]Microsoft employee Tuesday, July 19, 2011 5:27 PM
Tuesday, July 19, 2011 1:54 PM
All replies
-
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 -
Hi,
Please let me know/any link how to enable Sync Fx tracing.
Regards,
Sachin K
Tuesday, July 19, 2011 8:16 AM -
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 -
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 -
is that the stack trace? have you enabled tracing?Tuesday, July 19, 2011 10:57 AM
-
It is the Stack trace.No.I haven't enabled tracing..Tuesday, July 19, 2011 11:04 AM
-
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=89845dcd8080cc91Tuesday, July 19, 2011 12:38 PM -
am not seeing any error in your trace.
you might just want to increase your WCF timeout values.
- Marked as answer by Sid Singh [MSFT]Microsoft employee Tuesday, July 19, 2011 5:27 PM
Tuesday, July 19, 2011 1:54 PM -
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 -
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 -
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 -
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 -
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 -
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
-
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