Archive fails with an error ‘Processing Error: Unable to initialize Archive database.’ when attempting to initialize or reinitialize the Channels Archive Database
This is an issue beginning with Channels 9.4 CU10 QFE 2 and later.
To solve this issue
- Stop the Channels Service
- Replace the makeindex_mssql.sql file in the <Channels install directory>\Channels\conf directory with the attached version of the file: makeindex_mssql.sql.
- Start the Channels Service
- Initialize the Archive database