Error 3230 Failed to initialize the document provider

SYMPTOMS

When attempting to build an index via the automatic timer option or manual, the following errors appear during the build operation: 'Error 3230 Failed to initialize the document provider'

From the ZyTimer.log:
Begin indexing 'Index name xxxxxx ' (xxx)'
Indexing \index location \' failed (Descr:Error 3045: General failure: no files deleted.)
Stop (ZyTimerService.exe)

From the Document Provider log:
[0x0000206c] INFO ZyDocumentProvider.logger - Started
[0x0000206c] ERROR ZyDocumentProvider.logger - SQLCommand::reset,211: The database disk image is malformed
[0x0000206c] ERROR ZyDocumentProvider.logger - MainDB::BeginUpdate: The database disk image is malformed
[0x0000206c] INFO ZyDocumentProvider.logger - Stopped

'Disk image is malformed' error is experienced when attempting to repair the indexes in SQLite Expert Personal.

CAUSE

Corruption in main.db3 file of an index. This could be the result of a service or system crash.

The description is a general failure: no files deleted or SQLCommand::reset, 211: The database disk image is malformed.

RESOLUTION

• Run a repair on the main.db3 (\ZyLAB Data\Indexes\index_name\Configuration) file via SQLite Expert Professional.
• Open the file in SQLite > Select Database > Select Repair
• Repair can either create a new .db3 file using data in the existing database or it can overwrite the existing database.
• After running the repair it is recommended to rebuild the indexes in all of the tables.

APPLIES TO

3.6; 3.7 Service Pack 1; 3.7 Service Pack 2; 3.8