Two questions: 1. non-dbo schema supported? 2.SyncScope not Supported error?

Semua Balasan

• 02 Agustus 2012 6:00

  Moderator

   

   
  

  0

  non-dbo schema is supported. 

  can you share some more info when are you getting the error above?

  • Balas
  • Kutip

   
• 02 Agustus 2012 15:01

   

   
  

  0

  It's kind of hard to explain but when I provision my db with my schema included I get the error above or I get and error saying and it doesn't look like the scope_config and scope_info tables are getting populated properly compared to provisioning (dbo)

  ErrorDescription":"Microsoft.Synchronization.Data.DbSyncException\u000d\u000aCannot find a valid scope with the name 'cbcsync' in table '[scope_info]'.

  When I provision my db without my schema included I'm getting an error that says

  {"ErrorDescription":"Microsoft.Synchronization.Data.DbSyncException\u000d\u000aCannot find a valid scope with the name 'cbcsync_fbbbbc18-81fb-40d5-b686-a7bfc8184e1b' in table '[scope_info]'. Ensure that this scope exists and that it has a corresponding valid configuration in the configuration table '[scope_config]'.\u000d\u000a   at Microsoft.Synchronization.Data.SqlServer.SqlProviderFactory.ReadConfiguration(String scopeName, SyncSchemaInfo syncSchemaInfo)\u000d\u000a   at Microsoft.Synchronization.Data.SqlServer.SqlSyncProvider.Configure()\u000d\u000a   at Microsoft.Synchronization.Data.SqlServer.SqlSyncProvider.BeginSession(SyncProviderPosition position, SyncSessionContext syncSessionContext)\u000d\u000a   at Microsoft.Synchronization.Services.SqlProvider.SqlSyncProviderService.GetChanges(Byte[] clientKnowledgeBlob)\u000d\u000a   at Microsoft.Synchronization.Services.DownloadChangesRequestProcessor.ProcessRequest(Request incomingRequest)\u000d\u000a   at Microsoft.Synchronization.Services.SyncService`1.ProcessRequestForMessage(Stream messageBody)\u000d\u000a\u000d\u000a\u000d\u000a"}

  There error is occuring on my initial sync

  http://server/_dotnet35/hhd/CBCSyncService/CBCSyncService.SVC/CbcSync/DownloadChanges

  Ran the same code again and the error message came back with the same error except the scope name is different {"ErrorDescription":"Microsoft.Synchronization.Data.DbSyncException\u000d\u000aCannot find a valid scope with the name 'cbcsync_049034fb-77a8-4504-8c7b-7d9daa252244'

  
  

  • Diedit oleh V.Moss 02 Agustus 2012 18:27
  •  
  • Balas
  • Kutip

   
• 03 Agustus 2012 1:12

  Moderator

   

   
  

  0
  on the service code, did you set the schema name via SetSyncObjectSchema inside InitializeService ?
  • Balas
  • Kutip

   
• 03 Agustus 2012 15:24

   

   
  

  0
  Yes I did. but it appears to be looking in dbo.
  • Balas
  • Kutip

   
• 06 Agustus 2012 10:29

  Moderator

   

   
  

  0

  can you query what your scope_info table contains?

  if you specify a schema name, do you see the sync created objects prefixed with your schema?

  • Balas
  • Kutip

   
• 13 Agustus 2012 12:09

   

   
  

  0
  This a well-known bug

  ---

  Senior Jack of all trades

  
  

  • Diedit oleh M.Bi 13 Agustus 2012 12:09
  • Disarankan sebagai Jawaban oleh vmoss 25 Oktober 2012 17:00
  •  
  • Balas
  • Kutip