Unexpected error during full-text search in Explorer client

Background

The Express editions of SQL Server are supported as described in the Accruent Meridian Enterprise Supported Software document. The SQL Server Full Text Search component is required for full-text searches in the Meridian Explorer client.

Description

An error that states An unexpected error has occurred while processing the request can occur when a full-text search is performed in the Meridian Explorer client. This error can be caused by the repository database being restored from a backup after SQL Server Express (which does not include the Full Text Search component) is upgraded to SQL Server Express with Advanced Services (which does include the component).

In this scenario, the full-text indexes do not yet exist in the repository because the component was not installed when the repository was created. The indexes can be added to the repository manually by running the following script in SQL Server Management Studio.

Note    The lines in the following script that create and alter the stoplist are optional to improve search performance. If they are included the database COMPATIBILITY_LEVEL must be set to 100.

CREATE FULLTEXT CATALOG DocContentIndex ON FILEGROUP INDEXES WITH ACCENT_SENSITIVITY = ON AS DEFAULT AUTHORIZATION dbo;
CREATE FULLTEXT INDEX ON DocumentRevisionContentIndex (Data LANGUAGE 0) KEY INDEX PK_DocumentRevisionContentIndex ON DocContentIndex;
CREATE FULLTEXT INDEX ON DocumentRevisionIndex (Data LANGUAGE 0) KEY INDEX PK_DocumentRevisionIndex ON DocContentIndex;

CREATE FULLTEXT CATALOG TagContentIndex ON FILEGROUP INDEXES WITH ACCENT_SENSITIVITY = ON AS DEFAULT AUTHORIZATION dbo;
CREATE FULLTEXT INDEX ON ObjectTagRevisionIndex (Data LANGUAGE 0) KEY INDEX PK_ObjectTagRevisionIndex ON TagContentIndex;

CREATE FULLTEXT CATALOG AreaIndex ON FILEGROUP INDEXES WITH ACCENT_SENSITIVITY = ON AS DEFAULT AUTHORIZATION dbo;
CREATE FULLTEXT INDEX ON AreaIndex (Data LANGUAGE 0) KEY INDEX PK_AreaIndex ON AreaIndex;

CREATE FULLTEXT STOPLIST BCStopList;
ALTER FULLTEXT INDEX ON DocumentRevisionIndex SET STOPLIST = BCStopList;
ALTER FULLTEXT INDEX ON DocumentRevisionContentIndex SET STOPLIST = BCStopList;
ALTER FULLTEXT INDEX ON ObjectTagRevisionIndex SET STOPLIST = BCStopList;
ALTER FULLTEXT INDEX ON AreaIndex SET STOPLIST = BCStopList;