Summary

After you migrate an electronic document from one volume to a different volume, the electronic file is no longer correctly linked with the document.

Cause

This issue only affects Laserfiche 8 repositories that were migrated from Laserfiche 6 or 7 repositories. And only affects electronic documents that existed in the Laserfiche 6 or 7 repository. The Laserfiche 6/7 to Laserfiche 8 database migration process does not correctly set an internal value for electronic documents. This incorrect value becomes an issue if you then try to perform a volume migration operation on an electronic document. The electronic file remains in its original location, but the Laserfiche Server no longer correctly links the electronic file with the Laserfiche document.

Resolution

This issue is resolved in the Laserfiche 8.1 Migration Wizard. Please upgrade to the latest version of Laserfiche. Please see the following section if you used a previous version of the Migration wizard to migrate your Laserfiche 6 or Laserfiche 7 repository to Laserfiche 8.

More Information

There is a diagnostic and recovery utility available for this issue. The utility will perform the following operations:

1. Correct your Laserfiche 8 SQL database and prevent any future occurrences of this error.
2. Perform a diagnostic scan for electronic documents that are no longer correctly linked with their electronic files due to volume migration. The results of the scan are displayed as an HTML document.
3. If step 2 reveals any electronic documents, the utility gives you the option to either
   • automatically recover the missing link between the electronic document and its electronic file and copy the electronic file to the appropriate volume.
   • do not recover the missing link and instead copy any salvaged electronic files to a specified Windows folder.

Perform the following steps before running the utility:

1. The utility must be run on the computer hosting your Laserfiche 8 Server.
2. The Laserfiche Server must be shut down.
3. You must have a copy of the SQL database from prior to any volume migrations. This copy can be a backup of the Laserfiche 8 database prior to any volume migration operations involving electronic documents. Or it can be the original Laserfiche 6 or 7 database used during the migration process to Laserfiche 8.

Click the following link to download the recovery utility.

RecoveryUtil_scr44650.zip

To run the recovery utility

1. Extract the contents of the above zip file to a temporary location.
2. Double-click "SCR44650Tool.exe" to load the recovery utility.

Note: If you are using the 64-bit version of Laserfiche Server, you need to start the utility with the /64 command-line parameter (i.e. "SCR44650Tool.exe /64").

3. Read the first page of the utility to see an outline of the available functionality. Click Next to continue.

   Important: Please back up your volumes before continuing.

4. Under Choose the Repository to Recover Files in option, select the name of the affected Laserfiche 8 repository.
5. Under Database Authentication Information, specify how the recovery utility will authenticate to the underlying DBMS.
6. Click Next to continue.
7. The utility will perform a diagnostic scan on your database. The Summary Statistics section displays the results of the scan.
   • The scan automatically corrects your SQL database to prevent any future occurrences of this error. Results of this action are summarized with the number of Inoculated Documents.
   • Files Lost represents electronic documents that were migrated to a different volume and are no longer properly linked with its electronic file.
8. Click View Report to view a detailed report of the diagnostic scan.
9. If Files Lost displays a number, you will have the option of recovering the electronic files. Under Next Steps, select one of the two options:
   • I want to try to automatically recover files to fixed volume paths: Select this option if you want the utility to automatically recover the lost link between the Laserfiche electronic document and its associated electronic file. The utility will copy the file from its original volume location to the correct destination volume.
   • I want to try to copy salvaged electronic files to a directory: Select this option if you do not want to recover the link between the electronic document and the electronic file. Instead, the utility will copy any such files from its original volume location to a specified Windows directory.

Optional: Select the Delete files in old volume after copying if you want the utility to automatically remove the original file after creating a copy in the final destination.

10. Click Next to continue.
11. Next to Schema Type, select the type of backup database. This is the DBMS type of the database described in the list of steps prior to running the recovery utility.
12. Next to Server Instance/ODBC Driver Name, specify the name of the DBMS server hosting the backup database.
13. Next to Database/TNS Name, specify the name of the backup database.
14. Choose how you wish to authenticate to the back up database.
15. Click Next to start the recovery procedure.
16. The utility will display a summary of the recovery procedure as well as load a web page with a more detailed report of the procedure. Issues with the recovery process will be included in the report. Click Finish to close the recovery utility.

Related Links

There is an updated version of the Laserfiche 8 Migration Wizard available. Please see the following Knowledge Base article for more information.

1012163 Upgrading to Version 8.0.2.835 of the Laserfiche 8 Migration Wizard.

There is a different potential issue related to volume migration discovered during testing of the recovery utility. Please see the following Knowledge Base article for more information.

1012162 An "Error 9008 (error executing SQL command)" Error Occurs When Migrating Multi-Page Documents.