none
The provider does not have the required command 'SelectScopeInfoCommand' specified RRS feed

  • Question

  •  Getting error "The provider does not have the required command 'SelectScopeInfoCommand' specified.". I already have a application that sync the same database using SqlSyncProvider without setting up and commands for it. Something weird using it within WCF started happening. Can anybody please advise?

    Trace:

    VERBOSE, WCFWindowsServiceHosting, 8, 12/12/2012 04:13:23:716, Reading Schema Version Info
    VERBOSE, WCFWindowsServiceHosting, 8, 12/12/2012 04:13:23:716,    Executing Command: SELECT [schema_major_version], [schema_minor_version], [schema_extended_info] FROM [schema_info]
    ERROR  , WCFWindowsServiceHosting, 8, 12/12/2012 04:13:23:732, Missing command 'SelectScopeInfoCommand' 
    ERROR  , WCFWindowsServiceHosting, 8, 12/12/2012 04:13:23:732, Caught exception while getting scope: Microsoft.Synchronization.Data.DbMissingCommandException: The provider does not have the required command 'SelectScopeInfoCommand' specified.
       at Microsoft.Synchronization.Data.SqlServer.SqlSyncScopeHandler.ReadScope(IDbConnection connection, IDbTransaction transaction, ReadKnowledgeType readType, ReadForgottenKnowledgeType readFKtype)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.GetScope(DbSyncSession DbSyncSession)
    VERBOSE, WCFWindowsServiceHosting, 8, 12/12/2012 04:13:23:732, Closing Connection


    ess

    Wednesday, December 12, 2012 4:40 AM

All replies

  • have you previously set ObjectSchema or ObjectPrefix? check the Sync Fx objects if they have prefixes or non-dbo schemas

    Wednesday, December 12, 2012 5:35 AM
    Moderator