Summary

When upgrading to Laserfiche 9.0.2 on Oracle, you may receive an error in the Windows Application Event Log similar to the following:

Database statement execution error encountered. Session ID: 123; Dialog ID: 1234; Repository: 'MyRepository'; CLI routine: SysLogin; Message: [Oracle][ODBC][Ora]ORA-00900: invalid SQL statement ORA-06512: at line 10; SQL Statement: 'declare i integer; begin select count(*) into i from user_indexes where index_name = 'AUDIT_REASON_CHOICES_SID_IX'; if i = 0 then execute immediate 'audit_reason_choices_sid_ix on audit_reason_choices (sid)'; end if; end; '; SQL variable: ''; SQL State: 42000.

Resolution

There is a hotfix available for Laserfiche Server 9.0.2. The fix is an updated version of the Laserfiche 9.0.1 to 9.0.2 upgrade script for Oracle.

Click the following link to download a zip file containing the updated SQL upgrade script.

KB1013264.zip

Replace the existing copy of ora-upg42.sql in the SQL subfolder of your Laserfiche Server installation folder. By default, the path is C:\Program Files\Laserfiche\Server\sql.

Use the Laserfiche Administration Console to unregister and re-register your Laserfiche repository.