Summary

The CONNECT role has been modified in Oracle 10g Release 2. It now only grants the CREATE SESSION privilege. This means that you must now manually grant the CREATE VIEW and CREATE SYNONYM privileges when first setting up the user schema that will be used by the Laserfiche repository. If the user schema is not granted these privileges, you may receive the following error message in your Laserfiche repository's error.log file:

[7050] Open repository 'YourRepository failed: Could not execute statement : ORA-06550: line 1, column 7: PLS-00905: object YourUserSchema.LFS is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored"

In addition, the Oracle database interface included with previous versions of Laserfiche Server is not fully compatible with Oracle 10g Release 2. You may receive the following error message in your Laserfiche repository's error.log file:

[7050] Open repository 'YourRepository' failed: Could not execute statement : ORA-03113: end-of-file on communication channel.

Resolution 1

This issue is resolved in Laserfiche 7.2. Please upgrade to the latest version of Laserfiche.

Resolution 2

There is a hotfix available for Laserfiche Server 7.1.2 that updates the Laserfiche Oracle database interface. The fix is an updated version of LFOCI.dll. This fix is included in LFOCI (version 7.1.2.580 and later).

Note: This hotfix is only available for Laserfiche Server 7.1.2. If you are encountering this problem while using an earlier version of Laserfiche Server 7, please update your Laserfiche Server to 7.1.2 before applying this hotfix.

To update Laserfiche Server

1. Stop the Laserfiche Server service.
   1. Click Start, navigate to Control Panel, Administrative Tools, and select Services.
   2. Scroll down and select Laserfiche Server 7.x.
   3. From the Action menu, click Stop.
2. Click the following link to download a zip file containing an updated version of LFOCI.dll.
   Hotfix_SCR23793.zip
3. Replace the LFOCI.dll located in the Laserfiche Server installation folder with the updated version. By default, Laserfiche Server is installed at C:\Program Files\Laserfiche\Server.
4. Restart the Laserfiche Server service.
   1. Click Start, navigate to Control Panel, Administrative Tools, and select Services.
   2. Scroll down and select Laserfiche Server 7.x.
   3. From the Action menu, click Start.