An "Error reading repository information, or repository misconfigured [9025]." Error Occurs When the Laserfiche Server Starts on a Failover Computer.

November 11, 2016 | KB: 1012259
Laserfiche Server - Team (MSDE) 8, Laserfiche Server - United (MS SQL) 8, Laserfiche Server - United (Oracle) 8

Summary

In a failover cluster environment, when the Laserfiche Server attempts to start up on a backup computer, you may receive the following error message:

    Error reading repository information, or repository misconfigured [9025].

Cause

The Laserfiche Server stores DBMS connection information in the registry. By default, Laserfiche also encrypts this DBMS connection string information. The encryption scheme is machine specific. This means that when the registry is replicated between cluster nodes, the encrypted connection string is now invalid on the failover machine and Laserfiche is unable to connect to the DBMS.

Workaround

Add an unencrypted connection string to the registry under the HKEY_LOCAL_MACHINE\SOFTWARE\Laserfiche\Engine\8.0\Repositories\RepositoryName registry key.

To add a connection string

  1. Click Start and then click Run.
  2. In the Run dialog box, type the following and then click OK to load the Windows Registry Editor:
  3. regedt32

  4. Expand HKEY_LOCAL_MACHINE.
  5. Expand SOFTWARE.
  6. Expand Laserfiche.
  7. Expand Engine.
  8. Expand 8.0.
  9. Expand Repositories.
  10. Expand RepositoryName.
  11. From the Edit menu, point to New and click String Value.
  12. Name the new value:
  13. ConnectionString

  14. Double-click the new value and set the value data to the desired connection string. Use one of the following formats for your desired DBMS and version of Laserfiche Server.
  15. Microsoft SQL Server with Windows Authentication (Laserfiche Server 8 and 9):

    Driver={SQL Native Client};SERVER={YourMSSQLServerName};Trusted_Connection=yes;DATABASE={YourDatabaseName};

    Microsoft SQL Server with Windows Authentication (Laserfiche Server 10):

    Driver={ODBC Driver 11 for SQL Server};SERVER={YourMSSQLServerName};Trusted_Connection=yes;DATABASE={YourDatabaseName};

    Microsoft SQL Server with SQL Server Authentication (Laserfiche Server 8 and 9):

    Driver={SQL Native Client};SERVER={YourMSSQLServerNAme};UID={SQLLoginName};PWD={SQLPassword};DATABASE={YourDatabaseName};

    Microsoft SQL Server with SQL Server Authentication (Laserfiche Server 10):

    Driver={ODBC Driver 11 for SQL Server};SERVER={YourMSSQLServerNAme};UID={SQLLoginName};PWD={SQLPassword};DATABASE={YourDatabaseName};

    Oracle:

    Driver={Oracle in OraClient10g_home1};DBQ=OracleServerName;UID=schemaName;PWD=schemaPassword;