Office 365 users or groups not available when defining policy conditions and updated user data is not reflected in signatures

Scenario:

When trying to add Office 365 users or groups to signature conditions in Exclaimer Signature Manager Office 365 Edition, they are not visible for selection. Also, updated user data in Office 365 is not visible in the user’s email signature.

When you view the Exclaimer event log, the following error is reported:

Unable to complete aggregation.
System.Data.SQLite.SQLiteException (0x80004005): database disk image is malformed
malformed database schema (view_Quality) - table "view_Quality" already exists
at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
at System.Data.SQLite.SQLiteConnection.Open()
at Exclaimer.Data.CacheController.CacheWriter..ctor(Configuration config, Boolean readOnly)
at Exclaimer.Data.AggregationEngine.AggregationEngine.Run(Configuration config)

Solution:

Follow steps below:


  1. Close the Signature Manager Office 365 Edition console.
  2. Stop all Exclaimer Signature Manager Office 365 Edition services on the server, via the Windows Services Management console (services.msc).
  3. Rename the cache.sdf file (located in %programdata%\Exclaimer Ltd\Alternate Data Source) to cache.sdf.old.
  4. Start the following services:

    • Exclaimer Signature Manager Office 365 Edition Configuration service
    • Exclaimer Data Aggregation Service

    • This starts a rebuild of the database. The data aggregation status is visible in the Exclaimer console for Exclaimer Signature Manager Office 365 Edition, on the Advanced settings tab.

  5. Once data aggregation has finished, start the remaining Exclaimer Services.