Exception: An error occurred while running database schema update script (4331710)

While upgrading Content Matrix version from an earlier version to 9.3.0.1 or above, you may run into errors loading/connecting to large job history databases.

Content Matrix attempts to upgrade the job history database automatically, but the upgrade step may fail or timeout when upgrading large databases.

Solution 1:

1. Increase the value of "SQLQueryTimeoutTime" in the configuration variable file "/ProgramData/Metalogix/EnvironmentSettings.xml".
2. Relaunch Content Matrix Console.
3. Proceed to solution 2 if the issue persists.

Solution 2:

Upgrade the Job history database schema manually as explained below. As a general rule, it is advised to take backups of your database before executing scripts.

1) Open SQL Server.

2) Select the database which is configured as Job Database.

3) Execute the attached script "Step1-SchemaCreateScript".

4) Execute the attached script "Step2-9.2.0.1".

Note: Please Ignore any warning messages in SQL Server and relaunch Content Matrix.