Summary

When you attempt to OCR a document, the first page processes correctly. On the second page, the progress bar stops at 12%. Eventually, LaserFiche displays a dialog box prompting you to cancel the operation or continue to wait. The OCR process fails upon choosing either choice.

Cause

This error occurs because the expansion MSDE database is set to read-only. This prevents you from adding any additional pages or from altering existing documents within the database.

Edit the expansion database's setting and remove the read-only property. You can edit this setting using several methods:

1. Use Microsoft Enterprise Manager to remove the read-only property. See Resolution 1.
2. Use the OSQL utility to manually remove the read-only property. See Resolution 2.

Note: If you are using LaserFiche Standard/Enterprise, this issue will only apply if you upgraded from LaserFiche Group.

Resolution 1

Edit the database using Enterprise Manager.

To remove the read-only property using Enterprise Manager:

1. Click Start, select All Programs, select Microsoft SQL Server, and click Enterprise Manager.
2. Expand Console Root.
3. Expand Microsoft SQL Servers.
4. Expand the computer hosting the SQL Server.
5. Expand Databases.
6. Select the DatabaseName_Data_n database. In the term "DatabaseName_data_n", the term "DatabaseName" represents the name of the desired database and the variable "n" represents the number assigned to the expansion database.
7. From the Action menu, select Properties.
8. In the DatabaseName Properties dialog box, click the Options tab.
9. Clear the Read-only check box.
10. Click OK.
11. Repeat steps 6 - 10 for each expansion database.

Resolution 2

Use the OSQL command line utility to remove the read-only property from the expansion database.

To remove the read-only property using OSQL:

1. Click Start and then click Run.
2. Type in the following to open a command prompt window:

   cmd

3. Click OK.
4. In the command prompt window, type the following line to start the OSQL utility:

   OSQL -E -S ComputerName\LaserFiche
   

   Note: If you are using LaserFiche United (Standard\Enterprise), then you should only specify the name of the computer where the SQL server resides.

5. Get the filenames for you databases by typing the following three lines at the OSQL prompt:

   USE master
   SELECT * FROM sysdatabases
   GO

6. Write down the expansion databases that are displayed. The expansion databases are named, DatabaseName_data_n, where n is a number.
7. Type the following to remove the read-only property from the expansion database.

   Sp_dboption [DatabaseName_data_n], READ_ONLY, false
   GO

8. Repeat the previous step for each expansion database.