SharePoint Products TechCenter > SharePoint Products and Technologies Forums > SharePoint - Setup, Upgrade, Administration and Operation (pre-SharePoint 2010) > Application synchronization failed for "Microsoft.Office.Server.Search.Administration.SearchService"
Ask a questionAsk a question
 

AnswerApplication synchronization failed for "Microsoft.Office.Server.Search.Administration.SearchService"

  • Monday, November 23, 2009 8:51 PMJamirokoi Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hi everyone, 

    A domain controller have been recently demoted and then promoted for a new domain. On this server, Microsoft Office Sharepoint Server 2007 was installed Sharepoint. I've created the three missing groups: WSS_ Admin_WPG, WSS_RESTRICTED_WPG, WSS_WPG. 

    I've also followed these instructions: http://support.microsoft.com/default.aspx/kb/934838 and thanks to this link:  http://blog.tylerholmes.com/2008/03/restoring-shared-service-provider-admin.html, I was able to restore the SSP.

    Everything seems to work better but i'm getting this error in the Event Viewer: 

    Event ID:6483: 
    "Application synchronization failed for Microsoft.Office.Server.Search.Administration.SearchService.

    Reason: Column already has a DEFAULT bound to it.
    Could not create constraint. See previous errors.

    Techinal Support Details:
    System.Data.SqlClient.SqlException: Column already has a DEFAULT bound to it.
    Could not create constraint. See previous errors.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Office.Server.Data.SqlSession.ExecuteScript(TextReader textReader, Int32 commandTimeout)
       at Microsoft.Office.Server.Data.SqlSession.ExecuteScript(String path, Int32 commandTimeout)
       at Microsoft.Office.Server.Data.SqlSession.ExecuteScript(String path)
       at Microsoft.Office.Server.Search.Administration.SearchSharedApplication.InstallSearchSchema()
       at Microsoft.Office.Server.Search.Administration.SearchSharedApplication.Install()
       at Microsoft.Office.Server.Search.Administration.SearchSharedApplication.Microsoft.Office.Server.Administration.ISqlRestore.OnSqlRestore()
       at Microsoft.Office.Server.Administration.SharedResourceProvider.SynchronizeApplications(SharedComponentSecurity sharedApplicationSecurity)

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. "

    And when I try to start the "Windows SharePoint Services Administrations" service,  a warning is displayed: "The Window SharePoint Services Administration service on Local Computer started and then stopped. Some services stop automatically if they have no work to do ..." . And we have then an error in the event viewer: Event ID 0 Source: SPAdmin.

    "Service cannot be started. System.ComponentModel.Win32Exception: The specified local group does not exist
       at Microsoft.SharePoint.AdministrationOperation.Win32.SPNetApi32.NetLocalGroupGetMembers(String groupName)
       at Microsoft.SharePoint.AdministrationService.SPAdministrationService.RegisterSPAdministrationOperation()
       at Microsoft.SharePoint.AdministrationService.SPAdministrationService.OnStart(String[] args)
       at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)"

    Does someone have an idea about these errors ? 

    Thanks, 

Answers

All Replies