Relevant Products: Signature Manager Office 365 Edition
Scenario
The data within your signatures are not updating and when you review the logs via the Status button on the right-hand side of the console you see the below error being logged.
Status: Error
System.Data.SQLite.SQLiteException (0x80004005): database disk image is malformed malformed database schema (view_example group) - table "view_example group" already exists at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String&; strRemain)
System.Data.SQLite.SQLiteException (0x80004005): database disk image is malformed malformed database schema (view_example group) - table "view_example group" already exists at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String&; strRemain)
Cause
This issue indicates that the SQLite database we store Active Directory data within has become malformed and cannot be updated.
Resolution
- Close the Signature Manager Office 365 Edition console
- Stop all Signature Manager Office 365 Edition Services on the Machine using Services.msc
- Browse to %ProgramData%\Exclaimer Ltd\Alternative Data Source in File Explorer
- Rename the cache.sdf file here to cache.sdf.bak
- Once this has been renamed, start the following services
- Exclaimer Signature Manager Office 365 Edition Configuration Service
- Exclaimer Data Aggregation Service
- Open the Event Viewer (eventvwr.exe) and monitor for the Aggregation Completed event. This will log under Event ID 0.
- Once this event has been logged, start the rest of the Exclaimer Services and reopen the console.