Summary

Your searches can time out if the search results contain a document or folder that has an invalid parent folder.

Cause

If a document or folder in the Toc table has a ParentId that equals its own TocId, Laserfiche could go into an infinite loop when trying to calculate the entry access rights that affect that document or folder.

Resolution 1

This issue is resolved in Laserfiche 7.1.2. Please upgrade to the latest version of Laserfiche.

Resolution 2

There is a hotfix available for Laserfiche 7.x. The fix is a SQL script that updates the stored procedure responsible for checking entry access rights.

To update the calc_entry_access stored procedure

1. Click here to download a zip file containing two update scripts, one for 7.0.x databases and one for 7.1.x databases.
2. Extract calc_entry_access_fix_70x.sql and calc_entry_access_fix71x.sql to a temporary location.
3. Run the script directly from OSQL.
   1. Click Start and then click Run.
   2. In the Run dialog box, type the following and click OK to load a command prompt:

      cmd

   3. At the command prompt, type the following and press ENTER to run the script:

      OSQL -S SQLInstance -E -d DatabaseName -i "PathtoScript"

      SQLInstance is the name assigned to your instance of SQL Server. By default, the instance name is the name of the computer hosting SQL Server.

      DatabaseName is the name of the database associated with your Laserfiche repository.

      PathtoScript is the location of calc_entry_access_fix_70x.sql or calc_entry_access_fix71x.sql. Specify calc_entry_access_fix_70x.sql if you are using a Laserfiche 7.0.x repository. Specify calc_entry_access_fix71x.sql if you are using a Laserfiche 7.1.x repository.