

You can use the Workspace Upgrade queue to monitor the progress of scripts as they update workspace database schemas. In addition, you can also monitor upgrades to applications currently installed in workspaces. It also provides you with the ability to view detailed error messages when a script or application upgrade fails. You can use the advanced mass operations on the queue to edit the priority and order of workspace upgrades, as well as retry failed upgrades, and cancel upgrades.
You can view the Workspace Upgrade queue from Home. Select the Queue Management tab, and click Workspace Upgrade Queue. The Workspace Upgrade queue displays the current status and the progress of the upgrade for each workspaces.
The Workspace Upgrade Queue also displays the current status and version of the processing store upgrade process, which the Workspace Upgrade Worker agent completes in addition to upgrading the workspace.
For descriptions of the columns, see Workspace Upgrade queue columns.
Procuro is a utility used to upgrade the schema for all Relativity databases using scripts. As part of the database upgrade process, the Procuro utility automatically runs on your database server. It is also known as the Database Upgrade tool. Procuro makes updates to database schemas by adding, and removing columns in tables, creating new tables, re-naming table /columns, changing the types of data; adding or removing indexes and statistics to ensure functionality with Relativity. It is also required so Relativity can perform upgrades for future iterations created.
Procuro automatically sets the Upgrade Status of the workspaces to Pending in the Workspace Upgrade queue. This status indicates to the upgrade agents running in your environment that they can begin upgrading the workspaces immediately. You can use the advanced mass operation options to change the upgrade priority and order of workspaces or to prevent workspaces from upgrading. For more information, see Editing upgrade priority and order for a workspace.
The workspace upgrader uses agents that run jobs for upgrading the workspace database schemas and installing applications. You must configure these agents through the Agents tab in Relativity. See Populating the Workspace Upgrade queue.
If you do not see any activity in the Workspace Upgrade queue, these agents have not been configured. An alert message lists the agents that you need to configure.
The Workspace Upgrade queue continually populates with status information by the upgrade agents as they run scripts to update workspace databases and installed applications. The following agents run the scripts and the application upgrades:
Note: On an SQL Server profile, you can edit the Workspace Upgrade Limit field, which controls the number of agents accessing the server during an upgrade. The setting entered in this field can’t exceed the setting in the GlobalWorkspaceUpgradeLimit instance setting value. If you enter a number that exceeds this instance setting value, an error occurs that cancels your update.
During a Relativity upgrade, the agents complete the following tasks and then update the statuses displayed on the Workspace Upgrade queue:
During an Invariant upgrade, the agents complete the following tasks and then update the statuses displayed on the Workspace Upgrade queue:
The Workspace Upgrade queue displays the following columns:
Pending —the Invariant store have been added to the Workspace Upgrade queue, but the Workspace Upgrade Worker has not picked it up yet.
Upgrading Scripts—the Workspace Upgrade Worker agent is running scripts against the Invariant store.
Completed—the store is fully upgraded and ready for use.
Failed Script Upgrade—an error occurred while upgrading SQL scripts for the Invariant store, the upgrade failed, and Processing is disabled in the workspace.
Canceled—the user canceled the upgrade when it had the status of Pending, Pending Application Upgrade, Upgrading Scripts, or Upgrading Applications. See Canceling or retrying workspace upgrades.
NULL—a Store has not been created on this workspace
The following table contains descriptions for the statuses displayed in the Upgrade Status column on the Workspace Upgrade queue:
Canceled—the user canceled the upgrade when it had the status of Pending, Pending Application Upgrade, Upgrading Scripts, or Upgrading Applications. See Canceling or retrying workspace upgrades.
Completed—the upgrade of the workspace completed successfully.
Failed Application Upgrade—an error occurred while upgrading applications in the workspace. See Troubleshooting upgrades.
Failed Script Upgrade—an error occurred while upgrading SQL scripts for the workspace. See Troubleshooting upgrades.
Pending—the workspace has been added to the Workspace Upgrade queue, but the Workspace Upgrade Worker has not picked it up yet.
Pending Application Upgrade—the Workspace Upgrade Manager populates the application installation queue with any required applications.
Upgrading Applications—the Application Installation Manager upgrades the applications in the workspace.
Upgrading Scripts—the Workspace Upgrade Worker runs Procuro scripts against the workspace database.
You can set order and priority on workspaces for upgrades. Relativity always upgrades ordered workspaces before unordered workspaces regardless of their priority. Relativity uses priority to determine which of the workspaces to upgrade first when you do not assign an order.
In addition, if you assign the same order to a group of workspaces, Relativity uses their Artifact ID to determine the upgrade order. It follows a similar process if you assign the same priority to a group of workspaces.
The priority and order options provide you with the flexibility needed to control the workspaces that Relativity upgrades first and those that are upgraded later. For example, you might upgrade workspaces in high demand, so that they are available to users sooner than those less frequently accessed workspaces. The default priority for workspaces is Medium and the default order is blank.
Note: Your users may notice decreased Relativity performance if they are using a workspace on the same SQL Server where you are upgrading other workspaces. However, if you are upgrading workspaces on another server in a distributed environment, users should not notice any change in performance.
Use this procedure to change the priority and order:
If you want to revert from and ordered priority to an unordered priority, use this procedure:
From the Workspace Upgrade queue, you can view script and application errors, which may have occurred during an upgrade. You can also use the mass operations for retrying a workspace upgrade from the queue or canceling an upgrade. For more information, see the following sections:
When an application or script fails to upgrade properly, the Upgrade Status column displays a link that you can use to view additional information about the error that occurred.
Note: You can also view errors, upgrade status, script details, and other information on the History of Workspace dialog. To display this information, click the Workspace Details tab, and then click the View Audit button.
When a script upgrade fails, click the Failed Script Upgrade link to display the Error Information dialog, which includes a detailed error message, server, source, and other information.
You cannot access a workspace when a script or other upgrade non-application error occurs. If you attempt to open a workspace with these upgrade errors, you receive a message indicating that the workspace is inaccessible. Click the Return to Home link to display the default Home tab.
Note: If you only want to display workspaces that are fully upgraded and accessible, add a condition on the workspace view where the Workspace Accessibility field is set to Enabled. This setting filters only upgrade accessible workspaces, and hides any workspaces that users cannot interact with.
When a script error occurs during an upgrade, review the details of the failure in the error message available from the Failed Script Upgrade link. You may also want to rerun the upgrade using the Retry Upgrade option. See Canceling or retrying workspace upgrades.
When an application upgrade fails, click the Failed Application Upgrade link to display the Application Errors dialog. If multiple applications failed to upgrade, click this link to display a pop-up with links to the error pages for these applications.
When an application error occurs, review the details of the failure in the error message available from the Failed Application Upgrade link. You can resolve locking conflicts that occur when a locked application prevents an upgrade, and naming conflicts that occur when an object type in an application shares the same name as another object type in the workspace. To resolve these errors, perform one of the following tasks:
In addition, you can perform these tasks for resolving locking and naming conflicts through the Application Library tab.
You can continue accessing a workspace when an application that it contains fails to upgrade successfully for additional troubleshooting. From the Relativity Applications tab, you can view the application details to resolve application errors. When a workspace contains an application in this failed upgrade state, Relativity displays an orange message bar across most of its pages, which contains with a warning indicating that workspace upgrade isn’t complete.
You can cancel an upgrade job on a workspace or retry an upgrade job as necessary. After you cancel a job, the workspace remains in a partially upgraded state so it is no longer accessible. You must attempt to complete a successful upgrade in order to access the workspace.
Use this procedure to cancel or retry an upgrade job:
System secured applications are installed in the Application Library and hosted at the instance level. You can resolve upgrade failures for system secured applications by manually retrying them through the Application library tab. Alternatively, for Relativity 10.0.318.5 and above, you can retry them through the Workspace upgrade queue by clicking the Retry Admin App Upgrades link displayed when a failure occurs.
You can manually retry upgrading system secured applications through the Application Library tab.
The upgrade installer updates system secured applications through the Application Library tab.
When a required application upgrade fails in the Application Library, Relativity handles the failure as follows:
To resolve a failed application upgrade, click the Retry Admin App Upgrades link. You can click this link at any time to retry the upgrade. The next available agent then runs the job for upgrading the failed application in the Application Library. After successfully upgrading, the application is installed in workspaces, and the status columns in the Workspace Upgrade queue are updated.
Note: If you click the Retry Admin App Upgrades link, and the application installation fails again, don’t retry installing all of the applications. Review the Errors tab, check for database errors, and perform other troubleshooting. Application installation failures may be caused by an improperly configured service bus, an unavailable SQL server, and other issues. Contact the Customer Support team if you need additional help.
Why was this not helpful?
Check one that applies.
Thank you for your feedback.
Want to tell us more?
Great!