Summary

When you open a specific document, thumbnails do not display. You may receive bad document handle error messages in the error logs.

Cause

The thumbnail information stored in the database is incorrect.

Resolution

Remove the existing thumbnails and regenerate new thumbnails. Perform one of the following methods:

Note: SQL Server Enterprise Manager is only available if you have the full version of Microsoft SQL Server.

To remove existing thumbnails using SQL Server Enterprise Manager:

1. Click Start, then select All Programs.
2. Select Microsoft SQL Server and click Enterprise Manager.
3. Expand Console Root.
4. Expand Microsoft SQL Servers.
5. Expand SQL Server Group.
6. Expand the appropriate computer hosting the SQL database.
7. Expand the appropriate database.
8. Under the database name, click Tables.
9. In the right side view pane, right-click the LFT table, select Open, and click Return all rows.
10. Highlight all the entries and delete them. Click Yes when Enterprise Manager asks you to confirm permanently deleting the selected rows.
11. Close the LFT table.
12. Start the Laserfiche Client and log into the appropriate database.
13. Open the problem document and view it in thumbnail mode to regenerate the thumbnails.

To remove existing thumbnails from a MSDE database using the OSQL command line utility:

1. Click Start and click Run.
2. Open a command prompt window by typing the following in the Run dialog box:

   cmd

3. Click OK.
4. In the command prompt window, type the following line to remove all thumbnails:

   osql -E -S ComputerName\Laserfiche -d "DatabaseName_Data_1" -Q "delete from lft"

   Note: You must repeat the above command for any additional expansion databases. Replace the "Data_1" with "Data_2" and so on for any additional expansion databases.

5. Start the Laserfiche Client and log into the appropriate database.
6. Open the problem document and view it in thumbnail mode to regenerate the thumbnails.