Why am I getting an unexpected error while trying to upgrade my Test Manager instance?
Issue description
Sometimes, you may run into a generic error while attempting to upgrade your existing 21.10 Test Manager instance to a higher version.
Upon assessing the installation logs, you might see an error along the lines of:
Error code: 11000 ERR_UNCAUGHT, Message: !!! An error occured executing the following sql:
CREATE UNIQUE INDEX ON . ( ASC, ASC)
The error was The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'tmcore.Projects' and the index name 'IX_Projects_TenantId_ProjectPrefix'. The duplicate key value is (XXXXX, XXXXX).
The statement has been terminated.
Below is an example of how this error would present in the MSI logs:
Troubleshooting and Resolution
Step 1
The said error may occur due to potential migration failure at the time the Test Manager instance was set up.
To validate if this is indeed the issue, check if:
- There are duplicate values for the index "IX_Projects_TenantId_ProjectPrefix" present in the [tmcore].[Projects] table
- There are duplicate tables present in the DB particularly the following:
- UiPathTestManager].[tmcore].[Projects]
- [UiPathTestManager].[tmcore].[ProjectSettings]
- Any manual modifications were made or scripts ran in the database. Alternately, check if any DB tables were migrated from one DB to the other.
- There is an existing DB backup (which ideally one should, in case of an upgrade activity), check what the aforementioned index looks like in the old DB.
If there are any DB anomalies observed, the best and most robust solution to alleviate the issue is to restore a backup of the DB and ensure that the Test Manager is functioning using the same before attempting another upgrade.
Step 2
If the DB looks fine, delve deeper into the MSI logs. Check if you see the following exception:
Microsoft.Web.Administration.ServerManagerException: The World Wide Web Publishing Service (W3SVC) is stopped. Websites cannot be started unless the World Wide Web Publishing Service (W3SVC) is running.
In the MSI logs, this would appear as follows:
If you see this error, the issue is that the IIS is disabled when the upgrade is performed. This, in turn, disables the World Wide Web Publishing Service.
To resolve this, kindly enable the IIS since it is a requirement for IIS to be enabled and running during a Test Manager upgrade.
Step 3
If the issue persists, reach out to UiPath Support with the following details for further investigation:
- An error screenshot
- MSI logs of the installer from the failed installation attempt
- The DB details from Step 1 above