locked
SyncService for non-dbo schema throws "Invalid object name 'scope_info'" RRS feed

  • Question

  • I am trying to run a SyncService that is supposed to live from a database provisioned in a non-dbo schema. Unfortunatly it throws SqlException ""Invalid object name 'scope_info'".


    System.Data.SqlClient.SqlException
    Invalid object name 'scope_info'.
      at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
      at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
      at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
      at System.Data.SqlClient.SqlDataReader.get_MetaData()
      at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
      at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
      at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
      at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
      at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
      at System.Data.SqlClient.SqlCommand.ExecuteReader()
      at Microsoft.Synchronization.Data.SqlServer.SqlProviderFactory.ReadConfiguration(String scopeName)
      at Microsoft.Synchronization.Data.SqlServer.SqlSyncProvider.Configure()
      at Microsoft.Synchronization.Services.SqlProvider.SqlSyncProviderService.GetChanges(Byte[] clientKnowledgeBlob)
      at Microsoft.Synchronization.Services.DownloadChangesRequestProcessor.ProcessRequest(Request incomingRequest)
      at Microsoft.Synchronization.Services.SyncService`1.ProcessRequestForMessage(Stream messageBody)
    
    
    To me it seems that ISyncServiceConfiguration.SetSyncObjectSchema() is ignored. Probably this is the same issue or at least related to what has been reported in this thread .

     

    Tuesday, November 30, 2010 1:41 PM

Answers

  • Hi M.Bi,

    You are correct, this is a related issue where the schema name is not being honored leading to this error. We have a bug filed for this issue for the next release.


    SDE, Sync Framework - http://www.giyer.com
    • Proposed as answer by Ganeshan Tuesday, November 30, 2010 7:19 PM
    • Marked as answer by M.Bi Wednesday, December 1, 2010 7:27 AM
    Tuesday, November 30, 2010 7:19 PM

All replies

  • Did you use SyncSvcUtil.exe or SyncSvcUtilHelper.exe to provision the database? If so - the provisioning was successful?

    Can you execute these queries to see if they return an xml schema as expected?

    -- for regular scope

    select sc.config_data from scope_config sc, scope_info si where sc.config_id = si.scope_config_id and si.sync_scope_name like '<your scope name>'

    -- for template scope

    select sc.config_data from scope_config sc, scope_templates st where sc.config_id = st.template_config_id and st.template_name like '<your scope name>'

    Tuesday, November 30, 2010 6:41 PM
  • Hi M.Bi,

    You are correct, this is a related issue where the schema name is not being honored leading to this error. We have a bug filed for this issue for the next release.


    SDE, Sync Framework - http://www.giyer.com
    • Proposed as answer by Ganeshan Tuesday, November 30, 2010 7:19 PM
    • Marked as answer by M.Bi Wednesday, December 1, 2010 7:27 AM
    Tuesday, November 30, 2010 7:19 PM
  • Did you use SyncSvcUtil.exe or SyncSvcUtilHelper.exe to provision the database? If so - the provisioning was successful?

    Can you execute these queries to see if they return an xml schema as expected?

    I am using a handcrafted syncscopes.config and SyncSvcUtil.exe to provision the database. The provisioning worked well. The schemas (and all metadata and other database objects) do exist in the defined schema. It is just the service which does not find it.

    Hoping for the fix to make it into the next update, thanks.

    Wednesday, December 1, 2010 7:29 AM
  • Yes, Ganeshan repro'd this quickly and figured this is a bug :)
    Wednesday, December 1, 2010 10:43 PM
  • When will this be resolved? When is the next version comming with this bug fixed?

     

    Wednesday, March 23, 2011 1:29 PM
  • When will be Sync Framework next release?

    This is an important topic. Thnks.

    Tuesday, March 5, 2013 3:19 PM
  • the current release of the Sync Framework Toolkit is the latest release. I wouldnt count on getting new version release coming out anytime soon.
    Wednesday, March 6, 2013 1:15 AM