Phone Lines icon GFI Support

Articles in this section

See more

Emails Are Not Indexed Due to 'SQL Server Compact' is Missing or is Incorrectly Installed

Author: Luis Fernandes Updated

Overview

Emails are not indexed because Microsoft SQL Server Compact is missing or is incorrectly installed.

..\MailArchiver\Search\DebugLogs\IndexJob.log lists the following errors:

2012-05-28,09:45:19,300,1,"#000005E0","#0000000B","error  ","IndexJob","Error: failed to get updates Store.Exceptions.DalException: QueryFailed ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server);

or

...2012-05-28,09:45:19,300,1,"#000005E0","#0000000B","error  ","IndexJob","Error: Failed getting bulk messages QueryFailed"

or

IndexJob.log: 2012-06-27,15:00:31,498,1,"#000016A8","#0000000C","error  ","IndexJob","Error: Unable to get MetaStore Object reference not set to an instance of an object." 2012-06-27,15:00:31,498,1,"#000016A8","#0000000C","error  ","IndexJob","Error: failed to add to index System.NullReferenceException: Object reference not set to an instance of an object. ;   at Search.Indexer.IndexingJob.ProcessNew(RunningJobParams jobParams)" 2012-06-27,15:00:31,498,1,"#000016A8","#0000000C","warning","IndexJob","Warning: indexing failure, TS will not be updated. Exit" Meta.Errors.log: 2012-06-27,16:44:05,573,1,"#000016A8","#00000003","error  ","Meta.Error","error: CreateDatabase failed.  ;message: File version mismatch detected between ADO.NET Provider and native binaries of SQL Server Compact which could result in an incorrect functionality.  This could be due to the presence of multiple instances of SQL Server Compact of different versions.  Please install SQL Server Compact binaries of matching version [ADO.NET Provider File Version = 3.5.5692.*, Native Binary File Version = 3.5.8080.*]

Environment

  • GFI MailArchiver 2012 or older
  • All supported environments

Root Cause

GFI MailArchiver requires the external component Microsoft SQL Server Compact to manage its indexes. This is normally installed during the GFI MailArchiver installation. If this component is uninstalled or is not working properly, then GFI MailArchiver will fail to index the emails.

Resolution

To resolve this issue, re-install or repair Microsoft SQL Server Compact.