Upgrading Schema Version Failure During the Upgrade to GFI Archiver 15.10

Overview:

After upgrading to GFI Archiver version 15.10, some users may observe that the archive stores have not upgraded their schema version successfully. This can be verified via the Administration UI.

Root Cause:

This usually indicates that the automatic Database schema upgrade failed and needs to be performed manually.

Solution:

To manually bring all archive stores to the expected schema version (69) for 15.10:

Run the Bulk Schema Upgrader

1. Schedule a maintenance window.
2. Launch the Bulk Schema Upgrader:
   • Found in:
     C:\Program Files\GFI\Archiver\BulkSchemaUpgrader
3. Follow the on-screen instructions to upgrade all stores.

Refer to this guide for full steps: How to upgrade the Archiver database schema

You may also encounter a behaviour where only a few archive stores are upgraded. Refer to the following articles for resolution steps:

• Error: "Database schema failed to update" When the Archive Store Schema Is Being Updated
• Error: 'Database schema failed to update' or 'There was an error reading from the pipe: The pipe has been ended. (109, 0x6d)' when the Archive Store schema is being updated

If you're using the Firebird database engine, follow these steps:

1. Stop all GFI Archiver services.

2. Navigate to:
   Archiver\Store\Data\Schema

3. Move the following files to a backup location outside the Archiver folders:

   • MARMsSqlEml.xml

   • MARFBEml.xml

4. Unzip and place the corrected versions of these files into the same folder.

5. Restart all GFI Archiver services and ensure they are running.

6. Run the Bulk Schema Upgrader.