Summary

When you OCR documents in the database, you may receive the following error message:

8000: Unknown error

Cause

Error 8000 is a generic error that can be returned when Laserfiche encounters an error when communicating with Microsoft SQL Server. There are a number of causes for this particular error and they are listed as follows:

1. Stored procedures were not updated after upgrading the Laserfiche Server. See Resolution 1.
2. One or more expansion databases have not been attached. See Resolution 2.
3. The database (.mdf) files were renamed and attached to the Laserfiche Server under the new file name. See Resolution 3.
4. The Microsoft SQL Server transaction log has reached the maximum alloted file size. See Resolution 4.

Resolution 1

The Laserfiche Server uses stored procedures to access database data. This issue may arise when the stored procedures do not get updated after upgrading the Laserfiche Server.

To update stored procedures using a VBScript:

1. Click here to download Version.vbs.
2. Double-click on the Version.vbs file to begin running the script.
3. From the first Laserfiche dialog box, type the name of the computer where the SQL server resides. Click OK.

   Note: If you are using Laserfiche Team (Group), then you should append the following to the computer name: \Laserfiche.

4. From the second Laserfiche dialog box, type in the name of the SQL database associated with the Laserfiche database in question. Typically, the SQL database name is the same as the Laserfiche database name. Click OK.
5. Click "Yes" when asked to update.
6. Restart the Laserfiche for Microsoft SQL Server service.

This script resets the current stored procedure version number to "1." Restarting Laserfiche will now automatically update the stored procedures.

Resolution 2

This issue may also arise when an expansion database has not been attached. This section explains two methods (VBScript and OSQL) through which you may attach expansion databases.

To attach an expansion database using a VBScript:

1. Click here and here to download two files: ListSqlDbs.vbs and AttachDb.vbs.
2. Run ListSqlDbs.vbs by double-clicking it. This script is designed to find SQL databases with similar names.
   1. From the first Laserfiche dialog box, type ServerName\Laserfiche. The term ServerName represents the name of the computer where the SQL server resides. Click OK.

      Note: If you upgraded Laserfiche Team (Group) to Laserfiche United (Standard\Enterprise), then you should only specify the name of the computer where the SQL server resides.

   2. From the second Laserfiche dialog box, type in the name of the SQL database associated with the Laserfiche database in question. Typically, the SQL database name is the same as the Laserfiche database name. Click OK.
   3. A message box will post a list of SQL databases. Take note of all the databases that end in "_Data_n" where n stands for a sequential number.
   4. Compare what is listed to the .mdf files in the database directory.
   5. Use the following script to attach the unattached databases.
3. Run AttachDbs.vbs by double-clicking it. This script is designed to attach SQL databases.
   1. From the first Laserfiche dialog box, type ServerName\Laserfiche. The term ServerName represents the name of the computer where the SQL server resides. Click OK.

      Note: If you upgraded Laserfiche Team (Group) to Laserfiche United (Standard\Enterprise), then you should only specify the name of the computer where the SQL server resides.

   2. From the second Laserfiche dialog box, type in the name of the SQL database that you would like to attach.
   3. Type in the full path and filename for the specified database. Click OK.
4. Repeat step 5 as needed for any additional expansion databases.

To attach the expansion database using the OSQL command line utility:

1. Start the OSQL utility by opening a Windows command prompt.
   1. Click Start.
   2. Select Run to load the Run dialog box.
   3. Under the "Open" option, type the following line:

      cmd

   4. Click OK.
2. At the command prompt, type the following line:

   osql -E -S Computer Name\Laserfiche

3. Get the filenames for your databases by typing the following three lines at the OSQL prompt:

   USE master
   SELECT * FROM sysdatabases
   GO
   

4. Write down the databases that are displayed.
5. Compare what is listed to the files in the database directory.
6. Attach each database by typing the following in the command prompt:

   EXEC sp_attach_db 'Database Name_data_1', 'C:\Path to Database Directory\Database Name_data_1.mdf'
   GO
   

7. Repeat step 6 as needed for any additional expansion databases.
8. Type EXIT to close the program.

Resolution 3

The .mdf files were renamed while already attached to an existing Laserfiche Server.

To return the .mdf files to their original name:

1. Open the Laserfiche Administration Console:
   1. Click Start.
   2. Select All Programs.
   3. Select Laserfiche.
   4. Click Laserfiche Administration Console.
2. Expand the computer on which the database resides on.
3. Select the database.
4. From Action menu, select Detach.
5. Locate the directory where the database .mdf file is.
6. Rename the .mdf file back to its original name.
7. Return back to the Laserfiche Administration Console.
8. Re-attach the database detached in step 4.

Resolution 4

The transaction log has reached the maximum allowed size. Please see the documentation included with Microsoft SQL Server for more information on configuring the properties for your database's transaction log.