Stored Procedure 'spADSS_MergeEmployees' Not Found

Description

ADSS is not synchronizing users, and one of the following error messages displays in the PANAM event log.

Error Message 1

PNMsoft Sequence Active Directory Synchronization Service.
Could not find stored procedure 'spADSS_MergeOrganizations'.

Error Message 2

PNMsoft Sequence Active Directory Synchronization Service.
Could not find stored procedure 'spADSS_MergeEmployees'.
   at System.Data.SqlClient.SqlConnection.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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at PNMsoft.Sequence.Data.DataProvider.ExecuteNonQuery(DbCommand command)
   at PNMsoft.Sequence.WindowsServices.ADSS.Data.Sql.SqlADSynchronizationDataProvider.MergeEmployees(UniqueKeyProperty uniqueKey)
   at PNMsoft.Sequence.WindowsServices.ADSS.BuiltinThreads.ADSyncronizator.BulkSynchronize(IWorkflowEngine engine, String configDomain, Int32 pageSize, Double serverPageTimeLimit, UniqueKeyProperty uniqueKey, String apostrophe)

Cause

ADSS is active, but not configured.

Affected Versions

7.10 and later.

Solution

If you installed a fresh version of Sequence (7.10 or later), configure ADSS.

If you upgraded to Sequence 7.10 or later, use the Active Directory synchronization wizard to refresh your Active Directory synchronization settings. 

  1. Access the Administration console.
  2. Click Active Directory Settings.
  3. Click Next > Finish.