A "Failed to load thumbnails. Error executing SQL command [7050]" Error Occurs When Opening a Document.

August 25, 2006 | KB: 1011015
Laserfiche 7

Summary

When opening a document, you may receive the following error message:

    Failed to load thumbnails. Error executing SQL command [7050]

In most cases, the thumbnails will still load after this message has been received.

Cause

This issue occurs when an expansion database is not successfully attached, or when if it is attached under the wrong name. Expansion databases are created when using MSDE and Microsoft SQL Server: Personal Edition. Expansion databases store thumbnail information and word location data. If an expansion database is not attached, or is attached under a different name, Laserfiche will be unable to access thumbnail information.

Resolution

Expansion databases must be attached to the SQL server. For instructions on correctly attaching your expansion database, see the following article:

1011022 HOW TO: Attaching Expansion Databases to MSDE or SQL Server Personal Edition.

More Information

After the error message has been received, the thumbnails will usually appear. This is because the client first tries to retrieve the thumbnail data from the expansion database. If it is unable to do so, it will then attempt to regenerate the thumbnails.

Related Links

For more information about expansion database files, please see the following Laserfiche Knowledge Base article:

1000519: INFO: MSDE and SQL Server Personal Edition Database File Information.

For other issues with the same root cause and resolution, please see the following Laserfiche Knowledge Base articles:

1011023 ERROR: A "Failed writing data to repository [7050]" Error Occurs When OCRing.

1011038 ERROR: An "Error determining word locations. Error executing SQL command [7050]" Error Occurs When Applying Linked Text Annotations.

For information regarding other thumbnail display issues with different root causes, please see the following Laserfiche Knowledge Base articles:

1000744 ERROR: A "Failed to load thumbnails. Cannot generate thumbnail [7582]" Error Occurs When Opening a Document.

1000630 ISSUE: Thumbnails Do Not Display When Opening a Document.