A "Could not execute statement: ORA-00904: "TOCID": invalid identifier" Error Occurs When Migrating an Oracle Database.

October 15, 2008 | KB: 1012091
Laserfiche Server - United (MS SQL) 8, Laserfiche Server - United (Oracle) 8

Summary

When migrating your Laserfiche 7 Oracle database to Laserfiche 8, you may receive the following error messages:

    Could not execute statement : ORA-00904: "TOCID": invalid identifier

    Unable to read data from Doc table in source database: Could not execute statement : ORA-00904: "TOCID": invalid identifier

Resolution 1

This issue is resolved in the migration wizard included in Laserfiche 8.0.2 and later. Please upgrade to the latest version of Laserfiche.

Resolution 2

There is a hotfix available for Laserfiche 8.0.1. The fix is an updated version of the migration wizard, Lf8MigrationUtil.exe (version 8.0.1.753).

To update the Laserfiche 8 Migration Wizard

  1. Click one of the following links to download either the 32-bit or the 64-bit version of the hotfix.

    Hotfix_SCR42126_x86.zip

    Hotfix_SCR42126_x64.zip

  2. Replace your existing version of Lf8MigrationUtil.exe with the updated version included in the zip file. By default, the file is installed at "C:\Program Files\Laserfiche\Migration 8."