Relevant Products: Signature Manager Office 365 Edition
WARNING! Signature Manager Office 365 Edition has reached its end of support date - Exclaimer will no longer be renewing any Software Maintenance Agreement (SMA) for Signature Manager Office 365 Edition.
Please contact the Exclaimer Sales team to discuss your requirements for an upgrade to Exclaimer Cloud - Signatures for Office 365.
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.